 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
Problem with replication |
|
The replication at Central Repository was cancelled.
It's the log:
Getting properties of job #13...
Audit trail data archiving job
Error recipient: lorellana@XXXXXXXXXXX
Error sender: soporte@XXXXXXXX
Database profile: xxx
Getting properties of database profile xxx...
JDBC interface:
JDBC driver: sun.jdbc.odbc.JdbcOdbcDriver
Database URL: jdbc:odbc:produccion_odbc
User: dba3
Getting properties of repository profile Repository Server...
Repository JDBC interface:
Repository JDBC driver: sun.jdbc.odbc.JdbcOdbcDriver
Repository Database URL: jdbc:odbc:CentralRepository_DBaudit
Repository User: db_audit
Connecting to repository database...
Connected.
Connecting to repository database (aux)...
Connected.
Repository server type: Microsoft SQL Server
Archiving method: DATA PUMP
Connecting to database...
Connected
Retrieving catalog data...
Catalog query execution time: 0.0 seconds.
Pre-processing: Truncating staging table db_audit.STAGE$100001...
Pre-processing: Truncate query execution time: 0.0070 seconds.
Validating staging table db_audit.STAGE$100001...
Archiving audit data from sybsecurity.dbo.sysaudits_01...
Audit time range: 2011-09-29 11:38:21.363 to 2011-09-29 11:59:12.687 with timezone offset 0
Searching remote audit trail...
Copying records from remote audit trail into staging table...
Total audit data records copied: 0
process time: 0.03 seconds
performance: 0.0 records per second
Validating table [sybsecurity.dbo.sysaudits_01]...
System audit trail table detected.
Transforming audit data to common format...
Transformation query execution time: 0.0010 seconds.
Post-processing: Truncating staging table db_audit.STAGE$100001...
Post-processing: Truncate query execution time: 0.0070 seconds.
Saving last run-time in the catalog...
Update query execution time: 0.0050 seconds.
Updating job log...
Insert log query execution time: 0.0060 seconds.
-----------------------------------------------
Table sybsecurity.dbo.sysaudits_01 processing time: 0.187 seconds.
Pre-processing: Truncating staging table db_audit.STAGE$100002...
Pre-processing: Truncate query execution time: 0.0070 seconds.
Validating staging table db_audit.STAGE$100002...
Archiving audit data from sybsecurity.dbo.sysaudits_02...
Audit time range: [None] to 2011-09-29 11:59:12.687 with timezone offset 0
Searching remote audit trail...
Copying records from remote audit trail into staging table...
1000 records copied
1000 records copied
1000 records copied
1000 records copied
....
1000 records copied
Total audit data records copied: 141751
process time: 1195.942 seconds
performance: 118.52665 records per second
Validating table [sybsecurity.dbo.sysaudits_02]...
System audit trail table detected.
Transforming audit data to common format...
--- Start of Stack Trace ---
java.sql.SQLException: [Microsoft][SQL Server Native Client 10.0][SQL Server]La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3150)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.java:214)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(JdbcOdbcPreparedStatement.java:136)
at AlertJob.main(Unknown Source)
--- End of Stack Trace ---
Audit data archiving failed for table sybsecurity.dbo.sysaudits_02. [Microsoft][SQL Server Native Client 10.0][SQL Server]La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.
ERROR: [Microsoft][SQL Server Native Client 10.0][SQL Server]La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.
Table skipped...
Audit data archiving complete.
Disconnecting from database...
Disconnecting from repository database...
Closing Alert Center connection and terminating...
DATABASE: xxx - audit data archiving complete. Tables processed: 2. Tables failed: 1. Audit records archived: 0. Processing time: 19 minutes and 56 seconds.
Total processing time: 19 minutes and 56 seconds.
Please, why??
|
|
Thu Sep 29, 2011 1:41 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Date format appears to be incompatible between the source and target databases "La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo."
You may need to try a different driver (non ODBC) or a different replication method
|
|
Fri Sep 30, 2011 10:25 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|