Author |
Message |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
Error in REP_SYS_AUDIT_TRAIL |
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
Problems |
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
Odbc a Sybase |
|
I only have one odbc a Sybase.
In Database I wrote sybsecurity.
|
|
Fri Jun 24, 2011 4:05 pm |
|
![](templates/GreenTech/images/spacer.gif) |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
entries in cliconfg |
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
profile |
|
Yes, I have 2 profiles separated and Repository Central in other server.
[img]
[/img]
|
|
Fri Jun 24, 2011 5:26 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
tables of central repository (SQL Server) |
|
Yes
[img]
[/img]
|
|
Fri Jun 24, 2011 5:39 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
53.log |
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
Mismatch with db_audit.STAGE$100002 |
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
|