2008-07-31 21:29 AEST by Arthur Barrett - ora: diagnostics do not show error.

using Oracle 8i to conncet to either local 8i server (817) or a remote 10g 
server and the only message that appears is:
audit_trigger error: database is version 1 but need version 2.

However there is actually an EOF:
12:25:33: S -> Connecting to Oracle
12:25:33: S -> Instantiate COracleConnection
12:25:33: S -> COracleConnectionInformation::setVariable hostname=test
12:25:33: S -> COracleConnectionInformation::setVariable database=
12:25:33: S -> COracleConnectionInformation::setVariable username=sz
12:25:33: S -> COracleConnectionInformation::setVariable password=******
12:25:33: S -> COracleConnectionInformation::setVariable prefix=
12:25:33: S -> COracleConnectionInformation::setVariable home=
12:25:33: S -> set environment variable ORACLE_HOME=
12:25:33: S -> COracleConnectionInformation::setVariable schema=SZ
12:25:33: S -> COracleConnectionInformation::setVariable tablespace=USERS
12:25:33: S -> COracleConnectionInformation::setVariable schema=SZ
12:25:33: S -> COracleConnectionInformation::setVariable nls_lang=
12:25:33: S -> set environment variable NLS_LANG=
12:25:33: S -> COracleConnectionInformation::setVariable nls_nchar=
12:25:33: S -> set environment variable NLS_NCHAR=
12:25:33: S -> COracleConnectionInformation::setVariable tablespace=USERS
12:25:33: S -> COracleConnectionInformation::setVariable home=
12:25:33: S -> set environment variable ORACLE_HOME=
12:25:33: S -> COracleConnection::Execute _Execute()
12:25:33: S -> Audit SchemaVersion=Error or Eof
audit_trigger error: database is version 1 but need version 2.
12:25:33: S -> Destroy COracleConnection
12:25:33: S -> Destroyed COracleConnection
12:25:33: S -> Close COracleRecordset
12:25:33: S -> Closed COracleRecordset


In a case where an "Error or Eof" occurs it would be easier to diagnose the 
cause if the error message is returned to the client.

2008-07-31 21:48 AEST by Arthur Barrett - If I set schemaversion to 1 (so it passes the first test) I still get no 
meaningful message:
12:44:15: S -> COracleConnection::Execute _Execute()
12:44:15: S -> Audit SchemaVersion=Error or Eof
12:44:16: S -> Close COracleRecordset
12:44:16: S -> Closed COracleRecordset
12:44:16: S -> Insert Into SZ.SessionLog (Command, Date, Hostname, Username, 
Ses
sionId, VirtRepos, PhysRepos, Client) Values (?,'2008-07-31 
11:44:14',?,?,'acc48
91a58e4715',?,?,'CVSNT 2.5.03 (Scorpio) Build 3141 (RC 5)')
12:44:16: S -> COracleConnection:::ExecuteAndReturnIdentity _Execute()
12:44:16: S -> Close COracleRecordset
12:44:16: S -> Closed COracleRecordset
12:44:16: S -> audit_trigger error (session)

audit_trigger error (session):
12:44:16: S -> Destroy COracleConnection
12:44:16: S -> Destroyed COracleConnection
12:44:16: S -> Close COracleRecordset
12:44:16: S -> Closed COracleRecordset
12:44:16: S -> LoadTrigger(bugzilla.dll)

2008-07-31 22:02 AEST by Arthur Barrett - Created an attachment (id=1329)
diags and env