Skip to Content

SAP BO DS: Reverse pivot is not working with execute mode, but it is normally working in debug mode.

Hi experts!

I am using SAP BODS 4.2 SP 9 and Oracle 11g.

Currently I am facing the issue for reverse pivot transform while running Job in execute mode.

The issue is getting empty field of all output columns (but not pivoted) in reverse pivot transform. But it works fine if I run Job in debug mode.

All pivoted columns are assigned to parameters.

What the problem it might be? Please, help!

thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 30, 2017 at 01:21 PM

    Found the cause of the problem. The problem was that the job server was not configured to support the required data language.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 05, 2017 at 07:57 AM

    It can be because of some processes which are running as separate process and are not able to resolve in the main execution whereas the debug mode waits for each process and hence is getting populated. If there are any check marks for run as separate process, remove them and try once.

    Also you might want to check the optimized SQL generated and check if it is working fine for you ?

    Add comment
    10|10000 characters needed characters exceeded