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 laterInformation 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:
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:
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 |