My Oracle Support Banner

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]
All Platforms

Purpose

This document will help resolve SQLSTATE = 37000 errors when running an InfoMaker report against an Microsoft SQL Database.  The different errors are:

These errors are also accompanied by an inability to render the report's SQL Syntax in Graphics mode.

Note: Printing is only failing from InfoMaker, not Contract Management.

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
 Cause 1:  Incorrectly using ANSI_Escape Outer Join Syntax (oj)
 Cause 2: SQL Syntax Not Enclosed in Quotes

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