E1: XMLP: Known SQL Query issues using Data Access Server(DAD) and/or Data Access Server(DAS)
(Doc ID 1157853.1)
Last updated on FEBRUARY 04, 2019
Applies to:JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
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.
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
|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|