Transformation - Read Master Data Rule Error

[former_member212897]

In our development environment we've have activiated 0PUR_C01 from business content. In the past we had no issues loading data to this cube. Recently we've updated our OS, DB, and BW has been patched to 7.3.1 SP 12.

Since our updates we now run into a couple of issues with transformations that contain a rule for reading master data. One of the issues is that the transformation will appear to be active in the workbench but if you click on the transformation to view the detials the version indicates its version 'N'. Were also having an issue where any transformation that contains the 'Read Master Data' rule causese a short dump when trying to activate or test the rule.

Here is a snap shot of the rule from our transformation:

This is the short dump error were getting:

If we remove the rule from the transformation then we can activate the transformation as well as load data. I've searched for a solution to this problem and just can't seem to find a note that pertains to this. I have found some older notes that may of been relevent but those are notes from previous bw versions and early service packs.

Keep in mind that while I used the cube 0PUR_C01 as our example we are having this same issue with every transformation that has the read master data rule. I also want to point out that this structure has neve been modified from the standard business content that was initally installed.

I've seen some suggestions to get around this by writing some code but to me this is not a fix but a work around to a bigger issue. Does anyone have any suggestions that will help us address this issue.

Thanks,

Larry

[Loed · Accepted solution]

Hi Larry,

As Raman said, you need to fill out the FROM ATTR. OF field with the object name..

Regards,

Loed

[former_member212897 · Accepted solution]

Guys, please ignore my ignorance but when :

I put 0VENDOR into the From Attr. Of Field and click the 'Check Rule' button it blanks that field out.

I put 0VENDOR into the From Attr. Of FIeld and click transfer rule then when I activate I get a short dump.

Here is the image showing the From Attr. Of field filled out with 0VENDOR

This is the image of what you see after I click on 'Check', notice that the From Attr. Of field is blank yet the screen tells me 'No errors found during rule check'. I then click 'Transfer Values' button and try to active and get a short dump.

Am I missing something here?

[anshu_lilhori · Accepted solution]

In Infoobject assignment put 0vendor as well then try if it works or not.

Regards,

AL

[RamanKorrapati · Accepted solution]

in transformations have you mapped source 0VENDOR to 0Country?

Seems like you missed that mapping.

do that mapping and later from attr of enter 0VENDOR,

Check and transfer values.

Activate your transformations.

[former_member212897 · Accepted solution]

Same issue. I actually deleted the rule and then recreated it. When the rule is new and I enter 0VENDOR into the From Att. Of field it blanks this field out but adds 0VENDOR to the Source Field. I then populated the IOAssignement with 0VENDOR, checked the rule, it passed, transfered and ultimitally short dump again

[former_member212897 · Accepted solution]

Yes i've mapped it, still same issue.

[karthik_vasudevan · Accepted solution]

Hi Larry

This should work without any issues. I am not sure what is wrong in your case. Try this which might work.

Delete the source field assignment and once you choose the rule type, don't type anything in From Attr. of. Press F4 input help, it would automatically give you the screen like below. Choose 0VENDOR from that selections screen.

I just tried in the same 0PUR_C01 cube with country as the target field. It didn't any dump while activation.

If this doesn't work, try deleting the existing transformation and create a new one.

Let me know if this is helpful.

Regards

Karthik

[RamanKorrapati · Accepted solution]

0country is attribute of 0vendor(mean not hided at RSA6)?

can you check P table of vendor one or attributes tab 0vendor.

Try to activate 0vendory info object and later try do to mappings.

[former_member212897 · Accepted solution]

Raman,

I checked the table and 0COUNTRY was in the table. I did reactive 0VENDOR, deleted the rule, recreated the rule and same short dump.

[former_member212897 · Accepted solution]

karthik,

Is your transformation going from the DS -> Cube or Infosource -> Cube?

I'd delete the transformation but the transformation contains a ton of rules (All standard), if I delete the transformation and create a new one how will i reimplement the rules if I don't have the original transformation to cross reference.

Here is the current structure and the transformation causing the issues is from the infosource to the cube:

Thanks,

Larry

[karthik_vasudevan · Accepted solution]

Hi Larry

Actually our flow is 3.5 and even in the update rules, its perfectly working fine. The earlier screenshot that I shared was from another cube to 0PUR_C01. Just for testing purpose, I changed the rules of 0COUNTRY and it worked.

In the update rules, it appears like this, I tried changing it and it works fine. No dumps, no issues

As you are using infosource, try to use the transformation from infosource to cube for this purpose. You could leave the 0COUNTRY field blank in the transformation between DS and IS.

As we are not sure of what is the real cause for this, we could just try different things in trial and error basis. After all, we need the transformation to be active. So give a try

Regards

Karthik

[former_member212897 · Accepted solution]

So I copied my cube 0PUR_C01 and create a new one and then from the infosource to the new cube I created a new transformation. I left the default mappings and then updated 0COUNTRY to read fro 0VENDOR. Filled everything out, rule checked fine, transfered, activated, and short dump!

As I mentioned earlier in the post this was the example I used but i'm having this issue with any tranformation that contains a 'Read Master Data' rule which leads me to believe that this is a bigger issue than mapping and pulling from the right object. This seems to be a system wide error that happens regardless of the objects you're working with.

Im still open to suggestions but im going to review sap notes again and see if there is anything I can find that address this particular issue.

[karthik_vasudevan · Accepted solution]

This seems strange. Try to give the full dump. Lets see if there is something based on that

[former_member212897 · Accepted solution]

Not sure how much of this you want to see. The how to correct the error sections indicates the error occures in a non-modified sap program.

[former_member212897 · Accepted solution]

We've found the following note which appears to be the exact issue were having. I'm working on getting this implemented and I'll let you know what happens.

Note:

1816350 - 731SP8:Syntax errors in routines or Assertion failed during activation of transformation

[former_member212897 · Accepted solution]

So we applied the note last night and our issue is gone.

Since I inserted images of the errors I figured I would include a little more info to help anyone searching in the future:

Issue: Assertiaon Failed During Activation of Transformation

Symption: The determination of the source InfoObject - to determine whether the execution of an InfoObject routine is necessary - does not always work.

Desc: A transformation containing a rule to 'Read Master Data' would cause a short dump when trying to activate transformation or test rule. The transformation displayed as active but you could not send data through.

Errors:

In BW 7.31, a dump occurs in ASSERTION_FAILED in the method FACTORY_SUB, class CL_RSTRAN_GEN_STEPGRP_MASTER

"ASSERTION_FAILED" " "

"CL_RSTRAN_GEN_STEPGRP_MASTER==CP" or "CL_RSTRAN_GEN_STEPGRP_MASTER==CM002"

"FACTORY_SUB"

Fix: Implement Note - 1816350 - 731SP8:Syntax errors in routines or Assertion failed during activation of transformation

Hopefully this will help someone find the solution a little faster than we did.

[RamanKorrapati · Accepted solution]

Thanks larry for sharing solution in detailed.

[RamanKorrapati]

Hi Larry,

Rule details screen - you need to maintain master data object to read.

in your screen it showing as blank in such case how will allow you to activate transformations

From the attributes of - Here you need enter master data info object(which your going to read, assuming as 0vendor).

Thanks