Syntax Error or Access Rule Violation detected by database ( Unknown column 'sc_item_option.value' in 'field list')

[Akhilkumar2]

Hi All,

I have created a report for getting all Requested items details.

I have used sc_task table for gettiing information from CTASK level also.these are the fileds which i want

-RITM-No.
- Catalog-Item Name
- Stage
- State
- RITM created
- Requested for --> Name
- Requested by --> Name
- all variables/content in the RITM
- ...
- Approved by
- Actual pending CTASK No. (State= OPEN; WORK IN PROGRESS)
- Actual pending CTASK Short description
- Actual pending CTASK "Assignment group"
- Actual pending CTASK "Assigned to"

When i add fields under variables, im gettting an error like this

Any one knows , how to solve this issue.

Regards,

Akhil

[manish_sn]

Hi Akhilkumar,

From the symptoms provided by you, I think you are experiencing the following issue

Definition: Running a report that includes many variables on many tables (60 or more) causes SQL Exception "Unknown column 'sc_item_option.value' in 'field list'"

Workaround:

Create multiple reports, each of which have joins from less than 60 tables. These will export successfully.

Note: 1 variable = 1 join

Please let us know if this helps.

Regards

Manish

[Slawek_Radziewi]

I think you want to report on different request item on different variables.

When I am trying to do the same it requires me to pick one catalog item and its variables.

So it seems it is not so easy to report on all variables. 

Try to report on Request item.Textual Variables.