Page 1 of 1

Database Browser - MSSQL: Timeout expired

Posted: Tue Jun 12, 2012 3:24 am
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

Database Browser - MSSQL: Timeout expired

Posted: Tue Jun 12, 2012 9:40 am
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

Database Browser - MSSQL: Timeout expired

Posted: Tue Jun 12, 2012 5:08 pm
by pringtef
Great, thanks for the quick reply David