Data Integration - Loads Fail with Error In Process Log "Exception: ('getAdapterDetails', 'java.sql.SQLException: invalid Type Representation(getRep)')" (Doc ID 3002211.1)

Last updated on FEBRUARY 06, 2024

Applies to:

Symptoms

When attempting to run loads, all the process steps complete successfully, but the load ends in error in the Process Details and the following error is seen in the process log.

ERROR
-----------------------
INFO [AIF]: Executing the following script: AftLoad.py
DEBUG [AIF]: Executing Business Rule:BEGIN
INFO [AIF]: No business rules found for load id:380
DEBUG [AIF]: Executing Business Rule:END
ERROR [AIF]: The script has failed to execute:
ERROR [AIF]: The script has failed to execute
FATAL [AIF]: Error in CommData.loadData
Traceback (most recent call last):
  File "", line 2452, in loadData
  File "", line 364, in executeScript
  File "/<path>/EPMSystem11R1/products/FinancialDataQuality/bin/event/AftLoad.py", line 210, in
  adapterDetails = getAdapterDetails(fdmAPI,fdmContext["RULEID"])
  File "<path>EPMSystem11R1/products/FinancialDataQuality/bin/event/AftLoad.py", line 196, in getAdapterDetails
  raise Exception("getAdapterDetails",str(sys.exc_info()[1]).encode("utf-8"))
Exception: ('getAdapterDetails', 'java.sql.SQLException: invalid Type Representation(getRep)')

Cause

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