Posts By: dmytro

SAP BO SL SDK 4.1 Interface requested not found : csLIB

Posted by & filed under SDK.

I have struggled quite a lot with the error "Interface requested not found : csLIB" when trying to open a semantic layer using SAP BO SL SDK 4.1. It was quite a complex issue so I will summarize it here in case someone has a similar problem. Here I am using a local universe Test […]

Format date in Batch yyyyMMdd

Posted by & filed under Java, Kettle.

The usual approach to build a timestamp for a log files in a batch is to use standard Windows utilities date and time. However the format of the output depends on locale and it is almost not possible to make the script which runs on any machine. A solution might be to create a small java […]

Find MenuID and RoleID corresponding to ComponentID in Maconomy Portal

Posted by & filed under Maconomy.

Component/Role/Menu SELECT COMPONENTID , ROLEID , MENUID FROM MENUITEM WHERE COMPONENTID LIKE '%::BPM::%' DFME: SELECT DISTINCT COMPONENT.COMPONENTID , COMPONENT.LABEL COMPONENT_LABEL , MENU.NAME MENU_NAME , USERROLE.NAME USERROLE_NAME , FIELDATTRIBUTE.ATTRIBUTEVALUE FROM MENUITEM INNER JOIN COMPONENT ON MENUITEM.COMPONENTID = COMPONENT.COMPONENTID INNER JOIN MENU ON MENUITEM.MENUID = MENU.MENUID INNER JOIN USERROLE ON USERROLE.ROLEID = MENUITEM.ROLEID LEFT JOIN FIELDATTRIBUTE ON […]

Archiving Pentaho log table in SQL Server

Posted by & filed under Kettle, Maconomy.

Pentaho Data Integration displays only the last 50 log entries but anytime you open a transformation it has to read the whole log table. When the log table gets large, opening a transformation may take long time and PDI freezes for this time. A solution is to archive old entries from the log table. Create […]

How to find running SQL queries – Oracle

Posted by & filed under Uncategorized.

Running queries with performance metrics SELECT S.SQL_ID, S.MODULE, S.SQL_TEXT, U.USERNAME, ROUND((S.DISK_READS/DECODE(S.EXECUTIONS,0,1, S.EXECUTIONS)),2) DISK_READS_PER_EXEC, S.DISK_READS, S.BUFFER_GETS, S.PARSE_CALLS, S.SORTS, S.EXECUTIONS, S.ROWS_PROCESSED, 100 – ROUND(100 * S.DISK_READS/GREATEST(S.BUFFER_GETS,1),2) HIT_RATIO, S.FIRST_LOAD_TIME, S.SHARABLE_MEM, S.PERSISTENT_MEM, S.RUNTIME_MEM, S.CPU_TIME, S.ELAPSED_TIME FROM SYS.V_$SQL S, SYS.ALL_USERS U WHERE S.PARSING_USER_ID=U.USER_ID AND UPPER(U.USERNAME) NOT IN ('SYS','SYSTEM') ORDER BY 5 DESC SQL query in pieces SELECT * FROM SYS.V_$SQLTEXT […]

Couldn't find entry 'BusinessObjects.xml'

Posted by & filed under Uncategorized.

Failed to open the BIAR file. Reason: com.businessobjects.sdk.biar.om.internal.iw.ObjectManagerIWException:Input/Output exception occurred: 'Couldn't find entry 'BusinessObjects.xml'. Import Wizard could not handle files larger than 500Mb. Use multiple BIARs.

Merging and filters in BO XI 3.1 SP6

Posted by & filed under Uncategorized.

Let's define two similar queries for 2004 and 2005. The query for 2004 looks like: The queries are merged by Service: Now we want to filter table based on a measure from one of the queries. Let's define variable v_Filter as =Abs([2004].[Revenue])<100000 With the following report filter, the table will show 3 rows and it is expected. […]

Solution: Cannot launch Java Report Panel, please make sure you have installed a Java virtual machine

Posted by & filed under Uncategorized.

Start cmd.exe as Administrator Execute the following command which turns off blocking of outdated ActiveX controls for Internet Explorer reg add "HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\Ext" /v VersionCheckEnabled /t REG_DWORD /d 0 /f Restart IE PS. To enable blocking again, use command reg add "HKCU\Software\Microsoft\Windows\CurrentVersion\Policies\Ext" /v VersionCheckEnabled /t REG_DWORD /d 1 /f

XI 3.1 Issue with Excel Data Provider

Posted by & filed under Administration.

Problem A Webi document has a query based on Excel (Excel data source). The document can be refreshed in Web Intelligence Rich Client, but it fails in Infoview with WIS 30270 error. The following errors appear in the log: ExtensionFactoryImpl.cpp:201:void __thiscall WICDZExt::ExtensionFactoryImpl::createRemoteExtension(const class WICDZExt::ExtensionDescriptor &,struct WICDZExt::IExtension **): TraceLog message 24650 2014/10/17 09:02:31.474|>>|E| |13916|15036| |||||||||||||||ExtensionFactoryImpl::createRemoteExtension has […]