Error: "Unexpected Login Error. Please Contact Your Administrator" - "Invalid Column Name 'week_hr_cnt'" When Attempting To Logon To P6 Web Access (Doc ID 1140786.1)

Last updated on JUNE 30, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.2 to 7.0 [Release 6.2 to 7.0]
Information in this document applies to any platform.
***Checked for relevance on 10-Oct-2013***


Symptoms

The following error appears when attempting to logon to P6 v7.0 Web Access:

The following error is reported to the P6 Web Access HTML logs:

com.primavera.PhoenixException: DBEngine.executeSelect: {SELECT calendar.week_hr_cnt HoursPerWeek,calendar.day_hr_cnt HoursPerDay,calendar.year_hr_cnt HoursPerYear,calendar.default_flag DefaultFlag,calendar.month_hr_cnt HoursPerMonth,calendar.proj_id ProjectId FROM calendar WHERE calendar.default_flag = 'Y'} Invalid column name 'week_hr_cnt'.

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