1 Reply Latest reply: May 18, 2014 10:09 AM by Santosh Pradhan RSS

    Collector unable to start

    Santosh Pradhan

      Hello,

       

      Currently we have implemented AVDF 12.1.1.3.0.

      Earlier we had collected audit records for sys.aud$. Collector was working fine. Later we tried to collect data of sys auditing from audit trail location. But the collector wouldnt come up. So we removed the agent from host and installled again. Now the collector for directory doesnt come up. But the collector for sys.aud$ which was previously working comes up and then again goes down. We are unable to find out the exact problem. The following is the error which we re getting in log files :

       

      [2014-05-16T19:38:15.621+05:30] [collfwk] [ERROR] [] [] [tid: 82] [ecid: 172.18.1.99:88710:1400249293931:6,0] JDBCBatchingFlush : flush : Error occured. Mess

      age: ORA-01400: cannot insert NULL into ("AVSYS"."EVENT_LOG_TEMP"."ALERT_RAISED")[[

       

       

      ]]

      [2014-05-16T19:38:15.625+05:30] [collfwk] [ERROR] [] [] [tid: 82] [ecid: 172.18.1.99:88710:1400249293931:6,0] OAV-8018: Error sending records to serverCollec

      tionController : release : AuditException occured from flush. [[

      Error sending records to server

              at oracle.av.platform.agent.collfwk.impl.batch.JDBCBatchingFlush.flush(JDBCBatchingFlush.java:171)

              at oracle.av.platform.agent.collfwk.impl.batch.ArrayBasedBatch.flush(ArrayBasedBatch.java:174)

              at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.release(CollectionController.java:753)

              at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.run(CollectionController.java:373)

              at java.lang.Thread.run(Thread.java:744)

      Nested Exception:

      java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("AVSYS"."EVENT_LOG_TEMP"."ALERT_RAISED")

       

       

              at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)

              at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

              at java.lang.reflect.Method.invoke(Method.java:606)

              at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:230)

              at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:124)

              at com.sun.proxy.$Proxy42.executeBatch(Unknown Source)

              at oracle.av.platform.agent.collfwk.impl.batch.JDBCBatchingFlush.flush(JDBCBatchingFlush.java:147)

              at oracle.av.platform.agent.collfwk.impl.batch.ArrayBasedBatch.flush(ArrayBasedBatch.java:174)

              at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.release(CollectionController.java:753)

              at oracle.av.platform.agent.collfwk.impl.controller.CollectionController.run(CollectionController.java:373)

              at java.lang.Thread.run(Thread.java:744)

       

       

      ]]

       

       

      Any suggestios, Help is highly apppreciated.

      Thanks