Solved: BO Audit database in Oracle

Former Member · ‎08-18-2008

Hi,

Does anyone have BO Audit Database running in Oracle. I want the Oracle script to create tables, indexes, constraints etc. Can anyone send me the script? How can I get those scripts.

Thanks for your help.

Regards,

Tanveer.

N.B. I have already created a script but not confident whether it will work for all situations.

CREATE TABLE application_type (

Application_Type_ID number(10,0),

Application_Type_Description varchar2(50)

);

CREATE TABLE audit_detail (

Event_ID varchar2(64),

Detail_ID number(10,0),

Server_CUID varchar2(56),

Detail_Type_ID number(10),

Detail_Text varchar2(4000)

)

CREATE TABLE audit_event (

Event_ID varchar2(64),

User_Name varchar2(64),

Start_Timestamp date default to_date('01-01-1000','dd-mm-yyyy') ,

Duration number(10,0),

Event_Type_ID number(10,0),

Server_CUID varchar2(56),

Object_CUID varchar2(56),

Error_Code number(11,0)

)

CREATE TABLE detail_type(

Detail_Type_ID number(10,0),

Detail_Type_Description varchar2(50)

);

CREATE TABLE event_type (

Event_Type_ID number(10,0),

Event_Type_Description varchar2(50)

);

CREATE TABLE server_process (

Server_CUID varchar2(56) ,

Server_Name varchar2(50),

Application_Type_ID number(10,0),

Server_FullName varchar2(100),

Server_Version varchar2(100)

)

alter table application_type add constraint application_type_uk1 unique (Application_Type_ID);

alter table audit_detail add constraint audit_detail_uk1 unique (Event_ID,Detail_ID,Server_CUID);

alter table audit_event add constraint audit_event_uk1 unique (Event_ID,Server_CUID);

alter table audit_event modify (Start_Timestamp NOT NULL);

alter table detail_type add constraint detail_type_uk1 unique (Detail_Type_ID);

alter table event_type add constraint event_type_uk1 unique (event_type_ID);

alter table server_process add constraint server_process_uk1 unique (Server_CUID);

INSERT INTO application_type VALUES (1,'Unknown application');

INSERT INTO application_type VALUES (8,'Web Intelligence Report Server');

INSERT INTO application_type VALUES (10,'CMS');

INSERT INTO application_type VALUES (11,'Cache Server');

INSERT INTO application_type VALUES (12,'Report Job Server');

INSERT INTO application_type VALUES (13,'RAS');

INSERT INTO application_type VALUES (14,'Event Server');

INSERT INTO application_type VALUES (15,'Program Job Server');

INSERT INTO application_type VALUES (17,'Destination Job Server');

INSERT INTO application_type VALUES (18,'Web Intelligence Job Server');

INSERT INTO application_type VALUES (19,'DCP Job Server');

INSERT INTO application_type VALUES (20,'Question Engine Server');

INSERT INTO application_type VALUES (21,'Desktop Intelligence Job Server');

commit;

INSERT INTO detail_type VALUES (40,'Event ID');

INSERT INTO detail_type VALUES (41,'Event Filename');

INSERT INTO detail_type VALUES (42,'User Groups');

INSERT INTO detail_type VALUES (43,'Object Folder Path');

INSERT INTO detail_type VALUES (44,'Object Category Path');

INSERT INTO detail_type VALUES (45,'Session ID');

INSERT INTO detail_type VALUES (46,'Enterprise Error Text');

INSERT INTO detail_type VALUES (47,'ODBC SQLSTATE');

INSERT INTO detail_type VALUES (48,'ODBC Error Text');

INSERT INTO detail_type VALUES (49,'BOE UserID');

INSERT INTO detail_type VALUES (50,'Object Type');

INSERT INTO detail_type VALUES (51,'Report Data Type');

INSERT INTO detail_type VALUES (2,'Universe name');

INSERT INTO detail_type VALUES (3,'Object Name');

INSERT INTO detail_type VALUES (6,'Number of lines');

INSERT INTO detail_type VALUES (7,'Number of elements');

INSERT INTO detail_type VALUES (8,'Document name');

INSERT INTO detail_type VALUES (9,'Document size');

INSERT INTO detail_type VALUES (14,'Description');

INSERT INTO detail_type VALUES (15,'Category name');

INSERT INTO detail_type VALUES (16,'Keywords');

INSERT INTO detail_type VALUES (17,'Refresh options');

