Administrator

DB2 Issues When Uploading Hybrid Applications

Problem

With an upgrade to SAP Mobile Platform Server 3.0 SP08, the SMP_LCM_REVISION table has an additional column. If the back end database is DB2, uploading Hybrid apps may fail with a server log similar to the following:
#2.0#2015-06-01 08:48:24.259#+0:00#ERROR####Other#1433148503669001#016a13d6-86ed-4d35-8d73-1a51786b3797#multiple#sun.reflect.NativeMethodAccessorImpl:invoke0#smpAdmin#######559###There was an exception during persistence: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.1.v20121003-ad44345): org.eclipse.persistence.exceptions.DatabaseException
 Internal Exception: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;GOMOBILE.SMP_LCM_REVISION, DRIVER=4.11.77
 Error Code: -668
 Call: INSERT INTO SMP_LCM_REVISION (ID, APPKEY, ARCHIVE_SIZE_KB, DESCRIPTION, FEATURES_REQUIRED, INSTALL_TYPE, LAST_MODIFIED, MIME_TYPE, OWNER, REQUIRED_KAPSEL_VERSION, REVISION,

Workaround

Reorganize the SMP_LCM_REVISION table with the following SQL statement: REORG TABLE SMP_LCM_REVISION. See the IBM DB2 documentation for more information about REORG.