AuditLogManager Runtime Exception

, , ,
1

Hi All,

I have got a following problem while I was configuring the Monitor on an IS v6.1.
Please give your valuable comments on this.
I appreciate your time in advance.

Best Regards,
KVReddy

****What I did
->(1) I had created the database tables(Oracle 9.2) from the scripts provided by webMethods(from location “<drive>:&#60;wm>\common\db\scripts\create”).

->(2) I had setup the following fields in Extended Setting of Administrator window.
watt.server.auditLog=perSvc
watt.server.auditStore=database
watt.server.xref.type=jdbc

->(3) JDBC connection is enabled and working fine.

->(4) Created Pool Alias Definitions and Functional Definitions for Is Core Audit, Process Audit, Xref and TN and the test was successful and restarted the IS.

****PROBLEM
->(1) When I open the Monitor from browser I can see the error:
“Failed getting instance list (java.sql.SQLException: [wm-cjdbc33-0069][Oracle JDBC Driver][Oracle]ORA-00904: “T1”.“AUDITTIMESTAMP”: invalid identifier )”.

->(2) The server log from command prompt is:

2005-06-07 13:14:43 CDT [ISS.0095.0003C] AuditLogManager Runtime Exception: :[BA
A.0002.0000] Wrapped Exception: java.sql.SQLException: [wm-cjdbc33-0069][Oracle
JDBC Driver][Oracle]ORA-00904: “SESSIONID”: invalid identifier
processing log entry >>>BasicData:RootContextID=02783b80d78011d9ba6eea06100ac2
58,AuditTimestamp=1118168078136,ContextID=02783b80d78011d9ba6eea06100ac258,Audit
SchemaName=wMSession,AuditSchemaVersion=1,ServerID=192.168.2.4:5555,SessionID=5m
DXE4hFwqCSSeRaLud4oHrt9N+c-55554,SessionState=2,UserID=Administrator,SessionName
=system,Rpcs=0,Age=460,$$$AUDITPROCESS={MemData:DefaultJDBCConfig_1=4}<<<.
2005-06-07 13:14:43 CDT [ISS.0095.0004C] AuditLogManager Runtime Rejected entry
>>>BasicData:RootContextID=02320ac0d78011d9ba6bea06100ac258,AuditTimestamp=11181
68077676,ContextID=02320ac0d78011d9ba6bea06100ac258,AuditSchemaName=wMSession,Au
ditSchemaVersion=1,ServerID=192.168.2.4:5555,SessionID=5mDXE4hFwqCSSeRaLud4oHrt9
N+c-55554,SessionState=1,UserID=Administrator,SessionName=system,Rpcs=0,Age=0,$$
$AUDITPROCESS={MemData:DefaultJDBCConfig_1=4},ERRORINFO={MemData:exId=BAA.0002.0
000,exBundle=com.wm.app.audit.resources.AuditExcpMsgs,exError=0,exReason=0,exDfl
tMsg=null,exWrapped=java.sql.SQLException: [wm-cjdbc33-0069][Oracle JDBC Driver]
[Oracle]ORA-00904: “SESSIONID”: invalid identifier
,exParmcnt=0}<<<.

2

Hi There,

I resolved this problem. Now the Monitor is working fine.

Thanks,
KVReddy

3

Can you please give details on how you resolved the problem, im sure it will be very helpful to all of us.

Thanks,
Leon

4

Hi Leon,

I am working on IS v6.1 and Modeler v6.1.5.

What I Did:
I had created the database tables from the scripts(located “<drive>:&#60;wm>\common\db\scripts\create”) of version 6.1 for all the pools(IsCoreAudit,ProcessAudit,TN,Xref etc…).

Problem:
The IS is v6.1, Modeler v6.1.5 and Trading Networks v6.1 and there was a problem with the Audit Log Manager(no proper database tables were created for the Audit log)

Solution:
I created the database tables for IsCoreAuditLog and ProcessAuditLog from the scripts v6.1.5, TN and Xref tables from v6.1.

Now the Monitor is working fine and no more errors in serverlog/errorlog.

Thanks,
KVReddy