INSERT INTO detail_type VALUES (18,'Overwrite');

INSERT INTO detail_type VALUES (19,'SQL value');

INSERT INTO detail_type VALUES (21,'Document type');

INSERT INTO detail_type VALUES (22,'Report name');

INSERT INTO detail_type VALUES (23,'Prompt name');

INSERT INTO detail_type VALUES (24,'Prompt value');

commit;

INSERT INTO event_type VALUES (6,'Get list of universes');

INSERT INTO event_type VALUES (9,'Save document to repository');

INSERT INTO event_type VALUES (11,'Read Document');

INSERT INTO event_type VALUES (13,'Selection of universe');

INSERT INTO event_type VALUES (19,'Document refresh');

INSERT INTO event_type VALUES (21,'List of values');

INSERT INTO event_type VALUES (22,'Edit document');

INSERT INTO event_type VALUES (28,'Apply format');

INSERT INTO event_type VALUES (40,'Get page');

INSERT INTO event_type VALUES (41,'Generate SQL');

INSERT INTO event_type VALUES (42,'Drill out of scope');

INSERT INTO event_type VALUES (43,'Select prompt');

INSERT INTO event_type VALUES (65537,'Concurrent Logon Event');

INSERT INTO event_type VALUES (65538,'Named User Logon Event');

INSERT INTO event_type VALUES (65539,'User Logon Fails');

INSERT INTO event_type VALUES (65540,'User Logoff');

INSERT INTO event_type VALUES (65541,'Password Change');

INSERT INTO event_type VALUES (65542,'Object is Created');

INSERT INTO event_type VALUES (65543,'Object is Deleted');

INSERT INTO event_type VALUES (65544,'Object is Modified');

INSERT INTO event_type VALUES (65545,'Unresponsive Scheduling');

INSERT INTO event_type VALUES (65546,'Rights on an object have been modified');

INSERT INTO event_type VALUES (131073,'Report Viewed Successfully');

INSERT INTO event_type VALUES (131074,'Report Viewing Attempt Failed');

INSERT INTO event_type VALUES (196609,'Report Viewed Successfully');

INSERT INTO event_type VALUES (196610,'Report Viewing Attempt Failed');

INSERT INTO event_type VALUES (262145,'Event is Registered');

INSERT INTO event_type VALUES (262146,'Event is Unregistered');

INSERT INTO event_type VALUES (262147,'Event is Updated');

INSERT INTO event_type VALUES (262148,'Event is Triggered');

INSERT INTO event_type VALUES (327681,'Scheduling Succeeded');

INSERT INTO event_type VALUES (327682,'Scheduling Failed');

INSERT INTO event_type VALUES (327683,'Scheduling Failed but will be reattempted');

INSERT INTO event_type VALUES (458753,'Report is Opened');

INSERT INTO event_type VALUES (458754,'Object is Published/Saved Successfully (4 or 6)');

INSERT INTO event_type VALUES (458755,'Report is Created');

INSERT INTO event_type VALUES (458756,'Report Fails to Open');

INSERT INTO event_type VALUES (458757,'Object Publish/Save attempt Fails (4 or 6)');

INSERT INTO event_type VALUES (458758,'Report fails to get Created');

INSERT INTO event_type VALUES (655361,'Question Succeeded');

INSERT INTO event_type VALUES (655362,'Question Failed');

commit;

And some server specific values to server_process table.

amrsalem1983 · ‎08-18-2008

hiii,,

why do you want the script... the business objects system can create it for you directly

either from the CMS service whicn in the CCM

or from the Repository Migration Wizard.

tell me if you want me to guide you.

good luck

Amr

Former Member · ‎08-19-2008

I got the answer.Thanks to Jack and Amr both.

Former Member · ‎08-19-2008

Audit Universe for the Oracle Audit Database

Former Member · ‎08-19-2008

Hi Amr,

One thing. The Audit universe that we were using against the MySQL Audit database, can we use that again the Oracle Audit Database? Because I can see some of the functions in the Audit universe objects which are available in MySQL and not in oracle. So where can we get the Audit universe for oracle database?

Please let me know at your earliest.

Regards,

Tanveer.

BO Audit database in Oracle

Accepted Solutions (1)

Accepted Solutions (1)

Answers (3)

Answers (3)

What is the difference between OMS and OMM, while ...

Re: Incorporate international clients into VAR Chi...

Incorporate international clients into VAR Chile

Re: reading external (OData) API from cap

Re: reading external (OData) API from cap