July 28, 2015
Worksheet cannot be approved or rejected in the approval tab
To clear up this issue:
■make note of the worksheet reference ID.
■Go into a db management tool
■Find the worksheet in the ELNWORKSHEETS table using the reference. Note the dbID.
■Find the approval record in the ELNWORKSHEETAPPROVALS table using the worksheet db ID, (WRKAPPWRKDBID)
■Set the WRKAPPSTATUSID to 0 in this record.
■In a new portal tab, started after the changes were made, approve the worksheet again.