Error in transport for transformation & start routine

[abdullahqureshi]

Hi Folks,

While doing transport from DEV to QA system. I am getting error in one transformation and its start routine as shown in screen shot:

When go through on this transformation its showing active and also checked its correct. There is no syntax error in start routine also.

Earlier also faced this problem in this transformation after that again re-collect it in different request from DEV, now showing same error. In DEV this transformation and start routine are fine.

Its showing message no. RSAR051, RSTRA822 and RSTRAN523

Kindly share your views about this issue.

Your help will be appreciated.

Regards,

Abdullah

[former_member185177 · Accepted solution]

Hi Abdullah

Try with this program RSTRAN_ROUT_RSFO_CHECK to activate your transformation.

Some orphan routines are there in your present transformation.  So activate with this program.

Hope it resolves your issue.

Regards,

Krishna Chaitanya.

[abdullahqureshi]

Hi Folks,

Thanks to all for your precious time and valuable suggestions.

We have executed program RSTRAN_ROUT_RSFO_CHECK in QA for that transformation. In fresh TR collect only transformation & DTP, and import in QA this time its working fine.

Regards,

Abdullah

[former_member183012]

Hi Abdullah,

Thanks for update.can you please close this thread as your problem is resolved.which will be useful to others.

Regards,

Ganesh Bothe

[Former Member]

Hi Abdullah

Were u able to fix the issue u have mentioned above? I am also facing a similar issue...

BR

Merlin

[Former Member]

Hi,

By seeing the error, it can be case that the objects mensioned there in error messages are not getting reflected in transformations. Check your source and target fields once comparing between Dev and QA if that works. Thanks.

[RamanKorrapati]

hi,

Try again your transformations and routine into new transport and try move to quality.  if all of your used info object already exist in quality system then your transport will be succeed.

Thanks

[MGrob]

Hi

Check your transfromation startroutine in QA you most likely miss an object that is required in your startroutine that is not available in your QA system yet.

If you do a syntax check in QA you'll know what object is missing which you lookup in your startroutine.

hope that helps

Martin

[abdullahqureshi]

Thanks for the reply Martin,

I have checked (syntax check) that start routine and there is no error in QA. In error message showing info objects are available in QA and used in start routine.

Regards,

Abdullah

[former_member182470]

Hi Abdullah,

Can you delete the Transformation by using Power User ID in Qua and re-import the same TR freshly into Qua?

What I feel is, although the routine is correct in Qua, your transport doesn't recognize that due to improper update from database to confirm your TR.

Regards,

Suman

[MGrob]

Have you syntax checked in QA the routines belonging to those 3 inofobjects mentioned in the transport error? (0INT_BUS etc..) I still believe something the code is refering to is missing.

Martin

[former_member202718]

Hi Abdulla,

What i feel is that there is look up in the start routine and the look up is on a DSO.Can yu check if that DSO (Look up) is avaliable in QA.The Look DSO needs to be transported first that the Later Flow.

Tranport the Look DSO and then Reimport this request then it should work fine.

Rgds

SVU123

[abdullahqureshi]

Hi SVU,

Thanks for the reply. This transformation is between the info source and info cube at which i am getting error. In earlier transport it was inactive and now its showing active but showing error as in screen shot.

Regards,

Abdullah

[former_member202718]

Hi Abdulla,

Can you collect all the objects and retransport the entire flow once again from Datasource to Cube.

If still it does not work then as suggested by Suman,you delete and reTransport.

In any case post the result, so that we can come up with suggestions.

rgds

SVU123

[former_member183012]

Hi ,

Your error shows some objects are not present in your transport.

Can you check the following table in both the system ie DEV and QA then you will come to know what exactly missing

Copy your transformation tech name

1)SE16 -> RSTRAN

put your transformation name

execute it will give all routines present in this transformation.

Compare this output with your QA table..you will come to know the objects which is missing

Once again collect your transfomation and transport it will resolve your problem.

Regards,

Ganesh Bothe