BusinessObjects Board

XIR2 scheduling instances viewer

downloads
#145

Thanks rachidb

For sharing with us . This is very useful for me.

lax_lambor (BOB member since 2011-09-27)

#146

Iupdated the libraries for 12.0 XI 3.1sp3, ran fine and quickly. Nice resource

tkline :us: (BOB member since 2009-10-08)

#147

Hello Member
Thanks for the valuable script.
I need to run this script automaticay for every day.
How i can pass current date , without date prompting.
How i hard code userid, password & server name & authentication
without using log on form.

Regards

kksoft2002 (BOB member since 2009-12-10)

#148

Hi Members
When i try to get the size of the instance using the vb macro which is in this download area i get error on this line

.Cells(1 + i, j + 1).Value = oInfoObject.Files.Item(1).Size / 1024 & " KB"

may if there is no value for some instance it will through error.

if some one fix this please pso the code

Regards
Repos

kksoft2002 (BOB member since 2009-12-10)

#149

A very quick-and-dirty solution would be:

On Error Resume Next
.Cells(1 + i, j + 1).Value = oInfoObject.Files.Item(1).Size / 1024 & " KB" 
On Error Goto 0

or

If hasFiles(oInfoObject) Then
    .Cells(1 + i, j + 1).Value = oInfoObject.Files.Item(1).Size / 1024 & " KB" 
End If
....
Function hasFiles(oI as InfoObject) as Boolean
    hasFiles=false
    On Error Goto wtf
    Dim a as Integer : a = oI.Files.Count
    If a > 0 Then 
        hasFiles = true
        Exit Function
    End If
wtf:
End Function

(untested)

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

#150

Hello,
I have been looking for something like this but an automated way for this to run and email a report to us. At 7am we manually go into instance manager each day and take a screenshot of failed reports and running reports and email this to our group and our report developers. Any chance of getting something automated like this to email out? Thanks for any feedback. man this is some great work with that macro.

Guy Lotowicz

ccgll01 (BOB member since 2014-10-01)

#151

Hello,
I notice that when I run this it is not picking up any instances for Administrator and reporting them. I will keep playing with it. I see other submitters but not Administrator. Any ideas? Thanks.
Guy

ccgll01 (BOB member since 2014-10-01)

#152

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 and I am sure this is not because of the data, something else is wrongā€¦

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

#153

So I know it has been a while, but I have been working with the different versions of this amazing tool all day. Can anyone shed some light on the SI_NEXTRUNTIME error? I know it was mentioned on page 5-6 but I canā€™t seem to figure out what needs to be changed with that one. I took the query and ran it in Query Builder and it doesnā€™t bring back that field in any of the results. Let me know if you can. Thanks again!

rxdb (BOB member since 2017-02-13)

#154

Which version of BO are you using?

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

#155

Hi, sorry that would be helpful, wouldnā€™t it. we are on 4.1 SP4.

rxdb (BOB member since 2017-02-13)

#156

There are two XI3 versions that should work if you switch the references to version 14 of the libraries:

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

#157

joepeters, thanks a lot. Those are welcome changes to the original file. Have a great day! :smiley: [/quote]

rxdb (BOB member since 2017-02-13)

#158

Hi,

Not sure if someone is able to resolve this issue or not.
I have used this file on Windows server 2003 with MS Office 2003 and it was working fine.

we have migrated to Windows server 2008 R2 and have MS office 2003.
when I open the excel fine it is keep on giving me a message.

ā€œItem SI_MACHINE_USED was not found in the collectionā€

can someone please guide me what I am missing?

thanks.

mohsin30 (BOB member since 2016-11-01)

#159

Which version of BO are you using?

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

#160

BO XI 3.1 SP2 FP2.5

Thanks for looking in to this!

mohsin30 (BOB member since 2016-11-01)

#161

There are two XI3 versions that should work:

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

#162

Thanks!!!
Following link worked for me.

:smiley:

mohsin30 (BOB member since 2016-11-01)

#163

Hello,

Just like to know if this tool can also rerun failed instances ?

Thank you.

ruikuanli (BOB member since 2013-12-06)

#164

No, itā€™s read only. But you could modify it to do that.

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