My Oracle Support Banner

After Ingesting 1000GB Object Into DIVArchive SPM Does Not Process Actions (Doc ID 2179228.1)

Last updated on MARCH 13, 2018

Applies to:

Oracle DIVArchive - Version 5.8 to 6.5 [Release 5.8 to 6.5]
Information in this document applies to any platform.

Symptoms

On : 6.5 version, Configuration GUI. After archiving an object of or greater than size 1000GB, SPM Actions are not updating. When attempting to view SPM logs the following error occurs.

ERROR
-----------------------
04/08/16;16:58:34;0;7;ERROR ; DBManager::onDbResult; ORA-01455: converting column overflows integer datatype
;
04/08/16;16:58:34;0;7;INFO ; DBManager::onDbResult; left;
04/08/16;16:58:34;0;7;INFO ; DBManager::_loadActions; left;
04/08/16;16:58:34;0;7;ERROR ; DBManager::loadActions; GET_ACTION_LIST: ERROR;


 

To check for objects in spm that are over the recommended byte size:
SELECT count(*) AB_OBJECT_NAME from SPM_ARCHIVED_OBJECTS where AB_OBJECT_SIZE > 2147483648;

To check the objects that are displaying an issue, and the current state (scheduled, ect):

SELECT an_object_name, an_object_category, an_action_status
FROM spm_actions
WHERE (an_object_name, an_object_category) IN ( SELECT ab_object_name, ab_category FROM SPM_ARCHIVED_OBJECTS WHERE ab_object_size > 2147483648 );

 

Changes

 Recently archived an object of 1000GB or greater.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.