Scribd
Upload
382 views5 pages

Diagnostics - Engine - Log Session Information: HCM Data Loader Error Analysis Report

This report analyzes errors from an HCM data loader process. It loaded a file called PersonalPaymentMethod.zip with 1 data line, which was imported and loaded successfully except for 1 object that failed to load. The import and load process took 40.3 seconds and had a status of succeeded. It was run with default parameters for the data loader configuration.

Uploaded by

shravan oracle
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
382 views5 pages

Diagnostics - Engine - Log Session Information: HCM Data Loader Error Analysis Report

This report analyzes errors from an HCM data loader process. It loaded a file called PersonalPaymentMethod.zip with 1 data line, which was imported and loaded successfully except for 1 object that failed to load. The import and load process took 40.3 seconds and had a status of succeeded. It was run with default parameters for the data loader configuration.

Uploaded by

shravan oracle
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

HCM Data Loader Error Analysis Report 18/02/20 12:10 p.m.

HCM Data Loader Error Analysis Report


Test Name HCM Data Loader Error Analysis Report
Start Date 2020-02-18T[Link]Z
End Date 2020-02-18T[Link]Z
Execution Id 9A3777FAD39C7944E053068E3B0AB3AA
Run Id 9A3773214A1478B6E053068E3B0A0C3D
NLS Bundle
Source Language en
Status Code S
Version [Link].0
Date Format YYYY-MM-DDThh:mm:[Link]

Diagnostics_Engine_Log

Session Information

The Test HCM Data Loader Error Analysis Report is using a database connection with Session Id 1028 and Serial Number 61166

HCM Data Loader Error Analysis Report


Content ID = UCMFA12878021
B_BUSINESS_OBJECT_NAME = <no value specified>
Process ID = 7949136
Detailed Mode = Y

PARAMETERS

INPUT VALUES

UCM Content ID :UCMFA12878021

Business Object Name :

Process ID :

Detailed Report Mode :Y

DATALOADER PARAMETERS

PARAMETER_NAME HDL_PARAM_VALUE HSDL_PARAM_VALUE


Data Error Stack Trace Occurrences by Thread 2 2
Load Cache Clear Limit 500 500
File Character Set UTF-8 UTF-8
Initiate Business Object Post Processing Y Y
Calculate Worker Full-time Equivalent N N
File Encryption NONE NONE
Delete Source File Y Y
File Escape Indicator \ \
Transfer Group Size 100000 100000
Enable Audit Data N N
Enable UI Message Translation N N
Complex Error Stack Trace Occurrences by Thread 5 5
File Delimiter | |
Maximum Percentage of Load Errors 100 100
Environment Configuration
Import Cache Clear Limit 2400 2400
Generate Business Object Mapping Files ORA_N ORA_N
Load Group Size 100 100
Purge Audit Data N N
Disable Post Process Tasks
Extension Key N N
Maximum Percentage of Import Errors 100 100
Purge Person Enabled Key N N
Days to Retain Data Sets Before Deleting 30 30
Data Set Name ORA_DOC_TITLE ORA_DOC_TITLE
Enable Load Group Size Calculation Y Y
Date-effective Update Mode ORA_Y ORA_N
Maximum Concurrent Threads for Load 8 8
Import Commit Size 100 100
HCM Data Loader Scope ORA_FULL ORA_FULL

[Link] Página 1 de 5
HCM Data Loader Error Analysis Report 18/02/20 12:10 p.m.

Days to Retain Data Sets Before Archiving 5 5


File Action IMPORT_AND_LOAD IMPORT_AND_LOAD
Maximum Data Lines Before Archiving 10000000 10000000
Create Worker Default Work Hour Pattern N N
File New Line Indicator n n
Enable Load Events N N
Flexfields Enabled Y Y
Maximum Concurrent Threads for the Environment Configuration 0 0
Maximum Concurrent Threads for Import 8 8
39 row(s) retrieved.

DATA SET DETAILS: [Link]

Distinct Lines Lines


Process Transfer Imported Loaded Data Set : Lines : Lines : : Objects: Objects: Objects: Objects
Data Set ID Content ID ID Data Set Name Status Status Status Messages Total Imported Loaded Failed Total Loaded Failed Unproce
300000144458712 UCMFA12878021 7948699 [Link] SUCCESS SUCCESS ERROR 1 1 0 1 1 0 1 0
1 row(s) retrieved.

ESS PROCESS INFORMATION

Process Name Process Internal Name Process ID ESS Job Status Started Finished Elapsed
Import and Load Data HRC_DL_MAIN 7948699 Succeeded 2020/02/18 [Link] 2020/02/18 [Link] +000000000 [Link].305000
1 row(s) retrieved.

ESS PROCESS PARAMETERS

Process Internal Name Process ID Parameter Value


