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

Discussion posts and replies are publicly visible

Parents

0 sanjays0006 over 7 years ago

Sailesh,
I think this is data issue. When I look at the screenshot 2, one value is missing in moduleAsShippedUpdates(23ML-71-GB). Check the data once.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sanjays0006 over 7 years ago

Sailesh,
I think this is data issue. When I look at the screenshot 2, one value is missing in moduleAsShippedUpdates(23ML-71-GB). Check the data once.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data