Question
Capgemini
ES
Last activity: 24 Jun 2020 11:27 EDT
challenge error Manipulating application data 8.4 Commit error: Batch entry 0 WITH source a
Working in thie new academy challenge
https://academy.pega.com/challenge/manipulating-application-data/v1/in/2861
the transform populate correctly the the field group SelectedServices, but when I try to save the case I get this error.
Batch entry 0 WITH source as (SELECT 'GOGO-GOGOROAD-WORK A-4'
....
...
FROM source WHERE NOT EXISTS (SELECT null FROM upsert) was aborted. Call getNextException to see the cause.
see detailed log:
Commit error:
Working in thie new academy challenge
https://academy.pega.com/challenge/manipulating-application-data/v1/in/2861
the transform populate correctly the the field group SelectedServices, but when I try to save the case I get this error.
Batch entry 0 WITH source as (SELECT 'GOGO-GOGOROAD-WORK A-4'
....
...
FROM source WHERE NOT EXISTS (SELECT null FROM upsert) was aborted. Call getNextException to see the cause.
see detailed log:
Commit error:
Batch entry 0 WITH source as (SELECT 'GOGO-GOGOROAD-WORK A-4'::varchar "pzInsKey" , NULL::varchar "CancelRequest" , NULL::varchar ".ServiceAddress.City" , NULL::varchar ".VehicleInformation.Color" , NULL::varchar "CoverageLevelElected" , NULL::varchar "DoYouWantToEnroll" , '750000000000.0'::numeric "InvoicedTotal" , NULL::numeric "InvoiceTotal" , NULL::varchar ".VehicleInformation.Make" , NULL::varchar ".VehicleInformation.Model" , NULL::varchar ".VehicleInformation.ModelYear" , 'GoGoRoad'::varchar "pxApplication" , '01.01.01'::varchar "pxApplicationVersion" , '1'::numeric "pxCoveredCount" , '0'::numeric "pxCoveredCountOpen" , '0'::numeric "pxCoveredCountUnsatisfied" , NULL::varchar "pxCoverInsKey" , '2020-05-26 04:32:10.316000 -04:00:00'::timestamp "pxCreateDateTime" , 'author@gogoroad'::varchar "pxCreateOperator" , 'author'::varchar "pxCreateOpName" , 'pega'::varchar "pxCreateSystemID" , 'PRIM4'::varchar "pxCurrentStage" , 'Resolution'::varchar "pxCurrentStageLabel" , '0'::numeric "pxExternalSystemUpdateCount" , NULL::numeric "pxFlowCount" , 'A-4'::varchar "pxInsName" , 'GoGo-GoGoRoad-Work-AssistanceRequest'::varchar "pxObjClass" , '2020-05-26 04:32:59.171000 -04:00:00'::timestamp "pxSaveDateTime" , '2020-05-26 04:32:59.171000 -04:00:00'::timestamp "pxUpdateDateTime" , 'author@gogoroad'::varchar "pxUpdateOperator" , 'author'::varchar "pxUpdateOpName" , 'pega'::varchar "pxUpdateSystemID" , '10'::numeric "pxUrgencyWork" , NULL::timestamp "pyAckTimestamp" , '2020-05-26 04:32:10.316000 -04:00:00'::timestamp "pyAgeFromDate" , NULL::numeric "pyChargeAmount" , NULL::varchar "pyChargeTo" , NULL::varchar "pyContactChannel" , NULL::varchar "pyContactType" , NULL::varchar "pyCusLevel" , NULL::varchar "pyCustomer" , NULL::varchar "pyCustomerEnterprise" , NULL::varchar "pyCustomerName" , NULL::varchar "pyCustomerOrg" , NULL::timestamp "pyCustomerSatisfiedTimestamp" , NULL::varchar "pyDescription" , NULL::numeric "pyEffortActual" , NULL::numeric "pyEffortEstimate" , NULL::timestamp "pyEffortEstimateTimestamp" , NULL::numeric "pyElapsedCustomerAck" , '9.0'::numeric "pyElapsedCustomerUnsatisfied" , NULL::numeric "pyElapsedPastDeadline" , NULL::numeric "pyElapsedPastGoal" , '0'::numeric "pyElapsedStatusNew" , '23.0'::numeric "pyElapsedStatusOpen" , '0'::numeric "pyElapsedStatusPending" , NULL::varchar "pyEventID" , 'pyDefault'::varchar "pyFolderType" , NULL::varchar ".CustomerID.pyGUID" , 'A-4'::varchar "pyID" , 'Assistance Request'::varchar "pyLabel" , NULL::varchar "pyNote" , 'Services'::varchar "pyOrigDivision" , 'GoGo'::varchar "pyOrigOrg" , 'Auto'::varchar "pyOrigOrgUnit" , 'Services'::varchar "pyOrigUserDivision" , 'author@gogoroad'::varchar "pyOrigUserID" , 'default@GoGo'::varchar "pyOrigUserWorkgroup" , 'Services'::varchar "pyOwnerDivision" , 'GoGo'::varchar "pyOwnerOrg" , 'Auto'::varchar "pyOwnerOrgUnit" , NULL::varchar "pyPrimaryContact" , NULL::varchar "pyProblemReason" , NULL::varchar "pyProblemSource" , NULL::varchar "pyProblemType" , NULL::numeric "pyReopenCount" , NULL::timestamp "pyReopenTimestamp" , NULL::varchar "pyResolutionComplexity" , NULL::numeric "pyResolutionCost" , NULL::varchar "pyResolvedDivision" , NULL::varchar "pyResolvedOrg" , NULL::varchar "pyResolvedOrgUnit" , NULL::varchar "pyResolvedTime" , NULL::timestamp "pyResolvedTimestamp" , NULL::varchar "pyResolvedUserID" , NULL::varchar "pyResolvedUserWorkgroup" , NULL::varchar "pyRootCause" , NULL::timestamp "pySLADeadline" , NULL::timestamp "pySLAGoal" , NULL::varchar "pySLAName" , 'New'::varchar "pyStatusCustomerSat" , 'Pending-Fulfillment'::varchar "pyStatusWork" , NULL::varchar "pyWorkListDate1" , NULL::timestamp "pyWorkListDateTime1" , NULL::timestamp "pyWorkListDateTime2" , NULL::numeric "pyWorkListDecimal1" , NULL::numeric "pyWorkListDecimal2" , NULL::numeric "pyWorkListInteger1" , NULL::varchar "pyWorkListText1" , NULL::varchar "pyWorkListText2" , NULL::varchar "pyWorkListText3" , NULL::varchar "SelectedProvider" , NULL::varchar "ServiceType" , NULL::varchar ".ServiceAddress.State" , NULL::varchar ".ServiceAddress.Street" , NULL::varchar "copveragelevelelected" , NULL::numeric "servicestotal" , ?::bytea "pzPVStream"), upsert AS (UPDATE pegadata.pc_GoGo_GoGoRoad_Work t SET pxCommitDateTime = CURRENT_TIMESTAMP , "cancelrequest" = source."CancelRequest" , "city_1" = source.".ServiceAddress.City" , "color_1" = source.".VehicleInformation.Color" , "coveragelevelelected" = source."CoverageLevelElected" , "doyouwanttoenroll" = source."DoYouWantToEnroll" , "invoicedtotal" = source."InvoicedTotal" , "invoicetotal" = source."InvoiceTotal" , "make_1" = source.".VehicleInformation.Make" , "model_1" = source.".VehicleInformation.Model" , "modelyear_1" = source.".VehicleInformation.ModelYear" , "pxapplication" = source."pxApplication" , "pxapplicationversion" = source."pxApplicationVersion" , "pxcoveredcount" = source."pxCoveredCount" , "pxcoveredcountopen" = source."pxCoveredCountOpen" , "pxcoveredcountunsatisfied" = source."pxCoveredCountUnsatisfied" , "pxcoverinskey" = source."pxCoverInsKey" , "pxcreatedatetime" = source."pxCreateDateTime" , "pxcreateoperator" = source."pxCreateOperator" , "pxcreateopname" = source."pxCreateOpName" , "pxcreatesystemid" = source."pxCreateSystemID" , "pxcurrentstage" = source."pxCurrentStage" , "pxcurrentstagelabel" = source."pxCurrentStageLabel" , "pxexternalsystemupdatecount" = source."pxExternalSystemUpdateCount" , "pxflowcount" = source."pxFlowCount" , "pxinsname" = source."pxInsName" , "pxobjclass" = source."pxObjClass" , "pxsavedatetime" = source."pxSaveDateTime" , "pxupdatedatetime" = source."pxUpdateDateTime" , "pxupdateoperator" = source."pxUpdateOperator" , "pxupdateopname" = source."pxUpdateOpName" , "pxupdatesystemid" = source."pxUpdateSystemID" , "pxurgencywork" = source."pxUrgencyWork" , "pyacktimestamp" = source."pyAckTimestamp" , "pyagefromdate" = source."pyAgeFromDate" , "pychargeamount" = source."pyChargeAmount" , "pychargeto" = source."pyChargeTo" , "pycontactchannel" = source."pyContactChannel" , "pycontacttype" = source."pyContactType" , "pycuslevel" = source."pyCusLevel" , "pycustomer" = source."pyCustomer" , "pycustomerenterprise" = source."pyCustomerEnterprise" , "pycustomername" = source."pyCustomerName" , "pycustomerorg" = source."pyCustomerOrg" , "pycustomersatisfiedtimestamp" = source."pyCustomerSatisfiedTimestamp" , "pydescription" = source."pyDescription" , "pyeffortactual" = source."pyEffortActual" , "pyeffortestimate" = source."pyEffortEstimate" , "pyeffortestimatetimestamp" = source."pyEffortEstimateTimestamp" , "pyelapsedcustomerack" = source."pyElapsedCustomerAck" , "pyelapsedcustomerunsatisfied" = source."pyElapsedCustomerUnsatisfied" , "pyelapsedpastdeadline" = source."pyElapsedPastDeadline" , "pyelapsedpastgoal" = source."pyElapsedPastGoal" , "pyelapsedstatusnew" = source."pyElapsedStatusNew" , "pyelapsedstatusopen" = source."pyElapsedStatusOpen" , "pyelapsedstatuspending" = source."pyElapsedStatusPending" , "pyeventid" = source."pyEventID" , "pyfoldertype" = source."pyFolderType" , "pyguid_1" = source.".CustomerID.pyGUID" , "pyid" = source."pyID" , "pylabel" = source."pyLabel" , "pynote" = source."pyNote" , "pyorigdivision" = source."pyOrigDivision" , "pyorigorg" = source."pyOrigOrg" , "pyorigorgunit" = source."pyOrigOrgUnit" , "pyoriguserdivision" = source."pyOrigUserDivision" , "pyoriguserid" = source."pyOrigUserID" , "pyoriguserworkgroup" = source."pyOrigUserWorkgroup" , "pyownerdivision" = source."pyOwnerDivision" , "pyownerorg" = source."pyOwnerOrg" , "pyownerorgunit" = source."pyOwnerOrgUnit" , "pyprimarycontact" = source."pyPrimaryContact" , "pyproblemreason" = source."pyProblemReason" , "pyproblemsource" = source."pyProblemSource" , "pyproblemtype" = source."pyProblemType" , "pyreopencount" = source."pyReopenCount" , "pyreopentimestamp" = source."pyReopenTimestamp" , "pyresolutioncomplexity" = source."pyResolutionComplexity" , "pyresolutioncost" = source."pyResolutionCost" , "pyresolveddivision" = source."pyResolvedDivision" , "pyresolvedorg" = source."pyResolvedOrg" , "pyresolvedorgunit" = source."pyResolvedOrgUnit" , "pyresolvedtime" = source."pyResolvedTime" , "pyresolvedtimestamp" = source."pyResolvedTimestamp" , "pyresolveduserid" = source."pyResolvedUserID" , "pyresolveduserworkgroup" = source."pyResolvedUserWorkgroup" , "pyrootcause" = source."pyRootCause" , "pysladeadline" = source."pySLADeadline" , "pyslagoal" = source."pySLAGoal" , "pyslaname" = source."pySLAName" , "pystatuscustomersat" = source."pyStatusCustomerSat" , "pystatuswork" = source."pyStatusWork" , "pyworklistdate1" = source."pyWorkListDate1" , "pyworklistdatetime1" = source."pyWorkListDateTime1" , "pyworklistdatetime2" = source."pyWorkListDateTime2" , "pyworklistdecimal1" = source."pyWorkListDecimal1" , "pyworklistdecimal2" = source."pyWorkListDecimal2" , "pyworklistinteger1" = source."pyWorkListInteger1" , "pyworklisttext1" = source."pyWorkListText1" , "pyworklisttext2" = source."pyWorkListText2" , "pyworklisttext3" = source."pyWorkListText3" , "selectedprovider" = source."SelectedProvider" , "servicetype" = source."ServiceType" , "state_1" = source.".ServiceAddress.State" , "street_1" = source.".ServiceAddress.Street" , "copveragelevelelected" = source."copveragelevelelected" , "servicestotal" = source."servicestotal" , pzPVStream = source."pzPVStream" FROM source WHERE t.pzinskey = source."pzInsKey" RETURNING *) INSERT INTO pegadata.pc_GoGo_GoGoRoad_Work (pzInsKey , pxCommitDateTime , "cancelrequest" , "city_1" , "color_1" , "coveragelevelelected" , "doyouwanttoenroll" , "invoicedtotal" , "invoicetotal" , "make_1" , "model_1" , "modelyear_1" , "pxapplication" , "pxapplicationversion" , "pxcoveredcount" , "pxcoveredcountopen" , "pxcoveredcountunsatisfied" , "pxcoverinskey" , "pxcreatedatetime" , "pxcreateoperator" , "pxcreateopname" , "pxcreatesystemid" , "pxcurrentstage" , "pxcurrentstagelabel" , "pxexternalsystemupdatecount" , "pxflowcount" , "pxinsname" , "pxobjclass" , "pxsavedatetime" , "pxupdatedatetime" , "pxupdateoperator" , "pxupdateopname" , "pxupdatesystemid" , "pxurgencywork" , "pyacktimestamp" , "pyagefromdate" , "pychargeamount" , "pychargeto" , "pycontactchannel" , "pycontacttype" , "pycuslevel" , "pycustomer" , "pycustomerenterprise" , "pycustomername" , "pycustomerorg" , "pycustomersatisfiedtimestamp" , "pydescription" , "pyeffortactual" , "pyeffortestimate" , "pyeffortestimatetimestamp" , "pyelapsedcustomerack" , "pyelapsedcustomerunsatisfied" , "pyelapsedpastdeadline" , "pyelapsedpastgoal" , "pyelapsedstatusnew" , "pyelapsedstatusopen" , "pyelapsedstatuspending" , "pyeventid" , "pyfoldertype" , "pyguid_1" , "pyid" , "pylabel" , "pynote" , "pyorigdivision" , "pyorigorg" , "pyorigorgunit" , "pyoriguserdivision" , "pyoriguserid" , "pyoriguserworkgroup" , "pyownerdivision" , "pyownerorg" , "pyownerorgunit" , "pyprimarycontact" , "pyproblemreason" , "pyproblemsource" , "pyproblemtype" , "pyreopencount" , "pyreopentimestamp" , "pyresolutioncomplexity" , "pyresolutioncost" , "pyresolveddivision" , "pyresolvedorg" , "pyresolvedorgunit" , "pyresolvedtime" , "pyresolvedtimestamp" , "pyresolveduserid" , "pyresolveduserworkgroup" , "pyrootcause" , "pysladeadline" , "pyslagoal" , "pyslaname" , "pystatuscustomersat" , "pystatuswork" , "pyworklistdate1" , "pyworklistdatetime1" , "pyworklistdatetime2" , "pyworklistdecimal1" , "pyworklistdecimal2" , "pyworklistinteger1" , "pyworklisttext1" , "pyworklisttext2" , "pyworklisttext3" , "selectedprovider" , "servicetype" , "state_1" , "street_1" , "copveragelevelelected" , "servicestotal" , pzPVStream) SELECT source."pzInsKey" , CURRENT_TIMESTAMP , source."CancelRequest" , source.".ServiceAddress.City" , source.".VehicleInformation.Color" , source."CoverageLevelElected" , source."DoYouWantToEnroll" , source."InvoicedTotal" , source."InvoiceTotal" , source.".VehicleInformation.Make" , source.".VehicleInformation.Model" , source.".VehicleInformation.ModelYear" , source."pxApplication" , source."pxApplicationVersion" , source."pxCoveredCount" , source."pxCoveredCountOpen" , source."pxCoveredCountUnsatisfied" , source."pxCoverInsKey" , source."pxCreateDateTime" , source."pxCreateOperator" , source."pxCreateOpName" , source."pxCreateSystemID" , source."pxCurrentStage" , source."pxCurrentStageLabel" , source."pxExternalSystemUpdateCount" , source."pxFlowCount" , source."pxInsName" , source."pxObjClass" , source."pxSaveDateTime" , source."pxUpdateDateTime" , source."pxUpdateOperator" , source."pxUpdateOpName" , source."pxUpdateSystemID" , source."pxUrgencyWork" , source."pyAckTimestamp" , source."pyAgeFromDate" , source."pyChargeAmount" , source."pyChargeTo" , source."pyContactChannel" , source."pyContactType" , source."pyCusLevel" , source."pyCustomer" , source."pyCustomerEnterprise" , source."pyCustomerName" , source."pyCustomerOrg" , source."pyCustomerSatisfiedTimestamp" , source."pyDescription" , source."pyEffortActual" , source."pyEffortEstimate" , source."pyEffortEstimateTimestamp" , source."pyElapsedCustomerAck" , source."pyElapsedCustomerUnsatisfied" , source."pyElapsedPastDeadline" , source."pyElapsedPastGoal" , source."pyElapsedStatusNew" , source."pyElapsedStatusOpen" , source."pyElapsedStatusPending" , source."pyEventID" , source."pyFolderType" , source.".CustomerID.pyGUID" , source."pyID" , source."pyLabel" , source."pyNote" , source."pyOrigDivision" , source."pyOrigOrg" , source."pyOrigOrgUnit" , source."pyOrigUserDivision" , source."pyOrigUserID" , source."pyOrigUserWorkgroup" , source."pyOwnerDivision" , source."pyOwnerOrg" , source."pyOwnerOrgUnit" , source."pyPrimaryContact" , source."pyProblemReason" , source."pyProblemSource" , source."pyProblemType" , source."pyReopenCount" , source."pyReopenTimestamp" , source."pyResolutionComplexity" , source."pyResolutionCost" , source."pyResolvedDivision" , source."pyResolvedOrg" , source."pyResolvedOrgUnit" , source."pyResolvedTime" , source."pyResolvedTimestamp" , source."pyResolvedUserID" , source."pyResolvedUserWorkgroup" , source."pyRootCause" , source."pySLADeadline" , source."pySLAGoal" , source."pySLAName" , source."pyStatusCustomerSat" , source."pyStatusWork" , source."pyWorkListDate1" , source."pyWorkListDateTime1" , source."pyWorkListDateTime2" , source."pyWorkListDecimal1" , source."pyWorkListDecimal2" , source."pyWorkListInteger1" , source."pyWorkListText1" , source."pyWorkListText2" , source."pyWorkListText3" , source."SelectedProvider" , source."ServiceType" , source.".ServiceAddress.State" , source.".ServiceAddress.Street" , source."copveragelevelelected" , source."servicestotal" , source."pzPVStream" FROM source WHERE NOT EXISTS (SELECT null FROM upsert) was aborted. Call getNextException to see the cause.