My Oracle Support Banner

Primavera Analytics ODI Load Plans Failing with Error "ORA-12850: Cloud Not Allocate Slaves on All Specified Instance: 2 Needed, 1 Allocated" (Doc ID 2537003.1)

Last updated on JUNE 14, 2021

Applies to:

Primavera Analytics Cloud Service - Version 18.1 and later
Primavera Analytics - Version 18.8 and later
Information in this document applies to any platform.


ODI Load Plan fails and the underlying error in the ODI logs shows something like the following,


ODI-1217: Session LOOP_REALTIME_P6_GLOBAL (91663) fails with return code 12850.
ODI-1226: Step Extend Window fails after 1 attempt(s).
ODI-1229: An error occurred while performing a Journal operation on model code PRIMAVERA_ANALYTICS_P6_GLOBAL.
ODI-1228: Task Journalizing-PRIMAVERA_ANALYTICS_P6_GLOBAL-Store Current Date fails on the target connection PRIMAVERA_ANALYTICS_SRC_DS1.
Caused By: java.sql.SQLException: ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 1 allocated




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

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