Question

3
Replies
150
Views
MilindG6736 Member since 2018 4 posts
Syntel Inc
Posted: 1 year ago
Last activity: 1 year 9 months ago
Closed

Not able to create new data class in only one particular application of care management frame work

Hi Team,

Issue seems to be coming from the query timeout which results in "ORA-01013 user requested cancel of current operation".Even tracer is showing the same, with step 33 of pxRetrieveReportData activity failing with the above oracle error as it is not able to open the instances of the data class.This leads to the component stack mismatch error in the PEGARules logs. Caused by: java.lang.RuntimeException: Component stack mismatch {"pyCell":{"pyType":"layout","RWActive":"false","spanClass":"iconRequired standard_iconRequired","isFlex":"false","labelJSP":"false","pyLabelValue":""},"pyName":"DynamicLayoutCell","pyTemplates":[{"NTId":"1540539305031000","NTRef":"66d94c3efbd584a7f42f3a82e02b60be991ffc07_7","pyName":"pxNonTemplate","pyTemplates"

This is the below query which is getting timed out when we try to create the data type as well as while opening the existing data type :

WITH app_rulesets_pc0 AS ( SELECT "PC0AR".pzRuleSetName AS "pzRuleSetName", "PC0AR".pzRuleSetVersionMajor AS "pzRuleSetVersionMajor", "PC0AR".pzRuleSetVersionMinor AS "pzRuleSetVersionMinor", "PC0AR".pzRuleSetVersionPatch AS "pzRuleSetVersionPatch" , "PC0AR"."pzRuleSetOverallOrder" AS "pzRuleSetOverallOrder", "PC0AR".pzRuleSetVersionMinorPatch AS "pzRuleSetVersionMinorPatch" FROM ( SELECT "PC0AR".pzRuleSetName, "PC0AR".pzRuleSetVersionMajor, "PC0AR".pzRuleSetVersionMinor, "PC0AR".pzRuleSetVersionPatch, ROW_NUMBER() OVER (PARTITION BY "PC0AR".pzRuleSetName ORDER BY "PC0AH".pzAppHeight) AS "pzRuleSetOrder" , ROW_NUMBER() OVER (ORDER BY "PC0AH".pzAppHeight, "PC0AR".pzRuleSetIndex) AS "pzRuleSetOverallOrder" , "PC0AR".pzRuleSetVersionMinorPatch FROM RULES.pr_sys_app_hierarchy_flat "PC0AH" INNER JOIN RULES.pr_sys_app_ruleset_index "PC0AR" ON ("PC0AH".pzAppHash = "PC0AR".pzAppHash) WHERE "PC0AH".pzTopAppHash = ? AND "PC0AH".pzAppName IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ) "PC0AR" WHERE "PC0AR"."pzRuleSetOrder" = 1 ) ,rr_inheritance_pc0 AS ( SELECT "r".pzInsKey, "r".pyRuleAvailable, "r".pyClassName, "r".pyRuleSet, "r".pyRuleSetVersion, "r".pxInsId, "r".pyClass, RANK() OVER (PARTITION BY "r".pxInsId, "r".pyClass ORDER BY "c".pxHeight,"i"."pzRuleSetOverallOrder", "r".pyRuleSetVersion DESC) AS "rank_idx", DENSE_RANK() OVER (ORDER BY "r".pxInsId, "r".pyClass ) AS "group_idx" FROM RULES.pr4_rule_vw "r" INNER JOIN RULES.pr_sys_class_ancestors "c" ON ("r".pyClassName = "c".pxClassName) INNER JOIN app_rulesets_pc0 "i" ON ("r".pyRuleSet = "i"."pzRuleSetName") AND ("r".pzRuleSetVersionMajor = "i"."pzRuleSetVersionMajor" AND "r".pzRuleSetVersionMinorPatch <= "i"."pzRuleSetVersionMinorPatch") WHERE "r".pyClass = ? AND "c".pxLeafClassName = ? AND "r".pyRuleAvailable != 'No' AND "r".pyCircumstanceType IS NULL AND "r".pyRuleStarts IS NULL AND "r".pyRuleEnds IS NULL AND "r".pzClassType = 0 ) , bc_inheritance_pc0 AS ( SELECT "r".pzInsKey FROM ( SELECT "r".pzInsKey, "r".pyRuleAvailable FROM ( SELECT "s".pzInsKey, "s".pyRuleAvailable, RANK() OVER (PARTITION BY "s"."group_idx" ORDER BY "s"."rank_idx") AS "finalRank" FROM RULES.pr4_rule_vw "r" INNER JOIN app_rulesets_pc0 "i" ON ( "r".pyRuleSet = "i"."pzRuleSetName" AND ("r".pzRuleSetVersionMajor = "i"."pzRuleSetVersionMajor" AND "r".pzRuleSetVersionMinorPatch <= "i"."pzRuleSetVersionMinorPatch") AND "r".pzClassType = 0 AND "r".pyCircumstanceType IS NULL AND "r".pyRuleStarts IS NULL AND "r".pyRuleEnds IS NULL AND "r".pyRuleAvailable = 'Withdrawn' ) RIGHT OUTER JOIN rr_inheritance_pc0 "s" ON ( "r".pxInsId = "s".pxInsId AND "r".pyClass = "s".pyClass AND "r".pyClassName = "s".pyClassName AND "r".pyRuleSet = "s".pyRuleSet AND "r".pyRuleSetVersion >= "s".pyRuleSetVersion ) WHERE "r".pzInsKey IS NULL ) "r" WHERE "r"."finalRank" = 1 ) "r" WHERE "r".pyRuleAvailable != 'Blocked' ) , rr_wo_inheritance_pc0 AS ( SELECT "r".pzInsKey, "r".pyRuleAvailable, "r".pyClassName, "r".pyRuleSet, "r".pyRuleSetVersion, "r".pxInsId, "r".pyClass, RANK() OVER (PARTITION BY "r".pxInsId, "r".pyClass ORDER BY "i"."pzRuleSetOverallOrder", "r".pyRuleSetVersion DESC) AS "rank_idx", DENSE_RANK() OVER (ORDER BY "r".pxInsId, "r".pyClass) AS "group_idx" FROM RULES.pr4_rule_vw "r" INNER JOIN app_rulesets_pc0 "i" ON ("r".pyRuleSet = "i"."pzRuleSetName") AND ("r".pzRuleSetVersionMajor = "i"."pzRuleSetVersionMajor" AND "r".pzRuleSetVersionMinorPatch <= "i"."pzRuleSetVersionMinorPatch") WHERE "r".pyClass = ? AND "r".pyRuleAvailable != 'No' AND "r".pyCircumstanceType IS NULL AND "r".pyRuleStarts IS NULL AND "r".pyRuleEnds IS NULL AND "r".pzClassType = 1 ) , bc_wo_inheritance_pc0 AS ( SELECT "r".pzInsKey FROM ( SELECT "r".pzInsKey, "r".pyRuleAvailable FROM ( SELECT "s".pzInsKey, "s".pyRuleAvailable, RANK() OVER (PARTITION BY "s"."group_idx" ORDER BY "s"."rank_idx") AS "finalRank" FROM RULES.pr4_rule_vw "r" INNER JOIN app_rulesets_pc0 "i" ON ( "r".pyRuleSet = "i"."pzRuleSetName" AND ("r".pzRuleSetVersionMajor = "i"."pzRuleSetVersionMajor" AND "r".pzRuleSetVersionMinorPatch <= "i"."pzRuleSetVersionMinorPatch") AND "r".pzClassType = 1 AND "r".pyCircumstanceType IS NULL AND "r".pyRuleStarts IS NULL AND "r".pyRuleEnds IS NULL AND "r".pyRuleAvailable = 'Withdrawn' ) RIGHT OUTER JOIN rr_wo_inheritance_pc0 "s" ON ( "r".pxInsId = "s".pxInsId AND "r".pyClass = "s".pyClass AND "r".pyRuleSet = "s".pyRuleSet AND "r".pyRuleSetVersion >= "s".pyRuleSetVersion ) WHERE "r".pzInsKey IS NULL ) "r" WHERE "r"."finalRank" = 1 ) "r" WHERE "r".pyRuleAvailable != 'Blocked' ) , non_rr_rules_pc0 AS ( SELECT "r".pzInsKey FROM RULES.pr4_rule_vw "r" INNER JOIN app_rulesets_pc0 "i" ON ("r".pyRuleSet = "i"."pzRuleSetName") WHERE COALESCE("r".pyRuleAvailable, 'Yes') != 'No' AND "r".pyCircumstanceType IS NULL AND "r".pyRuleStarts IS NULL AND "r".pyRuleEnds IS NULL AND "r".pzClassType = 2 ) , resolved_rules_pc0 AS ( SELECT pzInsKey FROM bc_inheritance_pc0 UNION ALL SELECT pzInsKey FROM bc_wo_inheritance_pc0 UNION ALL SELECT pzInsKey FROM non_rr_rules_pc0 ) SELECT DISTINCT "PC0"."PZINSKEY" AS "pzInsKey" , "PC0"."PYPROPERTYNAME" AS "pyPropertyName" , "PC0"."PYCLASSNAME" AS "pyClassName" , "PC0"."PYPROPERTYMODE" AS "pyPropertyMode" , "PC0"."PYSTRINGTYPE" AS "pyStringType" , "PC0"."PYPAGECLASS" AS "pyPageClass" , "PC0"."PYLABEL" AS "pyLabel" , "PC0"."PYDATARETRIEVALTYPE" AS "pyDataRetrievalType" , "PC0"."PYADVANCEDPROPTYPE" AS "pyAdvancedPropType" , "PC0"."PYISREFERENCE" AS "pyIsReference" , "PC0"."PYGATEWAYCLASS" AS "pyGatewayClass" , "PC0"."PYDATAOBJECT" AS "pyDataObject" , "PC0"."PYISASSOCIATION" AS "pyIsAssociation" , "PC0"."PYRULESET" AS "pyRuleSet" , "PC0"."PYRULESETVERSION" AS "pyRuleSetVersion" , "DT"."PYLABEL" AS "pyLabel" , "DP"."PYLABEL" AS "pyLabel" , "ROC"."PYLABEL" AS "pyLabel" , "PC0"."PYSTREAMNAME" AS "pyStreamName" , "PC0"."PXINSNAME" AS "pxInsName" , "PC0"."PXCREATEDATETIME" AS "pxCreateDateTime" FROM RULES.pr4_rule_property "PC0" INNER JOIN resolved_rules_pc0 "resolved_rules_pc0" ON ("PC0".pzInsKey = "resolved_rules_pc0".pzInsKey) LEFT OUTER JOIN RULES.pr4_base "DT" ON ( ( "PC0"."PYPAGECLASS" = "DT"."PYCLASSNAME" ) AND "DT"."PXOBJCLASS" = ? AND "PC0"."PXOBJCLASS" = ? ) LEFT OUTER JOIN RULES.pr4_rule_declarepages "DP" ON ( ( "PC0"."PYDATAOBJECT" = "DP"."PYRULENAME" ) AND "DP"."PXOBJCLASS" = ? AND "PC0"."PXOBJCLASS" = ? ) INNER JOIN RULES.pr4_base "ROC" ON ( ( "PC0"."PYCLASSNAME" = "ROC"."PYCLASSNAME" AND "PC0"."PXINSID" IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ) AND "PC0"."PXOBJCLASS" = ? AND "ROC"."PXOBJCLASS" = ? ) WHERE "PC0"."PXOBJCLASS" = ? ORDER BY 7 ASC

SQL Inserts are below :

<RC!01.01.01$df603341016053397154447c0db77dbb> <PegaHCEWS> <PegaHL7> <CustomerService> <PegaHCFhir> <PegaX125010> <PegaRULES> <FhirApi> <PegaHC> <PegaHCAGM> <RC> <UIKit> <CSHC> <PegaCRMBase> <CareManagement> <PegaDM> <PegaHealthCodes> <PegaHCCore> <Rule-Obj-Property> <Syn-OncCare-Data-FirstDAta> <Rule-Obj-Property> <Rule-Obj-Class> <Rule-Obj-Property> <Rule-Declare-Pages> <Rule-Obj-Property> <!ADDRESS> <!ADJUDICATIONDATE> <!ALLOWDELETE> <!ALLOWEDAMOUNT> <!AMOUNTQUALIFIERCODE> <!APPEALLEVEL1DISPOSITION> <!APPEALLEVEL2DISPOSITION> <!APPEALLEVEL3DISPOSITION> <!CODE> <!COUNTY> <!CUSTOMID> <!DATETIMEPERIODFORMATQUALIFIER> <!DATETIMEQUALIFIER> <!DENTALONLYPLAN> <!DESCRIPTION> <!DIAGNOSISCODEVERSION> <!DIAGNOSISTYPE> <!DISPLAYEFFECTIVEDATE> <!DISPLAYENDDATE> <!DISPLAYNAME> <!DRGGROUPER> <!EFFECTIVEDATE> <!EFFECTIVEDATE_STRING> <!EMAILCOMMUNICATION> <!ENDDATE> <!ENDDATE_STRING> <!ERRORCODE> <!ERRORDESCRIPTION> <!FOLLOWUPACTIONCODE> <!GAP2ENDDATE> <!GAP2STARTDATE> <!GAPENDDATE> <!GAPSTARTDATE> <!HIOSISSUERID> <!HREF> <!INFORMATIONRECEIVER> <!INFORMATIONSOURCE> <!INSURANCETYPECODE> <!ISACTIVE> <!ISAPPROVED> <!ISATLEASTSAVEDONCE> <!ISAUTHORIZATIONREQUIRED> <!ISDECEASED> <!ISWITHINRANGE> <!LANGUAGES> <!LATITUDE> <!LISTING_PREFIX> <!LISTING_SEQ_NO> <!LISTOFLANGUAGES> <!LISTOFSECONDARYADMITTINGHOSP> <!LISTOFSECONDARYADMITTINGHOSPITAL> <!LISTOFSECONDARYSPECIALITIES> <!LOCATIONMATCHED> <!LONGITUDE> <!MARKETCOVERAGE> <!MASTEREFFECTIVEDATE> <!MASTERENDDATE> <!MEDICAREELIGIBILITYREASONCODE> <!MEDICARENUMBER> <!MEDICAREPLANCODE> <!MEDICARESTATUSCODE> <!NEWVERSIONNOTE> <!OLDKEY> <!ONHOLD> <!PATIENTID> <!PHONECOMMUNICATION> <!PLANVERSION> <!PROCEDURECODETYPE> <!PRODUCTCATEGORY> <!PRODUCTKEY> <!PRODUCTORSERVICEIDQUALIFIER> <!PROVIDERCONTRACTPICK> <!PROVIDERPICKMESSAGE> <!PROVIDERS> <!PXCREATEDATETIME> <!PXCREATEOPERATOR> <!PXCREATEOPNAME> <!PXCREATESYSTEMID> <!PXUPDATEDATETIME> <!PXUPDATEOPERATOR> <!PXUPDATEOPNAME> <!PXUPDATESYSTEMID> <!REASONFORCANCELLATION> <!REJECTREASONCODE> <!RELATIVEEFFECTIVEDATE> <!RELATIVEENDDATE> <!RESOURCESETTINGS> <!SOCIALMEDIACOMMUNICATION> <!SOURCE> <!SPECIALTYMATCHED> <!STATUS> <!TAXIDENTIFICATIONNUMBER> <!TAXONOMYCODE> <!TRACETYPECODE> <!UCASENAME> <!UPDATEFLAG> <!VALUE_LIST> <!VERSIONS> <!VIPINDICATOR> <Rule-Obj-Property> <Rule-Obj-Class> <Rule-Obj-Property>

Thanking You

Milind Ganbawale.

***Edited by Moderator Marissa to update platform capability tags; update SR details****

Low-Code App Development Data Integration SR Created
Moderation Team has archived post
Share this page LinkedIn