My Oracle Support Banner

E1: XMLP: Known SQL Query issues using Data Access Server(DAD) and/or Data Access Server(DAS) (Doc ID 1157853.1)

Last updated on MARCH 16, 2018

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Purpose

Data Access Sever (DAS) and Data Access Driver (DAD) are the read-only JDBC drivers used to connect BI Publisher Enterprise to EnterpriseOne database data-sources and tables.

This document describes common issues handling SQL queries through these drivers.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Issue 1: When using DAS JDBC driver BIP Enterprise is unable to bring up the schema.
 Issue 2: When using DAD JDBC driver the message "Schema is too large" shows, however if you type in the first three characters of the table a list of matching results will appear.
 Issue 3: SQL queries with sub query in WHERE clause are not working as expected.
 Issue 4: SQL query with BETWEEN condition in WHERE clause throws "Unable to parse operation" error while saving the query.
 Issue 5: Left Outer Join used in SQL query working as simple join.
 Issue 7: Left Outer Join includes the NULL in the WHERE clause for columns that are used to define the join
 Issue 8: SUM() function in SQL query not working properly with DAD
 Issue 9: Data model with linked data sets not producing the XML data properly.
 Issue 10: Queries with where clause condition with parameters not parsing in BIP 11g while using DAD.
 Issue 11: Issue with Self Join or joining the same table twice (or multiple times, multiple instances) in a SELECT query.
 Issue 12: Large Queries are not built correctly when using the Query Builder tool provided with BI Publisher Enterprise
 Issue 13: BI Publisher returns Parse Errors when trying to save query using Data Dictionary Items with alias which match reserved SQL keywords such as DESC or UNION
 Issue 14: BI Publisher returns Parse Errors when trying to save query using Data Dictionary items with alias ZON and PZON
 Issue 15: BI Publisher returns "[QUERY_TIMED_OUT] Query timed out. Operation is cancelled." Error when using Outer Join Queries on more than two pairs of Tables
 Issue 16: Data Access Driver returns error " [ TABLE_NOT_SPECIFIED_IN_JDBFIELD ] Table Name not specified in JDBField SDDCTO  within a multiple table request" when using Aliases in  Multiple Join Clause
 Issue 17: Data Access Driver returns error " JDBC error code = PARSE_ERROR. com.jdedwards.jdbc.base.JDBCException: Unable to parse operation. " when using 'LEAST' or 'GREATEST' functions in SQL query.
 Issue 18: Data Access Driver returns error [TABLE_NOT_SPECIFIED_IN_JDBFIELD] when using queries with LEFT OUTER JOIN
References


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