search cancel

ITPAM login page not launch after fresh installation

book

Article ID: 256190

calendar_today

Updated On:

Products

CA Process Automation Base

Issue/Introduction

Installed ITPAM in a new server with migrated DB from another environment.
Installation went successful but not able to get the login page with below error in c20.log:
-----------------------------
2022-12-13 00:20:59,956 ERROR [com.optinuity.c2o.ddlgenerator.C2ODDLGenerator] [eportingManager] Error occurred while executing ALTER Table TelemetryUsage DROP COLUMN Published:The object 'DF__Telemetry__Publi__08362A7C' is dependent on column 'Published'.
2022-12-13 00:20:59,957 ERROR [com.optinuity.c2o.ddlgenerator.C2ODDLGenerator] [eportingManager] Error occurred while updating Table definition
java.sql.SQLException: The object 'DF__Telemetry__Publi__08362A7C' is dependent on column 'Published'.
-----------------------------

Environment

Release : 4.3.05

Cause

Application and DB are not at same patch level.

Resolution

If any CP patch was applied to the previous environment, make sure to apply the same CP patch before starting the PAM service. 
Here, the another environment from where the DB was copied has CP04 patch applied, so applied CP04 patch on top of 4.3.05 and it resolved the issue.