Cognos 11: Divide by 100 receive error 'sqlScrollBulkFetch' status='-9'

[marsh06usn]

We are using JD Edwards Quality Module - test results table.  I need to divide the test results data by 100 to get the correct value.  Dividing by 100 works fine unless there is a "blank" / "null" value.  Then I receive the error:   RQP-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-9'

However, when I tried to use if/then statement to account for "blank" / "null" values, it still did not work.  I created tests to see if Cognos could identify the "null" or "blank" values using the following statements:

if([Moisture] is null) then (0) else (1)
if([Moisture] is missing) then (0) else (1)

And no Nulls or Missing items are returned! (all 1's!) 

I tried even in Excel to divide the raw data output by 100 and a blank value errors in Excel too: #Value!

Any suggestions on trying to divide the information by 100?  Ideally for the output, the null stays null and the values that have an actual number are divided by 100.

[MFGF]

We are using JD Edwards Quality Module - test results table.  I need to divide the test results data by 100 to get the correct value.  Dividing by 100 works fine unless there is a "blank" / "null" value.  Then I receive the error:   RQP-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-9'

However, when I tried to use if/then statement to account for "blank" / "null" values, it still did not work.  I created tests to see if Cognos could identify the "null" or "blank" values using the following statements:

if([Moisture] is null) then (0) else (1)
if([Moisture] is missing) then (0) else (1)

And no Nulls or Missing items are returned! (all 1's!) 

I tried even in Excel to divide the raw data output by 100 and a blank value errors in Excel too: #Value!

Any suggestions on trying to divide the information by 100?  Ideally for the output, the null stays null and the values that have an actual number are divided by 100.

That sounds weird! What is the data type of the Moisture item? If there really are null values in some rows, the test for null should come back as true.

The -9 error you posted is just the first part of a more detailed error message. On its own, it just means "something went wrong with the query". Is there a follow-on part of the error that gives more detail?

Is the need to divide by 100 simply for display, or is the divided value used elsewhere in other calculations? If it's just for display, you could instead try changing the format properties of the Moisture item to use a scale of -2? That would get around any division issues, and also be more efficient.

Cheers!

MF.