158 views

Description

Trying to use dot-walked tag fields in a list view or report results in Syntax Error or Access Rule Violation detected by database (Unknown column 'task4.sys_tags' in 'field list'):


mysql: Syntax Error or Access Rule Violation detected by database (Unknown column 'task4.sys_tags' in 'field list')
oracle: Syntax Error or Access Rule Violation detected by database (ORA-00904: "TASK1"."sys_tags": invalid identifier)

If you configure a list to add a dot walk to the tags field of a reference, the list no longer displays properly and you receive the above errors when trying to view the list.

Steps to Reproduce

  1. Login an early Helsinki instance.
  2. Go to any list of a table extended from task that has a reference field to a table extended from task (e.g. sc_task).
  3. Configure the list.
  4. Add a reference_field.tags column to the list (e.g. sc_req_item.tags).

Notice the errors thrown, and the list does not display.

Workaround

There is no workaround available for this issue. Please upgrade to one of the available patches listed in the Fixed In tab.

 


Related Problem: PRB634999

Seen In

Fuji Patch 11
Fuji Patch 2 Hot Fix 1
Geneva Patch 1 Hot Fix 5
Geneva Patch 4
Geneva Patch 6
Geneva Patch 7 Hot Fix 2

Fixed In

Geneva Patch 11 Hot Fix 1
Helsinki Patch 11
Istanbul Patch 6
Jakarta

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-02-23 07:28:31
Published:2018-02-23