Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
8 replies
Subscribers
7 subscribers
Views
2519 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi guys,i have a query rule which gets data from database,and i have placed this
shivakanthr
over 11 years ago
Hi guys,i have a query rule which gets data from database,and i have placed this rule in one script task.when the flow comes to this node it was failed returning alert message "The expression function 'queryruleexec("df3b9028-6eaf-42fd-97c8-4d4c83592b9e",241,null)' (user=e17804, exprId=268435669) could not be evaluated: Failed to create data store ".
can you plese provide solution.
Thanks in advance...
OriginalPostID-60255
OriginalPostID-60255
Discussion posts and replies are publicly visible
0
priyal.patel
Appian Employee
over 11 years ago
I would first validate your database schema and verify the mappings in your database.
Here is a thread where a user experienced a similar issue:
forum.appian.com/.../4856
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Siva
Certified Lead Developer
over 11 years ago
You can verify the following items.
1) Is Appian upgraded recently?
2) Verify the Primary Datasource.
3) In Data Source, you can verify the entity mappings.
4) Does the query rule exist? You can probably run getcontentdetailsbyuuid() custom function to find this. I see the UUID in the post
5) If it exists, does it run when run from a rule.
6) Is script task set to Run as whoever designed the process.
7) Is the Datastore security set with proper access rights?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shivakanthr
over 11 years ago
script task has been set to Run as whoever designed the process and i have access rights
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shivakanthr
over 11 years ago
@sivashankari,when iam verifying Data Source iam getting error message like
"An error occurred while attempting to verify the data store: The primary datasource cannot be reached. Details: could not load an entity: [com.appiancorp.type.model.DatatypeModel#3059] (APNX-1-4179-002"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shivakanthr
over 11 years ago
when i used getcontentdetailsbyuuid(),i got details like "testqueryrule: Type: Rule or Constant, Name: getTipRDPEscalationProcessDtls, Id: 79963, Parent: TIP Query Rule".this means query rule exists right?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Siva
Certified Lead Developer
over 11 years ago
Restart JBoss and check the the application-server.log, pay special attention to the section of this log that shows the startup of JBoss, JBoss connects to the primary data source during startup, if there's a problem with your configuration files or with the communication with the database, the error should be informative enough.
Just a question, does this problem happen only to this data store or to all data stores?
Another test you can do is to check if Query DB nodes work. Instead of using a predefined datasource in the node, enter the connection details manually and check if you are able to connect to the DB.
Do this exercise, identify whether there are errors or not. Hope this helps.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shivakanthr
over 11 years ago
above exception raised for this Datastore ,and the other problem is the flow is hanging(not moving forward) at onether Datastore
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shivakanthr
over 11 years ago
Finally we fixed this issue by restarting Server.
Thank you everyone
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel