Symptom
- Agentry Application like Work Manager or Inventory Manager or other custom application
- Example: We upgraded this SMP sever 3.0 to SP17 and have some failures on transmitting with an Agentry application like SAP Work Manager
- When we synchronize our devices to get the work orders to execute, everything is going well. We get all the informations needed
- But when we synchronize back to register informations from the field in our backend, it fails
- Error:
~~~~~~~~~~~~~Start Here~~~~~~~~~~~~~
07/26/2019 14:26:52, 1, 29, 1, Thr 5016, javax/persistence/RollbackException, javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.1.v20121003-ad44345): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Foreign key constraint violation occurred, dbname = 'XXX', table name = 'SMP_CLUSTER_CONFIG_PROP', constraint name = 'SMPCLSTRCNFGPROPCMPNNT'.
Error Code: 546
Call: INSERT INTO SMP_CLUSTER_CONFIG_PROP (PROP_ID, CLUSTER_ID, COMPONENT, CONTEXT, PROP_NAME, PROP_TYPE) VALUES (?, ?, ?, ?, ?, ?)
bind => [6 parameters bound]
~~~~~~~~~~~~~~end~~~~~~~~~~~~~~~~~ - Special note: The error with SMPCLSTRCNFGPROPCMPNNT may show differently depending on the backend data type - Example Oracle or MSSQLServer. So one data type may show a different rendition of the error above versus the other database type.
Read more...
Environment
- SAp Inventory Manager 4.3
- SAP Work Manager 6.4, 6.5
- SAP Mobile Platform 3.0 SP17
-
SAP Mobile Platform SDK 3.0 - 70.16.8.1
Product
Keywords
"SMPCLSTRCNFGPROPCMPNNT","javax/persistence/RollbackException","Work Manager org.eclipse.persistence.exceptions.DatabaseException" , KBA , MOB-ONP-AGS , SAP Mobile On Premise Agentry Server , MOB-SYC-SAP , Syclo Mobility for SAP backend , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.