2248945 - Violation of PRIMARY KEY constraint 'LP_FOLDER_PK' | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2248945 - Violation of PRIMARY KEY constraint 'LP_FOLDER_PK'

Symptom

  • FS-PRO 3.0 was installed and after verifying the installation we started the upgrade to SP01 patch2. 
  • We downloaded the following component i.e. FSPRO01P_2-80001099.ZIP SP01 Patch2 for FS-PRO 7.6 and followed the upgrade guide. 
  • After running the migrate.bat file we noticed the following error in the migration log i.e. Violation of PRIMARY KEY constraint 'LP_FOLDER_PK'. Cannot insert duplicate key in object 'CAMILION_PPMC.LP_FOLDER'. The duplicate key value is (3). 

ERROR:
DEBUG [main] com.camilion.migrationtool.engine.Launcher (ErrorUtil.java:106) - Trying -> INSERT INTO LP_FOLDER (PK_ID,PARENT_ID,FOLDER_TYPE_ID,OWNER_ID,CREATED_TIME,MODIFIED_TIME,MODIFIED_USER_ID,OBJECT_ID,UUID) VALUES ( (ISNULL( (SELECT PK_ID FROM LP_FOLDER WHERE UUID = 'sys-lpfolder-tmplt-lib') , 39)) ,1, (SELECT PK_ID FROM LP_FOLDER_TYPE WHERE TYPE_NAME = 'CONFIG_GRP') ,'1', SYSDATETIME() , SYSDATETIME() ,'1','CAMILION_MIGRATION_TOOL','sys-lpfolder-tmplt-lib')
ERROR [main] com.camilion.migrationtool.engine.Launcher (ErrorUtil.java:39) - Database error.
com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'LP_FOLDER_PK'. Cannot insert duplicate key in object 'CAMILION_PPMC.LP_FOLDER'. The duplicate key value is (3).
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
 at com.camilion.migrationtool.db.DatabaseUtil.runSql(DatabaseUtil.java:502)
 at com.camilion.migrationtool.db.DatabaseUtil.createStudioFolder(DatabaseUtil.java:2569)
 at com.camilion.migrationtool.db.DatabaseUtil.createConfigGroupFolder(DatabaseUtil.java:2593)
 at com.camilion.migrationtool.packages.versions.pa.v3_0_0_0.PatchPIF15053.createStudioFolderStructure(PatchPIF15053.java:76)


Read more...

Environment

  • SAP Product and Quotation Management for Insurance 3.0 SP00 Patch0
  • SAP Product and Quotation Management for Insurance 3.0 SP01 Patch0

Product

SAP Product and Quotation Management for Insurance 3.0

Keywords

fs-pro, fs-quo, dbmigrationTool, Database Migration Tool , KBA , FS-PRO , Product Management Insurance , FS-QUO , Quotation Management Insurance , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.