Import Hanging When Trying To Install Aers_4.6 (Upgrading From 4.5.2)

(Doc ID 960071.1)

Last updated on MAY 03, 2010

Applies to:

Adverse Event Reporting System - Version: 4.6 and later   [Release: 4.6 and later ]
Information in this document applies to any platform.

Goal

Started the AERS 4.6 install yesterday, and still running this morning. Checked the server and the
import (aers46_portal_imp.bat specifically) is still running.

The log shows:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by PORTAL30, not by you

import done in UTF8 character set and AL16UTF16 NCHAR character set
. importing PORTAL30's objects into PORTAL
. . importing table "AERS46_WWDOC_DOCUMENT" 8085 rows imported
. . importing table "AERS46_WWSBR_ALL_FOLDERS" 458 rows imported
. . importing table "AERS46_WWSBR_ALL_ITEMS" 12526 rows imported
. . importing table "AERS46_WWSBR_ITEM_ATTRIBUTES" 0 rows imported
. . importing table "AERS46_WWSEC_PRIV" 18019 rows imported

It appears to be stuck on the last table.

I rolled back and tried again this morning with the same results.



Solution

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