Instance location in Filestore

server administration XI Server Discussion
1

I’m trying to tie the report instance to the actual file in Filestore. I can tie the report document in input folders but not the instances.

Need your help.

ashu527 :us: (BOB member since 2008-01-10)

2

Check in CMC, there should be a path to it.

Marfi :poland: (BOB member since 2006-12-18)

3

We are using XI R2. I can see the path and filename for the report document but not for any instance !

ashu527 :us: (BOB member since 2008-01-10)

4

Am I understanding you correctly in that you’re trying to find the location of the output within the file store; i.e. a successful occurrence? If so, I look at each report instance by clicking on the status of that instance. There you’ll see something like this:

  Instance Location: frs://Output/a_031/240/205/13496351/~ce9cc66f93ff6d112ac4.pdf

At that point you go to that location and there’s your report.

Please note, only successful instances are kept in the output file store.

Hopefully I understood what you were asking.

Have a wonderful day!

Roxy21 :us: (BOB member since 2008-10-15)

5

Has anyone figured this out for 3.1?

clarence (BOB member since 2005-11-18)

6

In 3.1, I resort to Query Builder to find the FRS path. In InfoView or the CMC, go to the properties for the template document to get its ID. Then in Query Builder, run this query:

select si_id, si_name, si_update_ts, si_files from ci_infoobjects where si_parentid = <template document ID> and si_instance_object = 1 and si_schedule_status != 3

The file path will be displayed in the si_files property. Not exactly straightforward, but effective.

BoB LoblaW :us: (BOB member since 2007-10-23)

7

Yes it works !!

Thanks BoB LoblaW !

Follow this topic for ‘How to get to Query Builder in XI 3.1’ :

ashu527 :us: (BOB member since 2008-01-10)

8

Thanks all! I appreciate the help with this.

clarence (BOB member since 2005-11-18)