Question Re: errorr in data loading in Technology Q&A

errorr in data loading

Former Member — Fri, 13 Dec 2013 07:11:50 GMT

Hi experts,

I written the routine where the calday is converted to quarter but there is no syntax error. when i try to loading the below error message displaying so can any one suggest this issue.

@5C@

InfoObject ZQUARTER does not fulfill ref. integrity in record 1 in value 04

RSAR

192

@35@

@3R@

below the code

data:p1(02).

p1 = SOURCE_FIELDS-calday+4(2).

if p1 = 01 or p1 = 02 or p1 = 03.

move '04' to p1.

elseif p1 = 04 or p1 = 05 or p1 = 06.

move '01' to p1.

elseif p1 = 07 or p1 = 08 or p1 = 09.

move '02' to p1.

elseif p1 = 10 or p1 = 11 or p1 = 12.

move '03' to p1.

endif.

RESULT = p1 .

Regards

Re: errorr in data loading

RamanKorrapati — Fri, 13 Dec 2013 07:41:26 GMT

Hi Ram,

As my guess you may be selected ref. integrity check box for your info object ZQUARTER mappings at transformations.

Please recheck your mappings of ZQuarter--> rule details--> if you selected ref.integrity, untick and activate your transformations and try to load data.

better to do the test rule once.

Thanks

Re: errorr in data loading

MGrob — Sun, 15 Dec 2013 18:13:23 GMT

Why do you write a routine when you have calday? You can just assign calday to quarter and the time derive is automatically.

hope that helps

Martin