DTP failed because of cannot read from datastore object for record

[former_member202517]

Hi All,

One of the process chain DTP failed because of cannot read from datastore object for record.

As I checked the transformation, for the field Doctype, the mapping rule is "Reading from DSO". and the DSO is 0Pur_DS03.

I tried to find the issue but cam to know that this might be because of " Behavior Value not found" from this

So please let me know what could be the possible solution for this.

Thanks,

Ravi

[yugandhery]

Hi..

The lookup table (DSO) do not contain data for every record in target DSO, Check the read definition and its properties for data unavilability. It can be error message or constant value. See image attached.

Thanks

Yogi

[former_member202517]

Hi All,

Thank you for the update.

These are new data loads, they are running from one month and today they failed because of the issue that I stated. So I follow the thread that I provided should I change the transformation?

I have checked the data in the source DSO(0Pur_DS03), and the last 2 request contains no data for the field 0doc_type, but data avail for the other fields.

If this is authorization issue, the load was running fine from last 3 weeks. I dont think this is not authorization.

the field 0doc_type is avail in 2 dso. In the transformation of ZDS(data source)--> ZDSO, the rule was declared to read the data from 0Pur_DS03 for the field 0doc_type.

[Former Member]

The possible solution is outlined in the very thread you linked to. Did you try it and did it not work?

[RamanKorrapati]

is this new data flow and today first time you triggered?

old data flow and got error today only?

actually which objects are mapped at transformations and which object is reading from dso?

Source DSO - All loaded requests are Activated and have reproting symbole?

[Former Member]

Hello Ravi,

Do you think this can be an authorization issue. Try executing the DTP using a super user.

Also see the data in the DSO for DOCTYPE, if there is any more info why the error is encountered.?

Regards,

AR

[vijju-344]

hi experts i have faced the same situation however i got dtp failed at loading to infocube.as i shown below

my scenario 

Usage of Transformation Rule Type “Read from Datastore” to fill the field in info cube. i have flow like dso ZPURD10 --> cube ZXPURC03 and ZPURD07 is look up dso.

say KEY FIELDS in ZXPURC02 are DOC_NUM DOC_ITEM,

 DOC_NUM, DOC_ITEM in ZPURD06

  ZPURD10 :  0BBP_PO_ID
0BBP_POITEM,  then target field DOC_DATE in ZXPURC03 fill with

data from DOC_DATE field from ZPURD07

assigning this field DOC_DATE In info cube using rule type read from dso to load the data from zpurd06 to DOC_DATE                              why i am facing the issue and could please suggest me the error correction in this scenario.

Thanks and regards

VIJAY