My Oracle Support Banner

Schedule Reports Fails With Special Character '&' in Search Argument in BIP11g (Doc ID 2026606.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Siebel CRM - Version 8.1.1.11.9 [IP2013] and later
Information in this document applies to any platform.

Symptoms

When attempting to schedule BIP reports from Siebel and query argument has special character '&', the following error occurs.

ERROR
-----------------------
Job processor caused exception
[INSTANCE_ID=SL4170CEL06A.1409144272578] [INSTANCE_JOB_ID=1030]::::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=SL4170CEL06A.1409144272578] IOException:[INSTANCE_JOB_ID=1030] oracle.xdo.XDOException: oracle.xdo.dataengine.datasource.plugin.DataAccessException: oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.lang.NullPointerException
oracle.xdo.XDOException: oracle.xdo.XDOException: oracle.xdo.dataengine.datasource.plugin.DataAccessException: oracle.xdo.da

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Able to run report immediately

2) Able to schedule when do not filter by any record

3) Query for: 'A & B & C*' in Siebel UI before submitting the report and it fails:

Report Parameters:
Locale ENU
OutputIntObjectName 36*BIP Opportunity List - Current Query
Language ENU
NamedSearchSpec 0*
LoginID 0-1
TimeZone (GMT-08:00) Pacific Time (US & Canada)
CurrencyCode USD
SearchSpec 146*'Opportunity'.Search = "([Name] LIKE ""A & B & C*"" AND [Hospitality Template Flag] = ""N"")" 'Opportunity'.FixedSort = " Close Date (DESCENDING)"
PositionId 0-5220
ViewMode 9*Sales Rep

Execution error:
Job processor caused exception
[INSTANCE_ID=SL4170CEL06A.1409144272578] [INSTANCE_JOB_ID=1030]::::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=SL4170CEL06A.1409144272578] IOException:[INSTANCE_JOB_ID=1030] oracle.xdo.XDOException: oracle.xdo.dataengine.datasource.plugin.DataAccessException: oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.lang.NullPointerException
oracle.xdo.XDOException: oracle.xdo.XDOException: oracle.xdo.dataengine.datasource.plugin.DataAccessException: oracle.xdo.da

Due to this issue, users cannot schedule reports if they perform a query in UI including special characters.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.