Missing or bad option "-outputFile". while running runcat.cmd from command line

SekharGudapati

I am trying to get a listing of all catalog folders in classic analytics and what groups/roles/users have access and what those permissions are. As per documentation, I am running (example) below with correct values related to my environment. The script terminates giving the error Missing or bad option "-outputFile"

runcat.cmd -cmd report -online "https://OACinstance.ocp.oraclecloud.com/analytics-ws/saw.dll" -credentials "C:\aaa\tmp\runcat_OAC.txt" -outputFile "C:\aaa\tmp\Object.xls"  -excelFormat -folder "/shared" -type "All"  -fields "Path:Name:Signature:Content State:Owner:Creator:Created:ACL"

https://blogs.oracle.com/analytics/post/oracle-analytics-best-practices-reporting-on-catalog-acls

SekharGudapati

@Sumanth V -Oracle and @RajeshPolavarapu-Oracle Thank you both.

The issue is resolved. I have to log out of Zscaler to get the correct certificate. After importing that into cacerts, I was able to run the runcat.cmd with out errors and able to see the file generated.

Sumanth V -Oracle

@SekharGudapati - The syntax provided above seems to be from the documentation or a blog and is correct. Please share the actual command you are running when you see the error. Please check 'f'in outputFile parameter it should be 'F'. In case it's incorrectly used we see that error.

SekharGudapati

Hi Sumanth,

Thankyou. Here is the command I am using.

runcat.cmd -cmd report -online https://xxxx.analytics.ocp.oraclecloud.com/analytics-ws" -credentials "C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\credentials.txt" -outputFile "C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\OracleCatalogManagerReport.xls" -excelFormat -folder "/shared" -type "All" -fields "Path:Name:Signature:Content State:Owner:Creator:Created:ACL"

Sumanth V -Oracle

@SekharGudapati - I used the below command and it runs successfully.
Command: runcat.cmd -cmd report -online https://XXXXXXX.analytics.ocp.oraclecloud.com/analytics-ws/saw.dll -credentials "C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\credentials.txt" -outputFile "C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\OracleCatalogManagerReport.xls" -excelFormat -folder "/shared" -type "All" -fields "Path:Name:Signature:Content State:Owner:Creator:Created:ACL"

Output:
C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin>call C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\....\bifoundation\web\catalogmanager\runcatinternal.cmd -cmd report -online https://XXXXXXX.analytics.ocp.oraclecloud.com/analytics-ws/saw.dll -credentials C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\credentials.txt -outputFile C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\OracleCatalogManagerReport.xls -excelFormat -folder /shared -type All -fields "Path:Name:Signature:Content State:Owner:Creator:Created:ACL"
Instance Name is missing. Using default Instance Name: obips1
BI PRODUCT HOME is missing. Using default BI PRODUCT HOME: C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\web\catalogmanager......
"Temporary Worskspace : C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\......\domains\bi\servers\obips1\tmp\catalogmanager\30277"
env:
"PATH: C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\server\bin;C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\web\bin;C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\odbc\lib;C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\lib;C:\Oracle\Middleware\Oracle_Home\bi\lib;C:\Oracle\Middleware\Oracle_Home\bi..\lib;C:\Oracle\Middleware\Oracle_Home\bi..\bin;C:\Oracle\Middleware\Oracle_Home\bi\instantclient_12_2;C:\Users\sumvarad\DOCUME~1\MOBAXT~1\slash\bin;C:\Users\sumvarad\DOCUME~1\MobaXterm\slash\bin;C:\WINDOWS;C:\WINDOWS\system32;\bin"
"INSTANCE_NAME: obips1"
"BI_PRODUCT_HOME: C:\Oracle\Middleware\Oracle_Home\bi"
"DOMAIN_HOME: C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\......\domains\bi"
"ORACLE_BIPS_INSTANCE_CONFIGDIR: C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\......\domains\bi\config\fmwconfig\biconfig\OBIPS"
"ORACLE_BIPS_INSTANCE_DIAGNOSTICSDIR: C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\......\domains\bi\servers\obips1"
"ORACLE_BIPS_INSTANCE_TEMPDIR: C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\......\domains\bi\servers\obips1\tmp"
"JAVA_HOME: C:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\jre"
"Executing : "C:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\jre\bin\java" -Djava.net.useSystemProxies=true -jar C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\web\catalogmanager\startup.jar -clean -configuration "C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\......\domains\bi\servers\obips1\tmp\catalogmanager\30277" -data "C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\......\domains\bi\servers\obips1\tmp\catalogmanager\30277\workspace" -cmd report -online https://XXXXXXX.analytics.ocp.oraclecloud.com/analytics-ws/saw.dll -credentials C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\credentials.txt -outputFile C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\OracleCatalogManagerReport.xls -excelFormat -folder /shared -type All -fields "Path:Name:Signature:Content State:Owner:Creator:Created:ACL""
BIFNDN_LABEL =BIFNDN_20.5.0_LINUX.X64_210901.1058

Command : -cmd report -online https://XXXXXXX.analytics.ocp.oraclecloud.com/analytics-ws/saw.dll -credentials C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\credentials.txt -outputFile C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\OracleCatalogManagerReport.xls -excelFormat -folder /shared -type All -fields Path:Name:Signature:Content State:Owner:Creator:Created:ACL

Making SOAP connection to : https://XXXXXXX.analytics.ocp.oraclecloud.com/analytics-ws/saw.dll

Running Report..10..9..8..7..6..5..4..3..2..1..0..Done!

"Return status from Catalogmanager command : 0"

SekharGudapati

Hi Sumanth,

Thank you for your response. Tried with various outputFile options. All giving the same error.

Trail-1 (per documentation)

runcat.cmd -cmd report -online https://xxxxx.ocp.oraclecloud.com/analytics-ws/saw.dll" -credentials "C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\credentials.txt" -outputFile "C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\OracleCatalogManagerReport.xls" -excelFormat -folder "/shared" -type "All" -fields "Path:Name:Signature:Content State:Owner:Creator:Created:ACL"

Trail-3 (per documentation)

runcat.cmd -cmd report -online https://xxxxx.ocp.oraclecloud.com/analytics-ws/saw.dll" -credentials "C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\credentials.txt" -forceoutputFile "C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\OracleCatalogManagerReport.xls" -excelFormat -folder "/shared" -type "All" -fields "Path:Name:Signature:Content State:Owner:Creator:Created:ACL"

Trail-3

runcat.cmd -cmd report -online https://xxxxx.ocp.oraclecloud.com/analytics-ws/saw.dll" -credentials "C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\credentials.txt" -ForceoutputFile "C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\OracleCatalogManagerReport.xls" -excelFormat -folder "/shared" -type "All" -fields "Path:Name:Signature:Content State:Owner:Creator:Created:ACL"

RajeshPolavarapu-Oracle

Hi @SekharGudapati

For filePatchSeparator can you give forward slash / instead of backward slack \

runcat.cmd -cmd report -online
https://xxxxx.ocp.oraclecloud.com/analytics-ws/saw.dll -credentials
C:/Oracle/Middleware/Oracle_Home/bi/bitools/bin/credentials.txt
-outputFile
C:/Oracle/Middleware/Oracle_Home/bi/bitools/bin/OracleCatalogManagerReport.xls
-excelFormat -folder "/shared" -type "All" -fields
"Path:Name:Signature:Content State:Owner:Creator:Created:ACL"

Sumanth V -Oracle

@SekharGudapati - Please loose the " quotes after the URL in command and try once.

Use below:

https://xxxxx.ocp.oraclecloud.com/analytics-ws/saw.dll-credentials

Instead of:

https://xxxxx.ocp.oraclecloud.com/analytics-ws/saw.dll"

SekharGudapati

@Sumanth V -Oracle

I noticed that and ran the command after removing the quotes. Now I am getting certificate error :)

HTTP transport error: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
#Exception: HTTP transport error: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
com.sun.xml.internal.ws.transport.http.client.HttpClientTransport.getOutput(HttpClientTransport.java:117)
com.sun.xml.internal.ws.transport.http.client.HttpTransportPipe.process(HttpTransportPipe.java:208)

RajeshPolavarapu-Oracle

Hi @SekharGudapati

To fix this issue you have to import the root and intermediate certificate(s) [if exists] which you used for this website - https://xxxxx.ocp.oraclecloud.com/analytics

into $MW_HOME/oracle_common/jdk/jre/lib/security/cacerts file .

For more details on how to achieve this you can refer this document -
While
Opening OAC RPD In The Cloud Using Vanity URL Hostname The Model
Administration Tool Errors With - "javax.net.ssl.SSLHandshakeException"
[Video Content] (Doc ID 2937971.1)

SekharGudapati

@RajeshPolavarapu-Oracle Thank you. I will checking with our infra team.