Question

1
Replies
145
Views
PradeepPydi Member since 2017 204 posts
Anthem
Posted: 2 years ago
Last activity: 2 years 6 months ago
Closed

PEGA0005 alerts on the table CPMHC_WORK.

Hi Team,

We could find a lot of PEGA0005 alerts on the table CPMHC_WORK.

PFB for one of the alerts.

Database update took more than the threshold of 500 ms: 23,301 ms SQL: INSERT INTO dbo.CPMHC_WORK (pzInsKey , "ActionTaken" , "AddressLine1" , "AppointmentAssistance" , "AuthCancelReason" , "AuthNumber" , "AuthRequestType" , "CFRequest" , "CTICallID" , "CallBackNeeded" , "CallBackPhone" , "CallComments" , "CallPurpose" , "CallPurposeID" , "CallType" , "CallerType" , "CancelAuthReason" , "CancelAuthReasonCode" , "CancelReason" , "CheckReferenceID" , "City" , "ClaimDOS" , "ClaimID" , "Comments" , "CommentsForFLDifficulty" , "ContactId" , "ContactName" , "ContactPhone" , "ContactRelationships" , "CurrentPCPOpenClaim" , "CurrentWorkbasketName" , "DeniedAuth" , "DifficultyFindProvider" , "DocumentID" , "DropdownServicingProvider" , "DualMemberID" , "EDUID" , "EGName" , "EGRFollowUp" , "EGRUrgentRequest" , "EffectiveDateText" , "EndDOI" , "EnrollmentMarkets" , "FaxWOID" , "FlagBenefitsSubject" , "FlagCallerHungUp" , "FlagClinicalTask" , "FlagCreateNewMailAddress" , "FlagDenAuthFaxSent" , "FlagDenAuthLetterSent" , "FlagEnrollProcessSubject" , "FlagExist" , "FlagGoodContact" , "FlagMembersIssue" , "FlagNetworkSubject" , "FlagOtherSubject" , "FlagTTYandTDD" , "FlagUpdatedHomeAddress" , "FlagUpdatedMailAddress" , "GRCallerFirstName" , "GRCallerLastName" , "GRCallerPhoneNum" , "HCCustomerType" , "InquiryDate" , "InteractionGoal" , "InteractionTime" , "InteractionType" , "IsAdvTakenForAssistanceOffer" , "IsAuthCancelledForRedir" , "IsCallTransferred" , "IsCallerAMember" , "IsDenialLetterRequiredForEGR" , "IsEGRMember" , "IsFirstImpCall" , "IsItemsOpen" , "IsProvbehalfMem" , "IsRelatedToPriorInquiry" , "IsTransferredIn" , "IsTransferredOut" , "IssueResolved" , "MemberDualCitizen" , "MemberFullName" , "MemberID" , "MemberLOB" , "NATFAcceptance" , "NetPromoterCategory" , "NetPromoterScore" , "NewPCPID" , "NewPCPName" , "NoOfItemsCreated" , "PCPChangeFOM" , "PCPReasonCode" , "PayDispCatg" , "PerformAction" , "Performance" , "PhoneNumber" , "PolicyNumber" , "PrivacyType" , "ProactiveAssistance" , "ProviderIDSearch" , "ProviderName" , "ProviderNumber" , "ProvidersReviewedNone" , "QualityReviewCaseID" , "RDEDay" , "RDEMonth" , "RDEQuarter" , "RDEWeek" , "RDEYeay" , "ReasonForIDCard" , "ReasonForInteraction" , "RecipientType" , "RequestReceivedDate" , "ResolveNotes" , "SCCF_ID" , "SavingsAmount" , "SearchDateTime" , "SelectedPCPAddress" , "SelectedPCPID" , "SelectedPCPName" , "StartDOI" , "StateCodes" , "Subject" , "TTYandTDDComments" , "TotalScore" , "TransferCallCategory" , "TransferCallSubCategory" , "TypeofBreach" , "UpdateEligibilityUrgent" , "UpdateMbrType" , "UpdatePDQProvider" , "VoiceMailMarkets" , "VoiceMailRcvdDate" , "WarmComments" , "WarmTransfer" , "WorkbasketName" , "pxCoverInsKey" , "pxCoveredCount" , "pxCoveredCountOpen" , "pxCoveredCountUnsatisfied" , "pxCreateDateTime" , "pxCreateOpName" , "pxCreateOperator" , "pxCreateSystemID" , "pxFlowCount" , "pxInsName" , "pxObjClass" , "pxUpdateDateTime" , "pxUpdateOpName" , "pxUpdateOperator" , "pxUpdateSystemID" , "pxUrgencyWork" , "pyAgeFromDate" , "pyChargeAmount" , "pyDescription" , "pyEffortActual" , "pyEffortEstimate" , "pyElapsedCustomerAck" , "pyElapsedCustomerUnsatisfied" , "pyElapsedPastDeadline" , "pyElapsedPastGoal" , "pyElapsedStatusNew" , "pyElapsedStatusOpen" , "pyElapsedStatusPending" , "pyEventID" , "pyFolderType" , "pyID" , "pyLabel" , "pyOrigDivision" , "pyOrigOrg" , "pyOrigOrgUnit" , "pyOrigUserDivision" , "pyOrigUserID" , "pyOrigUserWorkgroup" , "pyOwnerDivision" , "pyOwnerOrg" , "pyOwnerOrgUnit" , "pyProblemReason" , "pyProblemType" , "pyReopenCount" , "pyResolutionCost" , "pyResolvedDivision" , "pyResolvedOrg" , "pyResolvedOrgUnit" , "pyResolvedTime" , "pyResolvedTimestamp" , "pyResolvedUserID" , "pyResolvedUserWorkgroup" , "pyRootCause" , "pySLADeadline" , "pySLAGoal" , "pySLAName" , "pyStatusCustomerSat" , "pyStatusWork" , "pyUrgencyAdjustment" , pzPVStream) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?) inserts: > > > > > > > > > > > > > > > > > > > > > > > 715066655> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 715066655> > > > > > > > > > > > > 0110955135> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 0> 0> 0> 2018-03-26 10:04:50.301> > 2018-03-26 10:04:50.646> 10> 2018-03-26 10:04:50.302> > > > > 0> > > 0> 0> 0> > > > > > > > > > > > > 2018-03-29 10:04:50.58> 2018-03-28 10:04:50.58> > [B@558d46e9>

System Administration
Moderation Team has archived post
Share this page LinkedIn