SAP Knowledge Base Article - Preview

2670189 - SAP Mobile Platform 3.0 Error : No primary key value for foreign key after upgrading from SP 12 to SP 14 PL03

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.