Error: "com.microsoft.sqlserver.jdbc.SQLServerException: Invalid Column Name Job_Type_Key" In P6 Logs When Loading Data (Doc ID 1352740.1)

Last updated on JULY 07, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version: 8.1 and later   [Release: 8.1 and later ]
Information in this document applies to any platform.

Symptoms

When loading data, P6 hangs.  In the P6 Log files, the following exception occurs:

ERROR
-----------------
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select job_id, job_name, job_type, user_id, job_type_key, last_run_date, update_date, recur_data, recur_type, status_code, seq_num, parent_job_id, last_error_descr, (select jobset.setting_value from jobset where jobset.setting_name='JobDataDateUpdateType' and jobset.job_id=jobsvc.job_id) as JobDataDateUpdateType, (select jobset.setting_value from jobset where jobset.setting_name='DataDateUpdateValue' and jobset.job_id=jobsvc.job_id) as DataDateUpdateValue from jobsvc where (recur_type = ? and status_code <> ?) or (recur_type=? and status_code=?) order by update_date]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'job_type_key'.
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:220)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
   at com.primavera.jobsvc.common.dao.JobServiceJDBCDaoImpl.loadJobs(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
   .....
   Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'job_type_key'.

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