Created
October 26, 2012 12:09
-
-
Save Dnefedkin/3958436 to your computer and use it in GitHub Desktop.
Runs BI Publisher Catalog Utility on Windows OS
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
@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 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
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