Invalid object name 'exp.proj' error, when previewing certain forms in InfoMaker

(Doc ID 909310.1)

Last updated on JANUARY 12, 2017

Applies to:

Primavera Contract Management - Version 11.0 to 13.1 [Release 11.0 to 13]
All Platforms

Symptoms

When trying to preview certain Contract Management forms in InfoMaker, the following error is thrown: Select Error: SQLSTATE = S0002[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'exp.proj'.

The Contract Management database server platform was migrated from Sybase Adaptive Server Anywhere to Microsoft SQL Server. In this situation, any Contract Management report or form with an 'exp' prefix in front of objects in the syntax will cause this error message. However, there are no objects with an exp prefix in the sql data view syntax mode for the problem form(s). The problem forms cannot be previewed from within the Contract Management application.

Changes

 Migrated from Sybase to Microsoft SQL Server

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms