Issues with Migrating the Task Persistence Database

Products

• CA Identity Suite

Issue/Introduction

It shows us the following warnings:
Warning: the objects were exported by IMARC, not by you

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
IMP-00403:

Warning: This import generated a separate SQL file "TEST_new_sys.sql" which contains DDL that failed due to a privilege issue.

Import terminated successfully with warnings.

Environment

Release : 14.5
Component : CA Identity Suite Virtual Appliance

Cause

The warning IMP-00403 indicates a privilege issue where the import process couldn't execute certain Data Definition Language (DDL) operations. This often happens when the user lacks the necessary permissions.

Re-run the import process as a SYSDBA user. This will provide the necessary privileges to execute all DDL operations.

Resolution

We have performed the procedure with the SYSDBA user and we no longer see the warnings.