public
Last active

Runs BI Publisher Catalog Utility on Windows OS

  • Download Gist
BIPCatalogUtil.cmd
Batchfile
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
@ECHO OFF
setLocal EnableDelayedExpansion
@REM *************************************************************************
@REM Purpose: Runs BI Publisher Catalog Utility on Windows OS
@REM Author: Dmitry Nefedkin (Dmitry.Nefedkin@oracle.com)
@REM Description: script is based on BIPCatalogUtil.sh
@REM found in $MW_HOME\Oracle_BI1\clients\bipublisher\ of Oracle BI EE 11.1.1.6 installation
@REM Last changed: Oct, 25, 2012 18:00
@REM Version: 0.1
@REM *************************************************************************
GOTO :ENDFUNCTIONS
 
:usage
echo(
echo Usage:
echo(
echo Unzip BIP binary object:
echo "BIPCatalogUtil.cmd -unzipObject source={source_xdoz/xdmz_path} target={target_directory_path} catalogPath={catalog_path} [overwrite={true|false}] [mode=fusionapps]"
echo(
echo Zip BIP object files:
echo "BIPCatalogUtil.cmd -zipObject source={source_directory_path} target={target_xdoz/xdmz_path} [mode=fusionapps]"
echo(
echo Export BIP object from BIP Server:
echo "BIPCatalogUtil.cmd -export [bipurl={http://hostname:port/xmlpserver} username={username} password={password}] catalogPath={catalog_path_to_object} target={target_filename_or_directory_path} [baseDir={base_output_directory_path}] extract={true|false} [overwrite={true|false}] [mode=fusionapps]"
echo(
echo Export catalog folder contents:
echo "BIPCatalogUtil.cmd -exportFolder [bipurl={http://hostname:port/xmlpserver} username={username} password={password}] catalogPath={catalog_path_to_folder} baseDir={base_output_directory_path} subFolders={true|false} extract={true|false} [overwrite={true|false}] [mode=fusionapps]"
echo(
echo List catalog folder contents:
echo "BIPCatalogUtil.cmd -listFolder [bipurl={http://hostname:port/xmlpserver} username={username} password={password}] catalogPath={catalog_path_to_folder} subFolders={true|false}"
echo(
echo Import BIP object to BIP Server:
echo "BIPCatalogUtil.cmd -import [bipurl={http://hostname:port/xmlpserver} username={username} password={password}] baseDir={base_directory_path} [overwrite=true|false] [mode=fusionapps]"
echo(
echo Import all BIP objects from a local folder
echo "BIPCatalogUtil.cmd -import [bipurl={http://hostname:port/xmlpserver} username={username} password={password}] source={source_xdoz/xdmz_path or directory_path_of_object_files} [catalogPath={catalog_path}] [overwrite=true|false] [mode=fusionapps]"
echo(
echo Generate XLIFF from BIP file:
echo "BIPCatalogUtil.cmd -xliff source={source_file_path} [target={target_directory_path}] [baseDir={base_output_directory_path}] [overwrite={true|false}]"
echo(
echo Check translatability of XLIFF:
echo "BIPCatalogUtil.cmd -checkXliff source={xliff_file_path or foler_path} [level=ERROR|WARNING] [mode=fusionapps]"
echo(
echo Check accessibility of Template:
echo "BIPCatalogUtil.cmd -checkAccessibility source={template_file_path or foler_path} [mode=fusionapps]"
echo(
echo Execute Job file:
echo "BIPCatalogUtil.cmd {job_file}.xml [tasks={task_name1},{task_name2},...,[task_nameX}]"
echo(
echo Execute TestSuite file:
echo "BIPCatalogUtil.cmd {TestSuite_file}.xml [tests={testcase_name1},{testcase_name2},...,[testcase_nameX}]"
echo(
echo Required Environment Variables: ORACLE_HOME, JAVA_HOME, BIP_LIB_DIR, (Optional) BIP_CLIENT_CONFIG
echo(
GOTO :EOF
 
:ENDFUNCTIONS
if "%1"=="" (
CALL :usage %0
GOTO :EOF
)
 
SET BIP_CLIENT_DIR=%~dp0\..
 
if "%ORACLE_HOME%"=="" (
REM guess that BIPCatalogUtil.zip has been unpacked to the current directory
REM If it is not so, ORACLE_HOME environment variable must be set explicitly
SET ORACLE_HOME=%BIP_CLIENT_DIR%\..\..
)
REM echo ORACLE_HOME=%ORACLE_HOME%
 
if EXIST %ORACLE_HOME%\..\registry.xml (
SET BIP_CLASSPATH=%ORACLE_HOME%\modules\oracle.bithirdparty_11.1.1\javax\jaxrpc\jaxrpc.jar;%ORACLE_HOME%\..\oracle_common\modules\oracle.webservices_11.1.1\orawsdl.jar;%ORACLE_HOME%\modules\oracle.bithirdparty_11.1.1\javax\jaxws\activation.jar;%ORACLE_HOME%\modules\oracle.bithirdparty_11.1.1\javax\mail.jar;%ORACLE_HOME%\modules\oracle.bithirdparty_11.1.1\apache\axis.jar;%ORACLE_HOME%\modules\oracle.bithirdparty_11.1.1\apache\commons\commons-logging.jar;%ORACLE_HOME%\modules\oracle.bithirdparty_11.1.1\apache\commons\commons-discovery.jar;%ORACLE_HOME%\lib\xmlparserv2.jar;%ORACLE_HOME%\common\JDBC\Oracle\11.1.2.0\lib\ojdbc6.jar;%ORACLE_HOME%\jlib\orai18n-collation.jar;%ORACLE_HOME%\jlib\orai18n-mapping.jar
) ELSE (
echo Incorrect ORACLE_HOME, please set ORACLE_HOME to directory where Oracle BI binaries have been installed, e.g.
echo "c:\Oracle\Middleware\Oracle_BI1"
GOTO :EOF
)
 
 
REM For sake of simplicity assume that libraries are located at %BIP_CLIENT_DIR%\..\lib
REM If you want to implement more sophisticated logic - you're welcome
SET BIP_LIB_DIR=%BIP_CLIENT_DIR%\lib
 
REM Add all libs from BIP_LIB_DIR to classpath
for /R %BIP_LIB_DIR% %%a in (*.jar) do (
set BIP_CLASSPATH=!BIP_CLASSPATH!;%%a
)
set BIP_CLASSPATH=!BIP_CLASSPATH!
REM echo BIP_CLASSPATH: %BIP_CLASSPATH%
 
set CLASSPATH=%BIP_CLASSPATH%;%CLASSPATH%
 
if "%BIP_CLIENT_CONFIG%"=="" (
SET BIP_CLIENT_CONFIG=%BIP_CLIENT_DIR%\config
)
 
SET JVMOPTIONS=%JVMOPTIONS% -Dbip.client.config.dir=%BIP_CLIENT_CONFIG%
REM echo %JVMOPTIONS%
 
REM echo JAVA_HOME=%JAVA_HOME%
if "%JAVA_HOME%"=="" (
echo Please set JAVA_HOME to the directory where JDK or JRE has been installed
GOTO :EOF
)
if EXIST %JAVA_HOME% (
%JAVA_HOME%\bin\java %JVMOPTIONS% oracle.xdo.tools.catalog.command.CommandRunner %*
) ELSE (
echo Incorrect JAVA_HOME, please set JAVA_HOME to the directory where JDK or JRE has been installed
GOTO :EOF
)

Hi Dmitry,

Thank you for the Windows version of "BIPCatalogUtil". Am getting error while exporting the file.

Is there anything that I might have missed out?

BIPublisher error:

[export] Connect to http://ServerName:9704/xmlpserver/ using weblogic
[export] Export E:\OBIEE11g_Middleware_Home\instances\instance1\bifoundationOracleBIPresentationServicesComponent\coreapplication_obips1\catalog\Oneview-R to E:\OBIEE11g_Middleware_Home\Oracle_BI1\clients\bipublisher\BIPCatalogUtil\bin\Oneview-Rz

Command Error: export->exportObject
oracle.xdo.webservice.exception.OperationFailedException: PublicReportService
::executeDownloadReport Failure: Unable to download Report for [E:\OBIEE11g_Midd
leware_Home\instances\instance1\bifoundationOracleBIPresentationServicesComponen
t\coreapplication_obips1\catalog\Oneview-R] Due to unable to find ReportObject
Done.
The system cannot find the path specified.

-Jitendra

Hi Dmitry,

Thank you for the Windows version of "BIPCatalogUtil". Am getting same error.

G:\OBIEE11G\Oracle_BI1\clients\bipublisher\BIPCatalogUtil\bin>BIPCatalogUtil -ex
port catalogpath=\shared\mmi-documents\schedules\p10mmisch100%2exdo target=E:\te
st extract=false
[export] Connect to http://bi_server_name:9704/xmlpserver/ using Admin
[export] Export \shared\mmi-documents\schedules\p10mmisch100.xdo to E:\test.xdoz

Command Error: export->exportObject
oracle.xdo.webservice.exception.OperationFailedException: PublicReportService
::executeDownloadReport Failure: Unable to download Report for [\shared\mmi-docu
ments\schedules\p10mmisch100.xdo] Due to unable to find ReportObject
Done.
G:\OBIEE11G\Oracle_BI1\clients\bipublisher\BIPCatalogUtil\bin>

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.