1. Roland Smith
  2. PowerBuilder
  3. Thursday, 10 December 2020 15:21 PM UTC

We are using PB 2019 GA and SNC SQL Server database driver.

We have a report datawindow that has three nested reports. The main datawindow has a number array as one of the arguments. Here is a snippet of the SQL taken from the SQL Server trace tool:

 

WHERE trans_hist.billing_period_id IN (32,31,30,29,28) and

 

We are adding the array to be one of the arguments passed to the nested report. Here is a snippet of the SQL executed by the nested report taken from the SQL Server trace tool:

 

WHERE ( 1 = 1 ) AND billing_period_id IN (1.618979505640535E-317,1.586600419474683E-317,1.554221333308831E-317,1.845632614735852E-317,1.81325352857E-317) AND (student_crs_hist.id_num = 1321 ) AND

 

Is this a known bug or one that has been fixed already?

 

Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Monday, 14 December 2020 09:02 AM UTC
  2. PowerBuilder
  3. # 1

Hi Roland,

 

This is indeed a bug and it also exists in SAP PB 12.6.

Currently you can work around it via one of the methods below:

Workaround 1

If there are arguments with Number Array type in the Retrieve Argument in the Main DW and Nest DW, please alter the DW to make sure the Number Array is executed as the first argument.

For instance: dw_1.retrieve(li_num_arr[], li_arg1, ls_arg2 ….)

Workaround 2

Use String Array instead of Number Array type in Main DW and Nest DW.

 

Besides, I found that you have reported it to the Appeon Support system. Thanks for reporting it.

 

Regards,

Ken

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 10 December 2020 19:25 PM UTC
  2. PowerBuilder
  3. # 2

Hi Roland;

  I see that you have opened a Support Ticket for this issue. Please attach the Source code for the three DWO's you mention to the ticket for Appeon to analyze further.

Regards ... Chris

Comment
  1. Roland Smith
  2. Thursday, 10 December 2020 20:06 PM UTC
Done
  1. Helpful
  1. Chris Pollach @Appeon
  2. Thursday, 10 December 2020 20:41 PM UTC
Awesome ... thanks Roland!
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.