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

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:
...

OriginalPostID-210126

OriginalPostID-210126