How to create OBJ_G_MIGRATION table

system · February 21, 2008, 2:40pm

Hi,

We are in the process of converting DESKI reports to WEBI and would like to generate audit report while using Report Conversion tool. We have imported auditing_ReportConversionTool_en.biar which has created the necessary universe and teh report but as the universe uses OBJ_G_MIGRATION table , where exactly do we find the script for creating this table. Not to be confused with BO auditing which contains 6 tables.

Thanks.

arindam_bhattach (BOB member since 2006-08-15)

system · February 21, 2008, 10:42pm

Check the section on “Auditing the conversion session” of the xir2_report_conversion_tool_en.pdf document from the Tech Support site, it should explain it all!

support.businessobjects.com/documentation/product_guides/boexir2/en/xir2_report_conversion_tool_en.pdf

Orange (BOB member since 2006-09-18)

system · February 22, 2008, 10:18am

After checking the knowledge base documents it seems that its a known fault and the table gets created after restarting the Report conversion tool once the connection is defined in the BO universe and in the CMC.

http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=c2019397&sliceId=&dialogID=17014041&stateId=1%200%2017012292

KBase Article ID:c2019397

arindam_bhattach (BOB member since 2006-08-15)

system · April 6, 2009, 8:15am

Hi,

I am in BOXI 3.0 an I have the same problem: generate audit report while using Report Conversion tool

I have created the Universe and the connection of Report Conversion Tool in Designer, and exported the Universe

I have defined the Audit Conversion connection in the CMC and restarted the server.

But the OBJ_G_MIGRATION table doesn’t created.

I created manually OBJ_G_MIGRATION table and check the Universe with this table and all is OK.

I restarted the server but the audit report while using Report Conversion tool doesn’t work. I get the message MIGTOOL_UNKNOWN_ERROR
and in details of error java stack there is
com.bo.migration.MigrationApp.insertDate(MigrationApp.java:2427)

Can somebody help me.

Thanks.

AL01 (BOB member since 2009-04-03)

system · April 6, 2009, 8:24am

The table is created the first time you use the RCT and pick the connection that points to the db (the same one you use in the universe). It’s probably best to remove the table from the db and then run the RCT.

wahey (BOB member since 2007-05-31)

system · April 6, 2009, 1:27pm

Hello,

I remove the table from the db and restart the BOXI server.

Then, I run the Report Convertion Tool. but I have the same error.

Do you know where I can find auditing_ReportConversionTool_en.biar for
BOXI 3.0 ?

I discover that the Report Convertion Tool call a script, migration.bat, in
%INSTALLDIR%\wun32_x86\scripts\

I see in this script that it is possible to execute the command in mode TRACE with argument=‘-trace’

I use this option, and try to execute migration document.

It doesn’t work but in file C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\Logging\javaw_7572_2009_04_06_16_32_11_281_trace.log
there is a lot of information. I put this file in attachement

In fact, RCT write temporary files in C:\Documents and Settings\administrateur\Local Settings\Temp\conversion\USER146731693\logs, and in sub-directory logs, it create a file D2419450.xml
that indicates Impossible d’ouvrir le document BusinessObjects ou le document Desktop Intelligence

I put the content of this file behind :

<?xml version="1.0" encoding="UTF-8"?>

D8454539ErreurImpossible d’ouvrir le document BusinessObjects ou le document Desktop IntelligenceFCDCErreur liÃ©e au processus BusinessObjects ou Desktop IntelligenceProcessus BusinessObjects ou Desktop IntelligenceImpossible de crÃ©er le document .widImpossible de lire le documentErreur BusinessObjects ou Desktop IntelligenceSupprimer le mot de passe si dÃ©fini
Not Converted

Hope these informations heps to solve the problem.

Thanks.
javaw_7572_2009_04_06_16_32_11_281_trace.txt (48.0 KB)

AL01 (BOB member since 2009-04-03)

system · April 19, 2009, 8:04am

Hi,

I am getting exactly the same problem on BOXI 3.1 on Windows 2003 Server when trying to audit log the Report Conversion Tool to an Oracle 10g database. The secured connection is correctly set and the Oracle user does have create table privileges (the same user was able to create the Audit database objects OK).

I find that this works fine with SQL Server 2005, but does not work with Oracle 10g. The following trace logging is produced which logs the problem, but doesn’t explain why the problem is occurring.

I have had a look at the release notes for XI 3.1 fix packs 1, 2 and 3. This does not mention a fix for this issue.

Any clues ?

Thanks,
Sean

[i]2009/04/19 07:32:28.687|>>|E| | 5112|5792| |||||||||||||||UMP: ERROR: addConnection: could not decrypt : Invalid decrypt buffer size ‘1416’ [umpauditdb.cpp;71]
umpauditdb.cpp:121:unsigned long __thiscall UMPAuditDb::checkDatabase(unsigned long): TraceLog message 12

