Skip to Content
0
Former Member
Mar 20, 2013 at 11:44 AM

Math(s) in BODS R4.1 SP1

230 Views

Executing the function...

ceil( 1553 / 500 )

from a simple script yields...

  • the expected value of 4 in BODS 3.2 (12.2.1.3) but
  • is returning 0 (zero) in BODS 4.1 SP1 (14.1.1.284)

running on Windows Server 2008 (64bit)!!

This must be a bug rather than a behavioural change????

Trace log from executing the script below in 4.1

print( 'ceil( 1523 / 500 ) = ' || ceil( 1523 / 500 ) );

print( '1523 / 500 = ' || 1523 / 500 );

is ...

7276 7280 JOB 20/03/2013 11:41:21 Current system configuration : <Mock>. 7276 7280 JOB 20/03/2013 11:41:21 Reading job <2c3abdb0_7c49_4a96_ab3e_f45816de743e> from the repository; Server version is <14.1.1.284>; Repository version is 7276 7280 JOB 20/03/2013 11:41:21 <14.1.1.0000>. 7276 7280 JOB 20/03/2013 11:41:21 Current directory of job <2c3abdb0_7c49_4a96_ab3e_f45816de743e> is <d:\Program Files (x86)\SAP BusinessObjects\Data 7276 7280 JOB 20/03/2013 11:41:21 Services\bin>. 7276 7280 JOB 20/03/2013 11:41:22 Starting job on job server host ,<xxxxx>, port <3500>. 7276 7280 JOB 20/03/2013 11:41:23 Job <New_Job> of runid <2013032011412272767280> is initiated by user <uuuuuu>. 7276 7280 JOB 20/03/2013 11:41:23 Processing job <New_Job>. 7276 7280 JOB 20/03/2013 11:41:23 Optimizing job <New_Job>. 7276 7280 JOB 20/03/2013 11:41:23 Job <New_Job> is started. 7276 7280 PRINTFN 20/03/2013 11:41:23 ceil( 1523 / 500 ) = 0 7276 7280 PRINTFN 20/03/2013 11:41:23 1523 / 500 = 3.046000 7276 7280 JOB 20/03/2013 11:41:23 Job <New_Job> is completed successfully.