Timeouts from GP in SSAS

More
9 years 11 months ago #4504 by ddavyjr
I am seeing issues with query timeouts in SSAS connecting to Greenplum. I have tried raising the timeout limit in the connection string, and examining GP log files and to verify that data is being returned from the database. Query performance in other tools suggests I should not be seeing timeouts.

Using 1.3.0.2228 version of the driver.

Are there any cost or row limits I should be aware of when querying data via SSAS and PGNP?

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

More
9 years 11 months ago #4505 by Moderator
PGNP Provider can handle very large volumes of data. Did you set COMMAND_TIMEOUT=0 in the Extended Properties of the Connection String?

Upgrading to the latest provider may also help resolve some issue. Please let our support know if you'd like to upgrade to the latest version.

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

More
9 years 11 months ago #4506 by ddavyjr
Adding COMMAND_TIMEOUT=0; to the connection string in Extended Properties appears to have worked. I was only looking at the Connect Timeout property until now. Thanks!

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

Time to create page: 0.053 seconds
Powered by Kunena Forum