Divide Field operator loses all data

Question

I wonder if anyone else has seen this and found a workaround? I have found one of my reports returns no data when it is expected to (and which it has been doing in a similar form in the past).

All datasources are based on a fixed timescale reporting except media details which uses a point in time. Firstly I have media details datasource with a condition on cartridge type which uses a group by to arrive at an average tape capacity, this is merged with a media count for the same cartridge type and a media count for all physical cartridge type. This is then merged with the totalsize datasource and results from this report have the following fields all which appear to be correct (and across all time instances):

Ultrium 5 Average Size

Ultrium 5 Count

Ultrium All Count

Total Size

Total SizeMB (this is a copy of Total Size multiplied by 1000 in order to divide by the U5 Av Size field which is in MB)

Noted field

Everything is okay at this point.

If I then apply the Divide Fields operator, dividing Total Size by U5 Av Size this then returns one line with values 0 (the value assigned for a null value).

Personally I suspect this is an issue with the graphic report writer somehow leading to more complex reports becoming in some way corrupt as I have been experimenting with this for the past couple of hours and been able to produce different reports from apparently identically configured datasources.

David_Hampson_90e289 · Answer

This seems to be a general problem for most arithmetic operations; another report I have I can add two fields together; the new field will have a value equal to the value of the two fields added together; the values for the two fields that were added are now null.  I have tried copying the fields and adding the copied fields together but see the same result (original and copied fields are null)

RJHarris1 · Answer

I'm not aware of an issue with these operators, nor can I recreate what you are seeing. Can I suggest you raise an SR for this and get your issue investigated by support?

David_Hampson_90e289 · Answer

I'd consider doing that, but our reseller is pretty hostile to us opening more than one SR at a time and we have an outstanding one which requires an update (though we have applied the relevant patch now) which is not going to be done for a short while.

David_Hampson_90e289 · Answer

I've just been through trying to provide evidence for this and it seems to be working okay now.  I'll have another go at duplicating it tomorrow - this has occurred on two parts of a report which had previously worked.  I am wondering if there may be some performance issue affecting this?

David_Hampson_90e289 · Answer

Not quite the same thing but here is an example of inconsistency in the report - although the report is only meant to return 2 fields, the rest being dropped, the other fields still show up in the report!?

I'll see if I can prove my original point and post some further info...

Data Protection Advisor

Divide Field operator loses all data

Was this post helpful?