Import biar file with command line

[Former Member]

Hi

I am trying to import biar file with command line on unix environment with BOXI R3.1 and Oracle DB

The biar file include one universe and it's connection (eFashion), one report and one user

when I run the command line:

java -jar /BO/boxi/bobje/java/lib/biarengine.jar /BO/boxi/test.properties

I recive the following error:

Failed to commit objects to server : Undefined Info Store error

An error occurred at the server during security batch commit:

Request 6 of type 36 failed with server error : Object not found (1433)

Request 11 of type 36 failed with server error : Object not found (1433)

Request 20 of type 38 failed with server error : Object not found (1433)

Request 26 of type 38 failed with server error : Object not found (1433)

Do you have any idea , what is the problem?

Thank you

[denis_konovalov]

2 things :

1. We need to see your properties file to make sure there are no problems there.

2. Are you sure that biar file is a working one ? Can you import from it using IW GUI ?

And the last , but not least - I hope you're not using RTM XI3.1 and are at a more recent patch level

[Former Member]

Hi

The properties file look like this:

importBiarLocation=/BO/boxi/test2.biar

action=importXML

userName=Administrator

password=

CMS=cru1a:54204

authentication=secEnterprise

I can not use the wizard since it to be "silent instalation"

the version if I not mistaken (I not at work at the moment- so I can not check) its FP3.5

[denis_konovalov]

properties file looks ok.

The IW test needed to see if the biar file is not corrupted and in working order. How was it created ?

[Former Member]

I have created the biar file

from same version of BO installation on a windows environment

I have check the log of the biar file I created it was fine

[denis_konovalov]

ok, but can you import this biar back into the same env using IW ?

how did you move it into your unix box (did you use binary transfer or auto) ?

what version of java do you use - run java -version, what it says ?

error message basicaly means :

there is either a problem with bir file itself, or the objects being imported can't overwrite those already in the destination or you're importing objects incompatible with biarengine (it doesn't have 100% parity with IW), or java used is wrong version...

so you have to eliminate all this possiblities to get to the bottom ...

Edited by: Denis Konovalov on May 24, 2011 6:38 PM

[Former Member]

thank you for your help

I have succeed to import it back to via IW

The java version on the unix is 1.5.0_07

And I use WinSCP to move the file , I have used it in the past with version BOXI R2 and there have never been problems.

The local support here said that I need to export the biar file in the same method.

But I do not see why, when I can export the file in a normal and friendly way by the IW. and when I have succeed to import a biar file with one report

[denis_konovalov]

so, we can rule out biar file corruption - great.

Now - what is exactly in this biar file ?

Do this objects exist in the destination ?

In general biarengine.jar has certain limitations described in the admin guide, so not all content exportable by IW can be imported by biarengine.

[Former Member]

the biar file include

eFashion (web) universe- already exist from the installation of BO

One report (under one folder)- already exist on the distanation from when I import only this report, with another bair file

New user- do not exist

[denis_konovalov]

ok, so we have universe, report and user. We know report import works.

Let's test if universe import works and then if user import works.

this will let us isolate if there is a specific object type on which this fails

[Former Member]

The one that failed, were of the user

What could be the problem with that

In the IW, I only mark the main check boxes, of the users and group ,all the others checkboxes are not mark

[denis_konovalov]

ok, now that we identified it only fails for that user, we'll ned to see if it fails for any user or this specific one ?

What groups it is a member of ?

Is it a group or parent object of that user that fails to import or user itself...

[Former Member]

The user is a member of "everyone"

I do not not know what failed , group object or the user.

In the source environment I only have 4 user the admonostrator and guset , and two other users that under the everyone group

Also , I am thinking of exporting the biar file through the command line

(just so I be sure that the problem is the object i.e. the user and not the utility)

but I do not know how to bulid the right query (I am not familiars with the tables)-

can you help me or direct me to a manual guide

Thank you

[Former Member]

BTW

The error message that I get , when I try to import a biar file that include only a user is "Failed to commit objects to server : Undefined Info Store error"

[denis_konovalov]

Now that you narrowed this down to the user object - I think it'll be better and more productive if you follow up with Support to get a resolution.

To find out why this happens it'll be required to review logs and user properties and both environments.

[Former Member]

Hi Denis

I found out after I create a biar file ,with only the user, through a command line. that the user did import since it was in a concurrent connectiontype , a type that not exit in the target environment.

But after I fix this in the source environment and saw that a biar file with only the user is loaded , I recreate the biar file with all the objects as before (user, universe, report , folder) and I still got the same error message as before.

So now I try to create the biar file with all those object through the command line. and I get a new errer message "Required dependencies not found on target system : '[AZK_.9sbf_lMgdQRpsbZfVw]"

I check it , and understand that the object is the report , but I do not see what missing..... : (

Those are the quries in the properties file:

exportQuery= SELECT * FROM CI_APPOBJECTS where si_kind = 'Universe' and si_name='eFashion'

exportQuery= SELECT * FROM CI_APPOBJECTS WHERE SI_ID in ( 894,926)

exportQuery= SELECT * from CI_SYSTEMOBJECTS WHERE SI_KIND = 'user' and SI_Name='repadmin'

exportQuery= SELECT * FROM CI_INFOOBJECTS WHERE si_kind= 'Folder' and SI_name = 'test'

exportQuery= SELECT * FROM CI_INFOOBJECTS WHERE SI_ID IN (2188)

Can you tell what is missing?

[Former Member]

Can you try importing using ImportWizard utility from a Windows box? If not share the BIAR and i can try that