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

Discussion posts and replies are publicly visible

Parents

0 mohamedb over 8 years ago

OK, there was a datatype mismatch between the XSD and the table.

When using the above mentioned SQL statement to generate a primary key on a DB View the following XSD representation for promary key works:

<xsd:element name="id" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Id @GeneratedValue @Column(name="WMG_VIEW_ID", nullable=false, columnDefinition="VARCHAR2(200)")</xsd:appinfo>
</xsd:annotation>
</xsd:element>

Also, after updating the XSD, make sure to delete the entity from the datastore; and then re-map it again; then verify the DataStore mapping is worrking - so as to ensure that the DS has picked the latest XSD version.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mohamedb over 8 years ago

OK, there was a datatype mismatch between the XSD and the table.

When using the above mentioned SQL statement to generate a primary key on a DB View the following XSD representation for promary key works:

<xsd:element name="id" nillable="true" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Id @GeneratedValue @Column(name="WMG_VIEW_ID", nullable=false, columnDefinition="VARCHAR2(200)")</xsd:appinfo>
</xsd:annotation>
</xsd:element>

Also, after updating the XSD, make sure to delete the entity from the datastore; and then re-map it again; then verify the DataStore mapping is worrking - so as to ensure that the DS has picked the latest XSD version.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data