BusinessObjects Board

XI3 Instance Viewer

Author: Joe Peters (with thanks to Rachidb)
Platform: MS Excel
Version: 1.0
Notes:

xi3sched.xls (197.0 KB)


joepeters :us: (BOB member since 2002-08-29)

Moderator note:
Approved, and moved to BOB’s Downloads.


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Hello,
I’m trying to use the Excel SDK to view instances and i’m getting “No response from server,time out exceeded”.I have CMS registry key values set to time out after 20 minutes,but this error is showing up after 10 minutes though.

Any ideas?


karen (BOB member since 2003-06-18)

Not sure if this is the same problem, but I had the same thing happen last week. Turned out we had around 100,00 failed instances due to this issue.

Joe


joepeters :us: (BOB member since 2002-08-29)

Thanks a lot of the tool…this is really helping me out.

Is there a way to get the parameters in the report for all the instances.

Any help is appreciated.


writetoprav :us: (BOB member since 2007-04-09)

Unfortunately, according to this post, no.

Joe


joepeters :us: (BOB member since 2002-08-29)

Hello,

I changed CMS thread timeout after N minutes to 60.But i still get “No response from server,time out exceeded” error message after 10 minutes.

Does anyone knows how to resolved this.Please advice.

Thanks


karen (BOB member since 2003-06-18)

Not sure exactly… I would check:
[list][:e9a83c587a]CMS and authentication are correct
[
:e9a83c587a]Desktop apps (DeskI/Designer) are correctly installed
[*:e9a83c587a]Log in is possible from desktop apps using the same credentials[/list]
Joe


joepeters :us: (BOB member since 2002-08-29)

Does the macro discard some records? The spreadsheet returns 556 records but when I run the generated query in Query Builder I get 845 records. (NOTE: Some of the records are NOT valid and I’m not sure why Query Builder would include them. The date ranges are WAY older than the criteria.) I’m just trying to look at the last couple days. Any help/advise?

End Goal : I trying to create a java program that will display schedule results and allow reports to be rescheduled. I can’t get my query results anywhere close to the results of this spreadsheet or Instance Manager (around 450).


ChrisW1204 :us: (BOB member since 2011-04-21)

Yes, there is some filtering done once the query is complete. It was done because of some quirkiness/bugs with the date fields in XI3; I haven’t revisited it since I applied SP3.1, so the logic may need to be changed again.

Check the getBOXISchedules routine, after For Each oInfoObject In oInfoObjects. It calculates the date to use based on either si_nextruntime or si_creation_time.

Joe


joepeters :us: (BOB member since 2002-08-29)

Looks like this IF statement filters them out based on some more date criteria.

           If (dSchedStart >= startdate And dSchedStart <= enddate) _
                Or (dActualStart >= startdate And dActualStart <= enddate) Then

ChrisW1204 :us: (BOB member since 2011-04-21)

Yes, exactly. Look just above it for the definitions of the date variables.


joepeters :us: (BOB member since 2002-08-29)

Nice work. It save me some time to access BO directly :smiley:

I’ve got a few comment/suggestions.

  1. The formula of “Avg Duration” and “Avg Delay” use SUBTOTAL. I think it should be something else
  2. The duration field is shown as “:00”, “:04:00”, etc
  3. Cannot find records within date range (Date format issue?)
  4. Current design cannot be used for scheduling. (lazy :roll_eyes: )

summoner :hong_kong: (BOB member since 2008-12-18)

Hi summoner,

SUBTOTAL is the correct formula, as it dynamically recalculates based on the currently selected filter. But it is broken – the Avg Duration should be pointed at column L, and Avg Delay at column M. And both should be formatted as h:mm:ss

That’s correct – it’s in h:mm:ss format

What do you mean? In the dialog box that appears when you run the macro?

What would you like it to do?

Joe


joepeters :us: (BOB member since 2002-08-29)

#1,2 - got it
#3 - After further checking, it is found that it is my problem :lol:
I propose #4 because of my laziness. Say I would like to setup a schedule job that runs on my desktop for checking yesterday’s schedules. They I do not need to open the file and choose the date range :roll_eyes:


summoner :hong_kong: (BOB member since 2008-12-18)

Does anyone know if this can be used for 4.0? What needs to be changed? Thank you.


jonesb (BOB member since 2011-05-04)

Does anyone know if this can be used for 4.x? What needs to be changed? Thank you.


elsv (BOB member since 2015-02-02)

It should work as long as you have the XI3 client software installed. I haven’t tried it on a machine with only the BI4 client software.

Joe


joepeters :us: (BOB member since 2002-08-29)

I tried this with BI 4.1 and it is working fine…

Now problem is I have BO 3.1 also installed, so not sure if something different allowed it to work or not …

This is a great tool … I am facing issues when running against 1 server may be because data is too much on that server…


aniketp :uk: (BOB member since 2007-10-05)

Does any one have a working copy of this utility. If so can you please upload it.

I am trying to using the one from 3.1 and having issues. I did make sure to reference new dlls but still having issues.

Thanks


billa (BOB member since 2008-06-11)