ALMBI 8.1.1 Transformation Batch Failed With Executable returned : 255 (Doc ID 2980226.1)

Last updated on OCTOBER 16, 2023

Applies to:

Symptoms

On 8.1.1 version, ALMBI Transformation failed with below errors.

ERRORS

1). From TRANSFORM_DATA_INFODOM_IRRBB_Report_20210930_2_Task1_RUNPROCEDURE.log:

[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] Parameters : FN_ALM_BI_TRANSFORMATION,'INFODOM_IRRBB_Report_20210930_2','20210930',806255,'N','N'
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] Statement to execute : BEGIN :D := FN_ALM_BI_TRANSFORMATION('INFODOM_IRRBB_Report_20210930_2','20210930',806255,'N','N'); END;
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] Fetching the return status.
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] Return value From the Stored Procedure : 0
[02-06-23 10:01:01 GMT AM][SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Error code returned : 0
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] execPackage : return val : 0
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][RUNPROCEDURE] After Calling execProc
[02-06-23 10:01:01 GMT AM][SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Stored procedure execution failed

2). From TRANSFORM_DATA_INFODOM_IRRBB_Report_20210930_2_Task1_DTCPP.log:

[02-06-23 10:01:00 GMT AM][INFO][BACKEND][OFSAA][DTCPP] Parameters : FN_ALM_BI_TRANSFORMATION,'INFODOM_IRRBB_Report_20210930_2','20210930',806255,'N','N'
[02-06-23 10:01:00 GMT AM][INFO][BACKEND][OFSAA][DTCPP] child pid : 2327759
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][DTCPP] Exited pid : 2327759, status : 256
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][DTCPP] exit status : 1
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][DTCPP] Step Failure : C594D73DAA97700FE054022128574717
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][DTCPP] taskStatus - in isRunnableChildPresent : 1
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][DTCPP] All the steps/jobs have been executed
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][DTCPP] Jobs over.
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][DTCPP] tasksatus inside executesteps - 1
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][DTCPP] Returned from executeSteps : 1
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][DTCPP] Stmt : update AAI_DMT_PLC_EXECUTE set v_status='F' where v_Infodom_Code='INFODOM' and v_obj_id='C594D73DAA97700FE054022128574717'
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][DTCPP] Task status : 1
[02-06-23 10:01:01 GMT AM][INFO][BACKEND][OFSAA][DTCPP] Task Failure

3). From TRANSFORM_DATA_INFODOM_IRRBB_Report_20210930_2_Task1_DT.log:

[02-06-23 10:00:59,155 GMT AM] [INFO ] [BACKEND] [SYSADMN] [DMT] [Postman]~[invokeTask]~Invoking executable as : [/u01/app/ofsaa/ficdb/bin/DTServer, INFODOM_IRRBB_Report_20210930_2, TRANSFORM DATA, Task1, 20210930, <ip_address>,EDW,INFODOM,ALM_BI_TRANSFORMATION,806255,'N','N']
[02-06-23 10:01:01,698 GMT AM] [INFO ] [BACKEND] [SYSADMN] [DMT] [Postman]~[invokeTask]~Logs from executable : ClsUStandardLogger :: InitConfigFile : FileName = BackendServerProperties.conf FilePath = /u01/app/ofsaa/ficdb/confClsUStandardLogger :: InitConfigFile :: Configuration file opened successfullyClsUStandardLogger :: InitConfigFile :: Configuration file reading successfulClsUStandardLogger :: InitConfigFile : FileName = BackendServerProperties.conf FilePath = /u01/app/ofsaa/ficdb/confClsUStandardLogger :: InitConfigFile :: Configuration file opened successfullyClsUStandardLogger :: InitConfigFile :: Configuration file reading successful
[02-06-23 10:01:01,699 GMT AM] [INFO ] [BACKEND] [SYSADMN] [DMT] [Postman]~[invokeTask]~Executable returned : 255

No error found in FSI_MESSAGE_LOG regarding execution of ALM BI Transformation task.

Cause

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