IMPORTANT: Due to the removal of ODBC functionality in Java 1.8, iDashboards will be retiring support for ODBC. The following applies only to iDashboards v9.1 and earlier, or later versions which are running 32-bit Tomcat and Java 1.7.
An operation timeout message appears when trying to upload an excel file from the iDashboards Admin application. The error is similar to the following:
"The data source (ID = <ID of the data source>) for this operation is currently unavailable. Contact your iDashboards System Administrator for assistance."
According to the iDashboards log file there is a timeout in trying to connect to the Excel spreadsheet. The error is as follows: "java.sql.SQLException: Operation timed out. Failed to connect after 10 seconds." This error is the true cause of the problem. This means that the JDBC connection to the data source, in this case the JDBC/ODBC connection to Excel, is timing out.
- Add the following line to the ivizgroup.properties file:
- Restart Tomcat.
- X Platform
- Enterprise Suite