Solved: Problems with SAP BO 4.2 migration from BOXI3.1 wi...

former_member303963 · ‎08-01-2018

Hi,

We are trying to perform an upgrade from BOXI3.1 to BO 4.2. I have created a BIAR file with BOXI3.1 Import Wizard.
The BIAR file seems to have al the exported objects. We have examined the Businessobjects.xml of the BIAR file an it includes a lot of <infoobject> tags.

However, when we import the file with thw Upgrame management tool, (via command, since we are in Linux), the result of the import is the following
(seeming that there are no objects in the BIAR):

The upgrade management tool will now perform a full update.
Opening BIAR file ...
Starting the session in the destination CMS ...
Opening BIAR file ...
Consulting the source system in search of objects that require parameters ...
100%
Preparing objects recovery ...
Retrieving objects ...
0
The step "Preparing objects" has been started.
Preparing 0 objects. Preparations:
100%
Step completed.
0 of 0 objects tried. 0 have failed.
The step "Updating objects" has been started.
Updating 0 objects. Updated:
0
Step completed.
0 of 0 objects tried. 0 have failed. 0 created objects. 0 executed objects.
The step "Committing objects" has been started.
Committing 0 objects. Committed:
100%
Step completed.
0 of 0 objects tried. 0 have failed.
The step "Updating confirmed objects" has been started.
Updating confirmed objects. Updated:
0
Step completed.
No object requires updating.
The update record can be found at: /tmp/log/LogFileUMT-20180801.csv
The tracking logs can be found at: / app / SAPBO42 / sap_bobj / logging /

So, no objects are imported, but no error is thrown.

Do you know what is happening?

Thanks,

Jose Manuel.

ayman_salem · ‎08-01-2018

What I notice in the log, there is a "permission denied" when creating a new file. (The "UMT" directory and the "UMT_properties.txt" file are created at runtime in the "Data" directory)

So, which user do you run the upgrade management tool with?

....

also, have you one biar file or multiple segmented BIAR files?

to use multiple segmented BIAR files as an upgrade source, ensure that all files are located in the same directory.

denis_konovalov · ‎08-01-2018

First of all - please remove all server names from posts you make.
Second - this is not a good place to post logs, as the formatting here makes them hard to read and logs have sensitive information that you shouldn't be sharing.
Third - why is this in your UMT logs :

java.io.FileNotFoundException: /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre.. ???

Why are you using this weird Java ??
Sounds like your BI4.2 is either not properly installed or your environment variables are wrong.

Fourth - importing back is using the import wizard and trying to import the biar you created earlier back into the Xi3.1.

Bases on logs - your BI4.2 environment is either not properly setup or its environment variables are wrong. UMT should not pick/use non SAP java.
This -

/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre..\..\..\..\Data\UMT\UMT_properties.txt should not be possible.
I suggest that you open an Incident with SAP support under component BI-BIP-LCM to sort it out.

denis_konovalov · ‎08-01-2018

What exactly is the Xi3.1 version ?

First suspicion is that BIAR file is not good. Can you import it back into source ?
What exactly was exported/how many objects and what exact option were selected during export ?

Also, if you have spare/temp windows server - install full stack of BOE on it and try using GUI UMT to see if there will be any difference ?
You can also try to export just couple reports and test import to see if that works. Maybe there is something else that is broken.

Also, check this KBA :
https://launchpad.support.sap.com/#/notes/2442510
and
https://launchpad.support.sap.com/#/notes/1904814

former_member303963 · ‎08-16-2018

Hi,

Finally we were able to fix the problem. We installed the BO4.2 SP3 Patch 13 and the import worked fine.

Thank you very much for your help.

Jose Manuel.

former_member303963 · ‎08-06-2018

I have found one incident similar to ours this page:

https://launchpad.support.sap.com/#/notes/2424335

The only thing is that we have a BO4.2 SP2, instead of the BO4.2 SP3 reported in the incident.

Do you thing our error can be produced by a bug in our version of BO, so it could be solved by installing BO4.2 SP4?

Thanks for your help. We are really in trouble and need some help.

former_member303963 · ‎08-03-2018

I have set up all the variables with the env.sh and also de JAVA_HOME and PATH. Now the java error have disapeared, but the other error persist:

