LCMBIAR file import errors

[Former Member]

Hi,

I am unable to import an LCMBIAR file created in my UAT environment to my production environment. Both systems are BI4.0 SP5 on Windows 200 R2.

In UAT I can create the LCMBIAR file and export it to a local drive ok. I have created numerous files now, from one that has all the users and content from UAT to one that has just one universe or just one report.

I then copy this LCMBIAR file to the production server.

There is no network connectivity between the two servers so I cannot use promotion management directly between them. I have to copy to my laptop from one remote desktop, then from my laptop to the other remote desktop.

I have tried zipping the LCMBIAR files to protect them form corruption during this copy/paste but this does not help.

Once the LCMBIAR is on the production machine I can use promoition management to navigate to the import file but when I click OK it thinks about it for a few moments then I get the error:

"

Sorry, Promotion management application is unable to process your request.

The error from the server is: Unable to retrieve Job from the selected file. Please check the file.(PRS 00009)com.businessobjects.lcm.utilities.LCMException: com.businessobjects.sdk.biar.BIARException$EngineException: Required dependencies not found on target system : '[AU0AtN8keaNIv7YTxQt3T4E]' at com.businessobjects.lcm.job.JobManager.getJobFromFile(JobManager.java:249) at com.businessobjects.lcm.job.JobManager.getJobFromFile(JobManager.java:209) at com.businessobjects.lcm.core.LCMEngine.getJobFromFile(LCMEngine.java:2027) at com.businessobjects.lcm.actionHelper.JobActionHelper.getJobFromFile(JobActionHelper.java:3879) at com.businessobjects.lcm.actionHelper.JobActionHelper.performAction(JobActionHelper.java:244) at com.businessobjects.lcm.actions.JobActions.execute(JobActions.java:59) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110) at com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46) at com.businessobjects.webutil.boetrustguard.BOETrustPrepareFilter.doFilter(BOETrustPrepareFilter.java:32) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.swd.shared.tracelog.TraceLogScopeFilter.doFilter(TraceLogScopeFilter.java:38) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:45) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.swd.appcontext.RequestInitFilter.doFilter(RequestInitFilter.java:26) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:235) at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197) at com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:166) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: com.businessobjects.sdk.biar.BIARException$EngineException: Required dependencies not found on target system : '[AU0AtN8keaNIv7YTxQt3T4E]' at com.businessobjects.sdk.biar.BIARException$EngineException.rethrow(BIARException.java:113) at com.businessobjects.sdk.biar.om.internal.ThrowableSink.rethrowExceptions(ThrowableSink.java:86) at com.businessobjects.sdk.biar.om.internal.importer.OMImporter.importObjects(OMImporter.java:256) at com.businessobjects.sdk.biar.om.internal.ObjectManager.doImport(ObjectManager.java:615) at com.businessobjects.sdk.biar.om.internal.ObjectManager.access$500(ObjectManager.java:58) at com.businessobjects.sdk.biar.om.internal.ObjectManager$1.run(ObjectManager.java:372) at com.businessobjects.sdk.biar.om.internal.ObjectManager$1.run(ObjectManager.java:380) at com.businessobjects.sdk.biar.om.internal.ObjectManager$AbstractImport.run(ObjectManager.java:855) at com.businessobjects.sdk.biar.om.internal.ObjectManager.importArchive(ObjectManager.java:327) at com.businessobjects.lcm.core.CMSLocal.importResources(CMSLocal.java:2083) at com.businessobjects.lcm.core.CMSLocal.importResources(CMSLocal.java:2041) at com.businessobjects.lcm.job.JobHelper.getJobFromFile(JobHelper.java:135) at com.businessobjects.lcm.job.JobManager.getJobFromFile(JobManager.java:236) ... 47 more Caused by: com.businessobjects.sdk.biar.BIARException$EngineException: Required dependencies not found on target system : '[AU0AtN8keaNIv7YTxQt3T4E]' at com.businessobjects.sdk.biar.om.internal.importer.OMImporter$BatchImporter.resolveParents(OMImporter.java:1117) at com.businessobjects.sdk.biar.om.internal.importer.OMImporter$BatchImporter.secondPass(OMImporter.java:697) at com.businessobjects.sdk.biar.om.internal.importer.OMImporter$BatchImporter.runSafely(OMImporter.java:508) at com.businessobjects.sdk.biar.om.internal.concurrent.AbstractThread.run(AbstractThread.java:19) com.businessobjects.lcm.utilities.LCMException: com.businessobjects.sdk.biar.BIARException$EngineException: Required dependencies not found on target system : '[AU0AtN8keaNIv7YTxQt3T4E]'

The error is consistent whether I have an LCMBIAR file with objects with dependencies or not.

I have ensured I am using the administrator logon on both systems.

The admin user has access to the temp storage, LCM folders and all the applications

