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.
After successfully uploaded a spreadsheet, when the user is attempting to create a chart from the user application, he/she might encounter the following error:
“An error occurred while retrieving the data for the chart : [Microsoft][ODBC Excel Driver] Too few parameters. Expected 4.”
This error is generally due to there being space in one or more of the column names of the Excel Named Range within the spreadsheet.
The solution is to remove all of the leading, trailing and other spaces in the Excel column name. Then save and re-upload the excel file.
- Eval Cloud
- Cloud Standard
- Cloud PAL
- Private Cloud
- X Platform
- Enterprise Suite