Custom Ship Ticket Error

I am trying to fix our Ship Ticket as it keeps giving us the error:

Query execution failed for dataset ‘OrderHed’. —> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

I have looked on the servers and nothing is mentioned on this error except for what I pasted here. Ideas on how to find the actual issue?

So, if you open SQL Studio and select the Report Services, Right Click on the Node, Go to advanced, under the Security section you can change the Remote Errors from false to true.

Do you see the error now?

Does it not work for only this ticket?

I can see it now. I just needed to enable remote errors in the SQL Studio.

Cool, nice. What does the error say?

It just gave me a list of Columns that needed to be allowed. I had them restricted. It is working now.

1 Like