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 for Me (Login required).

Search for additional results

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