SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Error in REP_SYS_AUDIT_TRAIL
Goto page 1, 2, 3  Next
 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Error in REP_SYS_AUDIT_TRAIL
Author Message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Error in REP_SYS_AUDIT_TRAIL Reply with quote
I attached the errors of Alert Center, I get the following error in the Audit Log Archiving Job for Sybase.

[img]


In the log I get the following message:
ERROR: Unable to run database query. [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]DB_AUDIT.REP_SYS_AUDIT_TRAIL not found. Specify owner.objectname or use sp_help to check wh


The table db_audit.REP_SYS_AUDIT_TRAIL don't have records.

[/img]
Mon Jun 13, 2011 6:28 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Your ODBC connection is not pointing to the right database. Please update your ODBC profile settings and select Central Repository database for the connection
Fri Jun 24, 2011 1:30 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Problems Reply with quote
I connect via odbc to sybase, and the conexion is ok.
[/img]


but, now i have the following error: "[DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]You can only use SELECT or SELECT INTO with the special table."
[img]


The table db_audit.REP_SYS_AUDIT_TRAIL doesn't have records.
[img]


In the log viewer shows message: "User DB Audit disconnected"
[img]


I can generater reports, but these are in blank
[/img]


I don't know why i don't have service Alert Center Scheduler
[img]


How can i fix these problems?[/img]
Fri Jun 24, 2011 2:43 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Let's do one step at a time. ODBC settings have nothing to do with the service.

So, going back to ODBC. Open Windows Control Panel, open ODBC Data Sources. Select your ODBC profile. Click Properties. Navigate to step where you can select the database for the connection in the database drop-down. Please make sure you have Central Repository database selected, not some other database (I don't know the actual database name, cannot see it on your screenshots)


Later, when you have it fixed. Read the manual on how to install the Alert Center Windows service (search for 24x7srv.exe if that is easier for you).
Fri Jun 24, 2011 3:48 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Odbc a Sybase Reply with quote
I only have one odbc a Sybase.



In Database I wrote sybsecurity.
Fri Jun 24, 2011 4:05 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post entries in cliconfg Reply with quote
I have configured entries in 'cliconfg' in the host where I installed DB Audit, because of that I don't have odbc to my Central Repository.

[img]


in the configuration of Central Repository I wrote the database of repository:
[/img]


I only created one odbc to Sybase from server of central repository.
Fri Jun 24, 2011 4:19 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
You need 2 separate profiles - one for the DB Audit console connecting to your monitored database (and the database can be anything) and another for your repository server (that connection need to point to the repository database, that name is no "sybsecurity' it is something else.

You are not using the same server by any chance for the repository?
The central repository server as name implies is supposed to be a separate central server in which you store data from the audited servers
Fri Jun 24, 2011 5:12 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post profile Reply with quote
Yes, I have 2 profiles separated and Repository Central in other server.
[img]

[/img]
Fri Jun 24, 2011 5:26 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Does the repository ODBC profile point to crd_dbaudit database?
Is that the database in which you have created the central repository tables?
Fri Jun 24, 2011 5:33 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post tables of central repository (SQL Server) Reply with quote
Yes
[img]

[/img]
Fri Jun 24, 2011 5:39 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Please Open Windows Explorer, and navigate to C:\Program Files\DB Audit Alert Center\Data folder. In that folder you should find several log files. One of the files should be named [job number].log where [job number] is the number of the audit data replication file for your Sybase server. Check that file for error messages. Specifically check for error messages indicating problems with inserting data into central repository tables. Please let us know what you find there.
Fri Jun 24, 2011 6:46 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post 53.log Reply with quote
Getting properties of job #53...
Audit trail data archiving job
Error recipient: lorellana@------------------
Error sender: soporte@------------------
Database profile: Sybase6
Getting properties of database profile Sybase6...
JDBC interface:
JDBC driver: sun.jdbc.odbc.JdbcOdbcDriver
Database URL: jdbc:odbc:sybase6_odbc
User: db_audit
Getting properties of repository profile Repository Server...
Repository JDBC interface: ./drivers/mss/sqljdbc.jar
Repository JDBC driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Repository Database URL: jdbc:sqlserver://-------------------;databaseName=crd_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.01 seconds.
Pre-processing: Truncating staging table db_audit.STAGE$100001...
Pre-processing: Truncate query execution time: 0.151 seconds.
Validating staging table db_audit.STAGE$100001...
Archiving audit data from sybsecurity.dbo.sysaudits_01...
Audit time range: [None] to 2011-06-24 17:49:13.836 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.0 seconds
performance: NaN records per second
Deleting audit data from sybsecurity.dbo.sysaudits_01...
Leaving 30 days of data in the audit trail, deleting everything before 2011-05-25 17:49:13.836
Audit data archiving failed for table sybsecurity.dbo.sysaudits_01. [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]You can only use SELECT or SELECT INTO with the special table.
ERROR: [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]You can only use SELECT or SELECT INTO with the special table.
Table skipped...
Pre-processing: Truncating staging table db_audit.STAGE$100002...
Pre-processing: Truncate query execution time: 0.11 seconds.
Validating staging table db_audit.STAGE$100002...
Archiving audit data from sybsecurity.dbo.sysaudits_02...
Audit time range: [None] to 2011-06-24 17:49:13.836 with timezone offset 0
Searching remote audit trail...
Copying records from remote audit trail into staging table...
Audit data archiving failed for table sybsecurity.dbo.sysaudits_02. Implicit conversion from data type nvarchar to binary is not allowed. Use the CONVERT function to run this query.
ERROR: Implicit conversion from data type nvarchar to binary is not allowed. Use the CONVERT function to run this query.
Table skipped...
Fri Jun 24, 2011 6:51 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Thank you.

I see couple of issues here.
1. sysaudit_01 table is empty, The replication job doesn't find any records in that table to copy to the central repository
2. It cannot delete records from that table. Does the user running g the process have sa_role role



PS. I edited your previous post and removed sensitive information
Mon Jun 27, 2011 6:36 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Please post DDL (column definitions) for table db_audit.STAGE$100002 in the repository database. There is some mismatch between that table definition in MS SQL Server repository and your Sybase table sybsecurity.dbo.sysaudits_02
Mon Jun 27, 2011 6:39 am View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Mismatch with db_audit.STAGE$100002 Reply with quote
What you advise me to do the db_audit.STAGE$100002 database in the repository database to fix the mismatch? Please tell me in detail.
Mon Jun 27, 2011 11:55 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
Goto page 1, 2, 3  Next
Page 1 of 3

 
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.