SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
AlertCenter-Parameter 8 (""): Data type 0x2A has a

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
AlertCenter-Parameter 8 (""): Data type 0x2A has a
Author Message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post AlertCenter-Parameter 8 (""): Data type 0x2A has a Reply with quote
I get the following message when I am replicating:

Audit data archiving failed for table sybsecurity.dbo.sysaudits_02. [Microsoft][SQL Server Native Client 10.0][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 8 (""): Data type 0x2A has an invalid precision or scale.

ERROR: [Microsoft][SQL Server Native Client 10.0][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 8 (""): Data type 0x2A has an invalid precision or scale.
Table skipped...
Fri Sep 30, 2011 9:32 am View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Reply with quote
Now, I get replication of Sybase to SQL, but data of SQL disappears.

Please, help me, I need data remain in the central repository.



Getting properties of job #13...
Audit trail data archiving job
Error recipient: lorellana@cred.com
Error sender: soporte@credcom
Database profile: xxx
Getting properties of database profile bkuxprod...
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.0010 seconds.
Pre-processing: Truncating staging table db_audit.STAGE$100001...
Pre-processing: Truncate query execution time: 0.0090 seconds.
Validating staging table db_audit.STAGE$100001...
Archiving audit data from sybsecurity.dbo.sysaudits_01...
Audit time range: 2011-09-30 08:14:48.547 to 2011-09-30 08:31:00.802 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.046 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.015 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.0060 seconds.
Updating job log...
Insert log query execution time: 0.0060 seconds.
-----------------------------------------------
Table sybsecurity.dbo.sysaudits_01 processing time: 0.191 seconds.

Pre-processing: Truncating staging table db_audit.STAGE$100002...
Pre-processing: Truncate query execution time: 0.0090 seconds.
Validating staging table db_audit.STAGE$100002...
Archiving audit data from sybsecurity.dbo.sysaudits_02...
Audit time range: 2011-09-30 08:14:48.547 to 2011-09-30 08:31:00.802 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
1000 records copied
1000 records copied
Total audit data records copied: 7348
process time: 50.114 seconds
performance: 146.62569 records per second
Validating table [sybsecurity.dbo.sysaudits_02]...
System audit trail table detected.
Transforming audit data to common format...
Transformation query execution time: 0.317 seconds.
Post-processing: Truncating staging table db_audit.STAGE$100002...
Post-processing: Truncate query execution time: 0.012 seconds.

Saving last run-time in the catalog...
Update query execution time: 0.0060 seconds.
Updating job log...
Insert log query execution time: 0.0 seconds.
-----------------------------------------------
Table sybsecurity.dbo.sysaudits_02 processing time: 50.46 seconds.

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: 0. Audit records archived: 7348. Processing time: 0 minutes and 51 seconds.

Total processing time: 0 minutes and 51 seconds.
Fri Sep 30, 2011 9:42 am View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Reply with quote
Why delete data of audit trail table db_audit.STAGE$100002?
Fri Sep 30, 2011 9:48 am View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Reply with quote
How can I fix this?
Fri Sep 30, 2011 9:49 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.