16-mj 11:20:10 INFO [Ora2MsSql] - reading configuration 16-mj 11:20:10 INFO [Ora2MsSql] - running... 16-mj 11:25:03 INFO [Ora2MsSql] - reading configuration 16-mj 11:25:03 INFO [Ora2MsSql] - running... 16-mj 11:26:53 INFO [Ora2MsSql] - reading configuration 16-mj 11:26:53 INFO [Ora2MsSql] - running... 16-mj 11:28:02 INFO [Ora2MsSql] - reading configuration 16-mj 11:28:02 INFO [Ora2MsSql] - running... 16-mj 11:33:52 INFO [Ora2MsSql] - reading configuration 16-mj 11:33:52 INFO [Ora2MsSql] - running... 16-mj 11:34:25 INFO [Ora2MsSql] - reading configuration 16-mj 11:34:25 INFO [Ora2MsSql] - running... 16-mj 11:34:54 INFO [Ora2MsSql] - reading configuration 16-mj 11:34:54 INFO [Ora2MsSql] - running... 16-mj 11:35:23 INFO [Ora2MsSql] - reading configuration 16-mj 11:35:23 INFO [Ora2MsSql] - running... 16-mj 11:37:40 INFO [Ora2MsSql] - reading configuration 16-mj 11:37:40 INFO [Ora2MsSql] - running... 16-mj 11:38:05 INFO [Ora2MsSql] - reading configuration 16-mj 11:38:05 INFO [Ora2MsSql] - running... 16-mj 11:38:24 INFO [Ora2MsSql] - reading configuration 16-mj 11:38:24 INFO [Ora2MsSql] - running... 16-mj 11:38:40 INFO [Ora2MsSql] - reading configuration 16-mj 11:38:40 INFO [Ora2MsSql] - running... 16-mj 11:39:46 INFO [Ora2MsSql] - reading configuration 16-mj 11:39:46 INFO [Ora2MsSql] - running... 16-mj 11:40:08 INFO [Ora2MsSql] - reading configuration 16-mj 11:40:08 INFO [Ora2MsSql] - running... 16-mj 11:40:36 INFO [Ora2MsSql] - reading configuration 16-mj 11:40:36 INFO [Ora2MsSql] - running... 16-mj 11:43:50 INFO [Ora2MsSql] - reading configuration 16-mj 11:43:50 INFO [Ora2MsSql] - running... 16-mj 11:43:51 INFO [Prerequisits] - disabling all constraints 16-mj 11:43:51 INFO [SchemaTransfer] - start transfer schema rl_objektdb / objektdb 16-mj 11:43:51 INFO [TableTransfer] - start transfer table-pattern % 16-mj 11:43:51 INFO [CleanUp] - enabling all disabled constraints 16-mj 11:45:17 INFO [Ora2MsSql] - reading configuration 16-mj 11:45:17 INFO [Ora2MsSql] - running... 16-mj 11:45:18 INFO [Prerequisits] - disabling all constraints 16-mj 11:45:19 INFO [SchemaTransfer] - start transfer schema rl_devel / dbo 16-mj 11:45:19 INFO [TableTransfer] - start transfer table-pattern % 16-mj 11:45:19 INFO [SequenceTransfer] - start transfer sequence-pattern % 16-mj 11:45:19 INFO [CleanUp] - enabling all disabled constraints 16-mj 13:57:28 INFO [Ora2MsSql] - reading configuration 16-mj 13:57:28 INFO [Ora2MsSql] - running... 16-mj 13:57:29 INFO [Prerequisits] - disabling all constraints 16-mj 13:57:29 INFO [SchemaTransfer] - start transfer schema RL_OBJEKTDB / objektdb 16-mj 13:57:29 INFO [TableTransfer] - start transfer table-pattern % 16-mj 13:57:30 INFO [Table] - copying RL_OBJEKTDB.ANTRIEBSART_AR 16-mj 13:57:30 INFO [Table] - copied: 8 16-mj 13:57:30 INFO [Table] - copying RL_OBJEKTDB.EINHEIT 16-mj 13:57:30 INFO [Table] - copied: 3 16-mj 13:57:30 DEBUG [Table] - enabling indexes 16-mj 13:57:32 INFO [Table] - copying RL_OBJEKTDB.EL_OBJEKTE 16-mj 13:57:34 INFO [Table] - copied: 767 16-mj 13:57:35 INFO [Table] - copying RL_OBJEKTDB.EL_SPARTE 16-mj 13:57:35 INFO [Table] - copied: 11 16-mj 13:57:35 DEBUG [Table] - enabling indexes 16-mj 13:57:35 INFO [Table] - copying RL_OBJEKTDB.EUROTAX_MARKE 16-mj 13:57:35 INFO [Table] - copied: 138 16-mj 13:57:35 INFO [Table] - copying RL_OBJEKTDB.INVENTARGRUPPE 16-mj 13:57:35 INFO [Table] - copied: 29 16-mj 13:57:35 DEBUG [Table] - enabling indexes 16-mj 13:57:37 INFO [Table] - copying RL_OBJEKTDB.KFZ_DATA 16-mj 13:57:37 ERROR [Table] - error copying record 1 com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type nvarchar to decimal. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source) at at.prowiso.ora2mssql.db.Table.processCopy(Table.java:321) at at.prowiso.ora2mssql.db.Table.copyData(Table.java:167) at at.prowiso.ora2mssql.db.Table.copy(Table.java:33) at at.prowiso.ora2mssql.TableTransfer.start(TableTransfer.java:38) at at.prowiso.ora2mssql.SchemaTransfer.start(SchemaTransfer.java:22) at at.prowiso.ora2mssql.Ora2MsSql.run(Ora2MsSql.java:40) at at.prowiso.ora2mssql.Ora2MsSql.main(Ora2MsSql.java:67) 16-mj 13:57:37 DEBUG [Table] - ID: 79935601 16-mj 13:57:37 ERROR [Table] - error copying table (Rollback)RL_OBJEKTDB.KFZ_DATA com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type nvarchar to decimal. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source) at at.prowiso.ora2mssql.db.Table.processCopy(Table.java:321) at at.prowiso.ora2mssql.db.Table.copyData(Table.java:167) at at.prowiso.ora2mssql.db.Table.copy(Table.java:33) at at.prowiso.ora2mssql.TableTransfer.start(TableTransfer.java:38) at at.prowiso.ora2mssql.SchemaTransfer.start(SchemaTransfer.java:22) at at.prowiso.ora2mssql.Ora2MsSql.run(Ora2MsSql.java:40) at at.prowiso.ora2mssql.Ora2MsSql.main(Ora2MsSql.java:67) 16-mj 13:57:38 ERROR [Table] - error copying table (Rollback)RL_OBJEKTDB.KFZ_DATA_BACKUP java.lang.Exception: mandatory column does not exist in MS-SQL: objektdb.KFZ_DATA_BACKUP.CREATE_TIMESTAMP at at.prowiso.ora2mssql.db.Table.chkColumnInfo(Table.java:230) at at.prowiso.ora2mssql.db.Table.copyData(Table.java:166) at at.prowiso.ora2mssql.db.Table.copy(Table.java:33) at at.prowiso.ora2mssql.TableTransfer.start(TableTransfer.java:38) at at.prowiso.ora2mssql.SchemaTransfer.start(SchemaTransfer.java:22) at at.prowiso.ora2mssql.Ora2MsSql.run(Ora2MsSql.java:40) at at.prowiso.ora2mssql.Ora2MsSql.main(Ora2MsSql.java:67) 16-mj 13:57:39 INFO [Table] - copying RL_OBJEKTDB.KFZDATEN_DOPPELT 16-mj 13:57:39 ERROR [Table] - error copying table (Rollback)RL_OBJEKTDB.KFZDATEN_DOPPELT com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'objektdb.KFZDATEN_DOPPELT'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source) at at.prowiso.ora2mssql.db.Table.processCopy(Table.java:273) at at.prowiso.ora2mssql.db.Table.copyData(Table.java:167) at at.prowiso.ora2mssql.db.Table.copy(Table.java:33) at at.prowiso.ora2mssql.TableTransfer.start(TableTransfer.java:38) at at.prowiso.ora2mssql.SchemaTransfer.start(SchemaTransfer.java:22) at at.prowiso.ora2mssql.Ora2MsSql.run(Ora2MsSql.java:40) at at.prowiso.ora2mssql.Ora2MsSql.main(Ora2MsSql.java:67) 16-mj 13:57:40 INFO [Table] - copying RL_OBJEKTDB.LAUFZEIT 16-mj 13:57:40 INFO [Table] - copied: 122 16-mj 13:57:40 DEBUG [Table] - enabling indexes 16-mj 13:57:40 INFO [Table] - copying RL_OBJEKTDB.LEISTUNG 16-mj 13:57:40 INFO [Table] - copied: 48 16-mj 13:57:40 INFO [Table] - copying RL_OBJEKTDB.MARKE 16-mj 13:57:40 INFO [Table] - copied: 323 16-mj 13:57:40 DEBUG [Table] - enabling indexes 16-mj 13:57:41 INFO [Table] - copying RL_OBJEKTDB.MARKE_EMA 16-mj 13:57:41 INFO [Table] - copied: 162 16-mj 13:57:41 INFO [Table] - copying RL_OBJEKTDB.MOB_CLUSTER 16-mj 13:57:41 INFO [Table] - copied: 11 16-mj 13:57:41 DEBUG [Table] - enabling indexes 16-mj 13:57:41 INFO [Table] - copying RL_OBJEKTDB.MOBILIEN 16-mj 13:57:42 INFO [Table] - copied: 209 16-mj 13:57:42 DEBUG [Table] - enabling indexes 16-mj 13:57:42 INFO [Table] - copying RL_OBJEKTDB.MODELL 16-mj 13:57:43 INFO [Table] - copied: 1000 16-mj 13:57:43 INFO [Table] - copied: 1278 16-mj 13:57:43 DEBUG [Table] - enabling indexes 16-mj 13:57:43 INFO [Table] - copying RL_OBJEKTDB.NUTZUNGSDAUER 16-mj 13:57:43 INFO [Table] - copied: 71 16-mj 13:57:43 DEBUG [Table] - enabling indexes 16-mj 13:57:44 INFO [Table] - copying RL_OBJEKTDB.OBJEKT 16-mj 13:57:45 INFO [Table] - copied: 1000 16-mj 13:57:46 INFO [Table] - copied: 2000 16-mj 13:57:46 INFO [Table] - copied: 3000 16-mj 13:57:47 INFO [Table] - copied: 4000 16-mj 13:57:48 INFO [Table] - copied: 5000 16-mj 13:57:49 INFO [Table] - copied: 6000 16-mj 13:57:50 INFO [Table] - copied: 7000 16-mj 13:57:51 INFO [Table] - copied: 8000 16-mj 13:57:52 INFO [Table] - copied: 9000 16-mj 13:57:53 INFO [Table] - copied: 10000 16-mj 13:57:54 INFO [Table] - copied: 11000 16-mj 13:57:55 INFO [Table] - copied: 12000 16-mj 13:57:56 INFO [Table] - copied: 13000 16-mj 13:57:57 INFO [Table] - copied: 14000 16-mj 13:57:58 INFO [Table] - copied: 15000 16-mj 13:57:59 INFO [Table] - copied: 16000 16-mj 13:58:00 INFO [Table] - copied: 17000 16-mj 13:58:00 INFO [Table] - copied: 18000 16-mj 13:58:01 INFO [Table] - copied: 19000 16-mj 13:58:02 INFO [Table] - copied: 20000 16-mj 13:58:03 INFO [Table] - copied: 21000 16-mj 13:58:04 INFO [Table] - copied: 22000 16-mj 13:58:05 INFO [Table] - copied: 23000 16-mj 13:58:06 INFO [Table] - copied: 24000 16-mj 13:58:07 INFO [Table] - copied: 25000 16-mj 13:58:08 INFO [Table] - copied: 26000 16-mj 13:58:09 INFO [Table] - copied: 27000 16-mj 13:58:10 INFO [Table] - copied: 28000 16-mj 13:58:11 INFO [Table] - copied: 29000 16-mj 13:58:12 INFO [Table] - copied: 30000 16-mj 13:58:12 INFO [Table] - copied: 31000 16-mj 13:58:13 INFO [Table] - copied: 32000 16-mj 13:58:14 INFO [Table] - copied: 32403 16-mj 13:58:14 DEBUG [Table] - enabling indexes 16-mj 13:58:15 INFO [Table] - copying RL_OBJEKTDB.OBJEKT_BACKUP 16-mj 13:58:16 INFO [Table] - copied: 1000 16-mj 13:58:16 INFO [Table] - copied: 2000 16-mj 13:58:17 INFO [Table] - copied: 3000 16-mj 13:58:18 INFO [Table] - copied: 4000 16-mj 13:58:19 INFO [Table] - copied: 5000 16-mj 13:58:19 INFO [Table] - copied: 6000 16-mj 13:58:20 INFO [Table] - copied: 7000 16-mj 13:58:21 INFO [Table] - copied: 8000 16-mj 13:58:21 INFO [Table] - copied: 8715 16-mj 13:58:22 INFO [Table] - copying RL_OBJEKTDB.OBJEKTGRUPPE 16-mj 13:58:22 INFO [Table] - copied: 39 16-mj 13:58:22 DEBUG [Table] - enabling indexes 16-mj 13:58:22 INFO [Table] - copying RL_OBJEKTDB.OBJEKTRATING 16-mj 13:58:22 INFO [Table] - copied: 11 16-mj 13:58:22 DEBUG [Table] - enabling indexes 16-mj 13:58:23 INFO [Table] - copying RL_OBJEKTDB.PLAN_TABLE 16-mj 13:58:23 INFO [Table] - copied: 0 16-mj 13:58:23 INFO [Table] - copying RL_OBJEKTDB.PROD_TYP 16-mj 13:58:23 INFO [Table] - copied: 29 16-mj 13:58:23 DEBUG [Table] - enabling indexes 16-mj 13:58:24 INFO [Table] - copying RL_OBJEKTDB.REST_KFZ 16-mj 13:58:25 INFO [Table] - copied: 266 16-mj 13:58:25 DEBUG [Table] - enabling indexes 16-mj 13:58:25 INFO [Table] - copying RL_OBJEKTDB.RESTWERTE 16-mj 13:58:26 INFO [Table] - copied: 1000 16-mj 13:58:27 INFO [Table] - copied: 2000 16-mj 13:58:27 INFO [Table] - copied: 3000 16-mj 13:58:28 INFO [Table] - copied: 4000 16-mj 13:58:29 INFO [Table] - copied: 5000 16-mj 13:58:29 INFO [Table] - copied: 6000 16-mj 13:58:30 INFO [Table] - copied: 7000 16-mj 13:58:30 INFO [Table] - copied: 8000 16-mj 13:58:31 INFO [Table] - copied: 9000 16-mj 13:58:32 INFO [Table] - copied: 10000 16-mj 13:58:32 INFO [Table] - copied: 11000 16-mj 13:58:33 INFO [Table] - copied: 12000 16-mj 13:58:33 INFO [Table] - copied: 13000 16-mj 13:58:34 INFO [Table] - copied: 14000 16-mj 13:58:35 INFO [Table] - copied: 15000 16-mj 13:58:35 INFO [Table] - copied: 16000 16-mj 13:58:36 INFO [Table] - copied: 17000 16-mj 13:58:36 INFO [Table] - copied: 17198 16-mj 13:58:36 DEBUG [Table] - enabling indexes 16-mj 13:58:36 INFO [Table] - copying RL_OBJEKTDB.RESTWERTKLASSE 16-mj 13:58:36 INFO [Table] - copied: 39 16-mj 13:58:36 DEBUG [Table] - enabling indexes 16-mj 13:58:37 INFO [Table] - copying RL_OBJEKTDB.SPARTE 16-mj 13:58:37 INFO [Table] - copied: 7 16-mj 13:58:37 DEBUG [Table] - enabling indexes 16-mj 13:58:37 INFO [Table] - copying RL_OBJEKTDB.SPRACHE 16-mj 13:58:37 INFO [Table] - copied: 2 16-mj 13:58:37 DEBUG [Table] - enabling indexes 16-mj 13:58:37 INFO [Table] - copying RL_OBJEKTDB.TEXT_ID 16-mj 13:58:37 INFO [Table] - copied: 308 16-mj 13:58:38 INFO [Table] - copying RL_OBJEKTDB.TEXT_I18N 16-mj 13:58:38 INFO [Table] - copied: 190 16-mj 13:58:38 DEBUG [Table] - enabling indexes 16-mj 13:58:38 INFO [Table] - copying RL_OBJEKTDB.TREIBSTOFFART_ET 16-mj 13:58:38 INFO [Table] - copied: 8 16-mj 13:58:38 INFO [Table] - copying RL_OBJEKTDB.WERTETABELLENSTEUERUNG 16-mj 13:58:38 INFO [Table] - copied: 0 16-mj 13:58:38 DEBUG [Table] - enabling indexes 16-mj 13:58:39 INFO [Table] - copying RL_OBJEKTDB.WERT_HISTORY 16-mj 13:58:39 INFO [Table] - copied: 221 16-mj 13:58:39 DEBUG [Table] - enabling indexes 16-mj 13:58:39 INFO [Table] - copying RL_OBJEKTDB.WERT_HISTORY_BACKUP 16-mj 13:58:39 INFO [Table] - copied: 16 16-mj 13:58:39 INFO [Table] - copying RL_OBJEKTDB.Z_LOOKUP 16-mj 13:58:40 INFO [Table] - copied: 1000 16-mj 13:58:40 INFO [Table] - copied: 2000 16-mj 13:58:41 INFO [Table] - copied: 2940 16-mj 13:58:41 INFO [Table] - copying RL_OBJEKTDB.Z_USRCODE 16-mj 13:58:41 INFO [Table] - copied: 359 16-mj 13:58:41 DEBUG [Table] - enabling indexes 16-mj 13:58:41 ERROR [Table] - Error enabling indexes com.microsoft.sqlserver.jdbc.SQLServerException: CREATE UNIQUE INDEX terminated because a duplicate key was found for object name 'objektdb.Z_USRCODE' and index name 'I_Z_USRCODE2'. The duplicate key value is (30, bankstatus ). at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown Source) at at.prowiso.ora2mssql.db.Table.enableIndexes(Table.java:403) at at.prowiso.ora2mssql.db.Table.cleanUp(Table.java:133) at at.prowiso.ora2mssql.db.Table.copy(Table.java:43) at at.prowiso.ora2mssql.TableTransfer.start(TableTransfer.java:38) at at.prowiso.ora2mssql.SchemaTransfer.start(SchemaTransfer.java:22) at at.prowiso.ora2mssql.Ora2MsSql.run(Ora2MsSql.java:40) at at.prowiso.ora2mssql.Ora2MsSql.main(Ora2MsSql.java:67) 16-mj 13:58:41 INFO [Table] - copying RL_OBJEKTDB.Z_USRCODEA 16-mj 13:58:42 INFO [Table] - copied: 1000 16-mj 13:58:43 INFO [Table] - copied: 2000 16-mj 13:58:43 INFO [Table] - copied: 3000 16-mj 13:58:44 INFO [Table] - copied: 4000 16-mj 13:58:44 INFO [Table] - copied: 4903 16-mj 13:58:44 DEBUG [Table] - enabling indexes 16-mj 13:58:45 INFO [CleanUp] - enabling all disabled constraints