Query timeout expired on WEBI Refresh. Hi,Please check out SAP BO KB 1. Explorer indexing fails due to a timeout. Same query when run on IDT fails as well with Query timeout expired error. Sample report Custom viewsfilters Servers list, organized in groups Integration with EventID. Net Consolidated view for all logs Free for subscribers. Important. Read the vSphere Migration documentation for guidance about migrating VMware vCenter Server to vCenter Server Appliance. Read the Known Limitations for. Unified Communications Manager Version 12. Get product information, technical documents, downloads, and community content. Whenever you need to connect to a database, you create a Connection object using the ADONewConnectiondriver function. NewADOConnectiondriver is an alternative. Hi, Please check out SAP BO KB 1729787 Explorer indexing fails due to a timeout. Same query when run on IDT fails as well with Query timeout expired error. Symptom. Explorer indexing is failing after 1. Explorer Indexing server logs indicate the following error MicrosoftSQL Server Native Client 1. Query timeout expired There are no query execution limits in universe business layer. All timeout setting have been changed to allow indexing on queries that take longer than 1. The query runs successfully after about 1. D00_01_2D00_28_5F00_151536.png' alt='Error Microsoft Odbc Sql Server Driver Query Timeout Expired' title='Error Microsoft Odbc Sql Server Driver Query Timeout Expired' />SQL Server database. Information Design Tool IDT The exact same query also fails when run from IDT on the Client workstation thereby eliminating the isue with Environment. SAP Business Intelligence Platform BI 4. All patch levels. Windows 2. 00. 8R2. Robocopy Long File Name Support. MSSQL Server 2. 00. Universe connections use SQL Server Native Client ODBC connection to SQL Server. Reproducing the Issue. Using Explorer, Create an Information space that runs a query which refreshes for more than 1. Index this Information space Alternatively, using IDT, create the same query using same universe and connection as used in Step 1 and run query Cause. The query is being canceled after 1. Resolution. Follow the below workaround to resolve the issue 1. Make a backup Copy and Edit the sqlsrv. C Program Files x. SAP Business. ObjectsBusiness. Objects Enterprise XI4. Accessconnection. Server in a default BI4 installation. World Of Warships Free Xp on this page. Change the parameter named Query Time. Out Available to False as belowlt Parameter NameQuery Time. Out Available Falselt Parameter 3. Restart the SIA Note When using clusters, make sure to change this parameter on all Nodes. Transformers Full Episodes Download Mp4 more. When experiencing issues on client products like IDT, Make the changes to sqlsrv. Hope this helps,Jin Chong.