Skip to Content
0
Jan 27, 2011 at 10:47 PM

Strange: report's SI_UPDATE_TS getting updated on infostore query

57 Views

Hello friends -

I've discovered a very strange behaviour, whereby a query issued against one of my BOE environments that looks like this:

select top 2000 * from ci_infoobjects where si_kind = 'FullClient' and si_instance = 0

...retrieves the top 2000 Desktop Intelligence report InfoObjects (which is OK), but then it mysteriously updates the SI_UPDATE_TS property of each of the 2000 infoobjects. So, if I ran this query at 4:15:43am, all of the retrieved infoobjects now have an SI_UPDATE_TS time of 4:15:43am.

This system is a standalone BOE server with a complete, default installation stack.

BOE: XI3.1 SP3 (no FPs)

Auditor installed: Yes

Any help or insights appreciated -

Atul

Edited by: Atul Chowdhury on Jan 27, 2011 11:47 PM