HRC_DL_MAIN 7948699 Content ID UCMFA12878021
HRC_DL_MAIN 7948699 File Encryption NONE
HRC_DL_MAIN 7948699 File Action IMPORT_AND_LOAD
HRC_DL_MAIN 7948699 File Name [Link]
HRC_DL_MAIN 7948699 Import Commit Size 100
HRC_DL_MAIN 7948699 Maximum Percentage of Import Errors 100
HRC_DL_MAIN 7948699 INTEGRATION_TYPE
HRC_DL_MAIN 7948699 Load Cache Clear Limit 500
HRC_DL_MAIN 7948699 Load Group Size -1
HRC_DL_MAIN 7948699 Maximum Percentage of Load Errors 100
HRC_DL_MAIN 7948699 Maximum Concurrent Threads for Load 8
HRC_DL_MAIN 7948699 File Character Set UTF-8
HRC_DL_MAIN 7948699 Delete Source File Y
HRC_DL_MAIN 7948699 Generate Business Object Mapping Files N
HRC_DL_MAIN 7948699 HCM Data Loader Scope ORA_FULL
HRC_DL_MAIN 7948699 Maximum Concurrent Threads for Import 8
HRC_DL_MAIN 7948699 Data Error Stack Trace Occurrences by Thread 2
HRC_DL_MAIN 7948699 Complex Error Stack Trace Occurrences by Thread 5
HRC_DL_MAIN 7948699 Transfer Group Size 100000
HRC_DL_MAIN 7948699 RUN_AS_LOGGED_IN_USER N
HRC_DL_MAIN 7948699 SOURCE_TYPE ZIP_DAT_FILE
21 row(s) retrieved.

BUSINESS OBJECT : PersonalPaymentMethod

BUSINESS OBJECT

Business
Imported Loaded Object Lines: Lines: Lines: Lines: Objects: Objects: Objects: Objects:
DATA_SET_BUS_OBJ_ID Business Object Version Status Status Messages Total Imported Loaded Failed Total Loaded Failed Unprocessed
300000144458735 PersonalPaymentMethod V1 SUCCESS ERROR 1 1 0 1 1 0 1 0
1 row(s) retrieved.

ESS PROCESS INFORMATION

Process ESS Job


Process Name Process Internal Name ID Status Started Finished Elapsed
-Import and Load Business Object HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Succeeded 2020/02/18 2020 /02/18 +000000000
[Link] [Link] [Link].104000
--Transfer Business Object HRC_DL_TRANSFER_OBJECT 7948705 Succeeded 2020/02/18 2020 /02/18 +000000000
[Link] [Link] [Link].209000
--Import Business Object HRC_DL_IMPORT_OBJECT 7948714 Succeeded 2020/02/18 2020 /02/18 +000000000
[Link] [Link] [Link].086000

[Link] Página 2 de 5
HCM Data Loader Error Analysis Report 18/02/20 12:10 p.m.

--Load Business Object HRC_DL_LOAD_OBJECT 7948715 Succeeded 2020/02/18 2020 /02/18 +000000000
[Link] [Link] [Link].898000
---Load Business Object: HRC_DL_DISPATCH_LOAD_REQUEST 7948716 Succeeded 2020/02/18 2020 /02/18 +000000000
Subprocess [Link] [Link] [Link].548000
5 row(s) retrieved.

ESS PROCESS PARAMETERS

Process Internal Name Process ID Parameter Value


