Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Data Module shows no data

    Posted Mon October 26, 2020 01:22 PM

    Data Module shows no data

    I am extracting 3 views

    The come from a schema of a PostgreSql Data base

    There are 21 fields most of them are VARCHAR

    There 2 fields that are not Varchae the first is INT8 and Int4

    When I try to view the grid I get a message :

    You can't preview this data

    The data contains errors. Please resolve them, and try again.

    View details

    Try again

    How Ever If I remove 3 fields (any 3 fields ) it does display!

    I assume it is a setup issue – however I can not find any limitation that can cause this ?

    Any advise will be received happily

    ​

    ------------------------------
    Barry Morris
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Data Module shows no data

    Posted Mon October 26, 2020 01:41 PM
    What happens when you bring only one of error field in Data Module?

    You can also create a Native SQL Option using the view and see that fails. You can do cast in Native SQL and see if type incompatibility is causing the issue or something else.

    ------------------------------
    Buddhi Gupta
    ------------------------------

    Original Message


  • 3.  RE: Data Module shows no data

    Posted Tue October 27, 2020 04:10 PM

    One filed or 5 works fine

    It doesn't matter which fields 3 I remove it works OK

    The SQL is the same with all fields or with one….
    I cannot find any incompatibility in the SQL



    ------------------------------
    Barry Morris
    ------------------------------

    Original Message


  • 4.  RE: Data Module shows no data

    Posted Mon October 26, 2020 02:41 PM
    What's the error you see when you click on view details?  There should be errors logged in cognosserver.log and the xqe log files.

    ------------------------------
    IAN HENDERSON
    ------------------------------

    Original Message


  • 5.  RE: Data Module shows no data

    Posted Tue October 27, 2020 04:12 PM

    There is no error message

    There is no error in the log

    Only cannot display data – and Unknown error



    ------------------------------
    Barry Morris
    ------------------------------

    Original Message


  • 6.  RE: Data Module shows no data

    Posted Wed October 28, 2020 04:08 PM

    When you click on view details there should be a message.  

    You will probably need to contact customer support for this.



    ------------------------------
    IAN HENDERSON
    ------------------------------

    Original Message


  • 7.  RE: Data Module shows no data

    Posted Tue November 03, 2020 05:38 PM
    This is what I copied from cognosserver.log  

    2020-11-04T00:01:27.555+0200  ERROR  com.ibm.ba.glass.exception.GlassExceptionMapper         [Default Executor-thread-811]        y8s88jq8M2qwjsCwyy28qd8Gl4l4Mw9h8vCMhshy                          y8s88jq8M2qwjsCwyy28qd8Gl4l4Mw9h8vCMhshy          NA          130.39.120.65     51571    LoginUser-149614924                NA          /v1/plugins/themes/current/favicon       ui/v1      1348       null

    java.lang.NullPointerException: null

                    at com.ibm.bi.platform.commons.http.BaseHttpClientConfig.<init>(BaseHttpClientConfig.java:130) ~[commons-core-11.1.6-20031121.jar:11.1.6-20031121]

                    at com.ibm.bi.rest.RESTClientConfig.<init>(RESTClientConfig.java:57) ~[commons-core-11.1.6-20031121.jar:11.1.6-20031121]

                    at com.ibm.bi.rest.RESTClientFactory.getClient(RESTClientFactory.java:51) ~[commons-core-11.1.6-20031121.jar:11.1.6-20031121]

                    at com.ibm.bi.glass.foundation.utils.RequestUtils.createRESTClient(RequestUtils.java:87) ~[glass-framework.war:?]

                    at com.ibm.bi.glass.foundation.utils.CARequestUtils.getJson(CARequestUtils.java:37) ~[glass-framework.war:?]

                    at com.ibm.bi.glass.services.UserProfileSettings.getAccountData(UserProfileSettings.java:87) ~[glass-framework.war:?]

                    at com.ibm.bi.glass.services.UserProfileSettings.getCurrentUserTenantID(UserProfileSettings.java:64) ~[glass-framework.war:?]

                    at com.ibm.bi.glass.services.UserProfileSettings$Proxy$_$$_WeldClientProxy.getCurrentUserTenantID(Unknown Source) ~[glass-framework.war:?]

                    at com.ibm.bi.extension.cache.CACacheKeyGenerator.getCacheKey(CACacheKeyGenerator.java:34) ~[glass-framework.war:?]

                    at com.ibm.ba.glass.loader.FSCurrentThemeLoader.getCacheArtifact(FSCurrentThemeLoader.java:134) ~[ba_glass_server_core-11.1.6-2004161031.jar:11.1.6-2004161031]

                    at com.ibm.ba.glass.loader.FSCurrentThemeLoader.getThemeFavIconPath(FSCurrentThemeLoader.java:111) ~[ba_glass_server_core-11.1.6-2004161031.jar:11.1.6-2004161031]

                    at com.ibm.ba.glass.loader.FSCurrentThemeLoader$Proxy$_$$_WeldClientProxy.getThemeFavIconPath(Unknown Source) ~[ba_glass_server_core-11.1.6-2004161031.jar:11.1.6-2004161031]

                    at com.ibm.bi.extension.loader.CACurrentThemeLoader.getThemeFavIconResource(CACurrentThemeLoader.java:92) ~[glass-framework.war:?]

                    at com.ibm.bi.extension.loader.CACurrentThemeLoader.getThemeFavIconResource(CACurrentThemeLoader.java:35) ~[glass-framework.war:?]

                    at com.ibm.bi.extension.loader.CACurrentThemeLoader$Proxy$_$$_WeldClientProxy.getThemeFavIconResource(Unknown Source) ~[glass-framework.war:?]

                    at com.ibm.ba.glass.endpoints.CurrentThemeResource.getFavicon(CurrentThemeResource.java:118) ~[ba_glass_server_core-11.1.6-2004161031.jar:11.1.6-2004161031]

                    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0]

                    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90) ~[?:1.8.0]

                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) ~[?:1.8.0]

                    at java.lang.reflect.Method.invoke(Method.java:508) ~[?:1.8.0]

                    at com.ibm.ws.jaxrs20.cdi.component.JaxRsFactoryImplicitBeanCDICustomizer.serviceInvoke(JaxRsFactoryImplicitBeanCDICustomizer.java:304) ~[?:?]

                    at com.ibm.ws.jaxrs20.server.LibertyJaxRsServerFactoryBean.performInvocation(LibertyJaxRsServerFactoryBean.java:641) ~[?:?]

                    at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.performInvocation(LibertyJaxRsInvoker.java:160) ~[?:?]

                    at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) ~[com.ibm.ws.jaxrs.2.0.common_1.0.35.jar:?]

                    at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:273) ~[?:?]

                    at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:191) [com.ibm.ws.jaxrs.2.0.common_1.0.35.jar:?]

                    at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:444) [com.ibm.ws.jaxrs.2.0.server_1.0.35.jar:?]

                    at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:101) [com.ibm.ws.jaxrs.2.0.common_1.0.35.jar:?]

                    at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:61) [com.ibm.ws.jaxrs.2.0.common_1.0.35.jar:?]

                    at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:99) [com.ibm.ws.jaxrs.2.0.common_1.0.35.jar:?]

                    at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:309) [com.ibm.ws.jaxrs.2.0.common_1.0.35.jar:?]

                    at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:124) [com.ibm.ws.jaxrs.2.0.common_1.0.35.jar:?]

                    at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:271) [com.ibm.ws.jaxrs.2.0.common_1.0.35.jar:?]

                    at com.ibm.ws.jaxrs20.endpoint.AbstractJaxRsWebEndpoint.invoke(AbstractJaxRsWebEndpoint.java:134) [com.ibm.ws.jaxrs.2.0.common_1.0.35.jar:?]

                    at com.ibm.websphere.jaxrs.server.IBMRestServlet.handleRequest(IBMRestServlet.java:146) [com.ibm.ws.jaxrs.2.0.server_1.0.35.jar:?]

                    at com.ibm.websphere.jaxrs.server.IBMRestServlet.doGet(IBMRestServlet.java:112) [com.ibm.ws.jaxrs.2.0.server_1.0.35.jar:?]

                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) [com.ibm.websphere.javaee.servlet.3.1_1.0.35.jar:?]

                    at com.ibm.websphere.jaxrs.server.IBMRestServlet.service(IBMRestServlet.java:96) [com.ibm.ws.jaxrs.2.0.server_1.0.35.jar:?]

                    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:729) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:426) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:182) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:78) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1001) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1139) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1010) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1410) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:171) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.bi.platform.commons.web.BIProxyBase.local(BIProxyBase.java:223) [web-filters-11.1.6-20031715.jar:11.1.6-20031715]

                    at com.ibm.bi.platform.commons.web.BIServiceProxy.proxyRequest(BIServiceProxy.java:85) [web-filters-11.1.6-20031715.jar:11.1.6-20031715]

                    at sun.reflect.GeneratedMethodAccessor738.invoke(Unknown Source) ~[?:?]

                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) ~[?:1.8.0]

                    at java.lang.reflect.Method.invoke(Method.java:508) ~[?:1.8.0]

                    at org.tuckey.web.filters.urlrewrite.Run.invokeRunMethod(Run.java:419) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.Run.execute(Run.java:537) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.Run.execute(Run.java:495) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.RuleBase.matchesBase(RuleBase.java:224) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.NormalRule.matches(NormalRule.java:92) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.RuleChain.doRuleProcessing(RuleChain.java:83) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.RuleChain.process(RuleChain.java:137) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:144) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at com.ibm.bi.platform.commons.web.filters.BIRewriteFilter.doFilter(BIRewriteFilter.java:84) [web-filters-11.1.6-20031715.jar:11.1.6-20031715]

                    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1001) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1139) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1010) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1410) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:171) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:213) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389) [urlrewritefilter-4.0.5.jar:4.0.5]

                    at com.ibm.bi.platform.commons.web.filters.BIRewriteFilter.doFilter(BIRewriteFilter.java:84) [web-filters-11.1.6-20031715.jar:11.1.6-20031715]

                    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.bi.platform.commons.web.filters.CompressionFilter.doFilter(CompressionFilter.java:94) [web-filters-11.1.6-20031715.jar:11.1.6-20031715]

                    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.bi.platform.commons.web.filters.LoggingContextFilter.doFilter(LoggingContextFilter.java:70) [web-filters-11.1.6-20031715.jar:11.1.6-20031715]

                    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.bi.platform.commons.web.filters.BISecurityFilter.doFilter(BISecurityFilter.java:151) [web-filters-11.1.6-20031715.jar:11.1.6-20031715]

                    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.bi.platform.commons.web.filters.BIFilter.doFilter(BIFilter.java:114) [web-filters-11.1.6-20031715.jar:11.1.6-20031715]

                    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at io.prometheus.client.filter.MetricsFilter.doFilter(MetricsFilter.java:170) [simpleclient_servlet-0.4.0.jar:?]

                    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.bi.platform.commons.web.filters.LoadBalancingFilter.doFilter(LoadBalancingFilter.java:82) [bi-loadbalancer-11.1.6-20031715.jar:11.1.6-20031715]

                    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.bi.platform.commons.web.filters.BIHeaderFilter.doFilter(BIHeaderFilter.java:65) [web-filters-11.1.6-20031715.jar:11.1.6-20031715]

                    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.bi.platform.commons.web.filters.BICORSFilter.doFilter(BICORSFilter.java:104) [web-filters-11.1.6-20031715.jar:11.1.6-20031715]

                    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.bi.platform.commons.web.caf.CAFFilter.doFilter(CAFFilter.java:59) [web-filters-11.1.6-20031715.jar:11.1.6-20031715]

                    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1001) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1139) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:5017) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.handleRequest(DynamicVirtualHost.java:314) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1007) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:279) [com.ibm.ws.webcontainer_1.1.35.jar:?]

                    at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:1136) [com.ibm.ws.transport.http_1.0.35.jar:?]

                    at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.wrapHandlerAndExecute(HttpDispatcherLink.java:417) [com.ibm.ws.transport.http_1.0.35.jar:?]

                    at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:376) [com.ibm.ws.transport.http_1.0.35.jar:?]

                    at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:548) [com.ibm.ws.transport.http_1.0.35.jar:?]

                    at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:482) [com.ibm.ws.transport.http_1.0.35.jar:?]

                    at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:347) [com.ibm.ws.transport.http_1.0.35.jar:?]

                    at com.ibm.ws.http.channel.internal.inbound.HttpICLReadCallback.complete(HttpICLReadCallback.java:70) [com.ibm.ws.transport.http_1.0.35.jar:?]

                    at com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:503) [com.ibm.ws.channelfw_1.0.35.jar:?]

                    at com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:573) [com.ibm.ws.channelfw_1.0.35.jar:?]

                    at com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:954) [com.ibm.ws.channelfw_1.0.35.jar:?]

                    at com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1043) [com.ibm.ws.channelfw_1.0.35.jar:?]

                    at com.ibm.ws.threading.internal.ExecutorServiceImpl$RunnableWrapper.run(ExecutorServiceImpl.java:239) [com.ibm.ws.threading_1.1.35.jar:?]

                    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160) [?:1.8.0]

                    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:1.8.0]

                    at java.lang.Thread.run(Thread.java:818) [?:2.9 (11-06-2019)]

    2020-11-04T00:01:27.570+0200  ERROR  com.ibm.bi.platform.commons.web.BIResponseWrapper              [Default Executor-thread-811]     y8s88jq8M2qwjsCwyy28qd8Gl4l4Mw9h8vCMhshy                          y8s88jq8M2qwjsCwyy28qd8Gl4l4Mw9h8vCMhshy          NA          130.39.120.65     51571    LoginUser-149614924                NA          /v1/plugins/themes/current/favicon       ui/v1      1348       HttpServletResponseCode for /ui/v1/themes/current/favicon is in error: 500

    2020-11-04T00:01:33.664+0200  ERROR  Audit.caf              [Default Executor-thread-801]                2jd9hGChqlvjsMMhv8wvhdhCd9yM4dvjyd2M2q9q         2jd9hGChqlvjsMMhv8wvhdhCd9yM4dvjyd2M2q9q                2hdjC4294GjyjGCMj8vC4ddMj8w8dssl4jqChwvM             NA          130.39.120.65     51601                    NA                          IBM Cognos        1348       Request               secure error - did not find userCapabilities            Warning                                              

    2020-11-04T00:01:33.711+0200  ERROR  com.ibm.bi.platform.commons.web.BIResponseWrapper              [Default Executor-thread-643]     2jd9hGChqlvjsMMhv8wvhdhCd9yM4dvjyd2M2q9q                         2jd9hGChqlvjsMMhv8wvhdhCd9yM4dvjyd2M2q9q         NA          130.39.120.65     51599    LoginUser-149614924                NA          /v1/disp/ibmcognos/sso/cisapi/bi/v1/login          user-profile-service        1348                HttpServletResponseCode for /user-profile-service/v1/login is in error: 599

    2020-11-04T00:12:14.096+0200  ERROR  com.ibm.bi.platform.commons.web.BIResponseWrapper              [Default Executor-thread-863]     whjCy94hjldvh2h29sywdvv92l2j4Ml4w42qClM8                 whjCy94hjldvh2h29sywdvv92l2j4Ml4w42qClM8 NA          130.39.120.65     52494    LoginUser1982615059 AggAAADGDatfAAAAAAoAAACzJnrMvIaB0HtLFAAAAHaIAwS/QxgdOAXNHehil6qrPsqyBwAAAFNIQS0yNTYgAAAAQ2a9e+ngCp81UpzonQuaaAhIZNRKFYwlt5rnUeJXGSE=               /v1/metadata/modules/398060859_78a283a43ff849caa78dddd8ad84e942_sessionTemp/feedbackCalculation                modelingservice               1348       HttpServletResponseCode for /modelingservice/v1/modules/398060859_78a283a43ff849caa78dddd8ad84e942_sessionTemp/feedbackCalculation is in error: 400

    2020-11-04T00:12:14.142+0200  ERROR  com.ibm.bi.platform.commons.web.BIResponseWrapper              [Default Executor-thread-83]       dsqsMlCy99w8ddG9sCl48v2dw9hjdyvjdsv9vs92                 dsqsMlCy99w8ddG9sCl48v2dw9hjdyvjdsv9vs92 NA          130.39.120.65     52485    LoginUser1982615059 AggAAADGDatfAAAAAAoAAACzJnrMvIaB0HtLFAAAAHaIAwS/QxgdOAXNHehil6qrPsqyBwAAAFNIQS0yNTYgAAAAQ2a9e+ngCp81UpzonQuaaAhIZNRKFYwlt5rnUeJXGSE=               /v1/metadata/modules/398060859_78a283a43ff849caa78dddd8ad84e942_sessionTemp/feedbackCalculation                modelingservice               1348       HttpServletResponseCode for /modelingservice/v1/modules/398060859_78a283a43ff849caa78dddd8ad84e942_sessionTemp/feedbackCalculation is in error: 400

    2020-11-04T00:20:18.462+0200  ERROR  com.ibm.bi.platform.commons.web.BIResponseWrapper              [Default Executor-thread-379]     22s2G8G9hsMdCv44hMGwylwlhMydMCjd4hMjwldq                      22s2G8G9hsMdCv44hMGwylwlhMydMCjd4hMjwldq      NA          130.39.120.65     53069                LoginUser1982615059 AggAAADGDatfAAAAAAoAAACzJnrMvIaB0HtLFAAAAHaIAwS/QxgdOAXNHehil6qrPsqyBwAAAFNIQS0yNTYgAAAAQ2a9e+ngCp81UpzonQuaaAhIZNRKFYwlt5rnUeJXGSE=                /v1/datasets/398060859_c8d950fd424748e6998aed96b85ab612_sessionTemp/data       bi-service            1348                HttpServletResponseCode for /bi/v1/proxy/dataset-service/v1/datasets/398060859_c8d950fd424748e6998aed96b85ab612_sessionTemp/data is in error: 500

    2020-11-04T00:20:41.072+0200  ERROR  com.ibm.bi.platform.commons.web.BIResponseWrapper              [Default Executor-thread-510]     C4MhyvlwyM9vMlh8wyMvdlGswds8dCh48CGjG8My                      C4MhyvlwyM9vMlh8wyMvdlGswds8dCh48CGjG8My      NA          130.39.120.65     53126                LoginUser1982615059 AggAAADGDatfAAAAAAoAAACzJnrMvIaB0HtLFAAAAHaIAwS/QxgdOAXNHehil6qrPsqyBwAAAFNIQS0yNTYgAAAAQ2a9e+ngCp81UpzonQuaaAhIZNRKFYwlt5rnUeJXGSE=                /v1/datasets/398060859_c8d950fd424748e6998aed96b85ab612_sessionTemp/data       bi-service            1348                HttpServletResponseCode for /bi/v1/proxy/dataset-service/v1/datasets/398060859_c8d950fd424748e6998aed96b85ab612_sessionTemp/data is in error: 500



    ------------------------------
    Barry Morris
    ------------------------------

    Original Message


  • 8.  RE: Data Module shows no data

    Posted Fri January 05, 2024 03:26 PM

    I realize this is an older post but I ran into the same thing and it ended up being settings on the web server, basically the request string gets truncated if using default server settings and you get the behavior you've seen:

    Here's the link to all the IIS settings:

    https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=services-configuring-iis-in-cognos-analytics

    And the relevant section is this:

    1. Adjust request size limits.
      1. Select the bi directory under the ibmcognos application created earlier.
      2. Double-click Request Filtering.
      3. Click Edit Feature Settings... from the right-hand panel.
        • Set Maximum URL length (bytes) to 8192.
        • Set Maximum query string (bytes) to 8192.
        • Click OK.
      4. Double-click Request Filtering.
      5. Select Headers tab and click Add Header.
      6. In Header Box, type the header field name as Referer.
      7. In the Size Limit box, type 8192.
      8. Click OK.
      9. Repeat process for a header field name entitled Cookie with the Size Limit of 4096.
      10. Click OK.
      11. Click the ibmcognos virtual directory.
      12. In the Home view, Management section, double-click Configuration Editor.
      13. In the Section drop-down list, expand system.web, and select httpRuntime.
      14. Set the property maxQueryStringLength to 8192.
      15. Apply the configuration change.
    2. Configure IIS to allow to pass through the custom 441 errors that are used for recoverable exceptions from CAM. Otherwise, IIS can block these errors, and the customer sees the "Invalid Logon Response" error when trying to log on.
      1. Click the ibmcognos virtual directory.
      2. In the Home view, Management section, double-click Configuration Editor.
      3. In the Section drop-down list, expand system.webServer, and select httpErrors.
      4. Set the existingResponse property to PassThrough.

    Cheers.

    --Greg



    ------------------------------
    Gregory Fordham
    ------------------------------

    Original Message