All pastes #491038 Raw Edit

Mine

public text v1 · immutable
·published 2007-05-16 12:00 UTC
rendered paste body
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