Importing Demo Libraries: ORA-31684: Object type USER:"USM01" already exists

• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
We are following the Upgrade Express 19.01 to 20.x user Guide, on page 11, section 4: Importing Demo libraries, step 4: Execute the Import. We are experiencing error with the step. I have attached the log (--best viewed with Wordpad -- not Notepad).

Aleph 20 was installed on this system via the Automated Installation Kit per SI 16384-155470. We initially installed the system as a single server install and later had out oracle team split the database off to a different server. Our database is located on libserv5, alongside our v19 Test Oracle database. Our Oracle dba believes that some schemas may be missing due to the fact that our database was not created with the aleph 20 installation scripts, but cloned from our previous version. We are currently at a standstill with our Version 20 Upgrade Express.

Resolution:
Looking at the USMnn demo libraries on aleph@libserv1(a20_3), I find that they already contain the proper version 20 data and, therefore, that nothing needs to be done with Importing Demo Libraries.

Examples of tables which changed from v19 to v20 which display properly on this server are usr00 z129 and z700, adm z30h and z71, and bib z104.

It seems to me that you can proceed with the other steps.

• Article last edited: 10/8/2013