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
11 replies
Subscribers
11 subscribers
Views
3801 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
I have changed the @Id of a view from integer to varchar2(200). The CDT XSD had
mohamedb
over 8 years ago
I have changed the @Id of a view from integer to varchar2(200). The CDT XSD had no errors and the DataStore Entity Synchronized fine with DB.
Now, I am getting a new error as shown, when I try to access the record view:
Error Evaluating UI Expression:
Expression evaluation error in rule 'wmg_gbl_generatecustomertablegrid' (called by rule 'wmg_gbl_generateaccountrecordview') at function a!queryEntity [line 11]: An error occurred while retrieving the data. (APNX-1-4198-000)
I am also attaching the record view for your reference.
application-server.log
OriginalPostID-219069
OriginalPostID-219069
Discussion posts and replies are publicly visible
Parents
0
mohamedb
over 8 years ago
I have checked the View. There are no duplicate rows. We use the function sys_guid() to generate unique primary keys for different rows.
Testing with a Query Rule to fetch the data from DB, it fails.
The DataStore entity synchronized successfuly with the DB.
There error I am getting on the query rule is:
Expression evaluation error in rule 'test_accountcustomerview' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [WMGGBLAccountCustomerViewDT56835], query: [test_AccountCustomerView], order by: [[]], filters:[null])
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
mohamedb
over 8 years ago
I have checked the View. There are no duplicate rows. We use the function sys_guid() to generate unique primary keys for different rows.
Testing with a Query Rule to fetch the data from DB, it fails.
The DataStore entity synchronized successfuly with the DB.
There error I am getting on the query rule is:
Expression evaluation error in rule 'test_accountcustomerview' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [WMGGBLAccountCustomerViewDT56835], query: [test_AccountCustomerView], order by: [[]], filters:[null])
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data