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 SUBSCRIPTION NUMBERS, LICENSE 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.
User avatar
pringtef
Posts: 45
Joined: Tue Feb 14, 2012 11:23 pm

Database Browser - MSSQL: Timeout expired

Post by pringtef » Tue Jun 12, 2012 3:24 am

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
Joined: Thu Aug 18, 2011 4:56 am

Database Browser - MSSQL: Timeout expired

Post by davidc » Tue Jun 12, 2012 9:40 am

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.

User avatar
pringtef
Posts: 45
Joined: Tue Feb 14, 2012 11:23 pm

Database Browser - MSSQL: Timeout expired

Post by pringtef » Tue Jun 12, 2012 5:08 pm

Great, thanks for the quick reply David