Hello!
We're working on getting upgraded to v16, and I'm shifting some of my focus to updating our plethora of custom reports to work in v16 (the important ones, anyway). I'm running into trouble with one of them.
The report uses a shared data source (impresario DB) and two datasets:
According to the customizations check report, there are no issues with this procedure that need updating. I do have an EOD parameter in the custom proc, but I've added the SQL to fix that. When I run the report using the shared dataset, I get "504 Gateway Time-out" error. According to documentation, when using the SetSecurityContext data set with AP_SET_SESSION_CONTEXT, you want to use the shared data source. As far as I can tell, I'm doing everything correctly. The set up is the same as Live, where it is working.
Any insight is greatly appreciated. Let me know if you need additional details.
Thanks,
Michael
We have a similar error with custom reports in our v16 DEV environment. When I execute the SPROC for the custom report, the message is "The EXECUTE permission was denied on the object 'AP_SET_SESSION_CONTEXT', database 'impresario', schema 'dbo'." We have opened a support ticket and they are investigating.
Thanks for responding Jairus Roallos! While I'm sorry to hear it's giving you trouble, it's nice to know I'm not the only one running into this issue. I suppose I'll go the route of opening a ticket as well. Let me know if you learn anything in your ticket.