Oracle: Error Saving Static Data in a Picklist – OSKAR

This will require Data Admin privileges to setup and Builder for implementation.

Problem:

When attempting to save a static picklist to an Oracle repository database, the following error is returned in the iDashboards log file:

ORA-01438: value larger than specified precision allowed for this column...

Information:

Creating a picklist with static data entered saves this static data to your repository. Since you are using Oracle as your repository, the error you are getting relates to specific details about your Oracle database and the data types therein.

This is the information available relating to this error on the Oracle website:

Cause: When inserting or updating records, a numeric value was entered that exceeded the precision defined for the column.

Action: Enter a value that complies with the numeric column's precision, or use the MODIFY option with the ALTER TABLE command to expand the precision.

Resolution:

This simply means that you need to take a look at the static data in your picklist and make sure that it falls into the requirements of the Oracle database you are trying to save it to.

For example, if you are using numeric values, you could be using more digits than are allowed, e.g. 1,000000001 in a column defined as number (10,2). The (10,2) is what is referred to as the precision in Oracle. You can see that there are more than 10 digits (including the comma) in the number and this is why it will not save to the database. The same goes for decimals, if you have a numeric value of 10.235 and a database column defined as number (10,2), you cannot have more than two decimal places in your value and the number 10.235 will not save to the database.

Correct for this by modifying the database column to allow it to accept the number you are trying to save and you should be able to save your picklist without error. Run the following command on the repository:

ALTER TABLE fv_picklist MODIFY max_data_rows NUMBER(10,0);

For More Information:

Oracle JDBC Driver Download
Oracle Database Documentation
Oracle JDBC Driver Documentation
iDashboards Admin Manual 10. Managing Data Sources

If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.