22 thoughts on “Discussion – UNX Universe Documenter”
Hi Admin,
Thanks for excellent utilities shared on this portal, I have been using CMS Query builder and unv documenter. these utlities gives an great relief for admins. I have faced one issue while using unx documenter. can you please help me on this, here is the error message to deep dive into it.
Importing [/Universes/DDW-Dell Data Warehouse/CORP/Product/GLBL_OFFER_ID_Reporting.unx]
Error
com.sap.tools.commons.exception.NestedException: Specified RDBMS is invalid : Teradata V2 R6
I installed Client tool 4.2. I had to change Java path in this way: SET JAVA=%BO%\win32_x86\jre8.
The utility starts. I open the Universe from my repository but when I start the process it remains hanging in blue (no red and no green).
Is your utility compatible with client tool 4.2. Another point is I have win10 and in my control panel/app I did not find “Modify” but I have only “Remove”. I’m not able to check if I installed all the required modules. Any idea?
Thanks
Amerigo
Hi Ametor,
We have not tested the tool with BO 4.2. The file unxdoc-debug.bat generates a log file. You can adjust JAVA in this file, run it and check the error message in log.txt. If you can send us the log file, we will investigate.
Thanks!
Error – Memory – select top 2500 SI_ID, SI_NAME, SI_USERGROUPS from ci_systemobjects where si_kind = ‘user’ and si_id not in (’11’,’12’) AND SI_USERGROUPS.SI_TOTAL >= 1
Exception in thread “AWT-EventQueue-0” java.lang.OutOfMemoryError: Java heap space
at org.apache.xmlbeans.impl.store.Saver$TextSaver.resize(Saver.java:1592)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.preEmit(Saver.java:1223)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.emit(Saver.java:1144)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.emitElement(Saver.java:926)
at org.apache.xmlbeans.impl.store.Saver.processElement(Saver.java:456)
at org.apache.xmlbeans.impl.store.Saver.process(Saver.java:307)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.saveToString(Saver.java:1727)
at org.apache.xmlbeans.impl.store.Cursor._xmlText(Cursor.java:546)
at org.apache.xmlbeans.impl.store.Cursor.xmlText(Cursor.java:2436)
at org.apache.xmlbeans.impl.values.XmlObjectBase.xmlText(XmlObjectBase.java:1455)
at org.apache.poi.xssf.model.SharedStringsTable.getKey(SharedStringsTable.java:130)
java version “1.7.0_25”
Java(TM) SE Runtime Environment (build 1.7.0_25-b17)
Java HotSpot(TM) Client VM (build 23.25-b01, mixed mode)
SAP BusinessObjects BI platform 4.1 SP6 Patch 1 update (14.1.6.1760)
SAP BusinessObjects BI platform 4.1 SP6 Patch 2 update (14.1.6.1785)
SAP BusinessObjects BI platform 4.1 SP6 Patch 3 update (14.1.6.1805)
SAP BusinessObjects BI platform 4.1 SP6 Patch 7 update (14.1.6.1979)
SAP BusinessObjects BI platform 4.1 SP6 Patch 9 update (14.1.6.2060)
SAP BusinessObjects BI platform 4.1 SP6 (14.1.6.2060) – en, it
Error occurred during initialization of VM
Could not reserve enough space for object heap
Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. Program will exit.
Hi, thanks for the superb tool!
We are using BO 4.2 SP2 and unx documenter works fine with most of the universes. However I am getting an error with a universe that has 287 Tables and 967 Joins.
The error: java.lang.NullPointerException
Debug:
Connected
Importing [/Universes A.unx]
Error
java.lang.NullPointerException
at com.businessobjects.mds.services.helpers.RelationalUniverseHelper.addTables(RelationalUniverseHelper.java:1616)
at com.businessobjects.mds.services.helpers.RelationalUniverseHelper.getTables(RelationalUniverseHelper.java:1599)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.setNewExtraTables(MdsToSdkBusinessLayerConverter.java:528)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyBusinessItemProperties(MdsToSdkBusinessLayerConverter.java:517)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.createSdkItem(MdsToSdkBusinessLayerConverter.java:306)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyMdsToSdk(MdsToSdkBusinessLayerConverter.java:258)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyMdsToSdk(MdsToSdkBusinessLayerConverter.java:265)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyMdsToSdk(MdsToSdkBusinessLayerConverter.java:265)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.createSdkModel(MdsToSdkBusinessLayerConverter.java:184)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.BusinessLayerModelToModel.createSdkModel(BusinessLayerModelToModel.java:31)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.createSdkBusinessLayer(LocalResourceServiceImpl.java:191)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.loadInternal(LocalResourceServiceImpl.java:170)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.load(LocalResourceServiceImpl.java:131)
at com.biclever.gui.unxdoc.UnxMetadataExtractor.extract(UnxMetadataExtractor.java:47)
at com.biclever.gui.unxdoc.UnxTool.run(UnxTool.java:67)
at com.biclever.gui.GuiProcessProcessingTask.doInBackground(GuiProcessProcessingTask.java:61)
at com.biclever.gui.GuiProcessProcessingTask.doInBackground(GuiProcessProcessingTask.java:1)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
The error occurs when the tool is importing universe inside of BO SDK. So it is not something we can fix in the tool. It is something SAP should fix in SDK or you in the universe.
I can see from the log that it failed when SDK was trying to add extra tables to some object in business layer when loading universe.
com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.setNewExtraTables(MdsToSdkBusinessLayerConverter.java:528)
If you can send us (support@biclever.com) the universe in LCMBIAR, we can try to investigate what specifically causes the issue. I understand that this might be not possible due to your company policies. In this case, we cannot help further but I will appreciate if you revert with any new information you will find about the issue for our future reference.
First of all, thanks for the quick answer. I appreciate you effort to help me.
It is a big universe, so it took a while to figure out what could possibly be wrong during the load.
I have identified the objects that are causing this error. The objects I’ve found are created from CALENDAR ALIAS tables. For e.g. CALENDAR_A.YEAR, CALENDAR_B.YEAR, CALENDAR_C.YEAR, etc. Note that in this universe there are other CALENDAR_D.YEAR, CALENDAR_E.YEAR that are not causing the error during the load.
I have been checking many different things with those objects (LoV, context, data type, etc.) and found that the problem in this case was related with “Display Formats”.
SOLUTION
I have managed to document the whole universe content by:
1. changing or deleting the display formats in problematic objects
2. deleting problematic objects
1. Solution
The display format is not documented using this documentation tool anyway. So in this context we can just delete the custom display formats to save some time (changing them takes more time). However, in this case you would need to create a copy of the universe for documentation. Steps:
• Open the universe
• Find the problematic objects
• Select the object
• Change the view to Advanced tab
• Edit or Delete Display Format
• Do the same for all the Claim Calendar Objects
In my case it was OK to do the change and fix the universe, since there were only 12 problematic objects. It was quite strange that all of them were YEAR from different CALENDAR Alias tables. The data type = Numeric. Selected display format Custom 0;;. I have no idea why there were ;; at the end. I expect it was a mistype and that was causing the problem during the load. Once I delete the Display Format or I change the Custom Display format from 0;; to 0 the documentation tool starts to work fine.
2. Solution
You can delete the problematic objects if you have a lot of them. But note that then you will lose some part of the documentation. In addition, you have to create a copy for the documentation.
So far it was the only universe I have had problems with using this tool in SAP BO 4,2 SP2.
Hi, I’m getting a Saving to Excel error “The maximum length of cell contents (text) is 32,767 characters”. Using SP3 – SP5 version. I’m on 4.1 SP5 Patch 2.
Please advise.
Thanks
First of all, hats off to you for providing us this!!
Now, as mentioned by btate123 in the comment, even I am getting the Saving to Excel error “The maximum length of cell contents (text) is 32,767 characters”.
I am using BI 4.2 SP2 Patch 4.
PFB the log:
Export to excel
java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters
at org.apache.poi.xssf.streaming.SXSSFCell.setCellValue(SXSSFCell.java:278)
at com.biclever.gui.unxdoc.excel.SpreadsheetMaker.makeCell(SpreadsheetMaker.java:101)
at com.biclever.gui.unxdoc.excel.SpreadsheetMaker.makeRow(SpreadsheetMaker.java:53)
at com.biclever.gui.unxdoc.excel.UnxExcelWriter.exportTableList(UnxExcelWriter.java:103)
at com.biclever.gui.unxdoc.excel.UnxExcelWriter.export(UnxExcelWriter.java:39)
at com.biclever.gui.unxdoc.UnxTool.exportToExcel(UnxTool.java:73)
at com.biclever.gui.GuiProcess.saveResultToExcel(GuiProcess.java:208)
at com.biclever.gui.GuiProcess$ExportButtonActionListener.actionPerformed(GuiProcess.java:158)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Please let me know what needs to be done.
The universe import was successful.
Hi,
I am having the same issue as mentioned by kumar4838 on January 3, 2017.
com.sap.tools.commons.exception.NestedException: Interface requested not found : csLIB
Any help is appreciated.
Below is the log from debug:
“C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0”
java version “1.7.0_25”
Java(TM) SE Runtime Environment (build 1.7.0_25-b17)
Java HotSpot(TM) Client VM (build 23.25-b01, mixed mode)
SAP BusinessObjects BI platform 4.1 Client Tools SP7 Patch 1 update (14.1.7.1933)
SAP BusinessObjects BI platform 4.1 Client Tools SP7 (14.1.7.1853) – en
SAP Data Services 4.2 SP7 Patch 2 (14.2.5.800) – en
Biclever UnxDoc for SAP BO 4.1 SP6+, version 1.5, build 2017.02.02
Connecting… boservername
Connected
Importing [/Universes/Samples/eFashionUnx_KM.unx]
Error
com.sap.tools.commons.exception.NestedException: Interface requested not found : csLIB
at com.sap.tools.commons.exception.NestedException.create(Unknown Source)
at com.businessobjects.mds.services.parser.decoder.DataFoundationSQLDecoder.getPRM(DataFoundationSQLDecoder.java:82)
at com.businessobjects.mds.services.parser.decoder.DataFoundationSQLDecoder.(DataFoundationSQLDecoder.java:97)
at com.businessobjects.mds.services.parser.decoder.UniverseSQLDecoder.(UniverseSQLDecoder.java:40)
at com.businessobjects.mds.services.parser.EncodeDecodeHelper.decodeExpression(EncodeDecodeHelper.java:303)
at com.businessobjects.mds.services.helpers.BindingHelper.decodeExpression(BindingHelper.java:250)
at com.businessobjects.mds.services.helpers.BindingHelper.decodeResultExpression(BindingHelper.java:264)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.getResultExpression(MdsToSdkBusinessLayerConverter.java:380)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyBusinessItemProperties(MdsToSdkBusinessLayerConverter.java:326)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.createSdkItem(MdsToSdkBusinessLayerConverter.java:275)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyMdsToSdk(MdsToSdkBusinessLayerConverter.java:227)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyMdsToSdk(MdsToSdkBusinessLayerConverter.java:234)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.createSdkModel(MdsToSdkBusinessLayerConverter.java:153)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.BusinessLayerModelToModel.createSdkModel(BusinessLayerModelToModel.java:31)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.createSdkBusinessLayer(LocalResourceServiceImpl.java:191)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.loadInternal(LocalResourceServiceImpl.java:170)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.load(LocalResourceServiceImpl.java:131)
at com.biclever.gui.unxdoc.UnxMetadataExtractor.extract(UnxMetadataExtractor.java:47)
at com.biclever.gui.unxdoc.UnxTool.run(UnxTool.java:67)
at com.biclever.gui.GuiProcessProcessingTask.doInBackground(GuiProcessProcessingTask.java:61)
at com.biclever.gui.GuiProcessProcessingTask.doInBackground(GuiProcessProcessingTask.java:1)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.sap.connectivity.cs.core.CSError: Interface requested not found : csLIB
at com.sap.connectivity.cs.extended.ImplementationManager.getImplementation(ImplementationManager.java:151)
at com.sap.connectivity.cs.extended.ImplementationManager.getConfiguration(ImplementationManager.java:195)
at com.sap.connectivity.cs.extended.NLDBProvider.populateMap(NLDBProvider.java:49)
at com.sap.connectivity.cs.extended.NLDBProvider.getManager(NLDBProvider.java:159)
at com.sap.connectivity.cs.extended.Provider.getEnvironment(Provider.java:93)
at com.sap.connectivity.cs.extended.ConnectionServer.JobProfile(ConnectionServer.java:532)
at com.sap.connectivity.cs.api.trace.EnvironmentLogger.JobProfile(EnvironmentLogger.java:609)
at com.businessobjects.mds.services.relational.PrmProperties.getDbParameterSet(PrmProperties.java:1474)
at com.businessobjects.mds.services.relational.PrmProperties.loadFunctions(PrmProperties.java:1517)
at com.businessobjects.mds.services.relational.PrmProperties.loadParameters(PrmProperties.java:1491)
at com.businessobjects.mds.services.relational.PrmProperties.(PrmProperties.java:171)
at com.businessobjects.mds.services.relational.CsService.getPRMProperties(CsService.java:1388)
at com.businessobjects.mds.services.parser.decoder.DataFoundationSQLDecoder.getPRM(DataFoundationSQLDecoder.java:80)
… 26 more
Caused by: java.lang.UnsatisfiedLinkError: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\cs_jni.dll: The specified procedure could not be found
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary1(Unknown Source)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at com.sap.connectivity.cs.library.ConnectionServer.(ConnectionServer.java:330)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.businessobjects.connectionserver.ConnectionServer.getImplementation(ConnectionServer.java:461)
at com.businessobjects.connectionserver.ConnectionServer.getInstance(ConnectionServer.java:132)
at com.sap.connectivity.cs.extended.ImplementationManager.getImplementation(ImplementationManager.java:144)
… 38 more
com.sap.tools.commons.exception.NestedException: Interface requested not found : csLIB
Logoff
when I try to use the tool to extract unx , I met below issue , could you help me on that , thanks in advance!
Log:
“D:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0”
java version “1.8.0_45”
Java(TM) SE Runtime Environment (build 1.8.0_45-b14)
Java HotSpot(TM) Client VM (build 25.45-b02, mixed mode)
SAP BusinessObjects BI platform 4.2 Client Tools SP2 (14.2.2.1975) – en
Biclever UnxDoc for SAP BO 4.1 SP6+, version 1.5, build 2017.02.02
Connecting… Fr711ubi4009.zeu.alcatel-lucent.com
Could not reach CMS ‘Fr711ubi4009.zeu.alcatel-lucent.com’. Specify the correct host and port and check for network issues. (FWM 20030)
at com.crystaldecisions.sdk.occa.security.internal.LogonService.ensureServiceStub(LogonService.java:688)
at com.crystaldecisions.sdk.occa.security.internal.LogonService.doUserLogon(LogonService.java:828)
at com.crystaldecisions.sdk.occa.security.internal.LogonService.doUserLogon(LogonService.java:805)
at com.crystaldecisions.sdk.occa.security.internal.LogonService.userLogon(LogonService.java:210)
at com.crystaldecisions.sdk.occa.security.internal.SecurityMgr.userLogon(SecurityMgr.java:166)
at com.crystaldecisions.sdk.framework.internal.SessionMgr.logon_aroundBody0(SessionMgr.java:454)
at com.crystaldecisions.sdk.framework.internal.SessionMgr.logon_aroundBody1$advice(SessionMgr.java:512)
at com.crystaldecisions.sdk.framework.internal.SessionMgr.logon(SessionMgr.java:1)
at com.biclever.gui.unxdoc.UnxTool.login(UnxTool.java:31)
at com.biclever.gui.GuiLogin.loginAction(GuiLogin.java:153)
at com.biclever.gui.GuiLogin.access$1(GuiLogin.java:147)
at com.biclever.gui.GuiLogin$LoginButtonActionListener.actionPerformed(GuiLogin.java:139)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2346)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6525)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6290)
at java.awt.Container.processEvent(Container.java:2234)
at java.awt.Component.dispatchEventImpl(Component.java:4881)
at java.awt.Container.dispatchEventImpl(Container.java:2292)
at java.awt.Component.dispatchEvent(Component.java:4703)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4898)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4533)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4462)
at java.awt.Container.dispatchEventImpl(Container.java:2278)
at java.awt.Window.dispatchEventImpl(Window.java:2750)
at java.awt.Component.dispatchEvent(Component.java:4703)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: com.crystaldecisions.sdk.exception.SDKException$OCAFramework: Communication error occurred when trying to connect to server Fr711ubi4009.zeu.alcatel-lucent.com (FWM 01009)
cause:com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server Fr711ubi4009.zeu.alcatel-lucent.com (FWM 01009)
cause:com.crystaldecisions.thirdparty.org.omg.CORBA.NO_RESOURCES: Unable to create client minor code: 0x0 completed: No
detail:Communication error occurred when trying to connect to server Fr711ubi4009.zeu.alcatel-lucent.com (FWM 01009) Unable to create client
detail:Communication error occurred when trying to connect to server Fr711ubi4009.zeu.alcatel-lucent.com (FWM 01009) Unable to create client
at com.crystaldecisions.sdk.exception.SDKException.map(SDKException.java:145)
at com.crystaldecisions.sdk.occa.security.internal.LogonService.ensureServiceStub(LogonService.java:687)
… 47 more
Caused by: com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server Fr711ubi4009.zeu.alcatel-lucent.com (FWM 01009)
cause:com.crystaldecisions.thirdparty.org.omg.CORBA.NO_RESOURCES: Unable to create client minor code: 0x0 completed: No
detail:Communication error occurred when trying to connect to server Fr711ubi4009.zeu.alcatel-lucent.com (FWM 01009) Unable to create client
at com.crystaldecisions.enterprise.ocaframework.RawAPSDirectory.find(RawAPSDirectory.java:256)
at com.crystaldecisions.enterprise.ocaframework.APSServerHandler.buildAPSClusterInfo(APSServerHandler.java:583)
at com.crystaldecisions.enterprise.ocaframework.APSServerHandler.buildServerInfo(APSServerHandler.java:194)
at com.crystaldecisions.enterprise.ocaframework.ServerController.redirectServer(ServerController.java:534)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.redirectServer(ServiceMgr.java:978)
at com.crystaldecisions.enterprise.ocaframework.ManagedSessions.get(ManagedSessions.java:258)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService_aroundBody4(ServiceMgr.java:539)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService(ServiceMgr.java:1)
at com.crystaldecisions.sdk.occa.security.internal.LogonService.ensureServiceStub(LogonService.java:645)
… 47 more
Caused by: com.crystaldecisions.thirdparty.org.omg.CORBA.NO_RESOURCES: Unable to create client minor code: 0x0 completed: No
at com.crystaldecisions.thirdparty.com.ooc.OB.ClientManager.getClientProfilePairs(ClientManager.java:384)
at com.crystaldecisions.thirdparty.com.ooc.OB.DowncallStub.getClientProfilePair(DowncallStub.java:89)
at com.crystaldecisions.thirdparty.com.ooc.OB.DowncallStub.createDowncall(DowncallStub.java:202)
at com.crystaldecisions.thirdparty.com.ooc.OB.DowncallStub.setupRequest(DowncallStub.java:541)
at com.crystaldecisions.thirdparty.com.ooc.CORBA.Delegate.request(Delegate.java:556)
at com.crystaldecisions.thirdparty.com.ooc.CORBA.Delegate.is_a(Delegate.java:373)
at com.crystaldecisions.thirdparty.org.omg.CORBA.portable.ObjectImpl._is_a(ObjectImpl.java:88)
at com.crystaldecisions.enterprise.ocaframework.idl.ImplServ.OSCAFactoryExHelper.narrow(OSCAFactoryExHelper.java:100)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getOSCAFactory_aroundBody8(ServiceMgr.java:571)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getOSCAFactory(ServiceMgr.java:1)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getUnmanagedService_aroundBody16(ServiceMgr.java:673)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getUnmanagedService(ServiceMgr.java:1)
at com.crystaldecisions.enterprise.ocaframework.RawAPSDirectory.find(RawAPSDirectory.java:155)
… 55 more
Hi,
Seems that my old question is not answered yet. Some time ago I found the answer to this question in UNX documenter documentation.
The tool works fine with SP04. I have just tried with SAP BO 4.2 SP05 and can cofirm that the tool works fine as well.
I have unistalled all the old BO versions and made an initial install of SAP BO 4.2 SP05.
Then I have made a small modification to unxdoc.bat ( SET JAVA=%BO%\win32_x86\jre8 ) and the UNX Documenter Tool is working fine after setting the correct JRE path.
Hi Admin,
Thanks for excellent utilities shared on this portal, I have been using CMS Query builder and unv documenter. these utlities gives an great relief for admins. I have faced one issue while using unx documenter. can you please help me on this, here is the error message to deep dive into it.
Importing [/Universes/DDW-Dell Data Warehouse/CORP/Product/GLBL_OFFER_ID_Reporting.unx]
Error
com.sap.tools.commons.exception.NestedException: Specified RDBMS is invalid : Teradata V2 R6
Hi Santhosh, Thank you for the feedback!
Are you able to import this UNX universe using Information Design Tool?
I installed Client tool 4.2. I had to change Java path in this way: SET JAVA=%BO%\win32_x86\jre8.
The utility starts. I open the Universe from my repository but when I start the process it remains hanging in blue (no red and no green).
Is your utility compatible with client tool 4.2. Another point is I have win10 and in my control panel/app I did not find “Modify” but I have only “Remove”. I’m not able to check if I installed all the required modules. Any idea?
Thanks
Amerigo
Hi Ametor,
We have not tested the tool with BO 4.2. The file unxdoc-debug.bat generates a log file. You can adjust JAVA in this file, run it and check the error message in log.txt. If you can send us the log file, we will investigate.
Thanks!
Hi, Could you run the tool using unxdoc-debug.but, this will generate a log file. Please send it to use on support@biclever.com. We will investigate.
Error – Memory – select top 2500 SI_ID, SI_NAME, SI_USERGROUPS from ci_systemobjects where si_kind = ‘user’ and si_id not in (’11’,’12’) AND SI_USERGROUPS.SI_TOTAL >= 1
Exception in thread “AWT-EventQueue-0” java.lang.OutOfMemoryError: Java heap space
at org.apache.xmlbeans.impl.store.Saver$TextSaver.resize(Saver.java:1592)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.preEmit(Saver.java:1223)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.emit(Saver.java:1144)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.emitElement(Saver.java:926)
at org.apache.xmlbeans.impl.store.Saver.processElement(Saver.java:456)
at org.apache.xmlbeans.impl.store.Saver.process(Saver.java:307)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.saveToString(Saver.java:1727)
at org.apache.xmlbeans.impl.store.Cursor._xmlText(Cursor.java:546)
at org.apache.xmlbeans.impl.store.Cursor.xmlText(Cursor.java:2436)
at org.apache.xmlbeans.impl.values.XmlObjectBase.xmlText(XmlObjectBase.java:1455)
at org.apache.poi.xssf.model.SharedStringsTable.getKey(SharedStringsTable.java:130)
Hi,
Try increasing the maximum heap size with the option -Xmx1g after “%JAVA%\bin\java.exe” in the batch file.
Hi,
Increasing the maximum -Xmx2g
java version “1.7.0_25”
Java(TM) SE Runtime Environment (build 1.7.0_25-b17)
Java HotSpot(TM) Client VM (build 23.25-b01, mixed mode)
SAP BusinessObjects BI platform 4.1 SP6 Patch 1 update (14.1.6.1760)
SAP BusinessObjects BI platform 4.1 SP6 Patch 2 update (14.1.6.1785)
SAP BusinessObjects BI platform 4.1 SP6 Patch 3 update (14.1.6.1805)
SAP BusinessObjects BI platform 4.1 SP6 Patch 7 update (14.1.6.1979)
SAP BusinessObjects BI platform 4.1 SP6 Patch 9 update (14.1.6.2060)
SAP BusinessObjects BI platform 4.1 SP6 (14.1.6.2060) – en, it
Error occurred during initialization of VM
Could not reserve enough space for object heap
Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. Program will exit.
Hi,
We have released a new version of CMS Query Builder. It requires far less memory.
Hi, thanks for the superb tool!
We are using BO 4.2 SP2 and unx documenter works fine with most of the universes. However I am getting an error with a universe that has 287 Tables and 967 Joins.
The error: java.lang.NullPointerException
Debug:
Connected
Importing [/Universes A.unx]
Error
java.lang.NullPointerException
at com.businessobjects.mds.services.helpers.RelationalUniverseHelper.addTables(RelationalUniverseHelper.java:1616)
at com.businessobjects.mds.services.helpers.RelationalUniverseHelper.getTables(RelationalUniverseHelper.java:1599)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.setNewExtraTables(MdsToSdkBusinessLayerConverter.java:528)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyBusinessItemProperties(MdsToSdkBusinessLayerConverter.java:517)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.createSdkItem(MdsToSdkBusinessLayerConverter.java:306)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyMdsToSdk(MdsToSdkBusinessLayerConverter.java:258)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyMdsToSdk(MdsToSdkBusinessLayerConverter.java:265)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyMdsToSdk(MdsToSdkBusinessLayerConverter.java:265)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.createSdkModel(MdsToSdkBusinessLayerConverter.java:184)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.BusinessLayerModelToModel.createSdkModel(BusinessLayerModelToModel.java:31)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.createSdkBusinessLayer(LocalResourceServiceImpl.java:191)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.loadInternal(LocalResourceServiceImpl.java:170)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.load(LocalResourceServiceImpl.java:131)
at com.biclever.gui.unxdoc.UnxMetadataExtractor.extract(UnxMetadataExtractor.java:47)
at com.biclever.gui.unxdoc.UnxTool.run(UnxTool.java:67)
at com.biclever.gui.GuiProcessProcessingTask.doInBackground(GuiProcessProcessingTask.java:61)
at com.biclever.gui.GuiProcessProcessingTask.doInBackground(GuiProcessProcessingTask.java:1)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
Thank you very much in advance.
Br
Vytas
Hi Vytas, Thank you for your message!
The error occurs when the tool is importing universe inside of BO SDK. So it is not something we can fix in the tool. It is something SAP should fix in SDK or you in the universe.
I can see from the log that it failed when SDK was trying to add extra tables to some object in business layer when loading universe.
com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.setNewExtraTables(MdsToSdkBusinessLayerConverter.java:528)
If you can send us (support@biclever.com) the universe in LCMBIAR, we can try to investigate what specifically causes the issue. I understand that this might be not possible due to your company policies. In this case, we cannot help further but I will appreciate if you revert with any new information you will find about the issue for our future reference.
Thank you!
Regards, Dmytro
Hi Dmytro,
First of all, thanks for the quick answer. I appreciate you effort to help me.
It is a big universe, so it took a while to figure out what could possibly be wrong during the load.
I have identified the objects that are causing this error. The objects I’ve found are created from CALENDAR ALIAS tables. For e.g. CALENDAR_A.YEAR, CALENDAR_B.YEAR, CALENDAR_C.YEAR, etc. Note that in this universe there are other CALENDAR_D.YEAR, CALENDAR_E.YEAR that are not causing the error during the load.
I have been checking many different things with those objects (LoV, context, data type, etc.) and found that the problem in this case was related with “Display Formats”.
SOLUTION
I have managed to document the whole universe content by:
1. changing or deleting the display formats in problematic objects
2. deleting problematic objects
1. Solution
The display format is not documented using this documentation tool anyway. So in this context we can just delete the custom display formats to save some time (changing them takes more time). However, in this case you would need to create a copy of the universe for documentation. Steps:
• Open the universe
• Find the problematic objects
• Select the object
• Change the view to Advanced tab
• Edit or Delete Display Format
• Do the same for all the Claim Calendar Objects
In my case it was OK to do the change and fix the universe, since there were only 12 problematic objects. It was quite strange that all of them were YEAR from different CALENDAR Alias tables. The data type = Numeric. Selected display format Custom 0;;. I have no idea why there were ;; at the end. I expect it was a mistype and that was causing the problem during the load. Once I delete the Display Format or I change the Custom Display format from 0;; to 0 the documentation tool starts to work fine.
2. Solution
You can delete the problematic objects if you have a lot of them. But note that then you will lose some part of the documentation. In addition, you have to create a copy for the documentation.
So far it was the only universe I have had problems with using this tool in SAP BO 4,2 SP2.
Greetings,
Vytas
Hi Dmytro, I’m unable to access and download the Unx Documenter files. Any help?
Thanks
Oto
Hi, I’m getting a Saving to Excel error “The maximum length of cell contents (text) is 32,767 characters”. Using SP3 – SP5 version. I’m on 4.1 SP5 Patch 2.
Please advise.
Thanks
Hi Admin,
First of all, hats off to you for providing us this!!
Now, as mentioned by btate123 in the comment, even I am getting the Saving to Excel error “The maximum length of cell contents (text) is 32,767 characters”.
I am using BI 4.2 SP2 Patch 4.
PFB the log:
Export to excel
java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters
at org.apache.poi.xssf.streaming.SXSSFCell.setCellValue(SXSSFCell.java:278)
at com.biclever.gui.unxdoc.excel.SpreadsheetMaker.makeCell(SpreadsheetMaker.java:101)
at com.biclever.gui.unxdoc.excel.SpreadsheetMaker.makeRow(SpreadsheetMaker.java:53)
at com.biclever.gui.unxdoc.excel.UnxExcelWriter.exportTableList(UnxExcelWriter.java:103)
at com.biclever.gui.unxdoc.excel.UnxExcelWriter.export(UnxExcelWriter.java:39)
at com.biclever.gui.unxdoc.UnxTool.exportToExcel(UnxTool.java:73)
at com.biclever.gui.GuiProcess.saveResultToExcel(GuiProcess.java:208)
at com.biclever.gui.GuiProcess$ExportButtonActionListener.actionPerformed(GuiProcess.java:158)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Please let me know what needs to be done.
The universe import was successful.
Thanks in Advance.
Hi,
I am having the same issue as mentioned by kumar4838 on January 3, 2017.
com.sap.tools.commons.exception.NestedException: Interface requested not found : csLIB
Any help is appreciated.
Below is the log from debug:
“C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0”
java version “1.7.0_25”
Java(TM) SE Runtime Environment (build 1.7.0_25-b17)
Java HotSpot(TM) Client VM (build 23.25-b01, mixed mode)
SAP BusinessObjects BI platform 4.1 Client Tools SP7 Patch 1 update (14.1.7.1933)
SAP BusinessObjects BI platform 4.1 Client Tools SP7 (14.1.7.1853) – en
SAP Data Services 4.2 SP7 Patch 2 (14.2.5.800) – en
Biclever UnxDoc for SAP BO 4.1 SP6+, version 1.5, build 2017.02.02
Connecting… boservername
Connected
Importing [/Universes/Samples/eFashionUnx_KM.unx]
Error
com.sap.tools.commons.exception.NestedException: Interface requested not found : csLIB
at com.sap.tools.commons.exception.NestedException.create(Unknown Source)
at com.businessobjects.mds.services.parser.decoder.DataFoundationSQLDecoder.getPRM(DataFoundationSQLDecoder.java:82)
at com.businessobjects.mds.services.parser.decoder.DataFoundationSQLDecoder.(DataFoundationSQLDecoder.java:97)
at com.businessobjects.mds.services.parser.decoder.UniverseSQLDecoder.(UniverseSQLDecoder.java:40)
at com.businessobjects.mds.services.parser.EncodeDecodeHelper.decodeExpression(EncodeDecodeHelper.java:303)
at com.businessobjects.mds.services.helpers.BindingHelper.decodeExpression(BindingHelper.java:250)
at com.businessobjects.mds.services.helpers.BindingHelper.decodeResultExpression(BindingHelper.java:264)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.getResultExpression(MdsToSdkBusinessLayerConverter.java:380)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyBusinessItemProperties(MdsToSdkBusinessLayerConverter.java:326)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.createSdkItem(MdsToSdkBusinessLayerConverter.java:275)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyMdsToSdk(MdsToSdkBusinessLayerConverter.java:227)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyMdsToSdk(MdsToSdkBusinessLayerConverter.java:234)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.createSdkModel(MdsToSdkBusinessLayerConverter.java:153)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.BusinessLayerModelToModel.createSdkModel(BusinessLayerModelToModel.java:31)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.createSdkBusinessLayer(LocalResourceServiceImpl.java:191)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.loadInternal(LocalResourceServiceImpl.java:170)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.load(LocalResourceServiceImpl.java:131)
at com.biclever.gui.unxdoc.UnxMetadataExtractor.extract(UnxMetadataExtractor.java:47)
at com.biclever.gui.unxdoc.UnxTool.run(UnxTool.java:67)
at com.biclever.gui.GuiProcessProcessingTask.doInBackground(GuiProcessProcessingTask.java:61)
at com.biclever.gui.GuiProcessProcessingTask.doInBackground(GuiProcessProcessingTask.java:1)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.sap.connectivity.cs.core.CSError: Interface requested not found : csLIB
at com.sap.connectivity.cs.extended.ImplementationManager.getImplementation(ImplementationManager.java:151)
at com.sap.connectivity.cs.extended.ImplementationManager.getConfiguration(ImplementationManager.java:195)
at com.sap.connectivity.cs.extended.NLDBProvider.populateMap(NLDBProvider.java:49)
at com.sap.connectivity.cs.extended.NLDBProvider.getManager(NLDBProvider.java:159)
at com.sap.connectivity.cs.extended.Provider.getEnvironment(Provider.java:93)
at com.sap.connectivity.cs.extended.ConnectionServer.JobProfile(ConnectionServer.java:532)
at com.sap.connectivity.cs.api.trace.EnvironmentLogger.JobProfile(EnvironmentLogger.java:609)
at com.businessobjects.mds.services.relational.PrmProperties.getDbParameterSet(PrmProperties.java:1474)
at com.businessobjects.mds.services.relational.PrmProperties.loadFunctions(PrmProperties.java:1517)
at com.businessobjects.mds.services.relational.PrmProperties.loadParameters(PrmProperties.java:1491)
at com.businessobjects.mds.services.relational.PrmProperties.(PrmProperties.java:171)
at com.businessobjects.mds.services.relational.CsService.getPRMProperties(CsService.java:1388)
at com.businessobjects.mds.services.parser.decoder.DataFoundationSQLDecoder.getPRM(DataFoundationSQLDecoder.java:80)
… 26 more
Caused by: java.lang.UnsatisfiedLinkError: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\cs_jni.dll: The specified procedure could not be found
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary1(Unknown Source)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at com.sap.connectivity.cs.library.ConnectionServer.(ConnectionServer.java:330)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.businessobjects.connectionserver.ConnectionServer.getImplementation(ConnectionServer.java:461)
at com.businessobjects.connectionserver.ConnectionServer.getInstance(ConnectionServer.java:132)
at com.sap.connectivity.cs.extended.ImplementationManager.getImplementation(ImplementationManager.java:144)
… 38 more
com.sap.tools.commons.exception.NestedException: Interface requested not found : csLIB
Logoff
Hi everyone,
how did you manage even to download Unx Documenter. When I try I keep getting following error:
‘This site can’t be reached’
Any idea?
Thanks
Oto
Sorry guys, the problem we are having with downloads relates to our company’s block. We’ll see what we can do about it.
Hi,
is it possible to enhance the output of the unx objects with it’s technical Information (IDT field “Source Information”)?
regards
HI admin ,
when I try to use the tool to extract unx , I met below issue , could you help me on that , thanks in advance!
Log:
“D:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0”
java version “1.8.0_45”
Java(TM) SE Runtime Environment (build 1.8.0_45-b14)
Java HotSpot(TM) Client VM (build 25.45-b02, mixed mode)
SAP BusinessObjects BI platform 4.2 Client Tools SP2 (14.2.2.1975) – en
Biclever UnxDoc for SAP BO 4.1 SP6+, version 1.5, build 2017.02.02
Connecting… Fr711ubi4009.zeu.alcatel-lucent.com
Could not reach CMS ‘Fr711ubi4009.zeu.alcatel-lucent.com’. Specify the correct host and port and check for network issues. (FWM 20030)
at com.crystaldecisions.sdk.occa.security.internal.LogonService.ensureServiceStub(LogonService.java:688)
at com.crystaldecisions.sdk.occa.security.internal.LogonService.doUserLogon(LogonService.java:828)
at com.crystaldecisions.sdk.occa.security.internal.LogonService.doUserLogon(LogonService.java:805)
at com.crystaldecisions.sdk.occa.security.internal.LogonService.userLogon(LogonService.java:210)
at com.crystaldecisions.sdk.occa.security.internal.SecurityMgr.userLogon(SecurityMgr.java:166)
at com.crystaldecisions.sdk.framework.internal.SessionMgr.logon_aroundBody0(SessionMgr.java:454)
at com.crystaldecisions.sdk.framework.internal.SessionMgr.logon_aroundBody1$advice(SessionMgr.java:512)
at com.crystaldecisions.sdk.framework.internal.SessionMgr.logon(SessionMgr.java:1)
at com.biclever.gui.unxdoc.UnxTool.login(UnxTool.java:31)
at com.biclever.gui.GuiLogin.loginAction(GuiLogin.java:153)
at com.biclever.gui.GuiLogin.access$1(GuiLogin.java:147)
at com.biclever.gui.GuiLogin$LoginButtonActionListener.actionPerformed(GuiLogin.java:139)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2346)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6525)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6290)
at java.awt.Container.processEvent(Container.java:2234)
at java.awt.Component.dispatchEventImpl(Component.java:4881)
at java.awt.Container.dispatchEventImpl(Container.java:2292)
at java.awt.Component.dispatchEvent(Component.java:4703)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4898)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4533)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4462)
at java.awt.Container.dispatchEventImpl(Container.java:2278)
at java.awt.Window.dispatchEventImpl(Window.java:2750)
at java.awt.Component.dispatchEvent(Component.java:4703)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: com.crystaldecisions.sdk.exception.SDKException$OCAFramework: Communication error occurred when trying to connect to server Fr711ubi4009.zeu.alcatel-lucent.com (FWM 01009)
cause:com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server Fr711ubi4009.zeu.alcatel-lucent.com (FWM 01009)
cause:com.crystaldecisions.thirdparty.org.omg.CORBA.NO_RESOURCES: Unable to create client minor code: 0x0 completed: No
detail:Communication error occurred when trying to connect to server Fr711ubi4009.zeu.alcatel-lucent.com (FWM 01009) Unable to create client
detail:Communication error occurred when trying to connect to server Fr711ubi4009.zeu.alcatel-lucent.com (FWM 01009) Unable to create client
at com.crystaldecisions.sdk.exception.SDKException.map(SDKException.java:145)
at com.crystaldecisions.sdk.occa.security.internal.LogonService.ensureServiceStub(LogonService.java:687)
… 47 more
Caused by: com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server Fr711ubi4009.zeu.alcatel-lucent.com (FWM 01009)
cause:com.crystaldecisions.thirdparty.org.omg.CORBA.NO_RESOURCES: Unable to create client minor code: 0x0 completed: No
detail:Communication error occurred when trying to connect to server Fr711ubi4009.zeu.alcatel-lucent.com (FWM 01009) Unable to create client
at com.crystaldecisions.enterprise.ocaframework.RawAPSDirectory.find(RawAPSDirectory.java:256)
at com.crystaldecisions.enterprise.ocaframework.APSServerHandler.buildAPSClusterInfo(APSServerHandler.java:583)
at com.crystaldecisions.enterprise.ocaframework.APSServerHandler.buildServerInfo(APSServerHandler.java:194)
at com.crystaldecisions.enterprise.ocaframework.ServerController.redirectServer(ServerController.java:534)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.redirectServer(ServiceMgr.java:978)
at com.crystaldecisions.enterprise.ocaframework.ManagedSessions.get(ManagedSessions.java:258)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService_aroundBody4(ServiceMgr.java:539)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService(ServiceMgr.java:1)
at com.crystaldecisions.sdk.occa.security.internal.LogonService.ensureServiceStub(LogonService.java:645)
… 47 more
Caused by: com.crystaldecisions.thirdparty.org.omg.CORBA.NO_RESOURCES: Unable to create client minor code: 0x0 completed: No
at com.crystaldecisions.thirdparty.com.ooc.OB.ClientManager.getClientProfilePairs(ClientManager.java:384)
at com.crystaldecisions.thirdparty.com.ooc.OB.DowncallStub.getClientProfilePair(DowncallStub.java:89)
at com.crystaldecisions.thirdparty.com.ooc.OB.DowncallStub.createDowncall(DowncallStub.java:202)
at com.crystaldecisions.thirdparty.com.ooc.OB.DowncallStub.setupRequest(DowncallStub.java:541)
at com.crystaldecisions.thirdparty.com.ooc.CORBA.Delegate.request(Delegate.java:556)
at com.crystaldecisions.thirdparty.com.ooc.CORBA.Delegate.is_a(Delegate.java:373)
at com.crystaldecisions.thirdparty.org.omg.CORBA.portable.ObjectImpl._is_a(ObjectImpl.java:88)
at com.crystaldecisions.enterprise.ocaframework.idl.ImplServ.OSCAFactoryExHelper.narrow(OSCAFactoryExHelper.java:100)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getOSCAFactory_aroundBody8(ServiceMgr.java:571)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getOSCAFactory(ServiceMgr.java:1)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getUnmanagedService_aroundBody16(ServiceMgr.java:673)
at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getUnmanagedService(ServiceMgr.java:1)
at com.crystaldecisions.enterprise.ocaframework.RawAPSDirectory.find(RawAPSDirectory.java:155)
… 55 more
Hi,
I have troubles with UNX universe documenter using SAP BO 4.2 SP 04 Patch 01.
“C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0”
The system cannot find the path specified.
SAP BusinessObjects BI platform 4.2 Client Tools SP4 Patch 1 update (14.2.4.2464)
SAP BusinessObjects BI platform 4.2 Client Tools SP4 (14.2.4.2410) – en
SAP BusinessObjects BI platform .NET SDK Redistributable 64bit 4.2 SP4 (14.2.4.2410) – ar, cs, da, de, en, es, fi, fr, he, hu, it, ja, kk, ko, nb, nl, pl, pt, ro, ru, sk, sl, sv, th, tr, uk, zh_cn, zh_tw
SAP BusinessObjects Live Office 4.2 SP4 (14.2.4.2410) – en
The system cannot find the path specified.
Does it mean that the UNX unvierse documenter is not compatible with SP04?
Thanks,
Vytas
Hi,
Seems that my old question is not answered yet. Some time ago I found the answer to this question in UNX documenter documentation.
The tool works fine with SP04. I have just tried with SAP BO 4.2 SP05 and can cofirm that the tool works fine as well.
I have unistalled all the old BO versions and made an initial install of SAP BO 4.2 SP05.
Then I have made a small modification to unxdoc.bat ( SET JAVA=%BO%\win32_x86\jre8 ) and the UNX Documenter Tool is working fine after setting the correct JRE path.