Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Fusion Application: While Bursting getting error java.sql.SQLRecoverableException: IO Error: Invalid

Received Response
25
Views
4
Comments
Punam Maskara-52775
Punam Maskara-52775 Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Summary

Fusion Application: While Bursting getting error java.sql.SQLRecoverableException: IO Error: Invalid number format for port number : INSTANCE_JOB_ID=[2040] IO Error: Invalid number format for port n

Content

Requirement is to mail BI report output using Bursting feature

Standalone report works.

Getting Error Message:

------------

View History : https://eebv-test.bi.us2.oraclecloud.com:443/analytics/saw.dll?bipublisherEntry&Action=historyDetails&itemType=.xdo&bipParams=%7B%22jobid%22%3A%222040%22%7D

Detail Message:

::JOB_PROCESSOR_EXCEPTION::[INSTANCE_ID=cffar64120v04.usdc2.oraclecloud.com.1494070352337] [INSTANCE_JOB_ID=2040]::oracle.xdo.servlet.scheduler.ProcessingException: ::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=cffar64120v04.usdc2.oraclecloud.com.1494070352337]  INSTANCE_JOB_ID=[2040] IO Error: Invalid number format for port number

  1. java.sql.SQLRecoverableException: IO Error: Invalid number format for port number

                at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)

                at oracle.jdbc.driv

Verified DB connection for Bursting Query - For Example - ApplicationDB_FSCM

Using proper DB connection for Bursting SQL.

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics & AI Coach

    Can you post the bursting definition?

  • Punam Maskara-52775
    Punam Maskara-52775 Rank 3 - Community Apprentice

    Hi Sherry,

    It is a valid connection ApplicationDB_FSCM

    And even the bursting query is fetching correct output seperately.

    Only when used in report it throws the mentioned error.

    Without bursting the report runs absolutely fine.

    Thanks,

    Punam

  • Sherry George
    Sherry George Rank 7 - Analytics & AI Coach

    Confirm your data source is a valid connection under bursting definition.

  • Punam Maskara-52775
    Punam Maskara-52775 Rank 3 - Community Apprentice

    SELECT pozs.vendor_id "KEY"

    ,'Layout4' "TEMPLATE"

    ,'en-US' "LOCALE"

    ,'PDF' "OUTPUT_FORMAT"

    ,'EMAIL' "DEL_CHANNEL"

    ,'true' "SAVE_OUTPUT"

    ,'Invoice_Supplier' "OUTPUT_NAME"

    ,'punam.mkar@abc.com' "PARAMETER1"

    ,'apeksha.patil@abc.com' "PARAMETER2"

    ,'punam.makr@abc.com' "PARAMETER3"

    ,'You Have got a Mail' "PARAMETER4"

    ,'Hey!! Bursting Successfull!!' "PARAMETER5"

    ,'true' "PARAMETER6"

    ,'apeksha.patil@abc.com' "PARAMETER7"

    ,NULL "PARAMETER8"

    FROM fusion.poz_suppliers pozs