My Oracle Support Banner

BI Publisher Throws "oracle.xdo.template.online.dms.common.XDODmsException: IO Exception" When URL Is Used on Null Column (Doc ID 2919651.1)

Last updated on JANUARY 16, 2023

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

BI Publisher throws IO Exception when URL is used on null column.

Steps:

   1. Go Catalog and create a new data model based on below sample SQL Query:

Select test test, some text ||chr(10)||with line brake text, 1 rn, sysdate mydate from dual
union all
Select test, some text ||chr(10)||with line brake text, 2 rn, null mydate from dual

   2. Add Parameter P_TEST.

   3. View; Save As Sample Data;Save; Create Report Wizard : Select Data : Next
Select Layout: Next.

   4. Create Table: Add all columns; Next.
Save Report: Finish.
Save as: RE_NULL_Record; OK.
Interactive View - Will Show two Records in Interactive View (Which is correct).
HTML view – Will show two records and also Line brake.
Edit Layout.

   5. Select Test Column data; Enter URL:

http://<HOST>:<PORT>/xmlpserver/SharedFolder/RE_NULL_Record.xdo?_xpt=0&_xdo=/SharedFolder/RE_NULL_Record.xdo&_xmode=2&P_TEST={/DATA_DS/G_1/TEST}&_xf=html

Done.

  6.1. Error : Interactive report shows only 1 row.

  6.2. Error : HTML view shows Error:

  6.3. PDF View shows the same error.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.