Where are messages stored for failed publication instances?

general discussion
1

Where are messages stored for failed publication instances?
When I run Query Builder and display all properties for the failed a publication there is no SI_STATUSINFO.Properties field that explains
the error.
This field is there on all regular failed Webi and Crystal reports.
Using Instance Manager I’m able to view the failed publication’s history instance detail that shows the reason for the error.
Where is Instance Manager getting this?
I run a Query Builder type script that displays all failures with the explanation but I don’t want to go to CMC/Instance Manager for failed
Publications.

Hope someone can help.

Thanks,

Bob

ODPPOLL (BOB member since 2007-05-30)

2

I see the si_statusinfo field for failed publication instances (we’re on version 4.1 sp9) and it has the error messages.

I ran this query to see all the failed instances of 1 of our publications:

select si_id, si_name, si_endtime, si_statusinfo from ci_infoobjects where si_parentid = 16000562 and si_schedule_status = 3 order by si_endtime desc

Norm Rosen :us: (BOB member since 2002-07-10)

3

Thanks, but we do not see that si_status_info field.
We are on BO4.2 SP5. I see some internet info about a publication log file but nothing where this log file is located. I think the info I need is stored there along with LCM Promotion jobs.

ODPPOLL (BOB member since 2007-05-30)

4

I think it might matter if the failure is in the publication itself or in a child report. In my failed publications, I do see an si_statusinfo field with an error message.

You might need the publication log. Its location is in a child of the publication instance. So if your failed publication has si_id 12345, do another query for si_parentid=12345. You should find a Publication Admin Log" object in there; its si_files will have the location of the actual log file.

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

5

Thanks but the failed publication instance has no children. SI_CHILDREN = 0
And when I ran what you suggested it brings back 0. Dang! I know there has to be some reference in this failed publication instance to have that error message in Instance Manager display. Typically where would the Publication Log file reside? There is some new looking property SI_TRACELOG_CONTEXT that has stuff like —> id={host=“ourserver”;pid=1324;tid=84;data_id=104985 among other things.

Miss ol’e COBOL with that green bar paper

ODPPOLL (BOB member since 2007-05-30)