|604E4994555A4F0691AE3287A3A75CE90|2018 08 03 10:29:57.931|+0200|Error| |==|E| |upgrademanagementtool| 6856| 20|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.sdk.biar.om.internal.importer.OMImporter||OMImporter Batch Importers' barrier broke.
com.businessobjects.sdk.biar.om.internal.concurrent.BarrierBrokenException
at com.businessobjects.sdk.biar.om.internal.concurrent.Barrier.awaitBarrierReached(Barrier.java:49)
at com.businessobjects.sdk.biar.om.internal.importer.OMImporter.importObjects(OMImporter.java:188)
at com.businessobjects.sdk.biar.om.internal.ObjectManager.doImport(ObjectManager.java:671)
at com.businessobjects.sdk.biar.om.internal.ObjectManager.access$500(ObjectManager.java:62)
at com.businessobjects.sdk.biar.om.internal.ObjectManager$1.run(ObjectManager.java:423)
at com.businessobjects.sdk.biar.om.internal.ObjectManager$1.run(ObjectManager.java:389)
at com.businessobjects.sdk.biar.om.internal.ObjectManager$AbstractImport.run(ObjectManager.java:913)
at com.businessobjects.upgrademanager.datasource.ObjectSourceFactory.openBiar(ObjectSourceFactory.java:108)
at com.businessobjects.upgrademanager.datasource.Ecosystem$BiarToLive.<init>(Ecosystem.java:799)
at com.businessobjects.upgrademanager.datasource.Ecosystem.logon(Ecosystem.java:85)
at com.businessobjects.upgrademanager.UpgradeManager.openBiarToLive(UpgradeManager.java:470)
at com.businessobjects.upgrademanager.PageLogOn$LogOnRunnable.run(PageLogOn.java:1104)
at com.businessobjects.upgrademanager.UpgradeManagerConsole.run(UpgradeManagerConsole.java:103)
at com.businessobjects.upgrademanager.UpgradeManagerConsole.run(UpgradeManagerConsole.java:112)
at com.businessobjects.upgrademanager.UpgradeManagerConsole.run(UpgradeManagerConsole.java:99)
at com.businessobjects.upgrademanager.PageLogOn.onTextModeInvocation(PageLogOn.java:601)
at com.businessobjects.upgrademanager.UpgradeManagerConsole.showPage(UpgradeManagerConsole.java:70)
at com.businessobjects.upgrademanager.UpgradeManagerConsole.open(UpgradeManagerConsole.java:44)
at com.businessobjects.upgrademanager.UpgradeManagerMain.run(UpgradeManagerMain.java:104)

I think taht this error causes not to import the objects, since time ago we achived to do a sucessfull import and this error was not produced.

The only thing we have changed since then is the CMS password in Oracle when it caducated, then BO didn't stated, so that we put again the old password and everithing worked fine (until this).

former_member303963 · ‎08-02-2018

Finally I find out that the error the tool is returning is this:

|CF02D02733DF4C9A8D1BD0B77164C3352|2018 08 02 12:05:40.663|+0200|Error| |==|E| |upgrademanagementtool| 4478| 16|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.sdk.biar.om.internal.importer.OMImporter||OMImporter Batch Importers' barrier broke.
com.businessobjects.sdk.biar.om.internal.concurrent.BarrierBrokenException
at com.businessobjects.sdk.biar.om.internal.concurrent.Barrier.awaitBarrierReached(Barrier.java:49)
at com.businessobjects.sdk.biar.om.internal.importer.OMImporter.importObjects(OMImporter.java:188)
at com.businessobjects.sdk.biar.om.internal.ObjectManager.doImport(ObjectManager.java:671)
at com.businessobjects.sdk.biar.om.internal.ObjectManager.access$500(ObjectManager.java:62)
at com.businessobjects.sdk.biar.om.internal.ObjectManager$1.run(ObjectManager.java:423)
at com.businessobjects.sdk.biar.om.internal.ObjectManager$1.run(ObjectManager.java:389)
at com.businessobjects.sdk.biar.om.internal.ObjectManager$AbstractImport.run(ObjectManager.java:913)
at com.businessobjects.upgrademanager.datasource.ObjectSourceFactory.openBiar(ObjectSourceFactory.java:108)
at com.businessobjects.upgrademanager.datasource.Ecosystem$BiarToLive.<init>(Ecosystem.java:799)
at com.businessobjects.upgrademanager.datasource.Ecosystem.logon(Ecosystem.java:85)
at com.businessobjects.upgrademanager.UpgradeManager.openBiarToLive(UpgradeManager.java:470)
at com.businessobjects.upgrademanager.PageLogOn$LogOnRunnable.run(PageLogOn.java:1104)
at com.businessobjects.upgrademanager.UpgradeManagerConsole.run(UpgradeManagerConsole.java:103)
at com.businessobjects.upgrademanager.UpgradeManagerConsole.run(UpgradeManagerConsole.java:112)
at com.businessobjects.upgrademanager.UpgradeManagerConsole.run(UpgradeManagerConsole.java:99)
at com.businessobjects.upgrademanager.PageLogOn.onTextModeInvocation(PageLogOn.java:601)
at com.businessobjects.upgrademanager.UpgradeManagerConsole.showPage(UpgradeManagerConsole.java:70)
at com.businessobjects.upgrademanager.UpgradeManagerConsole.open(UpgradeManagerConsole.java:44)
at com.businessobjects.upgrademanager.UpgradeManagerMain.run(UpgradeManagerMain.java:104)

