I changed the key for one of my data types to be a name string. I've been getting a .pyCommitError and after looking at the log files, I have determined that it is caused by the pyGUID still being seen as required, despite not being listed so in the data model. Does anyone know why this is happening and how I can fix/work around this?

The excerpt causing me to think this was "ERROR: null value in column "pyguid" violates not-null constraint." I've included the entire log entry for reference:

2022-04-04 15:28:52,267 GMT*8*EXCP0001*0*0*a4c7cf85120bfb8514e0b907cc30a9ad*NA*NA*HT1BZG59CQIR00JPANRJ48EH9I255K960A* Proprietary information hidden*ARMA-SEDA2-Work*SEDA2:01.01.01*c34743fe406c5e5f4336c69cb0bbd1f2*Y*492*HT1BZG59CQIR00JPANRJ48EH9I255K960A*165*https-jsse-nio2-9443-exec-20*PS2__TABTHREAD2*Rule_Obj_Activity.commitWithErrorHandling.Work_.Action*k2u6vfv8.pegace.net| Proprietary information hidden*Activity=FinishAssignment*Rule-Obj-Activity:FinishAssignment*@BASECLASS PXCALLRETRIEVEREPORTDATA #20200728T104225.579 GMT Step: 7 Circum: 0*0*false*NA**NA*NA*ARMA-SEDA2-Work-NEODataEntry*pyWorkPage*ARMA-SEDA2-Work-NEODataEntry*pyWorkPage*Commit;RULE-OBJ-ACTIVITY WORK- COMMITWITHERRORHANDLING #20180713T133047.594 GMT Step: 4 Circum: 0;doActivity Rule-Obj-Activity:commitWithErrorHandling;Call commitWithErrorHandling;RULE-OBJ-ACTIVITY WORK- WORKCOMMIT #20180713T133103.315 GMT Step: 3 Circum: 0;5 additional frames in stack;*OutputPageClass=[Removed];OnlyCreateOutputPageIfError=[Removed];pyTempPlaceHolder=TempPlaceHolder;OutputPageName=[Removed];*[MSG][Error in commit()][STACK][com.pega.pegarules.pub.database.IntegrityConstraintViolationException: Batch entry 0 WITH source as (SELECT '2017 AB123'::varchar "Name" , '20251106'::varchar "ApproachDate" , NULL::varchar "Astronomer" , NULL::varchar "case_id" , 0.463::numeric "Diameter" , 'Galla Layo'::varchar "DiscovererName" , '20160215'::varchar "DiscoveryDate" , NULL::numeric "EstimatedDiameterkm" , 0.011000000::numeric "ImpactLikelihood" , NULL::numeric "ImpactLikelihoodEstimate" , NULL::varchar "ObservationDate" , NULL::varchar "ObservationSave" , NULL::timestamp "pxCommitDateTime" , '2022-04-04 11:28:52.161-04'::timestamp "pxCreateDateTime" , ' Proprietary information hidden'::varchar "pxCreateOperator" , 'McKay.holmes'::varchar "pxCreateOpName" , 'pega'::varchar "pxCreateSystemID" , NULL::timestamp "pxSaveDateTime" , '2022-04-04 11:28:52.161-04'::timestamp "pxUpdateDateTime" , ' Proprietary information hidden'::varchar "pxUpdateOperator" , 'McKay.holmes'::varchar "pxUpdateOpName" , 'pega'::varchar "pxUpdateSystemID" , NULL::varchar "pyGUID" , NULL::varchar "RevisedApproachDateoptional" , NULL::numeric "SignificanceFactor" , NULL::varchar "TorinoDescription" , '6'::varchar "TorinoRating" , 'Asteroid'::varchar "Type" , NULL::varchar "UpdateApproachDate" , NULL::varchar "UpdateDiameter" , NULL::varchar "UpdateImpactLikelihood" , NULL::varchar "UpdateRating" , '[email protected]'::varchar "WorkEmail" , '123-456-7890'::varchar "WorkPhone"), upsert AS (UPDATE pegadata.pr_arma_seda2_data_neolocal t SET "name" = source."Name" , "approachdate" = source."ApproachDate" , "astronomer" = source."Astronomer" , "case_id" = source."case_id" , "diameter" = source."Diameter" , "discoverername" = source."DiscovererName" , "discoverydate" = source."DiscoveryDate" , "estimateddiameterkm" = source."EstimatedDiameterkm" , "impactlikelihood" = source."ImpactLikelihood" , "impactlikelihoodestimate" = source."ImpactLikelihoodEstimate" , "observationdate" = source."ObservationDate" , "observationsave" = source."ObservationSave" , "pxcommitdatetime" = source."pxCommitDateTime" , "pxcreatedatetime" = source."pxCreateDateTime" , "pxcreateoperator" = source."pxCreateOperator" , "pxcreateopname" = source."pxCreateOpName" , "pxcreatesystemid" = source."pxCreateSystemID" , "pxsavedatetime" = source."pxSaveDateTime" , "pxupdatedatetime" = source."pxUpdateDateTime" , "pxupdateoperator" = source."pxUpdateOperator" , "pxupdateopname" = source."pxUpdateOpName" , "pxupdatesystemid" = source."pxUpdateSystemID" , "pyguid" = source."pyGUID" , "revisedapproachdateoptional" = source."RevisedApproachDateoptional" , "significancefactor" = source."SignificanceFactor" , "torinodescription" = source."TorinoDescription" , "torinorating" = source."TorinoRating" , "type" = source."Type" , "updateapproachdate" = source."UpdateApproachDate" , "updatediameter" = source."UpdateDiameter" , "updateimpactlikelihood" = source."UpdateImpactLikelihood" , "updaterating" = source."UpdateRating" , "workemail" = source."WorkEmail" , "workphone" = source."WorkPhone" FROM source WHERE t."name" = source."Name" RETURNING ASTERISK) INSERT INTO pegadata.pr_arma_seda2_data_neolocal ("name" , "approachdate" , "astronomer" , "case_id" , "diameter" , "discoverername" , "discoverydate" , "estimateddiameterkm" , "impactlikelihood" , "impactlikelihoodestimate" , "observationdate" , "observationsave" , "pxcommitdatetime" , "pxcreatedatetime" , "pxcreateoperator" , "pxcreateopname" , "pxcreatesystemid" , "pxsavedatetime" , "pxupdatedatetime" , "pxupdateoperator" , "pxupdateopname" , "pxupdatesystemid" , "pyguid" , "revisedapproachdateoptional" , "significancefactor" , "torinodescription" , "torinorating" , "type" , "updateapproachdate" , "updatediameter" , "updateimpactlikelihood" , "updaterating" , "workemail" , "workphone") SELECT source."Name" , source."ApproachDate" , source."Astronomer" , source."case_id" , source."Diameter" , source."DiscovererName" , source."DiscoveryDate" , source."EstimatedDiameterkm" , source."ImpactLikelihood" , source."ImpactLikelihoodEstimate" , source."ObservationDate" , source."ObservationSave" , source."pxCommitDateTime" , source."pxCreateDateTime" , source."pxCreateOperator" , source."pxCreateOpName" , source."pxCreateSystemID" , source."pxSaveDateTime" , source."pxUpdateDateTime" , source."pxUpdateOperator" , source."pxUpdateOpName" , source."pxUpdateSystemID" , source."pyGUID" , source."RevisedApproachDateoptional" , source."SignificanceFactor" , source."TorinoDescription" , source."TorinoRating" , source."Type" , source."UpdateApproachDate" , source."UpdateDiameter" , source."UpdateImpactLikelihood" , source."UpdateRating" , source."WorkEmail" , source."WorkPhone" FROM source WHERE NOT EXISTS (SELECT null FROM upsert) was aborted: ERROR: null value in column "pyguid" violates not-null constraint<CR>  Detail: Failing row contains (null, null, 2022-04-04 11:28:52.161, Proprietary information hidden, McKay.holmes, pega, null, Proprietary information hidden, McKay.holmes, pega, 2022-04-04 11:28:52.161, 2017 AB123, 6, null, Asteroid, 20160215, 20251106, 0.463000000, 0.011000000, Galla Layo, 123-456-7890, [email protected], null, null, null, null, null, null, null, null, null, null, null, null).  Call getNextException to see other errors in the batch.<CR>DatabaseException caused by prior exception: java.sql.BatchUpdateException: Batch entry 0 WITH source as (SELECT '2017 AB123'::varchar "Name" , '20251106'::varchar "ApproachDate" , NULL::varchar "Astronomer" , NULL::varchar "case_id" , 0.463::numeric "Diameter" , 'Galla Layo'::varchar "DiscovererName" , '20160215'::varchar "DiscoveryDate" , NULL::numeric "EstimatedDiameterkm" , 0.011000000::numeric "ImpactLikelihood" , NULL::numeric "ImpactLikelihoodEstimate" , NULL::varchar "ObservationDate" , NULL::varchar "ObservationSave" , NULL::timestamp "pxCommitDateTime" , '2022-04-04 11:28:52.161-04'::timestamp "pxCreateDateTime" , ' Proprietary information hidden'::varchar "pxCreateOperator" , 'McKay.holmes'::varchar "pxCreateOpName" , 'pega'::varchar "pxCreateSystemID" , NULL::timestamp "pxSaveDateTime" , '2022-04-04 11:28:52.161-04'::timestamp "pxUpdateDateTime" , ' Proprietary information hidden'::varchar "pxUpdateOperator" , 'McKay.holmes'::varchar "pxUpdateOpName" , 'pega'::varchar "pxUpdateSystemID" , NULL::varchar "pyGUID" , NULL::varchar "RevisedApproachDateoptional" , NULL::numeric "SignificanceFactor" , NULL::varchar "TorinoDescription" , '6'::varchar "TorinoRating" , 'Asteroid'::varchar "Type" , NULL::varchar "UpdateApproachDate" , NULL::varchar "UpdateDiameter" , NULL::varchar "UpdateImpactLikelihood" , NULL::varchar "UpdateRating" , '[email protected]'::varchar "WorkEmail" , '123-456-7890'::varchar "WorkPhone"), upsert AS (UPDATE pegadata.pr_arma_seda2_data_neolocal t SET "name" = source."Name" , "approachdate" = source."ApproachDate" , "astronomer" = source."Astronomer" , "case_id" = source."case_id" , "diameter" = source."Diameter" , "discoverername" = source."DiscovererName" , "discoverydate" = source."DiscoveryDate" , "estimateddiameterkm" = source."EstimatedDiameterkm" , "impactlikelihood" = source."ImpactLikelihood" , "impactlikelihoodestimate" = source."ImpactLikelihoodEstimate" , "observationdate" = source."ObservationDate" , "observationsave" = source."ObservationSave" , "pxcommitdatetime" = source."pxCommitDateTime" , "pxcreatedatetime" = source."pxCreateDateTime" , "pxcreateoperator" = source."pxCreateOperator" , "pxcreateopname" = source."pxCreateOpName" , "pxcreatesystemid" = source."pxCreateSystemID" , "pxsavedatetime" = source."pxSaveDateTime" , "pxupdatedatetime" = source."pxUpdateDateTime" , "pxupdateoperator" = source."pxUpdateOperator" , "pxupdateopname" = source."pxUpdateOpName" , "pxupdatesystemid" = source."pxUpdateSystemID" , "pyguid" = source."pyGUID" , "revisedapproachdateoptional" = source."RevisedApproachDateoptional" , "significancefactor" = source."SignificanceFactor" , "torinodescription" = source."TorinoDescription" , "torinorating" = source."TorinoRating" , "type" = source."Type" , "updateapproachdate" = source."UpdateApproachDate" , "updatediameter" = source."UpdateDiameter" , "updateimpactlikelihood" = source."UpdateImpactLikelihood" , "updaterating" = source."UpdateRating" , "workemail" = source."WorkEmail" , "workphone" = source."WorkPhone" FROM source WHERE t."name" = source."Name" RETURNING ASTERISK) INSERT INTO pegadata.pr_arma_seda2_data_neolocal ("name" , "approachdate" , "astronomer" , "case_id" , "diameter" , "discoverername" , "discoverydate" , "estimateddiameterkm" , "impactlikelihood" , "impactlikelihoodestimate" , "observationdate" , "observationsave" , "pxcommitdatetime" , "pxcreatedatetime" , "pxcreateoperator" , "pxcreateopname" , "pxcreatesystemid" , "pxsavedatetime" , "pxupdatedatetime" , "pxupdateoperator" , "pxupdateopname" , "pxupdatesystemid" , "pyguid" , "revisedapproachdateoptional" , "significancefactor" , "torinodescription" , "torinorating" , "type" , "updateapproachdate" , "updatediameter" , "updateimpactlikelihood" , "updaterating" , "workemail" , "workphone") SELECT source."Name" , source."ApproachDate" , source."Astronomer" , source."case_id" , source."Diameter" , source."DiscovererName" , source."DiscoveryDate" , source."EstimatedDiameterkm" , source."ImpactLikelihood" , source."ImpactLikelihoodEstimate" , source."ObservationDate" , source."ObservationSave" , source."pxCommitDateTime" , source."pxCreateDateTime" , source."pxCreateOperator" , source."pxCreateOpName" , source."pxCreateSystemID" , source."pxSaveDateTime" , source."pxUpdateDateTime" , source."pxUpdateOperator" , source."pxUpdateOpName" , source."pxUpdateSystemID" , source."pyGUID" , source."RevisedApproachDateoptional" , source."SignificanceFactor" , source."TorinoDescription" , source."TorinoRating" , source."Type" , source."UpdateApproachDate" , source."UpdateDiameter" , source."UpdateImpactLikelihood" , source."UpdateRating" , source."WorkEmail" , source."WorkPhone" FROM source WHERE NOT EXISTS (SELECT null FROM upsert) was aborted: ERROR: null value in column "pyguid" violates not-null constraint<CR>  Detail: Failing row contains (null, null, 2022-04-04 11:28:52.161, Proprietary information hidden, McKay.holmes, pega, null, Proprietary information hidden, McKay.holmes, pega, 2022-04-04 11:28:52.161, 2017 AB123, 6, null, Asteroid, 20160215, 20251106, 0.463000000, 0.011000000, Galla Layo, 123-456-7890, [email protected], null, null, null, null, null, null, null, null, null, null, null, null).  Call getNextException to see other errors in the batch.<CR> | SQL Code: 0 | SQL State: 23502<CR><CR>DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: null value in column "pyguid" violates not-null constraint<CR>  Detail: Failing row contains (null, null, 2022-04-04 11:28:52.161, Proprietary information hidden, McKay.holmes, pega, null, Proprietary information hidden, McKay.holmes, pega, 2022-04-04 11:28:52.161, 2017 AB123, 6, null, Asteroid, 20160215, 20251106, 0.463000000, 0.011000000, Galla Layo, 123-456-7890, [email protected], null, null, null, null, null, null, null, null, null, null, null, null).<CR> | SQL Code: 0 | SQL State: 23502<CR><CR>From: (HT1BZG59CQIR00JPANRJ48EH9I255K960A: Proprietary information hidden) <CR> SQL: WITH source as (SELECT ?::varchar "Name" , ?::varchar "ApproachDate" , ?::varchar "Astronomer" , ?::varchar "case_id" , ?::numeric "Diameter" , ?::varchar "DiscovererName" , ?::varchar "DiscoveryDate" , ?::numeric "EstimatedDiameterkm" , ?::numeric "ImpactLikelihood" , ?::numeric "ImpactLikelihoodEstimate" , ?::varchar "ObservationDate" , ?::varchar "ObservationSave" , ?::timestamp "pxCommitDateTime" , ?::timestamp "pxCreateDateTime" , ?::varchar "pxCreateOperator" , ?::varchar "pxCreateOpName" , ?::varchar "pxCreateSystemID" , ?::timestamp "pxSaveDateTime" , ?::timestamp "pxUpdateDateTime" , ?::varchar "pxUpdateOperator" , ?::varchar "pxUpdateOpName" , ?::varchar "pxUpdateSystemID" , ?::varchar "pyGUID" , ?::varchar "RevisedApproachDateoptional" , ?::numeric "SignificanceFactor" , ?::varchar "TorinoDescription" , ?::varchar "TorinoRating" , ?::varchar "Type" , ?::varchar "UpdateApproachDate" , ?::varchar "UpdateDiameter" , ?::varchar "UpdateImpactLikelihood" , ?::varchar "UpdateRating" , ?::varchar "WorkEmail" , ?::varchar "WorkPhone"), upsert AS (UPDATE pegadata.pr_arma_seda2_data_neolocal t SET "name" = source."Name" , "approachdate" = source."ApproachDate" , "astronomer" = source."Astronomer" , "case_id" = source."case_id" , "diameter" = source."Diameter" , "discoverername" = source."DiscovererName" , "discoverydate" = source."DiscoveryDate" , "estimateddiameterkm" = source."EstimatedDiameterkm" , "impactlikelihood" = source."ImpactLikelihood" , "impactlikelihoodestimate" = source."ImpactLikelihoodEstimate" , "observationdate" = source."ObservationDate" , "observationsave" = source."ObservationSave" , "pxcommitdatetime" = source."pxCommitDateTime" , "pxcreatedatetime" = source."pxCreateDateTime" , "pxcreateoperator" = source."pxCreateOperator" , "pxcreateopname" = source."pxCreateOpName" , "pxcreatesystemid" = source."pxCreateSystemID" , "pxsavedatetime" = source."pxSaveDateTime" , "pxupdatedatetime" = source."pxUpdateDateTime" , "pxupdateoperator" = source."pxUpdateOperator" , "pxupdateopname" = source."pxUpdateOpName" , "pxupdatesystemid" = source."pxUpdateSystemID" , "pyguid" = source."pyGUID" , "revisedapproachdateoptional" = source."RevisedApproachDateoptional" , "significancefactor" = source."SignificanceFactor" , "torinodescription" = source."TorinoDescription" , "torinorating" = source."TorinoRating" , "type" = source."Type" , "updateapproachdate" = source."UpdateApproachDate" , "updatediameter" = source."UpdateDiameter" , "updateimpactlikelihood" = source."UpdateImpactLikelihood" , "updaterating" = source."UpdateRating" , "workemail" = source."WorkEmail" , "workphone" = source."WorkPhone" FROM source WHERE t."name" = source."Name" RETURNING ASTERISK) INSERT INTO pegadata.pr_arma_seda2_data_neolocal ("name" , "approachdate" , "astronomer" , "case_id" , "diameter" , "discoverername" , "discoverydate" , "estimateddiameterkm" , "impactlikelihood" , "impactlikelihoodestimate" , "observationdate" , "observationsave" , "pxcommitdatetime" , "pxcreatedatetime" , "pxcreateoperator" , "pxcreateopname" , "pxcreatesystemid" , "pxsavedatetime" , "pxupdatedatetime" , "pxupdateoperator" , "pxupdateopname" , "pxupdatesystemid" , "pyguid" , "revisedapproachdateoptional" , "significancefactor" , "torinodescription" , "torinorating" , "type" , "updateapproachdate" , "updatediameter" , "updateimpactlikelihood" , "updaterating" , "workemail" , "workphone") SELECT source."Name" , source."ApproachDate" , source."Astronomer" , source."case_id" , source."Diameter" , source."DiscovererName" , source."DiscoveryDate" , source."EstimatedDiameterkm" , source."ImpactLikelihood" , source."ImpactLikelihoodEstimate" , source."ObservationDate" , source."ObservationSave" , source."pxCommitDateTime" , source."pxCreateDateTime" , source."pxCreateOperator" , source."pxCreateOpName" , source."pxCreateSystemID" , source."pxSaveDateTime" , source."pxUpdateDateTime" , source."pxUpdateOperator" , source."pxUpdateOpName" , source."pxUpdateSystemID" , source."pyGUID" , source."RevisedApproachDateoptional" , source."SignificanceFactor" , source."TorinoDescription" , source."TorinoRating" , source."Type" , source."UpdateApproachDate" , source."UpdateDiameter" , source."UpdateImpactLikelihood" , source."UpdateRating" , source."WorkEmail" , source."WorkPhone" FROM source WHERE NOT EXISTS (SELECT null FROM upsert)<CR><CR>Caused by SQL Problems.<CR>Problem #1, SQLState 23502, Error code 0: java.sql.BatchUpdateException: Batch entry 0 WITH source as (SELECT '2017 AB123'::varchar "Name" , '20251106'::varchar "ApproachDate" , NULL::varchar "Astronomer" , NULL::varchar "case_id" , 0.463::numeric "Diameter" , 'Galla Layo'::varchar "DiscovererName" , '20160215'::varchar "DiscoveryDate" , NULL::numeric "EstimatedDiameterkm" , 0.011000000::numeric "ImpactLikelihood" , NULL::numeric "ImpactLikelihoodEstimate" , NULL::varchar "ObservationDate" , NULL::varchar "ObservationSave" , NULL::timestamp "pxCommitDateTime" , '2022-04-04 11:28:52.161-04'::timestamp "pxCreateDateTime" , ' Proprietary information hidden'::varchar "pxCreateOperator" , 'McKay.holmes'::varchar "pxCreateOpName" , 'pega'::varchar "pxCreateSystemID" , NULL::timestamp "pxSaveDateTime" , '2022-04-04 11:28:52.161-04'::timestamp "pxUpdateDateTime" , ' Proprietary information hidden'::varchar "pxUpdateOperator" , 'McKay.holmes'::varchar "pxUpdateOpName" , 'pega'::varchar "pxUpdateSystemID" , NULL::varchar "pyGUID" , NULL::varchar "RevisedApproachDateoptional" , NULL::numeric "SignificanceFactor" , NULL::varchar "TorinoDescription" , '6'::varchar "TorinoRating" , 'Asteroid'::varchar "Type" , NULL::varchar "UpdateApproachDate" , NULL::varchar "UpdateDiameter" , NULL::varchar "UpdateImpactLikelihood" , NULL::varchar "UpdateRating" , '[email protected]'::varchar "WorkEmail" , '123-456-7890'::varchar "WorkPhone"), upsert AS (UPDATE pegadata.pr_arma_seda2_data_neolocal t SET "name" = source."Name" , "approachdate" = source."ApproachDate" , "astronomer" = source."Astronomer" , "case_id" = source."case_id" , "diameter" = source."Diameter" , "discoverername" = source."DiscovererName" , "discoverydate" = source."DiscoveryDate" , "estimateddiameterkm" = source."EstimatedDiameterkm" , "impactlikelihood" = source."ImpactLikelihood" , "impactlikelihoodestimate" = source."ImpactLikelihoodEstimate" , "observationdate" = source."ObservationDate" , "observationsave" = source."ObservationSave" , "pxcommitdatetime" = source."pxCommitDateTime" , "pxcreatedatetime" = source."pxCreateDateTime" , "pxcreateoperator" = source."pxCreateOperator" , "pxcreateopname" = source."pxCreateOpName" , "pxcreatesystemid" = source."pxCreateSystemID" , "pxsavedatetime" = source."pxSaveDateTime" , "pxupdatedatetime" = source."pxUpdateDateTime" , "pxupdateoperator" = source."pxUpdateOperator" , "pxupdateopname" = source."pxUpdateOpName" , "pxupdatesystemid" = source."pxUpdateSystemID" , "pyguid" = source."pyGUID" , "revisedapproachdateoptional" = source."RevisedApproachDateoptional" , "significancefactor" = source."SignificanceFactor" , "torinodescription" = source."TorinoDescription" , "torinorating" = source."TorinoRating" , "type" = source."Type" , "updateapproachdate" = source."UpdateApproachDate" , "updatediameter" = source."UpdateDiameter" , "updateimpactlikelihood" = source."UpdateImpactLikelihood" , "updaterating" = source."UpdateRating" , "workemail" = source."WorkEmail" , "workphone" = source."WorkPhone" FROM source WHERE t."name" = source."Name" RETURNING ASTERISK) INSERT INTO pegadata.pr_arma_seda2_data_neolocal ("name" , "approachdate" , "astronomer" , "case_id" , "diameter" , "discoverername" , "discoverydate" , "estimateddiameterkm" , "impactlikelihood" , "impactlikelihoodestimate" , "observationdate" , "observationsave" , "pxcommitdatetime" , "pxcreatedatetime" , "pxcreateoperator" , "pxcreateopname" , "pxcreatesystemid" , "pxsavedatetime" , "pxupdatedatetime" , "pxupdateoperator" , "pxupdateopname" , "pxupdatesystemid" , "pyguid" , "revisedapproachdateoptional" , "significancefactor" , "torinodescription" , "torinorating" , "type" , "updateapproachdate" , "updatediameter" , "updateimpactlikelihood" , "updaterating" , "workemail" , "workphone") SELECT source."Name" , source."ApproachDate" , source."Astronomer" , source."case_id" , source."Diameter" , source."DiscovererName" , source."DiscoveryDate" , source."EstimatedDiameterkm" , source."ImpactLikelihood" , source."ImpactLikelihoodEstimate" , source."ObservationDate" , source."ObservationSave" , source."pxCommitDateTime" , source."pxCreateDateTime" , source."pxCreateOperator" , source."pxCreateOpName" , source."pxCreateSystemID" , source."pxSaveDateTime" , source."pxUpdateDateTime" , source."pxUpdateOperator" , source."pxUpdateOpName" , source."pxUpdateSystemID" , source."pyGUID" , source."RevisedApproachDateoptional" , source."SignificanceFactor" , source."TorinoDescription" , source."TorinoRating" , source."Type" , source."UpdateApproachDate" , source."UpdateDiameter" , source."UpdateImpactLikelihood" , source."UpdateRating" , source."WorkEmail" , source."WorkPhone" FROM source WHERE NOT EXISTS (SELECT null FROM upsert) was aborted: ERROR: null value in column "pyguid" violates not-null constraint<CR>  Detail: Failing row contains (null, null, 2022-04-04 11:28:52.161, Proprietary information hidden, McKay.holmes, pega, null, Proprietary information hidden, McKay.holmes, pega, 2022-04-04 11:28:52.161, 2017 AB123, 6, null, Asteroid, 20160215, 20251106, 0.463000000, 0.011000000, Galla Layo, 123-456-7890, [email protected], null, null, null, null, null, null, null, null, null, null, null, null).  Call getNextException to see other errors in the batch.<CR>Problem #2, SQLState 23502, Error code 0: org.postgresql.util.PSQLException: ERROR: null value in column "pyguid" violates not-null constraint<CR>  Detail: Failing row contains (null, null, 2022-04-04 11:28:52.161, Proprietary information hidden, McKay.holmes, pega, null, Proprietary information hidden, McKay.holmes, pega, 2022-04-04 11:28:52.161, 2017 AB123, 6, null, Asteroid, 20160215, 20251106, 0.463000000, 0.011000000, Galla Layo, 123-456-7890, [email protected], null, null, null, null, null, null, null, null, null, null, null, null).<CR>Problem #3, SQLState 23502, Error code 0: org.postgresql.util.PSQLException: ERROR: null value in column "pyguid" violates not-null constraint<CR>  Detail: Failing row contains (null, null, 2022-04-04 11:28:52.161, Proprietary information hidden, McKay.holmes, pega, null, Proprietary information hidden, McKay.holmes, pega, 2022-04-04 11:28:52.161, 2017 AB123, 6, null, Asteroid, 20160215, 20251106, 0.463000000, 0.011000000, Galla Layo, 123-456-7890, [email protected], null, null, null, null, null, null, null, null, null, null, null, null).<CR> at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:451)<CR> at com.pega.pegarules.data.internal.store.ConnectionStatementStore.executeBatchForAllStatements(ConnectionStatementStore.java:233)<CR> at com.pega.pegarules.data.internal.store.ManagedTransaction.executeOutstandingBatches(ManagedTransaction.java:267)<CR> at com.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:306)<CR> at com.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:108)<CR> at com.pega.pegarules.data.internal.store.DataStoreManager.doInTransaction(DataStoreManager.java:273)<CR> at com.pega.pegarules.data.internal.access.UpdateProcessor.processUpdates(UpdateProcessor.java:226)<CR> at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2171)<CR> at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2133)<CR> at com.pegarules.generated.activity.ra_action_commitwitherrorhandling_663a578384fcc69efadf2473d5dbfc39.step4_circum0(ra_action_commitwitherrorhandling_663a578384fcc69efadf2473d5dbfc39.java:522)<CR> at com.pegarules.generated.activity.ra_action_commitwitherrorhandling_663a578384fcc69efadf2473d5dbfc39.perform(ra_action_commitwitherrorhandling_663a578384fcc69efadf2473d5dbfc39.java:127)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11491)<CR> at com.pegarules.generated.activity.ra_action_workcommit_831f9b05908e4e9b7562054e154dc90d.step3_circum0(ra_action_workcommit_831f9b05908e4e9b7562054e154dc90d.java:426)<CR> at com.pegarules.generated.activity.ra_action_workcommit_831f9b05908e4e9b7562054e154dc90d.perform(ra_action_workcommit_831f9b05908e4e9b7562054e154dc90d.java:110)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11491)<CR> at com.pegarules.generated.activity.ra_action_finishassignment_e8fe2003e3b7eb82d467c7515e2139c4.step19_circum0(ra_action_finishassignment_e8fe2003e3b7eb82d467c7515e2139c4.java:2134)<CR> at com.pegarules.generated.activity.ra_action_finishassignment_e8fe2003e3b7eb82d467c7515e2139c4.perform(ra_action_finishassignment_e8fe2003e3b7eb82d467c7515e2139c4.java:391)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863)<CR> at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:653)<CR> at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:521)<CR> at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:4347)<CR> at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:456)<CR> at sun.reflect.GeneratedMethodAccessor103.invoke(Unknown Source)<CR> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<CR> at java.lang.reflect.Method.invoke(Method.java:498)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1392)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1124)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:978)<CR> at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:379)<CR> at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:934)<CR> at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:338)<CR> at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:282)<CR> at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:259)<CR> at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngineInner(JNDIEnvironment.java:281)<CR> at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:226)<CR> at com.pega.pegarules.web.impl.WebStandardImpl.invokeEngine(WebStandardImpl.java:853)<CR> at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:813)<CR> at com.pega.pegarules.web.impl.WebStandardImpl.doPostInner(WebStandardImpl.java:435)<CR> at sun.reflect.GeneratedMethodAccessor101.invoke(Unknown Source)<CR> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<CR> at java.lang.reflect.Method.invoke(Method.java:498)<CR> at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:388)<CR> at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:430)<CR> at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:225)<CR> at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:274)<CR> at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:164)<CR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)<CR> at com.pega.pegarules.internal.web.servlet.WebStandardBoot.service(WebStandardBoot.java:191)<CR> at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)<CR> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)<CR> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<CR> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)<CR> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<CR> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<CR> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)<CR> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)<CR> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)<CR> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)<CR> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)<CR> at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)<CR> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)<CR> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)<CR> at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)<CR> at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)<CR> at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)<CR> at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1701)<CR> at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)<CR> at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1190)<CR> at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:633)<CR> at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:611)<CR> at org.apache.tomcat.util.net.SecureNio2Channel$1.completed(SecureNio2Channel.java:1010)<CR> at org.apache.tomcat.util.net.SecureNio2Channel$1.completed(SecureNio2Channel.java:938)<CR> at sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:126)<CR> at sun.nio.ch.Invoker$2.run(Invoker.java:218)<CR> at sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:112)<CR> at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)<CR> at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)<CR> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)<CR> at java.lang.Thread.run(Thread.java:750)<CR>Caused by: java.sql.BatchUpdateException: Batch entry 0 WITH source as (SELECT '2017 AB123'::varchar "Name" , '20251106'::varchar "ApproachDate" , NULL::varchar "Astronomer" , NULL::varchar "case_id" , 0.463::numeric "Diameter" , 'Galla Layo'::varchar "DiscovererName" , '20160215'::varchar "DiscoveryDate" , NULL::numeric "EstimatedDiameterkm" , 0.011000000::numeric "ImpactLikelihood" , NULL::numeric "ImpactLikelihoodEstimate" , NULL::varchar "ObservationDate" , NULL::varchar "ObservationSave" , NULL::timestamp "pxCommitDateTime" , '2022-04-04 11:28:52.161-04'::timestamp "pxCreateDateTime" , ' Proprietary information hidden'::varchar "pxCreateOperator" , 'McKay.holmes'::varchar "pxCreateOpName" , 'pega'::varchar "pxCreateSystemID" , NULL::timestamp "pxSaveDateTime" , '2022-04-04 11:28:52.161-04'::timestamp "pxUpdateDateTime" , ' Proprietary information hidden'::varchar "pxUpdateOperator" , 'McKay.holmes'::varchar "pxUpdateOpName" , 'pega'::varchar "pxUpdateSystemID" , NULL::varchar "pyGUID" , NULL::varchar "RevisedApproachDateoptional" , NULL::numeric "SignificanceFactor" , NULL::varchar "TorinoDescription" , '6'::varchar "TorinoRating" , 'Asteroid'::varchar "Type" , NULL::varchar "UpdateApproachDate" , NULL::varchar "UpdateDiameter" , NULL::varchar "UpdateImpactLikelihood" , NULL::varchar "UpdateRating" , '[email protected]'::varchar "WorkEmail" , '123-456-7890'::varchar "WorkPhone"), upsert AS