Symantec Access Management

Version Details:
CABI version is 4.1 SP3

Report Server is 12.52.200.6411

PS Version 12.52.0201.6565

When running any report in WAM UI, we receive the error “The report server connection settings are invalid . Unable to continue”.

And the Server.log file shows, Language.xml is not found. Could someone help us in resolving this issue? 

Please find the Server.log below:

2017-01-27 17:40:22,880 ERROR [ims.ui] (default task-6) Page cannot be found. Please check the URL. (/iam/siteminder/ui/ca-css/font/ca_sans_web-regular.eot)
2017-01-27 17:40:22,880 ERROR [ims.ui] (default task-7) Page cannot be found. Please check the URL. (/iam/siteminder/ui/ca-css/font/ca_sans_web-bold.eot)
2017-01-27 17:40:30,043 INFO [com.ca.siteminder.uiagent.Connector] (default task-10) Establishing agent API connection for localhost
2017-01-27 17:40:59,680 ERROR [com.crystaldecisions.sdk.framework.LocaleHelper] (default task-54) LanguagePacks.xml not found:C:\Program Files\Business Objects\LanguagePacks.xml: java.io.FileNotFoundException
at com.businessobjects.foundation.language.LocaleHelper.getInstalledLocales(LocaleHelper.java:127) [logging.jar:]
at com.businessobjects.foundation.language.LangMgr.getInstalledLocales(LangMgr.java:39) [logging.jar:]
at com.businessobjects.foundation.exception.ExceptionWorker.getSupportedLanguages(ExceptionWorker.java:356) [logging.jar:]
at com.businessobjects.foundation.exception.ExceptionWorker.getErrorMessages(ExceptionWorker.java:299) [logging.jar:]
at com.businessobjects.foundation.exception.ExceptionWorker.<init>(ExceptionWorker.java:132) [logging.jar:]
at com.businessobjects.foundation.exception.CheckedException.<init>(CheckedException.java:50) [logging.jar:]
at com.crystaldecisions.celib.exception.CEException.<init>(CEException.java:92) [celib.jar:12.3.0.601]
at com.crystaldecisions.celib.exception.CEException.<init>(CEException.java:122) [celib.jar:12.3.0.601]
at com.crystaldecisions.celib.exception.AbstractException.<init>(AbstractException.java:109) [celib.jar:12.3.0.601]
at com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException.<init>(OCAFrameworkException.java:103) [cecore.jar:12.3.0.601]
at com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError.<init>(OCAFrameworkException.java:196) [cecore.jar:12.3.0.601]
at com.crystaldecisions.enterprise.ocaframework.RawAPSDirectory.find(RawAPSDirectory.java:252) [cecore.jar:12.3.0.601]
at com.crystaldecisions.enterprise.ocaframework.APSServerHandler.buildAPSClusterInfo(APSServerHandler.java:955) [cecore.jar:12.3.0.601]
at com.crystaldecisions.enterprise.ocaframework.APSServerHandler.buildServerInfo(APSServerHandler.java:359) [cecore.jar:12.3.0.601]
at com.crystaldecisions.enterprise.ocaframework.ServerController.redirectServer(ServerController.java:549) [cecore.jar:12.3.0.601]
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.redirectServer(ServiceMgr.java:1099) [cecore.jar:12.3.0.601]
at com.crystaldecisions.enterprise.ocaframework.ManagedSessions.get(ManagedSessions.java:256) [cecore.jar:12.3.0.601]
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService(ServiceMgr.java:702) [cecore.jar:12.3.0.601]
at com.crystaldecisions.sdk.occa.security.internal.LogonService.ensureServiceStub(LogonService.java:507) [cecore.jar:12.3.0.601]
at com.crystaldecisions.sdk.occa.security.internal.LogonService.doUserLogon(LogonService.java:654) [cecore.jar:12.3.0.601]
at com.crystaldecisions.sdk.occa.security.internal.LogonService.userLogon(LogonService.java:295) [cecore.jar:12.3.0.601]
at com.crystaldecisions.sdk.occa.security.internal.SecurityMgr.userLogon(SecurityMgr.java:166) [cecore.jar:12.3.0.601]
at com.crystaldecisions.sdk.framework.internal.SessionMgr.logon(SessionMgr.java:425) [cesession.jar:12.3.0.601]
at com.ca.ims.reporting.bo.utils.BOInfoviewUtils.login(BOInfoviewUtils.java:199) [suitereporting.jar:]
at com.netegrity.webapp.page.reporting.ReportServerSettingsCache.getNewReportServerSession(ReportServerSettingsCache.java:109) [user_console.jar:]
at com.netegrity.webapp.page.reporting.ReportServerSettingsCache.getBOInfoviewUtilsInstance(ReportServerSettingsCache.java:52) [user_console.jar:]
at com.netegrity.webapp.page.reporting.ReportingUtil.<init>(ReportingUtil.java:75) [user_console.jar:]
at com.netegrity.webapp.page.reporting.pages.ParameterHelper.init(ParameterHelper.java:336) [user_console.jar:]
at com.netegrity.webapp.page.reporting.pages.ParameterHelper.<init>(ParameterHelper.java:83) [user_console.jar:]
at com.netegrity.webapp.page.reporting.pages.ReportParameterDisplaySearchPage.setParameterHelper(ReportParameterDisplaySearchPage.java:125) [user_console.jar:]
at com.netegrity.webapp.page.reporting.pages.ReportParameterDisplaySearchPage.init(ReportParameterDisplaySearchPage.java:114) [user_console.jar:]
at com.netegrity.webapp.page.TaskController.setSearchPage(TaskController.java:1614) [user_console.jar:]
at com.netegrity.webapp.page.TaskController.init(TaskController.java:361) [user_console.jar:]
at com.netegrity.webapp.page.TaskController.createTaskController(TaskController.java:2355) [user_console.jar:]
at com.netegrity.webapp.page.TaskController.createTaskController(TaskController.java:2343) [user_console.jar:]
at com.netegrity.webapp.page.TaskController.createTaskControllerByTaskTag(TaskController.java:2200) [user_console.jar:]
at com.netegrity.taglib.skin.TagUtilLocal.update(TagUtilLocal.java:241) [user_console.jar:]
at com.netegrity.taglib.skin.UpdateTag.doEndTag(UpdateTag.java:145) [user_console.jar:]
at org.apache.jsp.app.ui7.index_jsp._jspx_meth_skin_005fupdate_005f0(index_jsp.java:1738)
at org.apache.jsp.app.ui7.index_jsp._jspService(index_jsp.java:191)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:69) [jastow-1.0.0.Final.jar:1.0.0.Final]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:366) [jastow-1.0.0.Final.jar:1.0.0.Final]
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:326) [jastow-1.0.0.Final.jar:1.0.0.Final]
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259) [jastow-1.0.0.Final.jar:1.0.0.Final]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:82) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchToPath(ServletInitialHandler.java:192) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.spec.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:160) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at com.netegrity.webapp.filter.ConsolePageFilter.doFilter(ConsolePageFilter.java:531) [user_console.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at com.netegrity.webapp.page.jsf.FacesFilter.doFilter2(FacesFilter.java:180) [user_console.jar:]
at com.netegrity.webapp.page.jsf.FacesFilter.doFilter(FacesFilter.java:151) [user_console.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:147) [tomahawk-1.1.5.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at com.netegrity.webapp.authentication.FrameworkLoginFilter.doFilter(FrameworkLoginFilter.java:322) [user_console.jar:]
at com.ca.siteminder.webadmin.configuration.ui.servlet.SiteMinderLoginFilter.doFilter(SiteMinderLoginFilter.java:457) [webadmin-configuration.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at com.netegrity.webapp.filter.LocaleFilter.doFilter(LocaleFilter.java:100) [user_console.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at com.netegrity.webapp.filter.ClientExtractFilter.doFilter(ClientExtractFilter.java:35) [user_console.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at com.netegrity.webapp.filter.SessionFilter.doFilter(SessionFilter.java:103) [user_console.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:63) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:247) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:76) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:166) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:197) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:759) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_31]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_31]

