INCR_LOAD_TEMP_MAP_DATA-INCR LOAD TABLE TEMP_CITY_LAT_LON Fails On The Target Connection ORACLE_FTI.
(Doc ID 2846707.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Fusion Transportation Intelligence - Version 6.4.3 and laterInformation in this document applies to any platform.
Symptoms
Running ETL, NCR_LOAD_TEMP_MAP_DATA-INCR LOAD TABLE TEMP_CITY_LAT_LON fails on the target connection ORACLE_FTI., with the following error:
Error on ODI Tool:
Reviewing the source data, The client noticed, LOCATION data for one record was populated with Japanese characters for PROVINCE_CODE and after that ETL process started failing
Did the following in ODI designer:
1. Increased PROVINCE_CODE length from 6 to 9
2. Designer > FTI_ETL>Procedures > INCR_LOAD_TEMP_DATA > Regenerate Scenario
3. RUN the scenario > INCR_LOAD_TEMP_DATA
4. Still, it returned the same error. It shows value on error as (actual: 9, maximum: 6) though the TEMP_CITY_LAT_LON>PROVENCE CODE has length of 9 bytes.
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 |