Error occured at INSERT entry into SAP table GVD_SPPARAMETER Return code 4

[Ganimede-Dignan]

Hi,

after a system copy base don export/import we can see this error message on target system for job SAP_PERIODIC_ORACLE_SNAPSHOT:

Error occured during creation of oracle snapshot (Creation aborted)
(Log see also transaction SLG1, Object ORASNAP, Subobject ORASNAPCR)
Oracle snapshot creation program aborted
Error occured at INSERT entry into SAP table GVD_SPPARAMETER Return code 4
Oracle view GV$SPPARAMETER

Have you got any idea?

The system it's a NetWeaver Box 7.31 on Windows 2008 R2 and Oracle 11.2.0.2.0

SAP_BASIS    731    0005    SAPKB73105

SAP_ABA    731    0005    SAPKA73105

PI_BASIS    731    0005    SAPK-73105INPIBASIS

ST-PI    2008_1_700    0008    SAPKITLRD8

BI_CONT    747    0002    SAPK-74702INBICONT

SAP_BW    731    0005    SAPKW73105

ST-A/PI    01Q_731    0002    SAPKITAB9L

Thank You.

Regards.

[ACE-SAP · Accepted solution]

Hello,

The GVD_* tables are outdated since Oracle 10. You should unschedule this job that is running report RSORAHST.

Regards

http://service.sap.com/sap/support/notes/1292088

1411834 - DBA Cockpit: GVD_* tables, RSORAHCL, history

If you do not require the information from the GVD_* tables, we recommend that you deactivate this history update type:

1. Deschedule the report RSORAHCL (see the table TCOLL).

2. Delete the contents of the GVD_* tables.

As of Basis 7.00 Support Package 21, the data collection using the reports RSORAHCL and RSORAHST is no longer used (also see Notes 1080813 and 1369716).