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
11 subscribers
Views
5059 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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
>