2017-01-27 17:41:00,009 ERROR [com.businessobjects.foundation.exception.ExceptionWorker] (default task-54) getErrorMessage(): cannot obtain installed locales
2017-01-27 17:41:00,024 ERROR [com.crystaldecisions.sdk.framework.LocaleHelper] (default task-54) LanguagePacks.xml not found:C:\Program Files\Business Objects\LanguagePacks.xml: java.io.FileNotFoundException
at com.businessobjects.foundation.language.LocaleHelper.getInstalledLocales(LocaleHelper.java:127) [logging.jar:]
at com.businessobjects.foundation.language.LangMgr.getInstalledLocales(LangMgr.java:39) [logging.jar:]
at com.businessobjects.foundation.exception.ExceptionWorker.getSupportedLanguages(ExceptionWorker.java:356) [logging.jar:]
at com.businessobjects.foundation.exception.ExceptionWorker.getErrorMessages(ExceptionWorker.java:299) [logging.jar:]
at com.businessobjects.foundation.exception.ExceptionWorker.<init>(ExceptionWorker.java:132) [logging.jar:]
at com.businessobjects.foundation.exception.CheckedException.<init>(CheckedException.java:50) [logging.jar:]
at com.crystaldecisions.celib.exception.CEException.<init>(CEException.java:92) [celib.jar:12.3.0.601]
at com.crystaldecisions.celib.exception.AbstractException.<init>(AbstractException.java:83) [celib.jar:12.3.0.601]
at com.crystaldecisions.sdk.exception.SDKException.<init>(SDKException.java:152) [cecore.jar:12.3.0.601]
at com.crystaldecisions.sdk.exception.SDKException$OCAFramework.<init>(SDKException.java:246) [cecore.jar:12.3.0.601]
at com.crystaldecisions.sdk.exception.SDKException.map(SDKException.java:214) [cecore.jar:12.3.0.601]
at com.crystaldecisions.sdk.occa.security.internal.LogonService.ensureServiceStub(LogonService.java:550) [cecore.jar:12.3.0.601]
at com.crystaldecisions.sdk.occa.security.internal.LogonService.doUserLogon(LogonService.java:654) [cecore.jar:12.3.0.601]
at com.crystaldecisions.sdk.occa.security.internal.LogonService.userLogon(LogonService.java:295) [cecore.jar:12.3.0.601]
at com.crystaldecisions.sdk.occa.security.internal.SecurityMgr.userLogon(SecurityMgr.java:166) [cecore.jar:12.3.0.601]
at com.crystaldecisions.sdk.framework.internal.SessionMgr.logon(SessionMgr.java:425) [cesession.jar:12.3.0.601]
at com.ca.ims.reporting.bo.utils.BOInfoviewUtils.login(BOInfoviewUtils.java:199) [suitereporting.jar:]
at com.netegrity.webapp.page.reporting.ReportServerSettingsCache.getNewReportServerSession(ReportServerSettingsCache.java:109) [user_console.jar:]
at com.netegrity.webapp.page.reporting.ReportServerSettingsCache.getBOInfoviewUtilsInstance(ReportServerSettingsCache.java:52) [user_console.jar:]
at com.netegrity.webapp.page.reporting.ReportingUtil.<init>(ReportingUtil.java:75) [user_console.jar:]
at com.netegrity.webapp.page.reporting.pages.ParameterHelper.init(ParameterHelper.java:336) [user_console.jar:]
at com.netegrity.webapp.page.reporting.pages.ParameterHelper.<init>(ParameterHelper.java:83) [user_console.jar:]
at com.netegrity.webapp.page.reporting.pages.ReportParameterDisplaySearchPage.setParameterHelper(ReportParameterDisplaySearchPage.java:125) [user_console.jar:]
at com.netegrity.webapp.page.reporting.pages.ReportParameterDisplaySearchPage.init(ReportParameterDisplaySearchPage.java:114) [user_console.jar:]
at com.netegrity.webapp.page.TaskController.setSearchPage(TaskController.java:1614) [user_console.jar:]
at com.netegrity.webapp.page.TaskController.init(TaskController.java:361) [user_console.jar:]
at com.netegrity.webapp.page.TaskController.createTaskController(TaskController.java:2355) [user_console.jar:]
at com.netegrity.webapp.page.TaskController.createTaskController(TaskController.java:2343) [user_console.jar:]
at com.netegrity.webapp.page.TaskController.createTaskControllerByTaskTag(TaskController.java:2200) [user_console.jar:]
at com.netegrity.taglib.skin.TagUtilLocal.update(TagUtilLocal.java:241) [user_console.jar:]
at com.netegrity.taglib.skin.UpdateTag.doEndTag(UpdateTag.java:145) [user_console.jar:]
at org.apache.jsp.app.ui7.index_jsp._jspx_meth_skin_005fupdate_005f0(index_jsp.java:1738)
at org.apache.jsp.app.ui7.index_jsp._jspService(index_jsp.java:191)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:69) [jastow-1.0.0.Final.jar:1.0.0.Final]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:366) [jastow-1.0.0.Final.jar:1.0.0.Final]
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:326) [jastow-1.0.0.Final.jar:1.0.0.Final]
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259) [jastow-1.0.0.Final.jar:1.0.0.Final]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:82) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchToPath(ServletInitialHandler.java:192) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.spec.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:160) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at com.netegrity.webapp.filter.ConsolePageFilter.doFilter(ConsolePageFilter.java:531) [user_console.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at com.netegrity.webapp.page.jsf.FacesFilter.doFilter2(FacesFilter.java:180) [user_console.jar:]
at com.netegrity.webapp.page.jsf.FacesFilter.doFilter(FacesFilter.java:151) [user_console.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:147) [tomahawk-1.1.5.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at com.netegrity.webapp.authentication.FrameworkLoginFilter.doFilter(FrameworkLoginFilter.java:322) [user_console.jar:]
at com.ca.siteminder.webadmin.configuration.ui.servlet.SiteMinderLoginFilter.doFilter(SiteMinderLoginFilter.java:457) [webadmin-configuration.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at com.netegrity.webapp.filter.LocaleFilter.doFilter(LocaleFilter.java:100) [user_console.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at com.netegrity.webapp.filter.ClientExtractFilter.doFilter(ClientExtractFilter.java:35) [user_console.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at com.netegrity.webapp.filter.SessionFilter.doFilter(SessionFilter.java:103) [user_console.jar:]
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:63) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:247) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:76) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:166) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:197) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:759) [undertow-core-1.1.0.Final.jar:1.1.0.Final]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_31]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_31]

