Question

2
Replies
133
Views
Close popover
Anandh Palanisamy (Anandh Palanisamy)
Ford Motor Company

Ford Motor Company
US
Anandh Palanisamy Member since 2013 62 posts
Ford Motor Company
Posted: June 29, 2017
Last activity: April 6, 2018
Closed

7.2 Dev-Ops Acceleration Pack error

Hi Team,

We are trying to implement the DevOps acceleration tool, getting the below error when I try to add the environment details.

2017-06-29 10:32:51,352 [ TP_http : 13] [ STANDARD] [ PegaPRESTO:07.20] ( rd.resolve.SqlReportResolver) ERROR wwwdev.warrantyauthoring.ford.com|19.39.33.72 APALANIS - An error occured during resolving the report definition - One of the join conditions involving the following unoptimized property is not allowed, since it can severely degrade performance: .tyTargetEnvironmentInsKey. Revise the join conditions or optimize the property.
com.pega.pegarules.data.internal.rd.resolve.UserResolveReportException: One of the join conditions involving the following unoptimized property is not allowed, since it can severely degrade performance: .tyTargetEnvironmentInsKey. Revise the join conditions or optimize the property.
at com.pega.pegarules.data.internal.rd.utils.ValidationUtils.throwException(ValidationUtils.java:479)
at com.pega.pegarules.data.internal.rd.resolve.FiltersResolver.validateFilter(FiltersResolver.java:312)
at com.pega.pegarules.data.internal.rd.resolve.FiltersResolver.resolveFilter(FiltersResolver.java:106)
at com.pega.pegarules.data.internal.rd.resolve.FiltersResolver.resolveFilters(FiltersResolver.java:84)
at com.pega.pegarules.data.internal.rd.resolve.JoinsResolver.resolveJoins(JoinsResolver.java:90)
at com.pega.pegarules.data.internal.rd.resolve.JoinsResolver.resolve(JoinsResolver.java:62)
at com.pega.pegarules.data.internal.rd.resolve.SqlReportResolver.resolve(SqlReportResolver.java:85)
at com.pega.pegarules.data.internal.rd.resolve.SqlReportResolver.resolve(SqlReportResolver.java:37)
at com.pega.pegarules.data.internal.rd.SQLExecutorResultsCP.resolve(SQLExecutorResultsCP.java:63)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeSubReport(SqlReportExecutor.java:128)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:75)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:50)
at com.pega.pegarules.data.internal.rd.resolve.SubReportResolver.executeSubReport(SubReportResolver.java:205)
at com.pega.pegarules.data.internal.rd.resolve.SetQueryResolver.processSetReports(SetQueryResolver.java:439)
at com.pega.pegarules.data.internal.rd.resolve.SetQueryResolver.resolve(SetQueryResolver.java:82)
at com.pega.pegarules.data.internal.rd.resolve.SqlReportResolver.resolve(SqlReportResolver.java:85)
at com.pega.pegarules.data.internal.rd.resolve.SqlReportResolver.resolve(SqlReportResolver.java:37)
at com.pega.pegarules.data.internal.rd.SQLExecutorResultsCP.resolve(SQLExecutorResultsCP.java:63)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeMainReport(SqlReportExecutor.java:98)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:77)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:50)
at com.pega.pegarules.data.internal.PRDataProviderImpl.executeReport(PRDataProviderImpl.java:1242)
at com.pega.pegarules.session.internal.mgmt.Executable.executeReport(Executable.java:10853)
at com.pegarules.generated.definition.ra_action_tygetinprogressrelbyenvironment_f2f3535b02607414a318096a4d3a2dc3.perform(ra_action_tygetinprogressrelbyenvironment_f2f3535b02607414a318096a4d3a2dc3.java:50)
at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:3315)
at com.pegarules.generated.activity.ra_action_pzgetfiltersfromcontent_4b7dc8a308d391e0d8cc79feaa62d56b.step2_circum0(ra_action_pzgetfiltersfromcontent_4b7dc8a308d391e0d8cc79feaa62d56b.java:312)
at com.pegarules.generated.activity.ra_action_pzgetfiltersfromcontent_4b7dc8a308d391e0d8cc79feaa62d56b.perform(ra_action_pzgetfiltersfromcontent_4b7dc8a308d391e0d8cc79feaa62d56b.java:89)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3510)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10587)
at com.pegarules.generated.activity.ra_action_pzresolvecopyfilters_90816073ea5116f243cb20b63a085841.step2_circum0(ra_action_pzresolvecopyfilters_90816073ea5116f243cb20b63a085841.java:269)
at com.pegarules.generated.activity.ra_action_pzresolvecopyfilters_90816073ea5116f243cb20b63a085841.perform(ra_action_pzresolvecopyfilters_90816073ea5116f243cb20b63a085841.java:86)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3510)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10587)
at com.pegarules.generated.activity.ra_action_runreport_9b5f068bf627f3c1f7df7e2a78ceab44.step21_circum0(ra_action_runreport_9b5f068bf627f3c1f7df7e2a78ceab44.java:1994)
at com.pegarules.generated.activity.ra_action_runreport_9b5f068bf627f3c1f7df7e2a78ceab44.perform(ra_action_runreport_9b5f068bf627f3c1f7df7e2a78ceab44.java:477)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3510)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10587)
at com.pegarules.generated.activity.ra_action_pxshowreport_73af1287d09b5bf48b0dd9afe0494643.step11_circum0(ra_action_pxshowreport_73af1287d09b5bf48b0dd9afe0494643.java:1111)
at com.pegarules.generated.activity.ra_action_pxshowreport_73af1287d09b5bf48b0dd9afe0494643.perform(ra_action_pxshowreport_73af1287d09b5bf48b0dd9afe0494643.java:290)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3510)
at com.pegarules.generated.html_property.ra_stream_chart_816ac6fd09fe40feea5190f2157c4b9c.execute(ra_stream_chart_816ac6fd09fe40feea5190f2157c4b9c.java:527)
at com.pega.pegarules.session.internal.mgmt.StreamBuilderTools.appendStreamKeepProperties(StreamBuilderTools.java:734)
at com.pega.pegarules.jsptags.ReferenceTag.appendFormattedProperty(ReferenceTag.java:708)
at com.pega.pegarules.jsptags.ReferenceTag.applyFormat(ReferenceTag.java:559)
at com.pega.pegarules.jsptags.ReferenceTag.doEndTag(ReferenceTag.java:408)
at com.pegarules.generated.html_section.ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406._jspx_meth_pega_reference__2(ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.java:290)
at com.pegarules.generated.html_section.ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.field_chart_2(ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.java:305)
at com.pegarules.generated.html_section.ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.simpleLayoutCell_2(ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.java:469)
at com.pegarules.generated.html_section.ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.simpleLayout_1(ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.java:503)
at com.pegarules.generated.html_section.ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.pzLayoutBodyWrapper_1(ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.java:240)
at com.pegarules.generated.html_section.ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.pzLayout_1(ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.java:523)
at com.pegarules.generated.html_section.ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.pzSectionBody_1(ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.java:229)
at com.pegarules.generated.html_section.ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.execute(ra_stream_tyallappreports_9c1ad21b5adfbc5326acf7b228b80406.java:102)
at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4043)
at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuleRuntime.getSectionStream(AutoStreamRuleRuntime.java:149)
at com.pegarules.generated.html_section.ra_stream_tydashboardhome_97a83c8eae999d98593ecdf57ca3391f.includeSectionBody_2(ra_stream_tydashboardhome_97a83c8eae999d98593ecdf57ca3391f.java:302)
at com.pegarules.generated.html_section.ra_stream_tydashboardhome_97a83c8eae999d98593ecdf57ca3391f.pzLayoutBodyWrapper_2(ra_stream_tydashboardhome_97a83c8eae999d98593ecdf57ca3391f.java:291)
at com.pegarules.generated.html_section.ra_stream_tydashboardhome_97a83c8eae999d98593ecdf57ca3391f.pzLayout_2(ra_stream_tydashboardhome_97a83c8eae999d98593ecdf57ca3391f.java:313)
at com.pegarules.generated.html_section.ra_stream_tydashboardhome_97a83c8eae999d98593ecdf57ca3391f.pzSectionBody_1(ra_stream_tydashboardhome_97a83c8eae999d98593ecdf57ca3391f.java:216)
at com.pegarules.generated.html_section.ra_stream_tydashboardhome_97a83c8eae999d98593ecdf57ca3391f.execute(ra_stream_tydashboardhome_97a83c8eae999d98593ecdf57ca3391f.java:100)
at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4043)

Can you please someone help me on this?

Regards,

Anandh

System Administration Upgrades
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.