Triggering ETL Throwing Error "ETL cannot be triggered as an ETL session with session ID XXX is already running" (Doc ID 3013062.1)

Last updated on MARCH 27, 2024

Applies to:

Oracle Transportation Management Cloud Service - Version 23.3 and later
Information in this document applies to any platform.

Symptoms

In OTM / GTM Transport Intelligence, the observation is ETL Process is not loading data in HDOWNER schema and thus FTI is not sowing any data.

All the setups and configurations are properly defined and required data load agents are also active and running- still TI did not show any data.

When user triggers ETL process manually, it throws error as follows :

Note : XXX refers any integer number.

When checked the status for ETL with the session ID on the error message, it was found that- the ETL is already completed and no other session is active.

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

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