HRC_DL_TRANSFER_OBJECT 7948705 Data Set Business Object ID 300000144458735
HRC_DL_TRANSFER_OBJECT 7948705 File Encryption NONE
HRC_DL_TRANSFER_OBJECT 7948705 File Action IMPORT_AND_LOAD
HRC_DL_TRANSFER_OBJECT 7948705 Import Commit Size 100
HRC_DL_TRANSFER_OBJECT 7948705 Maximum Percentage of Import Errors 100
HRC_DL_TRANSFER_OBJECT 7948705 Load Cache Clear Limit 500
HRC_DL_TRANSFER_OBJECT 7948705 MAX_TRANSFER_THREADS 8
HRC_DL_TRANSFER_OBJECT 7948705 File Character Set UTF-8
HRC_DL_TRANSFER_OBJECT 7948705 HCM Data Loader Scope ORA_FULL
HRC_DL_TRANSFER_OBJECT 7948705 Data Error Stack Trace Occurrences by Thread 2
HRC_DL_TRANSFER_OBJECT 7948705 Complex Error Stack Trace Occurrences by Thread 5
HRC_DL_TRANSFER_OBJECT 7948705 Transfer Group Size 100000
HRC_DL_TRANSFER_OBJECT 7948705 Parent Process ID 300000144459517
HRC_DL_LOAD_OBJECT 7948715 Data Set Business Object ID 300000144458735
HRC_DL_LOAD_OBJECT 7948715 File Action IMPORT_AND_LOAD
HRC_DL_LOAD_OBJECT 7948715 Import Commit Size 100
HRC_DL_LOAD_OBJECT 7948715 Load Cache Clear Limit 500
HRC_DL_LOAD_OBJECT 7948715 Load Group Size -1
HRC_DL_LOAD_OBJECT 7948715 Maximum Percentage of Load Errors 100
HRC_DL_LOAD_OBJECT 7948715 Maximum Concurrent Threads for Load 8
HRC_DL_LOAD_OBJECT 7948715 LOGGED_IN_USER N
HRC_DL_LOAD_OBJECT 7948715 Business Object ID 300000000282000
HRC_DL_LOAD_OBJECT 7948715 File Character Set UTF-8
HRC_DL_LOAD_OBJECT 7948715 HCM Data Loader Scope ORA_FULL
HRC_DL_LOAD_OBJECT 7948715 Data Error Stack Trace Occurrences by Thread 2
HRC_DL_LOAD_OBJECT 7948715 Complex Error Stack Trace Occurrences by Thread 5
HRC_DL_LOAD_OBJECT 7948715 Transfer Group Size 100000
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Content ID UCMFA12878021
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Data Set Business Object ID 300000144458735
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 File Action IMPORT_AND_LOAD
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Import Commit Size 100
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Maximum Percentage of Import Errors 100
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 IMPORT_PROCESS_STARTED Y
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Load Cache Clear Limit 500
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Load Group Size -1
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Maximum Percentage of Load Errors 100
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Maximum Concurrent Threads for Load 8
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 MAX_IMPORT_THREADS 8
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 MAX_TRANSFER_THREADS 8
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Business Object ID 300000000282000
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 File Character Set UTF-8
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Delete Source File Y
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 HCM Data Loader Scope ORA_FULL
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Maximum Concurrent Threads for Import 8
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Data Error Stack Trace Occurrences by Thread 2
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Complex Error Stack Trace Occurrences by Thread 5
HRC_DL_IMPORT_AND_LOAD_OBJECT 7948702 Transfer Group Size 100000
HRC_DL_IMPORT_OBJECT 7948714 Data Set Business Object ID 300000144458735
HRC_DL_IMPORT_OBJECT 7948714 File Action IMPORT_AND_LOAD
HRC_DL_IMPORT_OBJECT 7948714 Import Commit Size 100
HRC_DL_IMPORT_OBJECT 7948714 Maximum Percentage of Import Errors 100
HRC_DL_IMPORT_OBJECT 7948714 IMPORT_RETURN_STATUS_CODE 0
HRC_DL_IMPORT_OBJECT 7948714 Load Cache Clear Limit 500
HRC_DL_IMPORT_OBJECT 7948714 File Character Set UTF-8
HRC_DL_IMPORT_OBJECT 7948714 HCM Data Loader Scope ORA_FULL
HRC_DL_IMPORT_OBJECT 7948714 Data Error Stack Trace Occurrences by Thread 2
HRC_DL_IMPORT_OBJECT 7948714 Complex Error Stack Trace Occurrences by Thread 5
HRC_DL_IMPORT_OBJECT 7948714 Transfer Group Size 100000
HRC_DL_DISPATCH_LOAD_REQUEST 7948716 Data Set Business Object ID 300000144458735
HRC_DL_DISPATCH_LOAD_REQUEST 7948716 File Action IMPORT_AND_LOAD
HRC_DL_DISPATCH_LOAD_REQUEST 7948716 Import Commit Size 100
HRC_DL_DISPATCH_LOAD_REQUEST 7948716 Load Cache Clear Limit 500
HRC_DL_DISPATCH_LOAD_REQUEST 7948716 Load Group Size 50
HRC_DL_DISPATCH_LOAD_REQUEST 7948716 Maximum Percentage of Load Errors 100
HRC_DL_DISPATCH_LOAD_REQUEST 7948716 Maximum Concurrent Threads for Load 1
HRC_DL_DISPATCH_LOAD_REQUEST 7948716 LOGGED_IN_USER N

[Link] Página 3 de 5
HCM Data Loader Error Analysis Report 18/02/20 12:10 p.m.

HRC_DL_DISPATCH_LOAD_REQUEST 7948716 File Character Set UTF-8


HRC_DL_DISPATCH_LOAD_REQUEST 7948716 HCM Data Loader Scope ORA_FULL
HRC_DL_DISPATCH_LOAD_REQUEST 7948716 Data Error Stack Trace Occurrences by Thread 2
HRC_DL_DISPATCH_LOAD_REQUEST 7948716 Complex Error Stack Trace Occurrences by Thread 5
HRC_DL_DISPATCH_LOAD_REQUEST 7948716 Transfer Group Size 100000
71 row(s) retrieved.

