My Oracle Support Banner

Import Lease Program Is Either Too Long Or Ends In Error With ORA-01555: Snapshot Too Old (Doc ID 2499473.1)

Last updated on NOVEMBER 27, 2019

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.10.0 version, Set Up Asset Lifecycle Management

ACTUAL BEHAVIOR
---------------
Import lease program is either too long or ends in error with ORA-01555: snapshot too old

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

We have loaded a lease file with 10783 leases (FA_LEASES_INT) and 91397 lines of schedules (FA_LEASE_SCHEDULE_ITEMS_INT).
When we run the import assets lease program for the first time, the program ends in error after 4 hours with error message ORA-01555: snapshot too old: rollback segment number with name "" too small. : request_id 1885957
When we run the import assets lease program for the second time, the program ends in error after 3 hours with error message ORA-01555: snapshot too old : request_id 1886078
When we run the import assets lease program for the third time, the program ends in success request_id 1886345
Please find logs for all request_id


We have loaded another lease file with 2018 leases (FA_LEASES_INT) and 110353 lines of schedules (FA_LEASE_SCHEDULE_ITEMS_INT).
When we run the import assets lease program, the program ends in success but it takes more than 3 hours which is way too long request_id 1887748


Changes

 

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.