Sorry for the confusion. I got rid of that problem by uninstalling and installing the Report Server . Now end up with the below problem:
The logs are showing Report parameter file : SiteMinder\ProtectedResources.xml not found
Report parameter file : SiteMinder\UserActivity.xml not found.
CA Single Sign-On
Activity by User: Activity by User | | Error: | Task failed. |
| Fatal: | Failed to execute ReportingInstanceEvent. ERROR MESSAGE: SmApiWrappedException:Column 'RPT_INSTANCE_ID' cannot accept a NULL value. |
|
|
Here are the logs:
2017-02-08 12:04:58,995 ERROR [ims.ui] (default task-34) Page cannot be found. Please check the URL. (/iam/siteminder/ui/ca-css/font/ca_sans_web-regular.eot)
2017-02-08 12:04:59,026 ERROR [ims.ui] (default task-35) Page cannot be found. Please check the URL. (/iam/siteminder/ui/ca-css/font/ca_sans_web-bold.eot)
2017-02-08 12:05:03,366 WARN [com.ca.ims.reporting.bo.utils.BOInfoviewUtils] (default task-37) Report parameter file : SiteMinder\ProtectedResources.xml not found. Assuming there is no param XML file associated with this report.
2017-02-08 12:05:07,020 ERROR [com.ca.ims.reporting.utils.ScheduleReport] (Thread-137) ScheduleReport:The report does not exist.
2017-02-08 12:05:07,032 ERROR [com.netegrity.ims.exception.EventExecuteStateException] (Thread-137) Exception: : [facility=6 severity=3 reason=0 status=0 message=Wrapped Exception: Column 'RPT_INSTANCE_ID' cannot accept a NULL value.]
Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)
at com.netegrity.llsdk6.imsimpl.jdbcmanagedobject.JDBCManagedObject.createPersistedObject(JDBCManagedObject.java:223) [imsapi6.jar:]
at com.netegrity.webapp.managedobject.rptinstance.RptInstanceManagedObject.createPersistedObject(RptInstanceManagedObject.java:129) [user_console.jar:]
at com.netegrity.webapp.page.reporting.ReportingInstanceEvent.createObject(ReportingInstanceEvent.java:189) [user_console.jar:]
at com.netegrity.webapp.page.reporting.ReportingInstanceEvent.longRunningEventExecute(ReportingInstanceEvent.java:119) [user_console.jar:]
at com.netegrity.ims.AbstractLongRunningEvent$RunningEvent.run(AbstractLongRunningEvent.java:293) [ims.jar:]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_31]
Caused by: java.sql.SQLException: Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 16 more
Caused by: ERROR 23502: Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 10 more
2017-02-08 12:05:07,050 ERROR [com.netegrity.ims.exception.EventExecuteStateException] (Thread-137) Execution of event: ReportingInstanceEvent failed. Exception encountered: SmApiWrappedException:Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
2017-02-08 12:05:07,050 ERROR [ims.tmt.events] (Thread-137) Failed to execute ReportingInstanceEvent.
ERROR MESSAGE:
SmApiWrappedException:Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
2017-02-08 12:05:07,050 ERROR [ims.tmt.events] (Thread-137) Error during event execution [1c6ec927-3f57d19d-0011145d-d057e1de] ReportingInstanceEvent
2017-02-08 12:05:07,102 WARN [ims.tmt.eventlistener] (Thread-707 (HornetQ-client-global-threads-2793356)) Evt IMTaskEvent:a2426010-4b2b9743-9ee7ed5c-c94bc3 is invalid.
2017-02-08 12:06:13,194 WARN [com.ca.ims.reporting.bo.utils.BOInfoviewUtils] (default task-40) Report parameter file : SiteMinder\UserActivity.xml not found. Assuming there is no param XML file associated with this report.
2017-02-08 12:06:15,859 ERROR [com.ca.ims.reporting.utils.ScheduleReport] (Thread-139) ScheduleReport:The report does not exist.
2017-02-08 12:06:15,870 ERROR [com.netegrity.ims.exception.EventExecuteStateException] (Thread-139) Exception: : [facility=6 severity=3 reason=0 status=0 message=Wrapped Exception: Column 'RPT_INSTANCE_ID' cannot accept a NULL value.]
Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)
at com.netegrity.llsdk6.imsimpl.jdbcmanagedobject.JDBCManagedObject.createPersistedObject(JDBCManagedObject.java:223) [imsapi6.jar:]
at com.netegrity.webapp.managedobject.rptinstance.RptInstanceManagedObject.createPersistedObject(RptInstanceManagedObject.java:129) [user_console.jar:]
at com.netegrity.webapp.page.reporting.ReportingInstanceEvent.createObject(ReportingInstanceEvent.java:189) [user_console.jar:]
at com.netegrity.webapp.page.reporting.ReportingInstanceEvent.longRunningEventExecute(ReportingInstanceEvent.java:119) [user_console.jar:]
at com.netegrity.ims.AbstractLongRunningEvent$RunningEvent.run(AbstractLongRunningEvent.java:293) [ims.jar:]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_31]
Caused by: java.sql.SQLException: Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 16 more
Caused by: ERROR 23502: Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 10 more
2017-02-08 12:06:15,883 ERROR [com.netegrity.ims.exception.EventExecuteStateException] (Thread-139) Execution of event: ReportingInstanceEvent failed. Exception encountered: SmApiWrappedException:Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
2017-02-08 12:06:15,883 ERROR [ims.tmt.events] (Thread-139) Failed to execute ReportingInstanceEvent.
ERROR MESSAGE:
SmApiWrappedException:Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
2017-02-08 12:06:15,883 ERROR [ims.tmt.events] (Thread-139) Error during event execution [1c6fd631-3f57d19d-012b7b23-c5c52453] ReportingInstanceEvent
2017-02-08 12:06:15,939 WARN [ims.tmt.eventlistener] (Thread-707 (HornetQ-client-global-threads-2793356)) Evt IMTaskEvent:59f8a9ab-b4ea4e8f-c8a79457-2dbf178 is invalid.
2017-02-08 12:23:29,167 WARN [com.ca.ims.reporting.bo.utils.BOInfoviewUtils] (default task-43) Report parameter file : SiteMinder\ResourceActivity.xml not found. Assuming there is no param XML file associated with this report.
2017-02-08 12:23:33,927 ERROR [com.ca.ims.reporting.utils.ScheduleReport] (Thread-141) ScheduleReport:The report does not exist.
2017-02-08 12:23:33,939 ERROR [com.netegrity.ims.exception.EventExecuteStateException] (Thread-141) Exception: : [facility=6 severity=3 reason=0 status=0 message=Wrapped Exception: Column 'RPT_INSTANCE_ID' cannot accept a NULL value.]
Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)
at com.netegrity.llsdk6.imsimpl.jdbcmanagedobject.JDBCManagedObject.createPersistedObject(JDBCManagedObject.java:223) [imsapi6.jar:]
at com.netegrity.webapp.managedobject.rptinstance.RptInstanceManagedObject.createPersistedObject(RptInstanceManagedObject.java:129) [user_console.jar:]
at com.netegrity.webapp.page.reporting.ReportingInstanceEvent.createObject(ReportingInstanceEvent.java:189) [user_console.jar:]
at com.netegrity.webapp.page.reporting.ReportingInstanceEvent.longRunningEventExecute(ReportingInstanceEvent.java:119) [user_console.jar:]
at com.netegrity.ims.AbstractLongRunningEvent$RunningEvent.run(AbstractLongRunningEvent.java:293) [ims.jar:]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_31]
Caused by: java.sql.SQLException: Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 16 more
Caused by: ERROR 23502: Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 10 more
2017-02-08 12:23:33,947 ERROR [com.netegrity.ims.exception.EventExecuteStateException] (Thread-141) Execution of event: ReportingInstanceEvent failed. Exception encountered: SmApiWrappedException:Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
2017-02-08 12:23:33,947 ERROR [ims.tmt.events] (Thread-141) Failed to execute ReportingInstanceEvent.
ERROR MESSAGE:
SmApiWrappedException:Column 'RPT_INSTANCE_ID' cannot accept a NULL value.
2017-02-08 12:23:33,947 ERROR [ims.tmt.events] (Thread-141) Error during event execution [1c7facbf-3f57d19d-009f8cc3-fe2146d6] ReportingInstanceEvent
2017-02-08 12:23:33,980 WARN [ims.tmt.eventlistener] (Thread-718 (HornetQ-client-global-threads-2793356)) Evt IMTaskEvent:18f3b403-2fe72b8a-163678af-80b2215 is invalid.