Hello,

we have a PMF 7.2 installation using a tomcat / postgres installation.

I have the following issues : Systematic error when calling instances which are mapped to a database view : for instance

PEGAPROJMGMT-WORK SPR-1 is mapped on view data.ppm_sprint_totals.

I get the following error in the logs :

DId you experience same errors and do you have a workaround.

Best Regards,

2017-03-31 18:18:20,698 [ -------exec-2] [TABTHREAD2] [ ] [ ------PMF:01.01.01] ( rd.resolve.SqlReportResolver) ERROR ----------------------| Proprietary information hidden vikesh.napal - An error occured during resolving the report definition - Database-TableWithNoColumns data.ppm_sprint_totals PegaDATA
com.pega.pegarules.data.internal.rd.resolve.UnexpectedResolveReportException: Database-TableWithNoColumns data.ppm_sprint_totals PegaDATA
at com.pega.pegarules.data.internal.rd.resolve.KeyPropertiesResolver.resolve(KeyPropertiesResolver.java:61)
at com.pega.pegarules.data.internal.rd.resolve.SqlReportResolver.resolve(SqlReportResolver.java:62)
at com.pega.pegarules.data.internal.rd.resolve.SqlReportResolver.resolve(SqlReportResolver.java:37)
at com.pega.pegarules.data.internal.rd.SQLExecutorResultsCP.resolve(SQLExecutorResultsCP.java:66)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeMainReport(SqlReportExecutor.java:94)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:73)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:46)
at com.pega.pegarules.data.internal.PRDataProviderImpl.executeReport(PRDataProviderImpl.java:1277)
at com.pega.pegarules.session.internal.mgmt.Executable.executeReport(Executable.java:10977)
at com.pegarules.generated.definition.ra_action_pyinstancelist_3dbde4b22e0c1b074ecf7b9bad314823.perform(ra_action_pyinstancelist_3dbde4b22e0c1b074ecf7b9bad314823.java:52)
at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:3358)
at com.pegarules.generated.activity.ra_action_pxretrievereportdata_f0a229cf0656a9fb4410dab263aa5f1a.step33_circum0(ra_action_pxretrievereportdata_f0a229cf0656a9fb4410dab263aa5f1a.java:3593)
at com.pegarules.generated.activity.ra_action_pxretrievereportdata_f0a229cf0656a9fb4410dab263aa5f1a.perform(ra_action_pxretrievereportdata_f0a229cf0656a9fb4410dab263aa5f1a.java:701)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3553)
at com.pegarules.generated.html_section.ra_stream_pzviewinstances_8a05c73252ad6c4179dc5840af9c4e39.gridBeginLayout_2(ra_stream_pzviewinstances_8a05c73252ad6c4179dc5840af9c4e39.java:2267)
at com.pegarules.generated.html_section.ra_stream_pzviewinstances_8a05c73252ad6c4179dc5840af9c4e39.pzLayoutBodyWrapper_3(ra_stream_pzviewinstances_8a05c73252ad6c4179dc5840af9c4e39.java:1599)
at com.pegarules.generated.html_section.ra_stream_pzviewinstances_8a05c73252ad6c4179dc5840af9c4e39.pzLayout_1(ra_stream_pzviewinstances_8a05c73252ad6c4179dc5840af9c4e39.java:3210)
at com.pegarules.generated.html_section.ra_stream_pzviewinstances_8a05c73252ad6c4179dc5840af9c4e39.pzSectionBody_1(ra_stream_pzviewinstances_8a05c73252ad6c4179dc5840af9c4e39.java:292)
at com.pegarules.generated.html_section.ra_stream_pzviewinstances_8a05c73252ad6c4179dc5840af9c4e39.execute(ra_stream_pzviewinstances_8a05c73252ad6c4179dc5840af9c4e39.java:102)
at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4086)
at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuleRuntime.getSectionStream(AutoStreamRuleRuntime.java:149)
at com.pegarules.generated.html_harness.ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.includeSectionBody_2(ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.java:2041)
at com.pegarules.generated.html_harness.ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.buildHarnessContainer_1(ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.java:2088)
at com.pegarules.generated.html_harness.ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.processHarnessContainers_1(ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.java:2255)
at com.pegarules.generated.html_harness.ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.createFormElement_1(ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.java:2476)
at com.pegarules.generated.html_harness.ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.createPegaHarnessDIV_1(ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.java:2833)
at com.pegarules.generated.html_harness.ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.includePegaHarnessContent_1(ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.java:2861)
at com.pegarules.generated.html_harness.ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.buildHarnessMarkup_1(ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.java:2975)
at com.pegarules.generated.html_harness.ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.execute(ra_stream_pzviewinstances_0333698631cb04a6626d0f27cee25afd.java:118)
at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4086)
at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:3914)
at com.pegarules.generated.activity.ra_action_displayharnesswithclass_4cc9f9e9cb9b892dd9c83273e3c08a6c.step4_circum0(ra_action_displayharnesswithclass_4cc9f9e9cb9b892dd9c83273e3c08a6c.java:496)
at com.pegarules.generated.activity.ra_action_displayharnesswithclass_4cc9f9e9cb9b892dd9c83273e3c08a6c.perform(ra_action_displayharnesswithclass_4cc9f9e9cb9b892dd9c83273e3c08a6c.java:121)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3553)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10711)
at com.pegarules.generated.activity.ra_action_uiactiondisplayharness_a2acddc69e4867663d47eddec62d0d1d.step10_circum0(ra_action_uiactiondisplayharness_a2acddc69e4867663d47eddec62d0d1d.java:981)
at com.pegarules.generated.activity.ra_action_uiactiondisplayharness_a2acddc69e4867663d47eddec62d0d1d.perform(ra_action_uiactiondisplayharness_a2acddc69e4867663d47eddec62d0d1d.java:236)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3553)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10711)
at com.pegarules.generated.activity.ra_action_douiaction_1f90dfddb4f11dc7c89eadd8484da696.step19_circum0(ra_action_douiaction_1f90dfddb4f11dc7c89eadd8484da696.java:1956)
at com.pegarules.generated.activity.ra_action_douiaction_1f90dfddb4f11dc7c89eadd8484da696.perform(ra_action_douiaction_1f90dfddb4f11dc7c89eadd8484da696.java:373)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3553)
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:465)
at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:3203)
at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:391)
at sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1297)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1034)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:889)
at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:331)
at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:829)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:331)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:274)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:251)
at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngineInner(JNDIEnvironment.java:278)
at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:223)
at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:589)
at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:378)
at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:121)
at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doGet(WebStandardBoot.java:92)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)

***Moderator Edit: Vidyaranjan | Updated Categories***