SQLSTATE = 37000 Error when Print Previewing from InfoMaker
(Doc ID 909428.1)
Last updated on SEPTEMBER 25, 2019
Applies to:Primavera Contract Management - Version 11.0 to 13.1 [Release 11.0 to 13]
This document will help resolve SQLSTATE = 37000 errors when running an InfoMaker report against an Microsoft SQL Database. The different errors are:
- SQLSTATE = 37000 [Microsoft][ODBC SQL Server][SQL Server]The multi-part identifier table_name.project_name could not be bound
- SQLSTATE=3700 Incorrect syntax near...
These errors are also accompanied by an inability to render the report's SQL Syntax in Graphics mode.
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
|Cause 1: Incorrectly using ANSI_Escape Outer Join Syntax (oj)|
|Cause 2: SQL Syntax Not Enclosed in Quotes|