cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade BW 701 SP 10 to BW 731 SP05 - Transformation End Routine Syntax Error

Former Member
0 Kudos

Hi,

We have currently upgraded our lower BW landscape from BW 701 SP 10 to BW 731 SP05.

After the upgrade we find that transformations with end routines are giving syntax errors. This is due to change in the way the end routine structure _ty_s_TG_1 gets generated.  

After 731 upgrade, the structure does not include fields that have not been mapped in the transformation. This causes syntax errors to be generated when there is a reference to the unmapped fields in the End routine code.

SAP  Note 1635588 - "Problems with Start / End routine created at BW 7.0+ Release" addresses the same issue but it is not applicable to 731 SP05 as the solution was delivered in 731 SP02.

Has anyone faced a similar issue?

Thanks & Regards,

Rahul Rajagopalan Nair

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Rahul - We have similar issue and raised OSS message and waiting for response from SAP. Did you find any solution to resolve the issue. Please advise..

Thanks,

Somi

esjewett
Active Contributor
0 Kudos

Hi Rahul,

I believe that note was a related but different issue, even though it looks the same. I assume that your transformations are running OK as long as you don't change them, but if you try to reactivate them you are getting syntax errors? (Or not? If not, you do need an OSS message and just disregard what I'm saying below.) The note, I think, was to fix a problem where you would get runtime errors even if you didn't try to change your transformations.

What you're running into is that transformations just semantically work differently in 7.3 vs. 7.0. In 7.0 all fields appeared in the end-routine but only mapped fields would update to the data target by default. In 7.3 you have to manually choose which un-mapped fields show up in the end-routine and these fields all get updated in the target. Because of this you may need to rethink your transformation logic a bit.

In your case the solution is going to be to add the additional fields to the end-routine in the new transformation when you modify it. Just be careful because those fields will get updated in your target.

Regards,

Ethan

former_member182470
Active Contributor
0 Kudos

I suggest you to raise an OSS message to SAP

Former Member
0 Kudos

Thanks suman. But we have already raised an OSS message.