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

[former_member432257]

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.

[former_member432257 · Accepted solution]

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