Do you have any idea what can be causing this?

Thanks again.

former_member303963 · ‎08-02-2018

Hi,

I use a linux user 'bobjects' which is the one for the instalation of BO.

The directory where it tries yo copy UMT_properties.txt, does not exist. I think that the JAVA:HOME and PATH are not pointing to our JAVA installation for SAP BO.

Can you tell me where the JAVA_HOME and PATH variales should point to?

I have seen in this post (https://archive.sap.com/discussions/thread/2081627) the following :

Check your java version.

Otherwise set java home directory and path.

for example(linux):

export JAVA_HOME=/<bo home directory>/sap_bobj/enterprise_xi40/linux_x64/jdk

export PATH=/<bo home directory>/sap_bobj/enterprise_xi40/linux_x64/jdk/bin:$PATH

But I don't see any java in the mentioned /<bo home directory>/sap_bobj/enterprise_xi40/linux_x64/. There is not jdk directory.

Thanks.

former_member586423 · ‎08-01-2018

Hi Jose,

What is the SP Version installed on top of BI 4.2?

Is the destination enviornment newly setup or it contains data?

Regards,

Chaitanya

former_member586423 · ‎08-01-2018

Hi Jose,

What is the SP Version installed on top of BI 4.2?

Is the destination enviornment newly setup or it contains data?

Regards,

Chaitanya

former_member303963 · ‎08-01-2018

Denis,

The exact version is Business Objects XI 3.1 (SP2).

We have exported a couple of resporta a the result is the same.

What do you mean by import it back into source ?

The objects exported are the following (copied from the BIAR file):

<io:InfoObject xsi:type="fo:Folder">
<io:InfoObject xsi:type="fo:Folder">
<io:InfoObject xsi:type="fo:Folder">
<io:InfoObject xsi:type="md.dc:MetaData.DataConnection">
<io:InfoObject xsi:type="un:Universe">
<io:InfoObject xsi:type="un:Universe">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="wi:Webi">
<io:InfoObject xsi:type="crole:CustomRole">
<io:InfoObject xsi:type="crole:CustomRole">
<io:InfoObject xsi:type="crole:CustomRole">
<io:InfoObject xsi:type="crole:CustomRole">

former_member303963 · ‎08-01-2018

There is a log file in /app/SAPBO42/sap_bobj/logging /

I copy last lines of it:

|7741845A50A04970BB7B98617399A7A61|2018 08 01 14:45:26.461|+0200|Error| |==|E| |upgrademanagementtool|20924| 16|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.sdk.biar.internal.db.Derby||File error

java.io.FileNotFoundException: /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre..\..\..\..\Data\UMT\UMT_properties.txt (No such file or directory)

at java.io.FileInputStream.open(Native Method)

at java.io.FileInputStream.<init>(FileInputStream.java:137)

at java.io.FileInputStream.<init>(FileInputStream.java:96)

at java.io.FileReader.<init>(FileReader.java:58)

at com.businessobjects.sdk.biar.internal.db.Derby.createHashMapFromFile(Derby.java:172)

at com.businessobjects.sdk.biar.internal.db.Derby.<clinit>(Derby.java:69)

at com.businessobjects.upgrademanager.util.db.Database.<clinit>(Database.java:41)

at com.businessobjects.upgrademanager.util.db.DatabaseFactory.createDatabase(DatabaseFactory.java:16)

at com.businessobjects.upgrademanager.logic.statusdb.LogDatabase.<init>(LogDatabase.java:59)

at com.businessobjects.upgrademanager.logic.DBLogStore.<init>(DBLogStore.java:20)

at com.businessobjects.upgrademanager.logic.MigrationLogger.<init>(MigrationLogger.java:62)

at com.businessobjects.upgrademanager.UpgradeManager.<init>(UpgradeManager.java:294)

at com.businessobjects.upgrademanager.UpgradeManagerMain.run(UpgradeManagerMain.java:65)

-

|7741845A50A04970BB7B98617399A7A62|2018 08 01 14:45:35.612|+0200|Error| |==|E| |upgrademanagementtool|20924| 16|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.sdk.biar.om.internal.importer.OMImporter||OMImporter Batch Importers' barrier broke.

com.businessobjects.sdk.biar.om.internal.concurrent.BarrierBrokenException

at com.businessobjects.sdk.biar.om.internal.concurrent.Barrier.awaitBarrierReached(Barrier.java:49)

at com.businessobjects.sdk.biar.om.internal.importer.OMImporter.importObjects(OMImporter.java:188)

at com.businessobjects.sdk.biar.om.internal.ObjectManager.doImport(ObjectManager.java:671)

at com.businessobjects.sdk.biar.om.internal.ObjectManager.access$500(ObjectManager.java:62)

at com.businessobjects.sdk.biar.om.internal.ObjectManager$1.run(ObjectManager.java:423)

at com.businessobjects.sdk.biar.om.internal.ObjectManager$1.run(ObjectManager.java:389)

at com.businessobjects.sdk.biar.om.internal.ObjectManager$AbstractImport.run(ObjectManager.java:913)

at com.businessobjects.upgrademanager.datasource.ObjectSourceFactory.openBiar(ObjectSourceFactory.java:108)

at com.businessobjects.upgrademanager.datasource.Ecosystem$BiarToLive.<init>(Ecosystem.java:799)

at com.businessobjects.upgrademanager.datasource.Ecosystem.logon(Ecosystem.java:85)

at com.businessobjects.upgrademanager.UpgradeManager.openBiarToLive(UpgradeManager.java:470)

at com.businessobjects.upgrademanager.PageLogOn$LogOnRunnable.run(PageLogOn.java:1104)

at com.businessobjects.upgrademanager.UpgradeManagerConsole.run(UpgradeManagerConsole.java:103)

at com.businessobjects.upgrademanager.UpgradeManagerConsole.run(UpgradeManagerConsole.java:112)

at com.businessobjects.upgrademanager.UpgradeManagerConsole.run(UpgradeManagerConsole.java:99)

at com.businessobjects.upgrademanager.PageLogOn.onTextModeInvocation(PageLogOn.java:601)

at com.businessobjects.upgrademanager.UpgradeManagerConsole.showPage(UpgradeManagerConsole.java:70)

at com.businessobjects.upgrademanager.UpgradeManagerConsole.open(UpgradeManagerConsole.java:44)

at com.businessobjects.upgrademanager.UpgradeManagerMain.run(UpgradeManagerMain.java:104)

-

|7741845A50A04970BB7B98617399A7A63|2018 08 01 14:45:36.970|+0200|Error| |==|E| |upgrademanagementtool|20924| 16|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.upgrademanager||Phase 'Preparando objetos' begins.-

|7741845A50A04970BB7B98617399A7A64|2018 08 01 14:45:37.730|+0200|Error| |==|E| |upgrademanagementtool|20924| 16|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.upgrademanager||Phase 'Preparando objetos' ends.-

|7741845A50A04970BB7B98617399A7A65|2018 08 01 14:45:37.730|+0200|Error| |==|E| |upgrademanagementtool|20924| 16|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.upgrademanager||Phase 'Actualizando objetos' begins.-

|7741845A50A04970BB7B98617399A7A66|2018 08 01 14:45:37.783|+0200|Error| |==|E| |upgrademanagementtool|20924| 16|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.upgrademanager||Phase 'Actualizando objetos' ends.-

|7741845A50A04970BB7B98617399A7A67|2018 08 01 14:45:37.783|+0200|Error| |==|E| |upgrademanagementtool|20924| 16|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.upgrademanager||Phase 'Comprometiendo objetos' begins.-

|7741845A50A04970BB7B98617399A7A68|2018 08 01 14:45:37.809|+0200|Error| |==|E| |upgrademanagementtool|20924| 16|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.upgrademanager||Phase 'Comprometiendo objetos' ends.-

|7741845A50A04970BB7B98617399A7A69|2018 08 01 14:45:37.809|+0200|Error| |==|E| |upgrademanagementtool|20924| 16|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.upgrademanager||Phase 'Actualizando objetos confirmados' begins.-

|7741845A50A04970BB7B98617399A7A6a|2018 08 01 14:45:37.826|+0200|Error| |==|E| |upgrademanagementtool|20924| 16|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.upgrademanager||Phase 'Actualizando objetos confirmados' ends.-

|3E61FEE34B23434C8A9966763AEF33950|2018 08 01 14:54:35.193|+0200|Error| |==|E| |upgrademanagementtool|23312| 16|sap.bobj.umt.mainOSGiThread| ||||||||||||||||||||com.businessobjects.sdk.biar.internal.db.Derby||File error

java.io.IOException: Permission denied

at java.io.UnixFileSystem.createFileExclusively(Native Method)

at java.io.File.createNewFile(File.java:900)

at com.businessobjects.sdk.biar.internal.db.Derby.<clinit>(Derby.java:60)