234 views

ODBC queries against database views fail with errors

 

Problem
Querying a database view using the ODBC driver fails and results in an error.  

 

Symptoms
When you issue a query against a database view, you receive one of the following error messages, depending on the version of the driver:    

 

[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]com.ctc.wstx.exc.WstxEOFException: Unexpected EOF in prolog at [row,col {unknown-source}]: [1,0]

[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot execute the query.Cannot processe keys. [tableName=incident_sla] 

[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot execute the query.Cannot processe getKeys SOAP response. Please see the ODBC log file for more details. [tableName=incident_sla] 

 Additionally, the instance log files contain the following entries:

 

Problem processing asynchronous servlet request: java.lang.StackOverflowError: com.glide.db.conditions.CompoundCondition.clearJoins(CompoundCondition.java:95)

com.glide.db.conditions.QueryCondition.clearJoins(QueryCondition.java:942)

com.glide.db.conditions.CompoundCondition.clearJoins(CompoundCondition.java:97)

com.glide.db.conditions.CompoundCondition.clearJoins(CompoundCondition.java:97)

com.glide.db.conditions.CompoundCondition.clearJoins(CompoundCondition.java:97)

com.glide.db.conditions.CompoundCondition.clearJoins(CompoundCondition.java:97)

  

 

 

Cause
An error in the underlying platform layer occurs. This error is independent of the ODBC driver.

 


Resolution

Set the BatchSize ODBC Administrator property value to 500. Values greater than 500 should be tested with your specific configuration.

Article Information

Last Updated:2016-09-16 06:54:11
Published:2015-05-19