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
13 replies
Subscribers
9 subscribers
Views
6341 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
Hi All, In our current application, we have some entity-backed record
chetany
A Score Level 1
over 10 years ago
Hi All,
In our current application, we have some entity-backed records based on Views in Database. Recently, the Views were modified in the Database.(A few columns were added, one was renamed). Accordingly, I changed the XSD of the CDT related to that view. Then updated the CDT. I also updated the dependents. The dependents include the Data Store of our Application. No errors came up. Now when I navigate to my Entity-Backed record, I get the following error: The source of the data for “SCA Request” cannot be accessed. (APNX-1-4205-001)
To diagnose the above error, I also create a sample queryEntity() just to check if I am able to retrieve the data.
I get an error even there:
Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data.
Any idea what can be done? Is this some issue which is at Database side?
OriginalPostID-166673
OriginalPostID-166673
Discussion posts and replies are publicly visible
0
chetany
A Score Level 1
over 10 years ago
I have also checked the Data Store security. It is also set properly.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
neelimaj
over 10 years ago
Hi Chetan, try publishing Data store again.. It may occur if the values inserted in DB are not proper.. especially Date time fields.. I faced this issue in my project.. I found that the data inserted in datetime field was filled with 0s.
Try if it solves your issue..
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
tanmayareddyn241
over 10 years ago
You must have created an entity mapping to the data source....Please check if you have updated the mapping after you changed the CDT?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chetany
A Score Level 1
over 10 years ago
@All, I have published Data store again. Now I am getting this error: An error occurred while retrieving the data for “SCA Request”. (APNX-1-4205-003)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chetany
A Score Level 1
over 10 years ago
@neelimaj, we have only date fields in that CDT
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim
Certified Lead Developer
over 10 years ago
Do any of your date fields hold an invalid value such as 0000-00-00?
Please also check your application server log which should contain more database specific error details?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chetany
A Score Level 1
over 10 years ago
@tim, I checked the data. A few dates have null values. But there are no invalid values like 0000-00-00
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim
Certified Lead Developer
over 10 years ago
Please also check your application server log which should contain more database specific error details?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chetany
A Score Level 1
over 10 years ago
@tim, I would have checked the app. server log. But it is a very long process for getting an approval. I observed the following. I created a queryEntity, and purposefully included incorrect column name. As expected, it gave me the error like "The field [Prequa_ID] does not exist." But, when I input the correct column name, it gives " An error occurred while retrieving the data". Does this mean that, there is something wrong with the data in the view?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim
Certified Lead Developer
over 10 years ago
Try running a SQL statement in the query database node in a simple process connecting to the same jndi source as your datastore. This node can often provide a more verbose error output.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>