SSRS - Regular vs Sharepoint Integrated Mode

More
9 years 10 months ago #4513 by ddavyjr
I have an SSRS report which uses Greenplumb as a data source which runs just fine in Report Manager.

When I move the RDL over to a Sharepoint site however, I get a message saying that my report query cannot be parsed.

Other methods for connecting are working. Reports using other sources also working. When I pull the report SQL out of the SSRS logs and run it against GP it also works.

I'm in the process of eliminating the causes of this error, and I am wondering if you are aware of any differences in behavior for PGNP for reports run in Sharepoint Integrated Mode.

Using 1.3.0.2228 version of the driver.

Please Log in or Create an account to join the conversation.

More
9 years 10 months ago #4519 by Moderator
It is hard to say what is different that causes the issue. Version 1.3.0.2228 looks very old, and the issue might have been resolved in a later version (current is 1.4.0.3054).

I'd recommend updating PGNP provider to a later version. Please contact Support at pgoledb.com to obtain the updated module.

Also, would you run PGNP Profiler and collect errors trace? It could help us find what caused the issue. Thank you!

Please Log in or Create an account to join the conversation.

Time to create page: 0.053 seconds
Powered by Kunena Forum