Related to Frozen Job in process "VI_ESS_PWOHelperPWO Send mail new task for approver"

Question

Hello, 
 I am new to QOIM, can anyone please assist me to resolve a frozen job in process VI_ESS_PWOHelperPWO Send mail new task for approver at process step "SendRichmail" with below error message 
 Error executing the script 'ccc_get_RequestedItemDetails_PWO' 
 column ObjectKeyOrderd was not found in object of type PWOHelperPWO. 
 Column ObjectKeyOrderd does not exist. 
 Version : 7.1.2 
 Thank you !

Barry Jackson · Answer

Hi Jai, 
 
As Paul said, it looks like it's a custom script ..... as the error tells you ..... there is no column ObjectKeyOrderd on the table PWOHelperPWO. There is a column ObjectKeyOrdered on table PersonWantsOrg ...... note that the spelling of ObjectKeyOrdered is wrong in your error so either it's a typo in the script or the developer meant to access ObjectKeyOrdered on PersonWantsOrg and not PWOHelperPWO. 
 
HTH, Barry.