How do we determine what column task0.a_ref_10 is?
We submitted a HI ticket but while we are awaiting a response, I thought I'd throw this into the community. We moved an update set into PROD last night and our change tickets got all wonky. From the list view, the record numbers and the rest of the data is either empty or blank and we are getting a mean error when users open a Change record.
Incident and Problem are fine. This is only happening in Change. I found similar syntax error blogs but could not find a field "task0.a_ref_10"
Syntax Error or Access Rule Violation detected by database (Unknown column 'task0.a_ref_10' in 'field list')
If you want to know what fields are aliased to actual MySQL fields, you can use the table sys_storage_alias. Example:
