Sep 30 11 6:35 AM

Tags : :

Product:  BizInsight
Applies to:  V4-MAS 90/200
Article Type:  Error

When executing a BizInsight function or analysis set in Excel and using SQL authentication, a ‘Timeout expired’ error is appearing.

A timeout error can indicate many different problems:

1. There is a communication error when using SQL authentication to connect to your database. The type of connection currently used is defined in the BizFunctions.xml.
2. The user credentials provided in the ODBC data sources on the server have changed.
3. There is a hung query in SQL Server.

To resolve this issue, do the following:

1. Check basic connectivity to the server.
   a. Click on Start and then click on Control Panel. 
   b. Double-click Administrative Tools and then double-click Data Sources (ODBC)
   c. Click on the System DSN tab and click Add.
   d. Select SQL Server from the list of drivers.
   e. Enter a name in the Name field.  Any name will work.
   f. In the Server field, enter the servername\instance name of the SQL Server installation where the linked servers are located.  Click Next.
   g. On the next dialog, select a valid authentication method either Windows authentication or SQL authentication. 
       Click Next.
   h. If you are able to get to the next dialog where you’re able to choose the Default database, then you need to double-check the server information entered in the BizFunctions.xml and make sure that the servername\instance name you provided in the DataSource1 section  is the same as what you used for this data source.
   i. If you receive a Login Failed error, correct the credentials you’ve provided and try the ODBC data source again.
   j. If you get an error here like “SQL Server does not exist or access denied”, you have confirmed a basic connectivity problem to the server and should continue with the next troubleshooting step.

2.  If the connectivity test succeeds, go to the server and check the following:

    a. Go to the ODBC data source administrator (Start > Control Panel > Administrative Tools > Data Sources (ODBC).  On the System DSN tab, select one of the MAS90_xxx data sources and click Configure.  Go to the Debug tab and click Test Connection.  If a pop-up window occurs, go to the Logon tab and correct the user credentials provided there.
    b. Go to SQL Management Studio (Start > All Programs > Microsoft SQL Server 2005 > SQL Management Studio) and run the following query:

        select * from master.dbo.sysprocesses where waitresource like 'MAS90%'

       If the query returns records, there are hung queries that need to be cleared.  To clear the hung queries, right-click on the top level in the left pane of the SQL Management Studio window and choose Stop.  Then right-click again and choose Start.  Start a new query window and run the above query again to confirm that all records are cleared.

3. If your BizFunctions.xml is currently configured to use SQL authentication, use Windows authentication instead. Follow the instructions in the Installation Guide under the section Create Linked Servers in SQL Server 2005 Express Edition for further information on adding Windows users and editing the BizFunctions.xml.

If the provided Resolution/Workaround does not resolve your issues, please contact BizNet Software Support for further assistance.