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

Last updated on MARCH 02, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms