This issue surfaced when we deployed the application into a different server. Th

Sidhant Behura over 9 years ago

This issue surfaced when we deployed the application into a different server. This is working fine in the dev server.
This is related to Write to Multiple Data Store Entities Smart Service. The smart service is faling to insert data into the respective table with below exception.
The swim lane assignment is "Run as whoever designed the process model" and i.e user is a System Administrator.

Exception/Alert:
There is a problem with task “Write to any XYZ Entity” in the process “XYZ Data base interaction - 5/5/2016 12:46 PM GMT+00:00 - by Admin”. An error occurred while trying to write to the data store [XYZ - Application]. No values have been written. Details: could not insert: [XYZEmployeeDT1066] (APNX-1-4208-004)

I checked the previous post by other appian practitioners but without luck.
I checked the Write to Multiple Data Store Entities Smart Service in forum help and found out the same error with a cause.

Error:
...

Discussion posts and replies are publicly visible

0 Sidhant Behura over 9 years ago

...An error occurred while trying to write to the data store: {0}. No values have been written. Details: {1}
Cause
A database constraint or similar error occurred while attempting to save data to the database.

The cause is a little bit broad and would like some more information on it.

Any help is appreciated. Thanks in Advance.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ChristineH
Certified Lead Developer
over 9 years ago

Do you have primary key or foreign keys on the table you are trying to insert?
For PK, check the values in there and the nextval in the sequence to make sure there is not a conflict.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 9 years ago

@siddhanthb Would you please be able to attach the logs, especially the ones that wee generated at the time when the node fails? That might quickly help us to know what has happened and mostly 'Caused By' in it determines the root cause as per my knowledge. Else we may need to depend on some guess work and in this case I would suggest adding some more information such as table structure.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sidhant Behura over 9 years ago

@christineh Yes i have primary keys with auto-increment and foreign keys on the table on which i am trying to perform insert operation.
As mentioned above i exported the application from one server and imported into another server. I took the db(mysql) dump and imported into the new server and systematically truncated all the tables. As per my knowledge truncation of any table resets the nextval or the auto-increment value to 0. Please feel free ask any other information if needed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sidhant Behura over 9 years ago

@sikhivahan Sure...I will execute the same process model and attach the application server logs which are generated when the node fails.
Adding some extra information:
The application is able to insert data into other database in the same datasource but failing to insert data into this particular table.
Ex: It is successfully able to insert into Table1 in DB1 but failing to insert into Table 4 in DB2. DB1 and DB2 are into same datasource.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sumeet Khare over 9 years ago

Sidhant: Check the column defination where you have foreign key. I am guessing that the configuration is not null for that column which means you can't insert a null value for that column.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel