Warning: The able 'QUERYLIB' Has Been Created But Its Maximum Row Size (12604) Exceeds The Maximum Number Of Bytes Per Row (8060) (Doc ID 898310.1)

Last updated on JUNE 30, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version: 3.5 and later   [Release: 3.5 and later ]
Primavera Contractor - Version: 4.0 and later    [Release: 4.0 and later]
All Platforms
***Checked for relevance on 02-Mar-2011***

Symptoms

The following warning is encountered when attempting to upgrade a database:

Warning: The table 'QUERYLIB' has been created but its maximum row size
(12604) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE
of a row in this table will fail if the resulting row length exceeds 8060
bytes.


Server: Msg 208, Level 16, State 1, Procedure EXPPROJ, Line 2

Invalid object name 'dbo.EXPPROJ'.

Server: Msg 208, Level 16, State 1, Procedure FINDATES, Line 2

Invalid object name 'dbo.FINDATES'.

Server: Msg 208, Level 16, State 1, Procedure FORMCATG, Line 2

Invalid object name 'dbo.FORMCATG'.

Server: Msg 208, Level 16, State 1, Procedure FORMPROJ, Line 2

Invalid object name 'dbo.FORMPROJ'.

Server: Msg 208, Level 16, State 1, Procedure FORMTMPL, Line 2

Invalid object name 'dbo.FORMTMPL'.

Server: Msg 208, Level 16, State 1, Procedure ITERATION, Line 2

Invalid object name 'dbo.ITERATION'.

Server: Msg 208, Level 16, State 1, Procedure ITERDAYS, Line 2

Invalid object name 'dbo.ITERDAYS'.

Server: Msg 208, Level 16, State 1, Procedure ITERGOAL, Line 2

Invalid object name 'dbo.ITERGOAL'.

Server: Msg 208, Level 16, State 1, Procedure JOBRPT, Line 2

Invalid object name 'dbo.JOBRPT'.

Server: Msg 208, Level 16, State 1, Procedure PROCGROUP, Line 2

Invalid object name 'dbo.PROCGROUP'.

Server: Msg 208, Level 16, State 1, Procedure PROCITEM, Line 2

Invalid object name 'dbo.PROCITEM'.

Server: Msg 208, Level 16, State 1, Procedure PROJWSRPT, Line 2

Invalid object name 'dbo.PROJWSRPT'.

Server: Msg 208, Level 16, State 1, Procedure QUERYLIB, Line 2

Invalid object name 'dbo.QUERYLIB'.

Server: Msg 208, Level 16, State 1, Procedure RELEASE, Line 2

Invalid object name 'dbo.RELEASE'.

Server: Msg 208, Level 16, State 1, Procedure ROLERATE, Line 2

Invalid object name 'dbo.ROLERATE'.

Server: Msg 208, Level 16, State 1, Procedure RSRCSEC, Line 2

Invalid object name 'dbo.RSRCSEC'.

Server: Msg 208, Level 16, State 1, Procedure TASKFIN, Line 2

Invalid object name 'dbo.TASKFIN'.

Server: Msg 208, Level 16, State 1, Procedure TRSRCFIN, Line 2

Invalid object name 'dbo.TRSRCFIN'.

Server: Msg 208, Level 16, State 1, Procedure UDFCODE, Line 2

Invalid object name 'dbo.UDFCODE'.

Server: Msg 208, Level 16, State 1, Procedure WBSRSRC, Line 2

Invalid object name 'dbo.WBSRSRC'.

Server: Msg 208, Level 16, State 1, Procedure WBSRSRC_QTY, Line 2

Invalid object name 'dbo.WBSRSRC_QTY'.

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