I have checked the locale settings in the CMC preferences as per 1804206 and set them to English

I am able to create an LCMBIAR on the production machine itself and then re-import it successfully, so I am guessing it is something on the UAT machine that is wrong - but I have tried all hte settings I can think of or find.

I have queired the CMS to see what the AU0AtN8keaNIv7YTxQt3T4E object is, and it is the job/LCMBIAR file itself on the UAT system (each file I have tried is a different reference but when queried against the UAT CMS shows as the LCMBIAR file name). I am confused by this as by definition an LCMBIAR file created on another system will have no dependencies on the new system. Unless the design is such that it is impossible to import content from one system to another by LCMBIAR file, which would be an odd design decision.

My back up plan of manually transferring the unx and wid files failed after i found I could not re-point the webi queries at the new universes, which is also frustrating.

Anyway, any suggestions or assistance will be greatly appreciated,

thanks

Keith Fisher

[Former Member · Accepted solution]

It was fixed by applying fix pack 3 of service pack 5 to both UAT and production. It failed the first time we tried to bring in a LCMBIAR file after this, but worked on the second go and all subsequent imports.

suggestion was made by Philippe in SAP after we raised a support case

thanks for the suggestions everyone

[Former Member]

in further testing this morning I have found that I cannot re-import LCMBIAR files created on the UAT system, back into the UAT system. If I try to do this I get this error when I click OK on the selected file from the file system:

Sorry, Promotion management application is unable to process your request.
The error from the server is: Unable to retrieve Job from the selected file. Please check the file.(PRS 00009)com.businessobjects.lcm.utilities.LCMException: com.businessobjects.sdk.biar.om.OMException$StorageException: An exception occurred that prevents the reading or writing of an object to or from storage. (FWM 10002) at com.businessobjects.lcm.job.JobManager.getJobFromFile(JobManager.java:249) at com.businessobjects.lcm.job.JobManager.getJobFromFile(JobManager.java:209) at com.businessobjects.lcm.core.LCMEngine.getJobFromFile(LCMEngine.java:2027) at com.businessobjects.lcm.actionHelper.JobActionHelper.getJobFromFileWithPassword(JobActionHelper.java:4030) at com.businessobjects.lcm.actionHelper.JobActionHelper.performAction(JobActionHelper.java:695) at com.businessobjects.lcm.actions.JobActions.execute(JobActions.java:59) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110) at com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46) at com.businessobjects.webutil.boetrustguard.BOETrustPrepareFilter.doFilter(BOETrustPrepareFilter.java:32) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.swd.shared.tracelog.TraceLogScopeFilter.doFilter(TraceLogScopeFilter.java:38) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:45) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.swd.appcontext.RequestInitFilter.doFilter(RequestInitFilter.java:26) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:235) at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197) at com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:166) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: com.businessobjects.sdk.biar.om.OMException$StorageException: An exception occurred that prevents the reading or writing of an object to or from storage. (FWM 10002) at com.businessobjects.sdk.biar.om.OMException$StorageException.rethrow(OMException.java:87) at com.businessobjects.sdk.biar.om.internal.ThrowableSink.rethrowExceptions(ThrowableSink.java:86) at com.businessobjects.sdk.biar.om.internal.importer.OMImporter.importObjects(OMImporter.java:256) at com.businessobjects.sdk.biar.om.internal.ObjectManager.doImport(ObjectManager.java:615) at com.businessobjects.sdk.biar.om.internal.ObjectManager.access$500(ObjectManager.java:58) at com.businessobjects.sdk.biar.om.internal.ObjectManager$1.run(ObjectManager.java:372) at com.businessobjects.sdk.biar.om.internal.ObjectManager$1.run(ObjectManager.java:380) at com.businessobjects.sdk.biar.om.internal.ObjectManager$AbstractImport.run(ObjectManager.java:855) at com.businessobjects.sdk.biar.om.internal.ObjectManager.importArchive(ObjectManager.java:327) at com.businessobjects.lcm.core.CMSLocal.importResources(CMSLocal.java:2083) at com.businessobjects.lcm.core.CMSLocal.importResources(CMSLocal.java:2064) at com.businessobjects.lcm.job.JobHelper.getJobFromFile(JobHelper.java:137) at com.businessobjects.lcm.job.JobManager.getJobFromFile(JobManager.java:236) ... 47 more Caused by: java.sql.SQLException: Container 384 not found. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.(Unknown Source) at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at com.businessobjects.sdk.biar.om.internal.db.AnnotatedObjectStore$ConnectionResources.getPreparedStatement(AnnotatedObjectStore.java:1833) at com.businessobjects.sdk.biar.om.internal.db.AnnotatedObjectStore$ConnectionResources.getPreparedStatement(AnnotatedObjectStore.java:1850) at com.businessobjects.sdk.biar.om.internal.db.AnnotatedObjectStore.updateAll(AnnotatedObjectStore.java:1415) at com.businessobjects.sdk.biar.om.internal.db.AnnotatedObjectStore.updateAll(AnnotatedObjectStore.java:977) at com.businessobjects.sdk.biar.om.internal.concurrent.WriterThread.runSafely(WriterThread.java:50) at com.businessobjects.sdk.biar.om.internal.concurrent.AbstractThread.run(AbstractThread.java:19) Caused by: java.sql.SQLException: Container 384 not found. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 19 more com.businessobjects.lcm.utilities.LCMException: com.businessobjects.sdk.biar.om.OMException$StorageException: An exception occurred that prevents the reading or writing of an object to or from storage. (FWM 10002)

