Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
7 subscribers
Views
2311 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi All, I am trying to understand and solve the root cause of the fol
saileshd
over 7 years ago
Hi All,
I am trying to understand and solve the root cause of the following error:
An error occurred while trying to write to the entity “dealModuleStatusUpdate” [id=b2df0791-624a-4830-ae86-4800cb14d12a@7840, type=ICAMS_DealModulesStatusUpdate (id=3934)] (data store: ICAMS Datastore). Details: org.hibernate.exception.ConstraintViolationException: could not insert: [ICAMSDealModulesStatusUpdateDT1406]: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`Appian`.`ICAMS_DEAL_MODULES`, CONSTRAINT `ICAMS_DEAL_MODULES_ibfk_2` FOREIGN KEY (`SERIAL_NUMBER`) REFERENCES `ICAMS_MODULE` (`SERIAL_NUMBER`) ON UPDATE CASCADE) Data: TypedValue[it=3935,v={{2150,110332,23ML-77,1,2016-06-29 22:39:34.21,lewisro},{2151,110332,23ML-78,1,2016-06-29 22:39:34.21,lewisro},{2152,110332,23ML-79,1,2016-06-29 22:39:34.21,lewisro},{2153,110332,23ML-80,1,2016-06-29 22:39:34.21,lewisro},{21...
OriginalPostID-221106
OriginalPostID-221106
Discussion posts and replies are publicly visible
Parents
0
saileshd
over 7 years ago
Thanks Lakshmim.
I Have attached two images in the zip file. Capture.png shows the problem in the Datastore entity. Second image shows the values of two variables that I am writing to database. The first write to Data Store Entity Write "moduleAsShippedUpdates" to ICAMS_MODULE and second data store entity writes "dealModuleStatusUpdates" to ICAMS_DEAL_MODULES.
So I am not able to understand the real problem here. I tested the same feature in my other environments i.e DEV and QA and it works perfectly fine.
Foreign Constraint Error.zip
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
saileshd
over 7 years ago
Thanks Lakshmim.
I Have attached two images in the zip file. Capture.png shows the problem in the Datastore entity. Second image shows the values of two variables that I am writing to database. The first write to Data Store Entity Write "moduleAsShippedUpdates" to ICAMS_MODULE and second data store entity writes "dealModuleStatusUpdates" to ICAMS_DEAL_MODULES.
So I am not able to understand the real problem here. I tested the same feature in my other environments i.e DEV and QA and it works perfectly fine.
Foreign Constraint Error.zip
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data