error: SAP K4 variant no period is defined

dataservices rapidmarts
1

Hello :smiley:

I have never used Data Integrator and I am faced with the following error. Anyone has an idea where I should start?

log: error_12_23_2005_02_15_01_8_6ceb2953_fceb_4e74_878a_3d72e6e7c13b.txt Job Server: BROCA522:3500

(6.5) 12-23-05 02:15:36 (E) (0376:0168) R3C-150605: Dataflow DF_TimeDim
The SAP job was canceled for host <>, job name <R3_TimeDim 12/23/05 02:15:16>, job count <02240901>,
12/23/2005 02:24:09 Job started
12/23/2005 02:24:09 Step 001 started (program ZW00376201, variant &0000000000006, user ID BO)
12/23/2005 02:24:09 For the K4 fiscal year variant, no period is defined for 01/01/1990
12/23/2005 02:24:09 Job cancelled after system exception ERROR_MESSAGE

.

(6.5) 12-23-05 02:15:36 (E) (0908:0664) R3C-150605: Dataflow DF_TimeDim The SAP job was canceled for host <>, job name <R3_TimeDim 12/23/05 02:15:16>, job count <02240901>,
12/23/2005 02:24:09 Job started
12/23/2005 02:24:09 Step 001 started (program ZW00376201, variant &0000000000006, user ID BO)
12/23/2005 02:24:09 For the K4 fiscal year variant, no period is defined for 01/01/1990
12/23/2005 02:24:09 Job cancelled after system exception ERROR_MESSAGE

.

When the K4 variants get set back to 1990, even though the system only has transactional data in SAP starting July 1998 and
the job is run again, the following error appears.

(6.5) 12-23-05 09:25:13 (E) (2464:2532) R3C-150605: Dataflow DF_TimeDim
The SAP job was canceled for host <>, job name <R3_TimeDim 12/23/05 09:24:56>, job count , 12/23/2005 09:33:59 Job started
12/23/2005 09:33:59 Step 001 started (program ZW02464201, variant &0000000000033, user ID BO)
12/23/2005 09:34:01 For the K4 fiscal year variant, no period is defined for / /
12/23/2005 02:34:01 Job cancelled after system exception ERROR_MESSAGE

.

(6.5) 12-23-05 09:25:13 (E) (2508:2028) R3C-150605: Dataflow DF_TimeDim
The SAP job was canceled for host <>, job name <R3_TimeDim 12/23/05 09:24:56>, job count ,
12/23/2005 09:33:59 Job started
12/23/2005 09:33:59 Step 001 started (program ZW02464201, variant &0000000000033, user ID BO)
12/23/2005 09:34:01 For the K4 fiscal year variant, no period is defined for / /
12/23/2005 02:34:01 Job cancelled after system exception ERROR_MESSAGE

.

This is all the info I have for the time being. What I can maybe add to this is that this error is occuring due to a change in fiscal year in SAP.

tweetee :canada: (BOB member since 2004-10-14)

2

You are using a Rapid Mart.

Go to the workflow (component) C_TimeDim_SAP. There, you will find a script where the company code is set. With this $CCODE we, inside the DF, inside the R/3 DF, read the table T001, the field PERIV and use this as parameter for the SAP function module FI_PERIOD_DETERMINE.

And this function is raising the error that your PERIV value is incorrect, probably because the CCODE is wrong.

(Hope your RapidMart is a version not older than two years. Otherwise the flow will look slightly different but based on the function and its parameters you will be able to track the root cause)

Werner Daehn :de: (BOB member since 2004-12-17)

3

Are there other variables in the script than $CCODE ($PARAM1) which need to have values? I see another $PARAM2 in the initial ABAP code:

write  '* Program Complete *'.
write  'Copyright Business Objects Data Integration, Inc.'.

FORM FORM3.
DATA ALTMP1 TYPE D.

SELECT
  CRDAT
  VJAHR
  BJAHR
INTO CORRESPONDING FIELDS OF TFACD
FROM TFACD
WHERE ( ( BJAHR >= 2010 )
 AND ( VJAHR <= $PARAM2 ) ).
ALTMP1 = TFACD-CRDAT.
 move ALTMP1 to ITAB8-CRDAT.
 append ITAB8.
ENDSELECT.
ENDFORM.
  1. I have a “successful” job that returns an empty *.dat file - then chokes trying to load NULLs into the Time Dim (Oracle error). The file completes w/o error, just missing the data!

T001.BUKRS seems a valid Company Code, KNA1.PERIV has a matching value of “Z1”, what strikes me as wrong reading the generated ABAP is the fields as follows:

SELECT
  BUKRS
  PERIV
INTO CORRESPONDING FIELDS OF T001
FROM T001
WHERE ( BUKRS = $PARAM1 ).
LOOP AT ITAB6.
ALTMP29 = ITAB6-CALENDAR_YEAR.
ALTMP30 = ITAB6-MON01.
CALL FUNCTION 'FI_PERIOD_DETERMINE'
EXPORTING
I_BUDAT = ITAB6-DAY01
I_BUKRS = T001-BUKRS
I_GJAHR = 0
I_MONAT = 0
I_PERIV = T001-PERIV

It does not seem correct that I_GJAHR and I_MONAT are always “0”.

Any insight appreciated as documentation on this script is hard to find.

Best Regards,
Steve
Fiscal_Variant.jpg

Stracy :us: (BOB member since 2006-07-14)