RE: [SA-list] Database Logging

[Matt . A . Jefferson]

Title: Database Logging

Ahhh...right...  I changed a system into maintanence and an error appeared

 

Tuesday, February 11, 2003 3:36:18 PM ERR DB_ADD_RECORD : -2147217900([Oracle][ODBC][Ora]ORA-00900: invalid SQL statement
- 0-S) UID:7  time/date: 2/11/20033:30:41 PM

 

There is no space between the year and the hour.

 

It is Oracle 8.1.6

-----Original Message-----
From: Dirk Bulinckx [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 3:38 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Database Logging

Statistical logging entries are only added when an entry changes status, could that be the reason you didn't get any loggings yet (with the Oracle ODBC driver)?

 

As for the other error,

Tuesday, February 11, 2003 12:28:15 PM ERR DB_ADD_RECORD : -2147217900([Microsoft][ODBC driver for Oracle][Oracle]ORA-00900: invalid SQL statement- 0-P) UID:33  time/date: 2/11/200312:27:49 PM

Could you check if there wasn't a space between the year and the hour? (2/11/2003 12:27:49 PM)

 

 

dirk.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: Tue Feb 11 9:28 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Database Logging

Dirk-

 

I found an error message from earlier today

 

Tuesday, February 11, 2003 12:28:15 PM ERR DB_ADD_RECORD : -2147217900([Microsoft][ODBC driver for Oracle][Oracle]ORA-00900: invalid SQL statement- 0-P) UID:33  time/date: 2/11/200312:27:49 PM

 

This was using the Microsoft ODBC driver for Oracle, so I switched to the Oracle ODBC driver.  I have had no errors since then, but it does not create the table or log any information

 

Enterprise Version 4.0.1295

 

Oracle, Initially trying to get statistical logging going...

-----Original Message-----
From: Dirk Bulinckx [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 2:13 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Database Logging

Any errors in the log (text file logging)?

What version of SA?

Towards what kind of DB are you trying to do it?  Which logginG?

 

dirk.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: Tue Feb 11 9:10 PM
To: [EMAIL PROTECTED]
Subject: [SA-list] Database Logging

I cannot seem to get database logging to function.  It will not create any tables. 

Is there any way to debug the database logging connection?

--
<Matt Jefferson>
--