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

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6642

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

lorellan

Joined: 13 Jun 2011Posts: 124Country: 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

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6642

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

lorellan

Joined: 13 Jun 2011Posts: 124Country: Ecuador

Odbc a Sybase

I only have one odbc a Sybase.

In Database I wrote sybsecurity.

Fri Jun 24, 2011 4:05 pm

lorellan

Joined: 13 Jun 2011Posts: 124Country: 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

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6642

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

lorellan

Joined: 13 Jun 2011Posts: 124Country: Ecuador

profile

Yes, I have 2 profiles separated and Repository Central in other server.
[img]
[/img]

Fri Jun 24, 2011 5:26 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6642

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

lorellan

Joined: 13 Jun 2011Posts: 124Country: Ecuador

tables of central repository (SQL Server)

Yes
[img]
[/img]

Fri Jun 24, 2011 5:39 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6642

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.

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

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6642

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

lorellan

Joined: 13 Jun 2011Posts: 124Country: 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.