Hi Experts,
I ran a Rapid Mart Job for Sales and I got the following error.
“Error - First Run date for Job in table AW_FIRST_RUN_DATE is NULL”
I can understand the error that it is loading data from the current date and there is no data or no date. I need to correct it. But, I do not know how. It should be noted that I installed Cost Center Rapid Mart before in this machine and now I am attempting to install Sales Rapid Mart.
Here is the full details of TRACE and ERROR:
Trace:
The initial environment locale <eng_us.cp1252> has been coerced to <Unicode (UTF-16)> ().
Reading job <e6595234_7495_453a_b92b_79c56e4ff6ef> from the repository; Server version is <14.0.2.636>; Repository
version is <14.0.0.0000>.
Current directory of job <e6595234_7495_453a_b92b_79c56e4ff6ef> is <C:\Program Files (x86)\SAP BusinessObjects\Data
Services\bin>.
Starting job on job server host , port <4550>.
Job <Sales_Load_SAP> of runid <2013020717055274601668> is initiated by user .
Processing job <Sales_Load_SAP>.
Initializing transcoder for datastore <RM_DS> to transcode between engine codepage<Unicode (UTF-16)> and datastore
codepage <>
Run as separate process flag is set to YES for the Hierarchy_flattening transform <Hierarchy_Flattening> in data flow
<DF_SalesDocumentHierVr_SAP>.
This is because the dataflow is set to run in PAGEABLE cache and Hierarchy flattening cannot run in pageable mode.
To avoid running as separate process, set data flow cache type to IN MEMORY.
Run as separate process flag is set to YES for the Hierarchy_flattening transform <Hierarchy_Flattening> in data flow
<DF_SalesDocumentHierVr_SAP>.
This is because the dataflow is set to run in PAGEABLE cache and Hierarchy flattening cannot run in pageable mode.
To avoid running as separate process, set data flow cache type to IN MEMORY.
Optimizing job <Sales_Load_SAP>.
Job <Sales_Load_SAP> is started.
Current Job ‘Sales_Load_SAP’ Run Number: 1
Load date String = 2013.02.07 17:06:05
DELTA-Load started taking data from 2002.01.01 00:00:00 to 2013.02.07 17:06:05
*****Target Database is: Microsoft_SQL_Server
Current Job ‘Sales_Load_SAP’ Load Attempt: 3
Job <Sales_Load_SAP> is terminated due to error <50316>.
Error:
|Session Sales_Load_SAP|Function RM_GetFirstRunDate
Error - First Run date for Job in table AW_FIRST_RUN_DATE is NULL
|Session Sales_Load_SAP|Function RM_GetFirstRunDate
Function call <raise_exception ( Error - First Run date for Job in table AW_FIRST_RUN_DATE is NULL ) > failed, due
to error <50316>: < Error - First Run date for Job in table AW_FIRST_RUN_DATE is NULL >.
|Session Sales_Load_SAP
Function call <RM_GetFirstRunDate ( Sales_Load_SAP, FIRST, 0050 ) > failed, due to error <50316>: < Error - First Run
date for Job in table AW_FIRST_RUN_DATE is NULL >.
|Session Sales_Load_SAP
INFO: The above error occurs in the context <|Session Sales_Load_SAP|23 If Step
body|$G_ORIG_SDATE=…|RM_GetFirstRunDate(…)
Function Body|7 If Step body|raise_exception(…) Function Body|>.
|Session Sales_Load_SAP|Function RM_GetFirstRunDate
Error - First Run date for Job in table AW_FIRST_RUN_DATE is NULL
Kindly advice me to proceed further. Waiting for your valuable inputs.
Thanks,
With Kind Regards,
Kannan
kan1969 (BOB member since 2012-02-25)