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

Punam Maskara-52775

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.

Sherry George

Can you post the bursting definition?

Punam Maskara-52775

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

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

Punam Maskara-52775

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