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