Troubleshooting
The easiest method of troubleshooting is to validate to the produce website in the server SmartIQ is installed
Connection String Errors
Errors in the connection string result in the following errors.
| Description | Exception Details |
|---|---|
| An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. | System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'spConnectorSettings_RegisterSettingsType', database 'master', schema 'dbo'. |
Remediation
Validate the connection String.
Validation
A UDL File can be created to validate the connection string.
Validation the connection String using UDL file
- Create a file with the extension udl.
e.g. test.udl - Open the file by double clicking.The file should open in "OLE Core Services". If the file opens in another program use open with to select OLE Core services.
- Specify the details to connect to the database.
- Test the connection. You should be able to successfully connect to the database.
- Close the window.
- Open the UDL file using a text editor and copy the connection string.
- This connection string needs to be applied to SmartIQ using IIS Manager or by editing web.config.
Installing on a server without Internet access (Produce CDN files)
SmartIQ uses external CDN services to supply Bootstrap (CSS/JavaScript) and JQuery (JavaScript) files to users. This is intended to improve page load performance as there is a greater chance the user has already downloaded and cached the file in the course of browsing to other sites. It also reduces the number of files to be fetched directly from the SmartIQ server.
The "integrity" attribute is used on these external references to enable browsers to confirm that the files haven't been tampered with.
Manage does not use a CDN for privacy reasons, and because Manage is expected to see relatively low traffic compared to Produce.
The feature is enabled by default. It can be disabled by adding the following to the "AppSettings" section of the Produce appsettings.json file:
"AppSettings": {
"UseCdn": "False"
}
Updated over 3 years ago