SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Problem with replication

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Problem with replication
Author Message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Problem with replication Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.