2009/04/19 07:32:28.734|>>|E| | 5112|5792| |||||||||||||||UMP: ERROR: Bad Connect String Format : AUTHENTICATION_MODE [umpauditdb.cpp;121]
umpauditdb.cpp:167:unsigned long __thiscall UMPAuditDb::createDatabase(unsigned long): TraceLog message 13

2009/04/19 07:32:28.734|>>|E| | 5112|5792| |||||||||||||||UMP: ERROR: Bad Connect String Format : AUTHENTICATION_MODE [umpauditdb.cpp;167]
umpauditdb.cpp:174:unsigned long __thiscall UMPAuditDb::createDatabase(unsigned long): TraceLog message 14

2009/04/19 07:32:28.734|>>|E| | 5112|5792| |||||||||||||||UMP: ERROR: UMPAuditDb::createDatabase: Table creation failed. [umpauditdb.cpp;174]
umpauditdb.cpp:243:unsigned long __thiscall UMPAuditDb::insertData(unsigned long,class bo_utf8string &,class std::vector<class bo_utf8string,class std::allocator > &,bool): TraceLog message 15[/i]

Sean Reynolds (BOB member since 2004-12-16)

system · April 19, 2009, 8:14pm

My mistake, BOXI 3.1 Fix Pack 1.3 does list a fix for this issue - ADAPT01157521.

I will give this a go and report back.

Sean Reynolds (BOB member since 2004-12-16)

system · April 20, 2009, 2:31pm

On BOXI 3.1, Fix Pack 1.3 does indeed solve the problem.

Sean Reynolds (BOB member since 2004-12-16)

system · November 4, 2009, 1:45pm

This fix seems to be removed again with SP 2.

We are having the same problems again: the table obj_g_migration isn’t created…

Has anyone got the same problem?

jornvdd (BOB member since 2003-06-24)

system · April 5, 2010, 10:16am

create Access database
create odbc connection to created database
create connection in Universe Designer using odbc connection
convert the report. audit reports using created connection

And that’s it. Table created itself with all data…

Freestyle (BOB member since 2009-01-13)

system · May 3, 2010, 3:45pm

Thanks Freestyle for this guide!

The auditing with MS Access works perfect but I would like to use MS SQL Server instead for this purpose. I did the configuration similar to the instructions above but the OBJ_G_MIGRATION table is not created.

Is it possible to use another dbms than MS Access as auditing db for the RCT? Or are there any important steps I could have forgotten? I did the following steps:

create a new db in SQL Server
add a new user with the needed rights to create tables in this db
add a new BO-connection via Designer
configure this connection for auditing of the RCT in the CMC
convert a report and configure RCT that it writes data into the SQL server database via the BO connection

Thanks in advance!

jens-uwe.kiefer (BOB member since 2010-01-25)

system · May 5, 2010, 7:42am

I managed to find the solution for this problem:

1:
I had to import the RCT Audit Universe and Report from the “conversion_audit.biar” from “\win32_x86”.

2:
I had to use an ODBC connection to my MS SQL Server database because OLEDB is not supported.

After that the table was created without any problems and the auditing data was added to this table.

If you want/need to create the table manually you can use this SQL-statement:



create table OBJ_G_MIGRATION (
	G_MIG_C_LOGDATE VARCHAR(10), 
	G_MIG_C_DOCNAME VARCHAR(200), 
	G_MIG_C_STATUS VARCHAR (50), 
	G_MIG_C_LOGENTRY VARCHAR(100), 
	G_MIG_C_SEVERITY VARCHAR(10), 
	G_MIG_C_CAUSE VARCHAR(150), 
	G_MIG_C_SOURCE VARCHAR(10), 
	G_MIG_C_TYPE VARCHAR(40), 
	G_MIG_C_SUBTYPE VARCHAR(40), 
	G_MIG_C_ERRORTEXT VARCHAR(200), 
	G_MIG_C_FOCUS VARCHAR(255), 
	G_MIG_C_KEYWORD VARCHAR(40), 
	G_MIG_C_RESULT VARCHAR(150), 
	G_MIG_C_WORKAROUND VARCHAR(150), 
	G_MIG_C_USER VARCHAR(50), 
	G_MIG_C_FOLDER_CATEGORY VARCHAR(200),	
	G_MIG_C_AUTHOR VARCHAR(50), 
	G_MIG_C_COMMENT VARCHAR(50), 
	G_MIG_C_REP_CUID VARCHAR(100), 
	G_MIG_C_WID_CUID VARCHAR(100)
);

jens-uwe.kiefer (BOB member since 2010-01-25)

system · May 6, 2010, 11:11am

Just a quick note, but MS Access is not a supported database type to use for auditing, and therefore for RCT. MS SQL is, of course, fully supported.

Orange (BOB member since 2006-09-18)

system · May 10, 2010, 6:50am

Yes you’re right Orange! That’s exactly what the guy from BO told me.
But I had no problems when I used MS Access for RCT-auditing temporary.

jens-uwe.kiefer (BOB member since 2010-01-25)