INSTANCE Manager WRONG RESULTS.

[former_member528199]

Hi All,

Environment:

BO 4.2 SP3.2

From Past few days we are observing this strange issue that whenever we select the "STATUS" and " COMPLETION TIME" filters in Instance Manager it is rendering the results from last year etc ignoring the filters thus rendering incorrect data.

eg: STATUS = FAILED

COMPLETION STATUS = today 12 AM to 31st JAN 12 AM.

This should return failed schedules from today midnight however it is showing failed schedules from last year etc ..( PFA Screenshot).

instance-manager-results.png

Regards,

Nachiket

[Joe_Peters]

This has been an issue for quite a long time.

The problem is that the Completion Date filter applies to a different property than what is used to display the Completion Date column.

The filter applies to the si_update_ts property, while the column displays the value of the si_endtime property (the root property, not the one in si_scheduleinfo).

Usually, these two properties will have the exact same value for completed instances, and so the value that is displayed in the column will be within the range specified in the filter.

If a completed instance is ever modified, the si_update_ts property will be updated but si_endtime will not. When this happens the two properties will have different values, and you get results like what you are seeing.

Modification of instances is not common, since instances cannot be modified with BI launch pad or CMC. It can be done with the SDK, or with a reposcan. If you have recently run a reposcan (with repair), it would explain the result.