ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Error "PAM database is missing" during upgradation

book

Article ID: 239476

calendar_today

Updated On:

Products

CA Process Automation Base

Issue/Introduction

While upgrading to PAM 4.3.05, got the below error in the DB screen:
"PAM database is missing"

The installation.log shows:
"<ERROR 2022-04-05 02:15:45,933 OasisValidation::error> Exception creating table Temp
java.sql.SQLException: CREATE TABLE permission denied in database 'PAM'."

Cause

The user mentioned doesn't have the Administrator Privileges to the PAM database.

Environment

Release : 4.3.X

Component : Process Automation

Resolution

You must have user credentials with Administrator privileges. Check with your DBA to grant the Administrator privileges.