Symantec Access Management

 View Only
  • 1.  SMPS and ReportServer Configuration Issue - LanguagePacks.xml not found

    Posted Jan 27, 2017 09:13 AM

    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)

     



  • 2.  Re: SMPS and ReportServer Configuration Issue - LanguagePacks.xml not found

    Posted Jan 30, 2017 07:03 PM

    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



  • 3.  Re: SMPS and ReportServer Configuration Issue - LanguagePacks.xml not found

    Posted Jan 31, 2017 05:45 AM

    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.



  • 4.  Re: SMPS and ReportServer Configuration Issue - LanguagePacks.xml not found

    Posted Feb 06, 2017 08:34 PM

    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



  • 5.  Re: SMPS and ReportServer Configuration Issue - LanguagePacks.xml not found

    Posted Feb 07, 2017 05:27 AM

    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. 

     

    Agent details are missing in this image. The other image (got that from CA communities) that I have uploaded is showing the agent name details



  • 6.  Re: SMPS and ReportServer Configuration Issue - LanguagePacks.xml not found

    Posted Feb 07, 2017 08:27 PM

    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



  • 7.  Re: SMPS and ReportServer Configuration Issue - LanguagePacks.xml not found

    Posted Feb 08, 2017 01:53 AM

    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
    ErrorError:Task failed.
    FatalFatal:Failed to execute ReportingInstanceEvent. ERROR MESSAGE: SmApiWrappedException:Column 'RPT_INSTANCE_ID' cannot accept a NULL value.

     

     

     

     

     

    Resource Activity: Resource Activity
    ErrorError:Task failed.
    FatalFatal: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.



  • 8.  Re: SMPS and ReportServer Configuration Issue - LanguagePacks.xml not found
    Best Answer

    Posted Jun 08, 2017 03:25 AM

    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.