Database Browser - MSSQL: Timeout expired

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
This topic is 11 years and 9 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
pringtef
Posts: 45
Last visit: Mon Sep 23, 2019 11:00 am

Database Browser - MSSQL: Timeout expired

Post by pringtef »

Software : Primal Studio V3.0.4OS : Windows 7 SP1 x64Powershell Version : V2Hello,I'm getting a problem which i've traced to when using the database browser with large databases with PrimalStudio & PrimalSQL. I'd previously thought this issue had been resolved, but its still happening.When i click on the '+' symbol to the left of the database, after 30 seconds, the following text appears.Query:select pf.TABLE_CATALOG as PK_TABLE_DATABASE, pf.TABLE_SCHEMA as PK_SCHEMA_NAME, pf.TABLE_NAME as PK_TABLE_NAME, pf.COLUMN_NAME as PK_FIELD_NAME, ff.TABLE_CATALOG as FK_TABLE_DATABASE, ff.TABLE_SCHEMA as FK_SCHEMA_NAME, ff.TABLE_NAME as FK_TABLE_NAME, ff.COLUMN_NAME as FK_FIELD_NAME, pf.ORDINAL_POSITION as ORDINAL from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc, INFORMATION_SCHEMA.KEY_COLUMN_USAGE ff, INFORMATION_SCHEMA.KEY_COLUMN_USAGE pf where (rc.CONSTRAINT_NAME=ff.CONSTRAINT_NAME) and (rc.CONSTRAINT_SCHEMA=ff.CONSTRAINT_SCHEMA) and (rc.CONSTRAINT_CATALOG=ff.CONSTRAINT_CATALOG) and (rc.UNIQUE_CONSTRAINT_NAME=pf.CONSTRAINT_NAME) and (rc.UNIQUE_CONSTRAINT_SCHEMA=pf.CONSTRAINT_SCHEMA) and (rc.UNIQUE_CONSTRAINT_CATALOG=pf.CONSTRAINT_CATALOG) and (ff.ORDINAL_POSITION=pf.ORDINAL_POSITION) order by pf.TABLE_SCHEMA, pf.TABLE_NAME, ff.TABLE_SCHEMA, ff.TABLE_NAME, pf.ORDINAL_POSITIONMSSQL: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.It looks like the command timeout for the above command is set at a default of 30 seconds. For smaller databases this works fine because the query will execute within that period, but for larger ones they do not complete the query in time.


pringtef2012-06-12 10:25:34
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Database Browser - MSSQL: Timeout expired

Post by davidc »

Looks like we need to can a Timeout option to the Database browser :-). We will look at adding it for the next service release. David
David
SAPIEN Technologies, Inc.
pringtef
Posts: 45
Last visit: Mon Sep 23, 2019 11:00 am

Database Browser - MSSQL: Timeout expired

Post by pringtef »

Great, thanks for the quick reply David
This topic is 11 years and 9 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.