AX2769
Troubleshooting data save errors
If errors are found during a save-to-database process, these errors are displayed in the Save Data Errors task pane. The errors must be corrected before the data can be saved.
Save errors are organized by sheet in the workbook. Generally speaking, save-to-database errors fall into two major categories:
-
Save process errors: These are errors that prevent the overall save-to-database process from being performed, and are not specific to a certain cell in the worksheet. For example, if a user does not have the appropriate security permissions to save to the target table for the save-to-database process.
-
Cell-specific errors: Most save-to-database errors can be associated with a specific cell in the spreadsheet. For each error found, there is a description of the error and a cell address. You can double-click the cell address to be taken directly to that location.
Troubleshooting data save errors
The following issues are common causes of data save errors:
| Issue | Description |
|---|---|
| Invalid table or column names are used in save-to-database control rows |
All table and column names must match existing table and column names in the database (or alias names). Additionally, for each save-to-database row, all columns must save to the same table (whether the table is explicitly specified in the Save2DB keyword, or determined based on the first destination column in the row that points to a data table). NOTE: If the save process is for a plan file and the file group has enabled the option to Restrict Saves to Related Tables, then the target table for the save process must be listed in the Table Variables tab for the file group, otherwise the table name will be considered invalid. |
| Invalid data exists in the data to be saved to the database | The data in the spreadsheet columns must match the specified data type of the destination column. Also, if the destination column is a validated column, the data to be saved is validated against the lookup column. For example, if an account code in the spreadsheet is not present in the ACCT table, then that data is invalid. |
| Excel formula errors exist in the rows(s) that are configured to save to the database |
If Excel formula errors exist in the rows to be saved, this may result in incorrect or invalid data, and therefore the save is prevented until the errors are corrected. If desired, you can check for Excel formula errors before saving, by choosing Tools > Find Formula Errors from the Advanced group of the Axiom tab. NOTE: Axiom formula errors (#ERR) are not found by the validation process and do not prevent saving to the database. Also, errors on rows that are not configured to be saved to the database are ignored. |
| The user does not have the appropriate permissions to perform the save | The save-to-database process will be stopped if the user does not have write permission to the target table, or if the data to be saved is outside of the user's write filter, or if the user does not have Allow Save Data permission for the file. Also, many Save Type 4 processes require additional security permissions to execute the save. |
All errors must be corrected before the save-to-database can be performed. Note that the file itself is saved, regardless of data save errors (unless you chose to Save Data Only).
