• State Suggested Answer
  • Locked Locked
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 95 subscribers
  • Views 2486 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

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

Jai
over 7 years ago

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 !

  • 0 over 7 years ago
    The fact that the referenced script starts with "ccc_" means that it is a custom script. Using the Designer.exe you can open the script and review the contents, I would guess it's looking at the PersonWantsOrg table , often shortened to "PWO".
  • 0 over 7 years ago
    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.