Home
%3CLINGO-SUB%20id%3D%22lingo-sub-388124%22%20slang%3D%22en-US%22%3EExtending%20timeout%20setting%20for%20Reference%20Data%20Services%20(RDS)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388124%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Apr%2010%2C%202013%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EDQS%2C%20by%20default%2C%20uses%20connection%20timeout%20of%201%20minutes%20when%20connecting%20to%20external%20Reference%20Data%20Services%20(RDS)%20provider.%26nbsp%3B%26nbsp%3BYou%20can%20modify%20the%20timeout%20setting%2C%20using%20the%20following%20steps%3A%3C%2FP%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3ERun%20the%20following%20query%20on%20SQL%20Server%20where%20DQS%20is%20installed%3A%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3CBLOCKQUOTE%3E%3CBR%20%2F%3E%3CP%3ESELECT%20%5BID%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%2C%5BSERVICE%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%2C%5BNAME%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%2C%5BUPDATE_TIME%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%2C%5BDESCRIPTION%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%2C%5BVALUE%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%2C%5BREVISION%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EFROM%20%5BDQS_MAIN%5D.%5Bdbo%5D.%5BA_CONFIGURATION%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3E%20where%20id%3D916%20%3C%2FSTRONG%3E%3C%2FP%3E%3CBR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EClick%20on%20the%20value%20cell%20(XML)%20and%20copy%20the%20XML%20output%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F99798i1B81F9AC66546315%22%20%2F%3E%3C%2FP%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EChange%20the%20ConnectionTimeout%20parameter%20(default%2060000%20or%201%20minute)%20and%20update%20the%20record%20(%20%3CSTRONG%3E%20Tips%20%3C%2FSTRONG%3E%20%3A%20Make%20sure%20to%20update%20DQS_MAIN%20database%20before%20you%20make%20the%20update)%2C%20for%20example%3A%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3CBLOCKQUOTE%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3E%20BEFORE%20%3C%2FSTRONG%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3Eupdate%20%5BDQS_MAIN%5D.%5Bdbo%5D.%5BA_CONFIGURATION%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3Eset%20value%20%3D%20'%3CCONFIGURATION%20name%3D%22%26quot%3BReferenceData%26quot%3B%22%3E%3C%2FCONFIGURATION%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BCacheEnabled%26quot%3B%22%20value%3D%22%26quot%3B1%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BCacheCleanupIntervalMinutes%26quot%3B%22%20value%3D%22%26quot%3B1440%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BCacheInvalidationTimeHours%26quot%3B%22%20value%3D%22%26quot%3B24%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BCacheSizeEntries%26quot%3B%22%20value%3D%22%26quot%3B1000000%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BBatchQuerySizeEntries%26quot%3B%22%20value%3D%22%26quot%3B100%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BQueryMinConfidence%26quot%3B%22%20value%3D%22%26quot%3B0.4%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BQueryMaxSuggestions%26quot%3B%22%20value%3D%22%26quot%3B5%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BProxyAddress%26quot%3B%22%20value%3D%22%26quot%3B%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3E%20%3C%2FSTRONG%3E%3COBJECT%3E%3CSTRONG%3E%20%3C%2FSTRONG%3E%20%3CSTRONG%3E%20%3C%2FSTRONG%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BDataMarketCatalogEntryPoint%26quot%3B%22%20value%3D%22%26quot%3Bservices%2Fmy%2FDatasets%3F%24filter%3DCategory%2520eq%2520''Data%22%20quality%3D%22%22%20services%3D%22%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BMetadataEntryPoint%26quot%3B%22%20value%3D%22%26quot%3B%2F%24metadata%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BRetryErrorCodes%26quot%3B%22%20value%3D%22%26quot%3B504%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BRetryReduceFactor%26quot%3B%22%20value%3D%22%26quot%3B5%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3C%2FBLOCKQUOTE%3E%3C%2FLINGO-BODY%3E'%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3Ewhere%20%3C%2FSTRONG%3E%20%3CSTRONG%3E%20id%3D916%3C%2FSTRONG%3E%3C%2FP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3E%20AFTER%20%3C%2FSTRONG%3E%3C%2FP%3E%3CBR%20%2F%3E%3CBLOCKQUOTE%3E%3CBR%20%2F%3E%3CP%3Eupdate%20%5BDQS_MAIN%5D.%5Bdbo%5D.%5BA_CONFIGURATION%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3Eset%20value%20%3D%20'%3CCONFIGURATION%20name%3D%22%26quot%3BReferenceData%26quot%3B%22%3E%3C%2FCONFIGURATION%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BCacheEnabled%26quot%3B%22%20value%3D%22%26quot%3B1%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BCacheCleanupIntervalMinutes%26quot%3B%22%20value%3D%22%26quot%3B1440%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BCacheInvalidationTimeHours%26quot%3B%22%20value%3D%22%26quot%3B24%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BCacheSizeEntries%26quot%3B%22%20value%3D%22%26quot%3B1000000%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BBatchQuerySizeEntries%26quot%3B%22%20value%3D%22%26quot%3B100%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BQueryMinConfidence%26quot%3B%22%20value%3D%22%26quot%3B0.4%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BQueryMaxSuggestions%26quot%3B%22%20value%3D%22%26quot%3B5%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BProxyAddress%26quot%3B%22%20value%3D%22%26quot%3B%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3E%20%3C%2FSTRONG%3E%3COBJECT%3E%3CSTRONG%3E%20%3C%2FSTRONG%3E%20%3CSTRONG%3E%20%3C%2FSTRONG%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BDataMarketCatalogEntryPoint%26quot%3B%22%20value%3D%22%26quot%3Bservices%2Fmy%2FDatasets%3F%24filter%3DCategory%2520eq%2520''Data%22%20quality%3D%22%22%20services%3D%22%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BMetadataEntryPoint%26quot%3B%22%20value%3D%22%26quot%3B%2F%24metadata%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BRetryErrorCodes%26quot%3B%22%20value%3D%22%26quot%3B504%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3COBJECT%3E%3CPARAM%20name%3D%22%26quot%3BRetryReduceFactor%26quot%3B%22%20value%3D%22%26quot%3B5%26quot%3B%22%20%2F%3E%3C%2FOBJECT%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E'%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3Ewhere%20%3C%2FSTRONG%3E%20%3CSTRONG%3E%20id%3D916%3C%2FSTRONG%3E%3C%2FP%3E%3CBR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CBR%20%2F%3E%3CP%3ENote%3A%20make%20sure%20to%20qualify%20single%20quote(%E2%80%98)%20for%20DatamarketCatalogEntryPoint%20with%20two%20single%20quote%20(%E2%80%98%E2%80%99)%3C%2FP%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3ERestart%20sql%20server%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%0A%20%0A%3CLINGO-TEASER%20id%3D%22lingo-teaser-388124%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Apr%2010%2C%202013%20DQS%2C%20by%20default%2C%20uses%20connection%20timeout%20of%201%20minutes%20when%20connecting%20to%20external%20Reference%20Data%20Services%20(RDS)%20provider.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-388124%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eazure%20datamarket%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edata%20quality%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edata%20quality%20service%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edata%20quality%20services%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edqs%20cleansing%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ereference%20data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ereference%20data%20service%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor
First published on MSDN on Apr 10, 2013