2017-01-27 17:41:00,274 ERROR [com.businessobjects.foundation.exception.ExceptionWorker] (default task-54) getErrorMessage(): cannot obtain installed locales
2017-01-27 17:41:00,290 ERROR [com.crystaldecisions.sdk.occa.security.internal.LogonService] (default task-54) Communication error occurred when trying to connect to server 192.168.46.100 (FWM 01009) attempt to establish connection failed: java.net.ConnectException: Connection refused: connect
2017-01-27 17:41:00,290 ERROR [com.crystaldecisions.sdk.occa.security.internal.LogonService] (default task-54) Is the CMS alive? Ensure the CMS supports SDK version 1200
2017-01-27 17:41:00,290 ERROR [com.ca.ims.reporting.bo.utils.BOInfoviewUtils] (default task-54) Error in BOInfoviewUtils.login() Communication error occurred when trying to connect to server 192.168.46.100 (FWM 01009)

Hi,

Please first make sure Report Server CMS is up and running.

What is 192.168.46.100 referring to? Are both policy server and report server on the same machine?

Is the Report working fine before? If it is, any changes prior you encounter the error?

If this is new setup and never work before, I think is best to review the Report server install log (<Report server install path>/CA_Business_Intelligence_InstallLog), configuration log (<Report server install path>/install_config_info folder) to check if there was any error reported during installation and configuration.

