The "Write to Data Store" node fails

Question

Hi folks, 
 
 I am trying to create a request and the request is created but does not show on the dashboard. The Write to Data Store node fails in the process model with the following error: 
 
 An error occurred while trying to write to the entity &ldquo;ABC_Request&rdquo; [id=adae9f92-536c-4b1d-8420-fea70822e668@453193, type=ABC_Request (id=5304)] (data store: ABC Requests). Details: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00904: "abcmilestone_milestone_id": invalid identifier Data: TypedValue[ ... ] 
 
 I am unable to understand why this error occurs. Any help would be appreciated. TIA!

Amit Mishra · Answer

Hi Apoorva, Your error says, Primary key "abcmilestone_milestone_id" field has mapping issue.Please check you CDT's XSD. It should be exactly as below... @Id @GeneratedValue Also, Your Primary Key name "abcmilestone_milestone_id" is big(If dummy, then OK). Best Practice is to limit your elements name within 28 characters. Hope this information will be helpful for you. Thanks

Sidhant Behura · Answer

Hi @apoorvam0001, 
 From the SQL Error code thrown "ORA-00904" it looks like you are using Oracle Database. This error is encountered in Oracle when you have an invalid column name or the column name is missing. 
 To be a valid column name in Oracle the following criteria must be met: 
 1. The column name must begin with a letter. 2. The column name can not be longer than 30 characters. 3. The column name must be made up of alphanumeric characters or the following special characters: $, _, and #. If the column name uses any other characters, it must be enclosed in double quotation marks. 4. The column name can not be a reserved word. Please share your XSD so that we can see the definition of the column "abcmilestone_milestone_id". 
 There is also a record about "ORA-00904" in the Appian Knowledge Base. Please check it out, it may help you. 
 Regards, 
 Sidhant Behura