BusinessObjects Board

Pull Auditor data using ETL tool.

other Auditor
#1

Hi ,

After dealing with one too many undocumented features of BO XI3.1 we have decided to see if we can write ETL program to pull the audit data out.

Has any body written a ETL to pull the data out? Is there a guide that helps me understand what columns from the audit text file get populated into various audit tables.

Is my effort even worth trying and please dont suggest upgrade to BI4 since we are no there yet… :hb:

BO XI3.1 SP3
SQL server 2005
Windows 2008
Tomcat 5.5

Manasi (BOB member since 2004-12-17)

#2

Not sure why you would want to use ETL, as the data is there and you have a Universe exposing the data. But of you want to have more info try the admin guide (http://help.sap.com/businessobject/product_guides/boexir31/en/xi3-1_bip_admin_en.pdf)

Orange :netherlands: (BOB member since 2006-09-18)

#3

Well in a nut shell our auditor keeps breaking we dont when and why but it simply stops writing event to the Audit DB…

Manasi (BOB member since 2004-12-17)

#4

Aha - now I understand the original request. But those text files, as you have found out, are not in clear text, so you’ll need to use some key, which I dont know of.

It’s better, in my humble opinion, to try and figure out what’s happening with the Audit database? I have never seen any such issues with auditing but it’s probably better to try and fix that issue.

So, if you’re game, can you answer the following questions:

  • I suppose the audit database is on SQL server 2005. Is that in a separate database from the repository or are they in the same database?
  • Do you see any error messages in the Application Event Viewer on the CMS server?
  • Know that the CMS in it’s role as auditor only writes the audit details to the audit database in certain intervals and in batches. So if you were to leave the system be for 24 hours, do the auditing details get written to the database eventually?

Orange :netherlands: (BOB member since 2006-09-18)

#5

Sorry for the late reply got occupied “fixing” auditor

Yes SQL server 05
Seperate DB
There are few lines of error , not sure if this is related.

Manasi (BOB member since 2004-12-17)

#6

That message you show is not related to the auditing functionality. It means that the sever listed in the message is not responding to ping/hearbeat requests from the CMS to determine whether it is up or not.

Any messages in the Windows Event viewer?

Also, if you continue troubleshooting your auditor problem in this thread then you need to get rid of the other one you created.
https://bobj-board.org/t/213666

jwhite9 :us: (BOB member since 2006-07-28)