SET COMMANDS

Sequence Number Command


0 row(s) retrieved.

METADATA

Parent Header Distinct


Sequence Resolution Transfer Header
Number LINE_ID HEADER_ID Object Discriminator Type Status Messages METADATA
2 300000144552720 300000144552721 PersonalPaymentMethod SUCCESS METADATA|PersonalPaymentMethod|LegislativeDataGroupName|AssignmentNum
1 row(s) retrieved.

LOAD ERRORS

Error Count Originating Process Message Text


1 LOAD The Account Number is invalid.
1 row(s) retrieved.

LOGICAL/PHYSICAL LINE ERRORS(TOP 25 ERRORS)

Attention: Within each error only a sample of 10 data is shown

Error 1 : The Account Number is invalid.

ERROR STACK

Error Stack
[Link]: JBO-[Link]_INVALID_ACCOUNT_NUM: <MESSAGE><NUMBER>CE-660105</NUMBER><TEXT>The Account Number is in
<ACTION></ACTION><DETAILS>The Account Number is invalid because one of the following validations failed: the value entered contains either too many digits or not enough digits, t
and should be numeric or it is numeric and should be alphanumeric, or the check digit validation failed.</DETAILS><INCIDENT></INCIDENT></MESSAGE> at
[Link]([Link]) at [Link]
Method) at [Link]([Link]) at [Link]([Link]
[Link]([Link]) at [Link]([Link]) at [Link]
at [Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at [Link]([Link]) at [Link]
[Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at [Link]([Link]) at [Link]
[Link]([Link]) at [Link](DataL
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link](HcmDataLoaderCoreSetupServiceAMImp
[Link](Unknown Source) at [Link]([Link]) at [Link].M
[Link]([Link]) at [Link]([Link]) at [Link]
[Link](HCMCommonDataLoaderCo
[Link](HCMCommonDataLoa
[Link](Unknown Source) at [Link]([Link]) at [Link].M
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at [Link](Unknown Sour
[Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at [Link](JeeI
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at [Link](Unknown Source)
[Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at [Link](JeeI
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at [Link](Unknown Source)
[Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at [Link](JeeI
[Link]([Link]) at
[Link]([Link]) at [Link]$[Link](JpsAbsInte
[Link](Native Method) at [Link]([Link]) at [Link]
[Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at [Link](Unknown Source) at

[Link] Página 4 de 5
HCM Data Loader Error Analysis Report 18/02/20 12:10 p.m.

[Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at [Link](JeeI
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at [Link](Environm
[Link]([Link]) at [Link]
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at [Link].$[Link](Unknown So
[Link].HCMCommonDataLoaderCoreSetupServiceImpl_5kh9nj_HCMCommonDataLoaderCoreSetupSe
at [Link]([Link]) at
[Link].HCMCommonDataLoaderCoreSetupServiceImpl_5kh9nj_HCMCommonDataLoaderCoreSetupSe
Source) at [Link].invoke0(Native Method) at [Link]([Link]) at
[Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at [Link].$[Link](Unknown Source) at [Link].N
Method) at [Link]([Link]) at [Link]([Link]
[Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at [Link](AsyncRequest
[Link]([Link]) at [Link]$100(AsyncMessageP
[Link]$[Link]([Link]) at [Link](Native Method) at [Link]
at [Link]([Link]) at [Link]$[Link](Abstra
[Link]$[Link]([Link]) at [Link](A
[Link]([Link]) at [Link]([Link]) at [Link](W
[Link]([Link]) at [Link]$[Link]
[Link]([Link]) at [Link](AsyncMessageProcesso
[Link]([Link]) at [Link](AsyncMessageProces
[Link]([Link]) at [Link](Unknown Source)
[Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at [Link](Unknown Source)
[Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at [Link](JeeI
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at
[Link]([Link]) at [Link].$[Link](Unknown Source)
[Link]([Link]) at [Link]([Link]) at
[Link]([Link]) at [Link](NewJMSMessageP
[Link]([Link]) at [Link]([Link]) at
[Link]$[Link]([Link]) at [Link]([Link]) at
[Link]([Link])
1 row(s) retrieved.

Error on Entity : PersonalPaymentMethod

FUSION_ASSIGNED_KEY SOURCESYSTEMID SOURCESYSTEMOWNER GUID LEGISLATIVEDATAGROUPID PAYROLLRELATIONSHIPID PERSONALPAYMENTMETH


300000144554702 2_ASI_PPM HRC_SQLLOADER Banregio Nomina

1 row(s) retrieved.

OBJECT COUNT

Business Object Count


PersonalPaymentMethod 1
1 row(s) retrieved.

OBJECT COMPONENT COUNT

Business Object Root Count Total Count


PersonalPaymentMethod 1 1
1 row(s) retrieved.

[Link] Página 5 de 5

You might also like