Troubleshooting

Database Timeouts

If your database is very large and heavily used, complex SQL queries can sometimes fail to get a response within the default timeout period of 30 seconds. You may see an error message like “Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.” If this starts to occur when loading an existing ADV project that has loaded successfully in the past, you can increase the length of time to wait for a response before an error is reported by editing the Data Source that has the problem. Open an ADVM version of the project, and the Settings tab of the Data Source Editor will allow a larger value to be entered:

After increasing the timeout value, you should Save the Data Source definition and then save the project in ADV format, and use the ADV file to replace the master file for the project.

If you receive a timeout error when creating a new data source, you can change the default timeout for new data sources by editing the Config file for your application (ProApp.exe.config for ADVIZOR Analyst, or PublisherApp.exe.config for ADVIZOR Analyst/X). Near the end of the XML-format text file, under &ltappSettings&gt, change the value for the CommandTimeout key.

Multiple Credential Prompts from Non-IE Browsers

If you are using the Google Chrome (or Firefox) browser to connect to an ADVIZOR Server AE system configured for Windows Authentication you might see multiple (usually 3) prompts for username and password:

This can be avoided by proper Windows Internet Options settings:

1. Open the “Internet Options” dialog (from Windows Control Panel, Network and Internet category, or near the bottom of the Internet Explorer “Tools” [gear icon] menu).
2. On the Security tab, set the ADVIZOR Server AE system as a trusted site: click “Trusted sites”, click “Sites”, enter server URL, click “Add” and “Close”.
3. Still on the Security tab, set a custom security level for Trusted sites: click “Custom level…”, scroll to the last setting (Logon), and select “Automatic logon with current user name and password” to allow credentials to be supplied automatically.

For servers in other domains, it may be necessary to check the “Remember my credentials” box in the Windows Security prompt.

IE Security Warning

On Windows Server 2003, 2008, and 2012, you will see one or more warnings when an ADVIZOR desktop application is started if the Internet Explorer Enhanced Security Configuration is in effect for your account. This occurs because the embedded Internet Explorer control is used in the application. The warnings can be dismissed, since pages from Internet sites are not normally displayed in the application. Alternatively, the warnings can be avoided by disabling the Enhanced Security Configuration from Add/Remove Windows Components or the Server Manager, as described in the Microsoft article .aspx)

Cookie Errors

If you receive an error in a browser connecting to ADVIZOR Server AE that states “Server Error in ‘/ADV’ Application” and “A potentially dangerous Request.Cookies value was detected from the client”, or a System.Web.HttpRequestValidationException, you can eliminate the error messages by making a change in the web.config file. (Remember the techniques for editing this file detailed in the section on configuring for secure access.) In the &ltsystem.web&gt section, the httpRuntime line should add the attribute requestValidationMode=”2.0” to look like this: