SLM version: 1.2.1
Oracle Collector version: 2011.1r1
JDBC Connector version: 2011.1r3-Beta1

The Database Server(Event Source) is a production box, running
absoloutley fine.

SLM is unable to connect with a JDBC Event Source(Oracle 11g R2), we
are getting following error messages in the server0.0.log:


Code:
--------------------

Wed Oct 02 17:16:42 PKT 2013|SEVERE|QueryId=82;QueryExecutoresecurity.ccs. comp.evtsrcmgt.connector.database.JDBCConnector$Qu eryExecutor@620bcbe1|esecurity.ccs.comp.evtsrcmgt. connector.database.JDBCConnector$QueryExecutor.han dleSqlException
; Exception ORA-01841: (full) year must be between -4713 and +9999, and not be 0
; java.sql.SQLException;
Wed Oct 02 17:16:42 PKT 2013|SEVERE|QueryId=82;QueryExecutoresecurity.ccs. comp.evtsrcmgt.connector.database.JDBCConnector$Qu eryExecutor@620bcbe1|esecurity.ccs.comp.evtsrcmgt. connector.database.JDBCConnector$QueryExecutor.han dleSqlException
java.sql.SQLException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0

at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:113)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 754)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStateme nt.java:210)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4C Statement.java:963)
at oracle.jdbc.driver.OracleStatement.executeMaybeDes cribe(OracleStatement.java:1074)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescri be(T4CStatement.java:845)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1156)
at oracle.jdbc.driver.OracleStatement.executeQuery(Or acleStatement.java:1315)
at esecurity.ccs.comp.evtsrcmgt.connector.database.JD BCConnector$QueryExecutor.run(JDBCConnector.java:9 16)
at java.lang.Thread.run(Thread.java:722)

Wed Oct 02 17:16:42 PKT 2013|SEVERE|QueryId=82;QueryExecutoresecurity.ccs. comp.evtsrcmgt.connector.database.JDBCConnector$Qu eryExecutor@620bcbe1|esecurity.ccs.comp.evtsrcmgt. connector.database.JDBCConnector$QueryExecutor.han dleSqlException
_status_ =""2"" _error_msg_ =""java.sql.SQLException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0\n""
Wed Oct 02 17:16:42 PKT 2013|INFO|QueryId=82;QueryExecutoresecurity.ccs.co mp.evtsrcmgt.connector.database.JDBCConnector$Quer yExecutor@620bcbe1|esecurity.ccs.comp.audit.AuditL ogger.execute
Audit High:: Call by user System to app DBConnector object DBConnector method ExecuteQueryError client Unknown failed : Error executing query 'with getmachine(machine) as (select /*+ materialize */ MACHINE from v$session where schemaname='SYS' and rownum=1), getversion(banner) as (select /*+ materialize */ banner from v$version where BANNER LIKE 'Oracle%') SELECT OS_USERNAME, USERNAME, USERHOST, TERMINAL, TO_CHAR(EXTENDED_TIMESTAMP ,'YYYY/MM/DD HH24:MI:SS') AS EXTENDEDTIME, TO_CHAR(LOGOFF_TIME ,'YYYY/MM/DD HH24:MI:SS') AS LFTIME, TO_CHAR(TIMESTAMP ,'YYYY/MM/DD HH24:MI:SS') TIMESTAMP, ACTION, ACTION_NAME, SESSIONID, ENTRYID, STATEMENTID, RETURNCODE, OWNER, OBJ_NAME , GLOBAL_UID, SCN, GRANTEE, SQL_BIND, SQL_TEXT,machine as DHN,banner as DB_VERSION FROM SYS.DBA_AUDIT_TRAIL, getmachine,getversion WHERE TIMESTAMP >= TO_TIMESTAMP ('null', 'YYYY/MM/DD HH24:MI:SS.FF6') and rownum <= 2000 ORDER BY TIMESTAMP '. Error message from database is: ORA-01841: (full) year must be between -4713 and +9999, and not be 0

--------------------


Please help asap.


--
sharfuddin
------------------------------------------------------------------------
sharfuddin's Profile: https://forums.netiq.com/member.php?userid=1016
View this thread: https://forums.netiq.com/showthread.php?t=48832