Symptom
After upgrading the SAP Mobile Platform Server 3.0 from SP 12 to SP 14 PL03 the following error is seen (in the SMP server logs) after connecting/syncing the client device to the SMP server and changing a Work Order:
- ERROR :java.sql.SQLException: No primary key value for foreign key 'FK_SMP_CLUSTER_CONFIG_PROP_COMPONENT' in table 'SMP_CLUSTER_CONFIG_PROP'
- ERROR#com.sap.mobile.platform.server.agentry.console###Agentry SAPWM_MM_TEST Worker 139666880120576 Thread#na#######Exception: 15:46:47 07/13/2018 : 29 (Java Exception), javax/persistence/RollbackException (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.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (MPSMOBILE.SMPCLUSTERCONFIG_PROPCOMPONENT) violated - parent key not found |
2018 07 13 15:46:47#0-500#ERROR#com.sap.mobile.platform.server.agentry.console###Agentry SAPWM_MM_TEST Worker 139666880120576 Thread#na#######Exception: 15:46:47 07/13/2018 : 29 (Java Exception), javax/persistence/RollbackException (), /build/ablack/AgSrvrel171164/src/com.sap.mobile.platform.server.agentry/Syclo/ag3/agent/ClusteredUserTransactionStorage.cpp#99:putData |
Read more...
Environment
- SAP Mobile Platform 3.0 SP14 PL 03
- SAP Work Manager 8.1
- Mobile Add-On version/patch : SMERP,SMFND and SMISU 620_700 with SP01
Product
SAP Mobile Platform 3.0 ; SAP Work Manager all versions
Keywords
SMP 3.0, SMP Cluster Prop Value Error, cluster config prop component, parent key , KBA , 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.