DQS, by default, uses connection timeout of 1 minutes when connecting to external Reference Data Services (RDS) provider.  You can modify the timeout setting, using the following steps:



  • Run the following query on SQL Server where DQS is installed:



SELECT [ID]


,[SERVICE]


,[NAME]


,[UPDATE_TIME]


,[DESCRIPTION]


,[VALUE]


,[REVISION]


FROM [DQS_MAIN].[dbo].[A_CONFIGURATION]


where id=916





  • Click on the value cell (XML) and copy the XML output




  • Change the ConnectionTimeout parameter (default 60000 or 1 minute) and update the record ( Tips : Make sure to update DQS_MAIN database before you make the update), for example:



BEFORE


update [DQS_MAIN].[dbo].[A_CONFIGURATION]


set value = '<configuration name="ReferenceData">


<param name="CacheEnabled" value="1" />


<param name="CacheCleanupIntervalMinutes" value="1440" />


<param name="CacheInvalidationTimeHours" value="24" />


<param name="CacheSizeEntries" value="1000000" />


<param name="BatchQuerySizeEntries" value="100" />


<param name="QueryMinConfidence" value="0.4" />


<param name="QueryMaxSuggestions" value="5" />


<param name="ProxyAddress" value="" />


<param name="ConnectionTimeout" value="60000" />


<param name="DataMarketCatalogEntryPoint" value="services/my/Datasets?$filter=Category%20eq%20''Data Quality Services''" />


<param name="MetadataEntryPoint" value="/$metadata" />


<param name="RetryErrorCodes" value="504" />


<param name="RetryReduceFactor" value="5" />


</configuration>'


where id=916




AFTER



update [DQS_MAIN].[dbo].[A_CONFIGURATION]


set value = '<configuration name="ReferenceData">


<param name="CacheEnabled" value="1" />


<param name="CacheCleanupIntervalMinutes" value="1440" />


<param name="CacheInvalidationTimeHours" value="24" />


<param name="CacheSizeEntries" value="1000000" />


<param name="BatchQuerySizeEntries" value="100" />


<param name="QueryMinConfidence" value="0.4" />


<param name="QueryMaxSuggestions" value="5" />


<param name="ProxyAddress" value="" />


<param name="ConnectionTimeout" value="300000" />


<param name="DataMarketCatalogEntryPoint" value="services/my/Datasets?$filter=Category%20eq%20''Data Quality Services''" />


<param name="MetadataEntryPoint" value="/$metadata" />


<param name="RetryErrorCodes" value="504" />


<param name="RetryReduceFactor" value="5" />


</configuration>'


where id=916



Note: make sure to qualify single quote(‘) for DatamarketCatalogEntryPoint with two single quote (‘’)



  • Restart sql server