22 views

Overview


The error below has been observed occurring when a user tries to run a SQL query in ISql using the OBDC driver:

ODBC Call = SQLPrepareW()
SQL State = 42S02
Native error = 10129(2791)
Error Message = [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]Base table:incident not found.
Elapsed time 2683 ms.
Elapsed time: Prepare 0 ms. Execute 0 ms. Fetch results 2683 ms.

 

Solution


This is due to a database view that has referenced itself, throwing the SchemaProcessor into a recursive loop, so causing a stack overflow.

Go to System Definitions > Database Views to remove or rename the self-referencing view.

 

Article Information

Last Updated:2018-08-03 02:07:22
Published:2018-07-17