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
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.
SAP Knowledge Base Article - Preview