Question

2
Replies
332
Views
SrikkaRey Member since 2016 1 post
PDN
Posted: 2 years ago
Last activity: 2 years 9 months ago
Closed

DB error as .pyCommitError when Case is triggered

Hi everyone,

I created a new case and trigger it which results the ".pyCommitError", Now my problem is that following error affecting all my other cases which belong to the ClassGroup/Workpool Class ?? May I know Solution How to Resolve this issue??(below there is attached file which shows error)

Errors:

· pyCommitError:** ** Batch entry 0 INSERT INTO personaledition.pc_Prox_CWS_OES_WWS_Work (pzInsKey , pxCommitDateTime , pxcoveredcount , pxcoveredcountopen , pxcoveredcountunsatisfied , pxcoverinskey , pxcreatedatetime , pxcreateoperator , pxcreateopname , pxcreatesystemid , pxcurrentstage , pxcurrentstagelabel , 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 , pyid , pylabel , 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 , CheckBox , cost , loanamount , loantype , totalcost , pzPVStream) VALUES ('PROX-CWS-OES-WWS-WORK P-16' , CURRENT_TIMESTAMP , '0' , '0' , '0' , NULL , '2017-11-17 4:7:7.675000 -8:0:0' , 'Prashanti@Proximus.Com' , 'Prashanti' , 'pega' , NULL , NULL , NULL , 'P-16' , 'Prox-CWS-OES-WWS-Work-ParentCase' , '2017-11-17 4:7:12.123000 -8:0:0' , '2017-11-17 4:7:12.123000 -8:0:0' , 'Prashanti@Proximus.Com' , 'Prashanti' , 'pega' , '10' , NULL , '2017-11-17 4:7:7.676000 -8:0:0' , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , '4' , NULL , NULL , '4' , '0' , '0' , NULL , 'pyDefault' , 'P-16' , 'ParentCase' , 'CWS' , 'BGC' , 'OES' , 'CWS' , 'Prashanti@Proximus.Com' , 'Default' , 'CWS' , 'BGC' , 'OES' , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , 'New' , 'New' , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , ?) was aborted. Call getNextException to see the cause.

Thanks,

Srikanth

Pega Academy
Moderation Team has archived post
Share this page LinkedIn