Hello,
I am migrating from v11.3 to v12.2. When running the migration I received the following errors:
Unable to insert table row into database: TableRow [type: ESP_PEOPLESOFT_JOB, values: [10761403, TAX7, SQR Report, TAX7, BATCH, null, PSNT, PDF, null, WEB, CENTRAL_PR_MGR,CENTRAL_PR_ACCT_AUDT,ITD_2ND_LEVEL_HELP_DESK, , QTRLYTAXRPTS, null, null, No, null, null, No, null, null, null, null]] |
com.ca.wa.engine.migration.table.TableWriteException: Unable to insert table row into database: TableRow [type: ESP_PEOPLESOFT_JOB, values: [10761403, TAX007, SQR Report, TAX007, HXBATCH, null, PSNT, PDF, null, WEB, CENTRAL_PR_MGR,CENTRAL_PR_ACCT_AUDT,ITD_2ND_LEVEL_HELP_DESK, , QTRLYTAXRPTS, null, null, No, null, null, No, null, null, null, null]] at com.ca.wa.core.engine.migration.table.DbTableWriter.writeTableRow(DbTableWriter.java:83) at com.ca.wa.engine.migration.table.TableMigrationStep.migrate(TableMigrationStep.java:102) at com.ca.wa.engine.migration.table.TableMigrationDriver.migrate(TableMigrationDriver.java:207) at com.ca.wa.engine.migration.Main.migrateTables(Main.java:551) at com.ca.wa.engine.migration.Main.start(Main.java:336) at com.ca.wa.engine.migration.Main.main(Main.java:244) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK__H_PEOPLES__JOB_I__693CA210". The conflict occurred in database "STG122CUR_DB", table "dbo.H_GENERIC_JOB", column 'JOB_ID'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:426) at com.ca.wa.core.engine.migration.table.DBQueryAdapterBasedTableExportImportDetails.importOneRow(DBQueryAdapterBasedTableExportImportDetails.java:67) at com.ca.wa.core.engine.migration.table.ESP_PEOPLESOFT_JOB_ExportImportDetails.importOneRow(ESP_PEOPLESOFT_JOB_ExportImportDetails.java:118) at com.ca.wa.core.engine.migration.table.DbTableWriter.writeTableRow(DbTableWriter.java:69)
How do I correct this issue?
ONLY 30 of 3662 ROWS CAME OVER with the MIGRATION..
Thank you...