BusinessObjects Board

Item not found in collection

sdk development
#1

Hello,

I am trying to retrieve the SI_MACHINE_USED property of a scheduled report through VB. When I hit a resultset that does not have this property, I get the error “Item SI_MACHINE_USED not found in collection”

select si_id, si_name, SI_SCHEDULEINFO.SI_MACHINE_USED from CI_INFOOBJECTS WHERE SI_INSTANCE = 1

When I print out the result set in a for loop, it works for the instances that have a value for SI_MACHINE_USED but errors out when it hits the result that does not have this property.

Is there a way I can check to see if this property exists before printing it out? Does anyone know why this would be null for a scheduled instance? Thanks

seagrowler (BOB member since 2008-08-05)

#2

SI_MACHINE_USED is null when status is pending or paused.
You can check code in my macro in BOB’s DOWNLOADS XIR2 scheduling instances viewer:

Rachid

rachidb :morocco: (BOB member since 2006-07-06)