Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Runs BI Publisher Catalog Utility on Windows OS
@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
)
@Jitendra8254

This comment has been minimized.

Copy link

commented Feb 27, 2013

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

@hmewara

This comment has been minimized.

Copy link

commented Mar 21, 2013

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>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.