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| Proprietary information hidden 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