Regards,

Kar Meng

Hi Kar Meng,

192.168.46.100 is the ReportServer Machine. 

Both are running on a different machines.

This is the first time I have installed RS and didnt find any errors in the installation logs. But BW Publisher Service is not running  on this machine.

Any pointers on how can we debug it further?

Thanks,
Sankar.

Hi Sankar,

1. In your report server box, did you find all service in Central Configuration Manager (Apache Tomcat and Server Intelligence Agent Services) running?

2. From policy server box, try telnet to the report server box with port 6400 and check if it able to connect.

ie:

telnet SERVERNAME_WITH_CMS 6400

3. At policy server side, did xpsregclient -report run successfully?

ie:

XPSRegClient client_name[:passphrase] -report

4. At Report server side, did regreportserver run succes?

ie:

regreportserver.bat -pshost host_name -client client_name -passphrase passphrase -psport portnum -fipsmode 0|1

5. When configure report server connection (Report Server Host field) in WAMUI, are you using host name or ip address? If you are using host name, try add host name into host file and check if that make different.

Regards,

Kar Meng

Hello Kar Mang,

1) Yes ..Both the services are running ( the console shows BW Publisher Service is stopped, Tried to run this but not able to start it)

2) Telnet was successful 

3) and 4) report server registration was successful. Trusted host entry was also generated

5) Tried this earlier and now also but of no use. 

Hi Sankar,

Thanks for your update.

From the screenshot that you provided, it seems report server connection is not an issue. Based on your initial issue description, I expect you have following when click on "Activity by User" report.

Audit type of reports involved audit store.

If you access Reports -> Analysis -> Resource Based -> Protected Resources

Are you getting the report generate? My intention is to check if the report server able to generate report that not involve audit store.

Thank you.

Regards,

Kar Meng

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. (&#47;iam&#47;siteminder&#47;ui&#47;ca-css&#47;font&#47;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. (&#47;iam&#47;siteminder&#47;ui&#47;ca-css&#47;font&#47;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.

Hi Sankar, 

I understand , after creating the ODBC connection from  Report Server to the AuditDB server we were able to solve the issue.

Regards,

Leo Joseph.