I have changed the @Id of a view from integer to varchar2(200). The CDT XSD had

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
  • 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])
Reply
  • 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])
Children
No Data