Scheduled Analytics Publisher Jobs fails intermittently with Error "ApplSession returned from ATG API is null"
(Doc ID 2957553.1)
Last updated on JUNE 26, 2023
Applies to:
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.23.04.0 and laterOracle Fusion Financials Common Module Cloud Service - Version 11.13.23.04.0 and later
Oracle Fusion Self Service Procurement Cloud Service - Version 11.13.23.04.0 and later
Information in this document applies to any platform.
Symptoms
Analytics Publisher Scheduled Jobs fails intermittently with the below error. This issue can occur after receiving 23B Quarterly update. As a result the failed job related report output will not be available.
Steps
- Login to Fusion cloud service
- Navigate to Tools > Report & Analytics
- Click Browse Catalog
- Navigate to the shared folder of the Analytics Publisher report to be scheduled
- Click on More > Schedule to submit a Job
- Click on Home
- Navigate to Report Job History Page and verify the Status details
- Few Jobs may fail due to the below error
Error
[INSTANCE_ID=bip.bi_serverHA] DataException:[INSTANCE_JOB_ID=xxxxxx] oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo.XDOException: ApplSession returned from ATG API is null:API is called with sessionId:******7A983Exxxxxxx3310A6xxxx
Could not get data source connection for: ApplicationDB_FSCM oracle.xdo.servlet.data.DataException: oracle
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 |
Cause |
Solution |
References |