This page will help to identify the issue concerning the snapshot failure with the error as mentioned below while generating a snapshot.The snapshot fails at "Create Snapshot Definition" step with the following error:
ORA-12899: value too large for column "XXXX_CENTRAL"."DSS_OBJECTS"."OBJECT_DESCRIPTION" (actual: 1088, maximum: 1000)
ORA-06512: at "XXXX_CENTRAL.DSS_CREATE_OBJECT", line 22
ORA-06512: at line 1
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1.x | |
| 8.0.x | |
| 7.2.x |  |
| 7.0.x | |
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS3 | |
| CSS2 | |
Step by Step scenario
- Package the source code
- Run the snapshot
This scenario is generally encountered when the Description field (Cast-MS>Application>Description) has more than 1000 characters which actually exceeds the maximum allowed length on the database.
Since the database allows upto 1000 characters for the column 'OBJECT_DESCRIPTION' and on the GUI we have more than 1000 characters, the snapshot fails while synchronizing the Description on the Dashboard Service.
Perform the below actions as a workaround
- Make the description short on the GUI level and limit it to 1000 or less (including spaces)
Note: This WA has been tested by support.
This issue was reported for 7.0.8 version.
Support was able to reproduce this issue on 7.0.19 as well so this has been reported internally to R&D as improvement to limit the Description to allow only 1000 characters at the GUI level.
Specify pages indirectly related to this topic.(eg:side- effects)