To see the stack trace, click:

I have checked the file, by renaming it as a .zip file and extracting the contents - there is an XML file, a properties file and 5 files all named the same (the cuid of the job) except for the extensions which are numbered 001 to 005.

I assume that there is an issue with the promotion management job on the UAT server, in that the files it is creating cannot be read back in by itself or by the production system. (I can create and read back in LCMBIARs on the production system with no issues)

I have created a new LCM specific AdaptiveProcessingServer but this has not changed the outcome at all.

Any suggestions welcome as to how I could go about getting the content of the UAT system into the Production system.

thanks

Keith

[Former Member]

I have managed to get the LCMBIAR issue on my UAT system corrected by changing the account the system is running under from the LocalSystem to one with admin rights on the server, looks like that was an issue with access to the Temp directory for the transitional database.

However the issue with 'required dependencies' in the production system still persists.

Anyone have any new ideas?

[Former Member]

Keith,

What patch level you are on? Does the Production and and your UAT system are on the same patch level?

Can you do Live to live?

Can you do the below steps?

Tomcat configuration -> Java:
- We could add more memory to the Maximum Memory Pool (we can monitor
performance for value 4GB) to be added in M; e.g. 4GB = 4096M.

** BOE Servers:
- In properties of Adaptive Job Server and Adaptive Processing Server
for LCM.
- After a 'space' add "-Xmx4g" to the end of the command line of these

[Former Member]

Hi Jawahar,

thanks for the reply,

Both systems are on SP05 with no fix patches applied.

It is possible to do Live to Live (and now UAT to UAT)

I will try the above steps and let you know what we find.

thanks

Keith

[Former Member]

Jawahar,

I have made the memory changes in the Tomcat configuration and on the Adaptive Processing server (and restarted both) and still get the same error.

thanks

Keith

[Former Member]

Can you do the same for AJS as well? When we are in SP4 and Patch2 or 3 , we used to get the issue intermittently. After applying Patch4, we did not see the issue.

I believe SP5 does not contain Patch4.

We called SAP support, when we had the issue, they suggested us above memory configuration.

How many objects you are adding to biar file? What objects you are adding?

[former_member202789]

Have you created the LCMBIAR with usersecurity and application security both?

Try creating a LCM BIAR without security and then try the same.

Regards,

Animesh Kumar

[former_member182521]

Hello Keith,

Are we promoting all the dependent objects in the BIAR file. I could see enormous missing dependecy errore in the log.

Do we export connections as well along with Universe and reports? Can you brief bit more.

Regards

Mani

[Former Member]

This message was moderated.

[Former Member]

Hi Mani,

thanks for your reply.

I have tried creating an LCMBIAR file with all dependent objects and importing that, and also tried creating some without dependent objects, and both fail with very similar errors.

Looking up the object named in the error message, it is always the LCMBIAR file object itself, not the objects within the file.

thanks

Keith

[DayaJha]

Hi Keith,

Please refer the following SNotes From SAP Market Place regarding LCM in SAP Business Objects Business Intelligence 4.0.

1666943 - Error: "Version check failed. The source system or source BIAR file must be of an older version. The destination system must be of the current version. (UMT 20012)" when transferring data using Upgrade Management Tool (UMT) in BI 4.0

Links:

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

1804206 - Unable to import LCMBIAR file which was created by LCM_cli.bat with error "Sorry, Promotion management application is unable to process your request. The error from the server is: Unable to retrieve Job from the selected file. Please check the file.(PRS..00009)"

Links:

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

1574546 - LCM Can't import XI3.1 lcmbiar into SAP BI4.0

Links:

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

1365215 - LCM - "promotion" or "test promote" fails with FWM 04003 when using delegated administration

Links:

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

1808609 - Import file parsing exception occurred : 'The entity name must immediately follow the '&' in the entity reference.' (FWM 04009)

Links:

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

Hope this will help you as well.

Thanks,

Daya

[Former Member]

Hi Daya,

thanks for your reply, however I have seen most of those already and I don't think any of them are relevant in this case.

Some of them do imply at least that you are supposed to be able to move content from one BI4.0 system to another with LCMBIAR files, so I'm not going mad

thanks

Keith