AERS 4.6.2 Install Guide Step 3.8.5.2 Hangs - IMP-00086: TOID "WWSBR_ARRAY" not found in export file (Doc ID 1272801.1)

Last updated on MAY 25, 2012

Applies to:

Adverse Event Reporting System - Version 4.6.2 and later
Information in this document applies to any platform.

Symptoms


AERS 4.6.2 Install Guide step 3.8.5.2 hangs at
IMP-00086: TOID "WWSBR_ARRAY" not found in export file

e.g.


Import: Release 10.1.0.5.0 - Production on Wed Dec 8 22:10:12 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.


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

Export file created by EXPORT:V09.02.00 via conventional path
import done in UTF8 character set and AL16UTF16 NCHAR character set
. importing PORTAL's objects into PORTAL
. . importing table "WWUTL_EXPORT_IMPORT$" 1 rows imported
. . importing table "WWUTL_EXPORT_IMPORT_DETAIL$" 54 rows imported
. . importing table "WWUTL_APP_TX_APPLICATION$" 0 rows imported
. . importing table "WWUTL_APP_TX_APPLICATION_DET$" 4 rows imported
. . importing table "WWUTL_APP_TX_DATAPTLS$" 0 rows imported
. . importing table "WWUTL_APP_TX_DATAPTL_DATA$" 0 rows imported
. . importing table "WWUTL_APP_TX_MODULES$" 4 rows imported
. . importing table "WWUTL_APP_TX_MODULE_DETAILS$" 387 rows imported
. . importing table "WWUTL_APP_TX_USR_CAT_LOV$" 1 rows imported
. . importing table "WWUTL_APP_TX_USR_COLORS$" 0 rows imported
. . importing table "WWUTL_APP_TX_USR_DYNAMIC_LOV$" 1 rows imported
. . importing table "WWUTL_APP_TX_USR_FONTS$" 0 rows imported
. . importing table "WWUTL_APP_TX_USR_IMAGES$" 0 rows imported
. . importing table "WWUTL_APP_TX_USR_JAVA_SCRIPTS$" 0 rows imported
. . importing table "WWUTL_APP_TX_USR_MENUS$" 0 rows imported
. . importing table "WWUTL_APP_TX_USR_STATIC_LOV$" 0 rows imported
. . importing table "WWUTL_APP_TX_USR_TEMPLATE$" 0 rows imported
. . importing table "WWUTL_APP_TX_USR_TEMPLATE_DET$" 0 rows imported
. . importing table "WWUTL_CTX_TX_PROXY$" 0 rows imported
. . importing table "WWUTL_DOC_TX_DOCUMENT$" 0 rows imported
. . importing table "WWUTL_EXPORT_IMPORT_LOG$" 345 rows imported
. . importing table "WWUTL_IMPORT_MAPPING$" 0 rows imported
. . importing table "WWUTL_NLS_TX_STRINGS$" 114 rows imported
. . importing table "WWUTL_POB_TX_DOCUMENT$" 0 rows imported
. . importing table "WWUTL_POB_TX_EVENT$" 0 rows imported
. . importing table "WWUTL_POB_TX_EVENT_MAP$" 0 rows imported
. . importing table "WWUTL_POB_TX_FLOW_ELEM$" 0 rows imported
. . importing table "WWUTL_POB_TX_FLOW_GROUP$" 0 rows imported
. . importing table "WWUTL_POB_TX_FLOW_LINK$" 0 rows imported
. . importing table "WWUTL_POB_TX_ITEM$" 38 rows imported
. . importing table "WWUTL_POB_TX_LAYOUT$" 0 rows imported
. . importing table "WWUTL_POB_TX_OBJ_REF$" 0 rows imported
. . importing table "WWUTL_POB_TX_PAGE$" 12 rows imported
. . importing table "WWUTL_POB_TX_PAGEGROUP_SETT$" 2 rows imported
. . importing table "WWUTL_POB_TX_PAGE_CUSTOM$" 12 rows imported
. . importing table "WWUTL_POB_TX_PAGE_IMPORT$" 0 rows imported
. . importing table "WWUTL_POB_TX_PAGE_PRIVS$" 0 rows imported
. . importing table "WWUTL_POB_TX_PARAM$" 13 rows imported
. . importing table "WWUTL_POB_TX_PARAM_CUST$" 0 rows imported
. . importing table "WWUTL_POB_TX_PARAM_MAP$" 0 rows imported
. . importing table "WWUTL_POB_TX_PORTLET_INST$" 20 rows imported
. . importing table "WWUTL_POB_TX_REGION$" 35 rows imported
. . importing table "WWUTL_POB_TX_REGION_ATTRIBUTE$" 35 rows imported
. . importing table "WWUTL_POB_TX_STRINGS$" 0 rows imported
. . importing table "WWUTL_POB_TX_STYLE$" 0 rows imported
. . importing table "WWUTL_POB_TX_STYLE_INST$" 0 rows imported
. . importing table "WWUTL_PORT_TX_INSTANCE$" 0 rows imported
. . importing table "WWUTL_PORT_TX_INSTANCE_FLAT$" 0 rows imported
. . importing table "WWUTL_PRE_TX_NAME$" 63 rows imported
. . importing table "WWUTL_PRE_TX_PATH$" 12 rows imported
. . importing table "WWUTL_PRE_TX_VALUE$" 61 rows imported
. . importing table "WWUTL_PRO_TX_PROVIDERS$" 8 rows imported
. . importing table "WWUTL_PRO_TX_PROVIDER_GROUP$" 0 rows imported
. . importing table "WWUTL_PRO_TX_PROVIDER_PREFS$" 0 rows imported
. . importing table "WWUTL_PRO_TX_PTL_METADATA$" 19 rows imported
. . importing table "WWUTL_PRO_TX_REG_PROPERTY$" 0 rows imported
. . importing table "WWUTL_PRO_TX_USER_CAT_MAP$" 0 rows imported
. . importing table "WWUTL_PTL_TX_FAVORITE$" 0 rows imported
. . importing table "WWUTL_PTL_TX_FAVORITE_GROUP$" 0 rows imported
. . importing table "WWUTL_RW_TX_AVAIL_COMP$" 0 rows imported
. . importing table "WWUTL_RW_TX_AVAIL_DEFS$" 0 rows imported
. . importing table "WWUTL_RW_TX_AVAIL_TYPES$" 0 rows imported
. . importing table "WWUTL_RW_TX_SYS_COMPCALENDAR$" 0 rows imported
. . importing table "WWUTL_RW_TX_SYS_COMPDEF$" 0 rows imported
. . importing table "WWUTL_RW_TX_SYS_DESTYPE" 0 rows imported
. . importing table "WWUTL_RW_TX_SYS_PRNLIST" 0 rows imported
. . importing table "WWUTL_RW_TX_USER_PARAMS$" 0 rows imported
. . importing table "WWUTL_SBR_TRANSPORT_TABLE$" 0 rows imported
. . importing table "WWUTL_SBR_TX_APPROVAL$" 0 rows imported
. . importing table "WWUTL_SBR_TX_APPROVER$" 0 rows imported
. . importing table "WWUTL_SBR_TX_ATTRIBUTE$" 3 rows imported
. . importing table "WWUTL_SBR_TX_CORNERS$" 0 rows imported
. . importing table "WWUTL_SBR_TX_CUSTOMTEXT$" 0 rows imported
. . importing table "WWUTL_SBR_TX_EXPIRY$" 0 rows imported
. . importing table "WWUTL_SBR_TX_FOLDERFUNC_ATTRI$" 0 rows imported
. . importing table "WWUTL_SBR_TX_FOLDER_ATTRIBUTE$" 0 rows imported
. . importing table "WWUTL_SBR_TX_FOLDER_PERSPECTI$" 0 rows imported
. . importing table "WWUTL_SBR_TX_FOLDER_REGION$" 0 rows imported
. . importing table "WWUTL_SBR_TX_FOLDER_SUBTYPE$" 0 rows imported
. . importing table "WWUTL_SBR_TX_FOLDER_SUBTYPEAT$" 0 rows imported
. . importing table "WWUTL_SBR_TX_FOLDER_SUBTYPE_F$" 0 rows imported
. . importing table "WWUTL_SBR_TX_GROUP$" 0 rows imported
. . importing table "WWUTL_SBR_TX_ITEM_APPROVAL$" 0 rows imported
. . importing table "WWUTL_SBR_TX_MEMBER$" 0 rows imported
. . importing table "WWUTL_SBR_TX_NAVIGATION_BAR$" 0 rows imported
. . importing table "WWUTL_SBR_TX_NAVIGATION_BAR_E$" 0 rows imported
. . importing table "WWUTL_SBR_TX_PERSON$" 0 rows imported
. . importing table "WWUTL_SBR_TX_PERSPECTIVES$" 0 rows imported
. . importing table "WWUTL_SBR_TX_PORTLET$" 3 rows imported
. . importing table "WWUTL_SBR_TX_REGION_ATTRIBUTE$" 0 rows imported
. . importing table "WWUTL_SBR_TX_SETTINGS$" 320 rows imported
. . importing table "WWUTL_SBR_TX_SETTINGSSETS$" 1 rows imported
. . importing table "WWUTL_SBR_TX_SITES$" 1 rows imported
. . importing table "WWUTL_SBR_TX_SITE_CATEGORY$" 2 rows imported
. . importing table "WWUTL_SBR_TX_SITE_FOLDERTYPES$" 5 rows imported
. . importing table "WWUTL_SBR_TX_SITE_LANGUAGES$" 1 rows imported
. . importing table "WWUTL_SBR_TX_SITE_PERSPECTIVE$" 0 rows imported
. . importing table "WWUTL_SBR_TX_SITE_SUBTYPES$" 26 rows imported
. . importing table "WWUTL_SBR_TX_SUBSCRIPTION$" 0 rows imported
. . importing table "WWUTL_SBR_TX_SUBTYPEATTRIBUTE$" 117 rows imported
. . importing table "WWUTL_SBR_TX_SYS_PRIV$" 0 rows imported
. . importing table "WWUTL_SBR_TX_TEXT$" 1 rows imported
. . importing table "WWUTL_SBR_TX_THINGATTRIBUTES$" 48 rows imported
. . importing table "WWUTL_SBR_TX_THINGFUNCTION_AT$" 11 rows imported
. . importing table "WWUTL_SBR_TX_THINGS$" 38 rows imported
. . importing table "WWUTL_SBR_TX_THINGSPERSPECTIV$" 0 rows imported
. . importing table "WWUTL_SBR_TX_THINGSUBTYPE$" 17 rows imported
. . importing table "WWUTL_SBR_TX_THINGSUBTYPE_FUN$" 3 rows imported
. . importing table "WWUTL_SBR_TX_TOPICS$" 0 rows imported
. . importing table "WWUTL_SBR_TX_URL$" 0 rows imported
. . importing table "WWUTL_SBR_TX_USER_SEARCHES$" 0 rows imported
. . importing table "WWUTL_SEC_TX_EXT_APP_LKUP$" 3 rows imported
. . importing table "WWUTL_SEC_TX_GROUP$" 0 rows imported
. . importing table "WWUTL_SEC_TX_MEMBER$" 0 rows imported
. . importing table "WWUTL_SEC_TX_PERSON$" 0 rows imported
. . importing table "WWUTL_SEC_TX_SYS_PRIV$" 23 rows imported
. . importing table "WWUTL_SRC_TX_DEPENDENCY$" 15 rows imported
. . skipping TOID validation on type PORTAL.WWSBR_DISPLAY_ATTRIBUTE
. . skipping TOID validation on type PORTAL.WWSBR_DISPLAY_ATTRIBUTE_ARRAY
. . skipping TOID validation on type PORTAL.WWSBR_LANG_STRING_PAIR
. . skipping TOID validation on type PORTAL.WWSBR_LS_PAIRS
. . skipping TOID validation on type PORTAL.WWSBR_STRING_PREFERENCE
. . skipping TOID validation on type PORTAL.WWSBR_SEARCH_ATTRIBUTE
. . skipping TOID validation on type PORTAL.WWSBR_SEARCH_ATTRIBUTE_ARRAY
. . skipping TOID validation on type PORTAL.WWSRC_ATT_VALUE_IDS
. . skipping TOID validation on type PORTAL.WWSRC_ID_VALUE_VARRAY
. . skipping TOID validation on type PORTAL.WWSRC_ATT_VALUE_SET
. . skipping TOID validation on type PORTAL.WWSBR_SITE_ARRAY
. . skipping TOID validation on type PORTAL.WWSBR_SEARCH_PREFERENCE
. . importing table "WWUTL_SRC_TX_PREFERENCE$" 1 rows imported
IMP-00086: TOID "WWSBR_ARRAY" not found in export file

Cause

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