Error: "SQL State: I, SQL Error Code: 4121 Level: 16, Procedure: PRMAUD_TASKPRED, Line: 86 Cannot find either column “dbo” or the user-defined function or aggregate “dbo.column_audited”, or the name is ambiguous" When Trying to Delete or Import a Project

(Doc ID 2217807.1)

Last updated on MARCH 06, 2017

Applies to:

Primavera P6 Professional Project Management - Version 16.2.0.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 16.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When connecting to a SQL Server database and attempting to delete a project OR import a project, the following error occurs:

ERROR

PRM D8Access Error: SQL State: I, SQL Error Code: 4121 Level: 16, Procedure: PRMAUD_TASKPRED, Line: 86
Cannot find either column “dbo” or the user-defined function or aggregate “dbo.column_audited”, or the name is ambiguous.


STEPS
The issue can be reproduced at will with the following steps:
1. Launch P6 Professional.

2. Attempt to delete or import a project.

3.  Observe reported error.

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users cannot delete or import a P6 project.

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