Skip to Content
0

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

Jul 03, 2017 at 10:10 AM

40

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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 ?

Share
10 |10000 characters needed characters left characters exceeded
Станислав Уколкин Jul 30, 2017 at 01:21 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded