Oracle Business Intelligence

Products Banner

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

Accepted answer
100
Views
10
Comments

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

Best Answer

Answers

  • Sumanth V -Oracle
    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.

  • 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
    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"

  • 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
    edited May 14

    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
    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"

  • @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)

  • 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)

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