Unable to import data source into the library in Spotfire 14.x, with error "Cannot delete the last version"
Article ID: KB0070202
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 14.0.1, 14.0.2, 14.0.3, 14.0.4, 14.1.0, 14.2.0, 14.3.0, 14.4.0 |
Description
Unable to import a data source into the Spotfire 14.x.x library, either from a lower version or the same version.
You get one of the following errors:
---------
Caused by: oracle.jdbc.OracleDatabaseException: ORA-20004: Cannot delete the last version
Caused by: com.spotfire.ws.library.StorageException: ORA-20004: Cannot delete the last version
---------
Library import works fine for other library items, such as DXP and folders.
Issue/Introduction
Environment
Resolution
You need to set the information-services.retain-original-version-after-import-validation configuration property to true.
Follow the below steps:
For a Linux installation:
- Export the existing configuration.
- Run the following commands:
./config.sh set-config-prop --name="library.versioning.enabled" --value="true"
./config set-config-prop --name="library.versioning.enabled-by-default" --value="false"
./config.sh set-config-prop --name="information-services.retain-original-version-after-import-validation" --value="true"
- Import the configuration.
- Restart the services on their app servers.
For a Windows installation:
- Export the existing configuration.
- Run the following commands:
config set-config-prop --name="library.versioning.enabled" --value="true"
config set-config-prop --name="library.versioning.enabled-by-default" --value="false"
config set-config-prop --name="information-services.retain-original-version-after-import-validation" --value="true"
- Import the configuration.
- Restart the services on their app servers.
Feedback
