During Patch Application, hxctab.odf Errors With: "AD Worker - aduobbrt2: INFO: ORA-03211: The Segment Does Not Exist Or Is Not In A Valid State" (Doc ID 818044.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Time and Labor - Version: 12.0.6 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.
***Checked for relevance on 15-DEC-2010***

Symptoms

You are upgrading from 10.5.10.2 to Release 12.  The application of driver u6394500.drv errors with:

  Comparing objects in username HXC with ODF file
  /u003/app/applmgr/ANRAPRE/apps/apps_st/appl/hxc/12.0.0/patch/115/odf/hxctab.odf

  Reading objects from ODF file

  Reading table HXC_TIME_BUILDING_BLOCKS ...
  Reading table HXC_RETRIEVAL_RANGES ...
  Reading table HXC_TIME_ATTRIBUTES ...
  Reading table HXC_RETRIEVAL_RANGE_RESOURCES ...
  Reading table HXC_TRANSACTIONS ...
  Reading table HXC_APP_PERIOD_SUMMARY ...
  Reading table HXC_DEPOSIT_PROCESSES ...
  Reading table HXC_TRANSACTION_DETAILS ...
  Reading table HXC_MAPPING_COMP_USAGES ...
  Reading table HXC_TIME_SOURCES ...
  Reading table HXC_MAPPING_COMPONENTS ...
  Reading table HXC_RETRIEVAL_PROCESSES ...
  Reading table HXC_RETRIEVAL_RULES ...
  Reading table HXC_RETRIEVAL_RULE_COMPS ...
  Reading table HXC_TIME_RECIPIENTS ...
  Reading table HXC_APPROVAL_STYLES ...
  Reading table HXC_DATA_APP_RULE_USAGES ...
  Reading table HXC_TIME_ATTRIBUTE_USAGES ...
  Reading table HXC_APPROVAL_PERIOD_SETS ...
  Reading table HXC_APPROVAL_PERIOD_COMPS ...
  Reading table HXC_RECURRING_PERIODS ...
  Reading table HXC_BLD_BLK_INFO_TYPES ...
  Reading table HXC_BLD_BLK_INFO_TYPE_USAGES ...
  Reading table HXC_MAPPINGS ...
  Reading table HXC_PREF_DEFINITIONS ...
  Reading table HXC_RESOURCE_RULES ...
  Reading table HXC_ALIAS_VALUES ...
  Reading table HXC_ALIAS_VALUES_TL ...
  Reading table HXC_TIME_ENTRY_RULES ...
  Reading table HXC_ENTITY_GROUPS ...
  Reading table HXC_ENTITY_GROUP_COMPS ...
  Reading table HXC_DEBUG ...
  Reading table HXC_DEBUG_TEXT ...
  Reading table HXC_LAYOUTS ...
  Reading table HXC_LAYOUTS_TL ...
  Reading table HXC_LAYOUT_COMPONENTS ...
  Reading table HXC_LAYOUT_COMP_QUALIFIERS ...
  Reading table HXC_LAYOUT_COMP_DEFINITIONS ...
  Reading table HXC_LAYOUT_COMP_PROMPTS ...
  Reading table HXC_TIME_CATEGORIES ...
  Reading table HXC_TIME_CATEGORY_COMPS ...
  Reading table HXC_PREF_HIERARCHIES ...
  Reading table HXC_ALIAS_TYPE_COMPONENTS ...
  Reading table HXC_TK_TIMEKEEPER_SUBMITS ...
  Reading table HXC_ALIAS_DEFINITIONS ...
  Reading table HXC_ALIAS_DEFINITIONS_TL ...
  Reading table HXC_ERRORS ...
  Reading table HXC_TK_GROUPS ...
  Reading table HXC_ALIAS_TYPES ...
  Reading table HXC_TK_GROUP_QUERIES ...
  Reading table HXC_TK_GROUP_QUERY_CRITERIA ...
  Reading table HXC_APPROVAL_COMPS ...
  Reading table HXC_TIMECARD_SUMMARY ...
  Reading table HXC_AP_DETAIL_LINKS ...
  Reading table HXC_TC_AP_LINKS ...
  Reading table HXC_LOCKER_TYPES ...
  Reading table HXC_LOCKING_RULES ...
  Reading table HXC_LOCKS ...
  Reading table HXC_SEEDDATA_BY_LEVEL ...
  Reading table HXC_LATEST_DETAILS ...
  Reading table HXC_TEMP_TIMECARDS ...
  Reading table HXC_DATA_SETS ...
  Reading table HXC_TIME_ATTRIBUTE_USAGES_BK ...
  Reading table HXC_TIME_ATTRIBUTES_BK ...
  Reading table HXC_TIME_CATEGORY_COMP_SQL ...
  Reading table HXC_TEMPLATE_SUMMARY ...
  Reading table HXC_TEMP_TIMECARD_CHUNKS ...
  Reading table HXC_TIME_BUILDING_BLOCKS_AR ...
  Reading table HXC_TIME_ATTRIBUTE_USAGES_AR ...
  Reading table HXC_TIME_ATTRIBUTES_AR ...
  Reading table HXC_TRANSACTIONS_AR ...
  Reading table HXC_TRANSACTION_DETAILS_AR ...
  Reading table HXC_DATA_SET_DETAILS ...
  Reading table HXC_APP_PERIOD_SUMMARY_AR ...
  Reading table HXC_AP_DETAIL_LINKS_AR ...
  Reading table HXC_TC_AP_LINKS_AR ...
  Reading table HXC_APP_COMP_NOTIFICATIONS ...
  Reading table HXC_APP_COMP_NOTIF_USAGES ...

   *** Reading objects from HXC schema

  Reading table HXC_TIME_BUILDING_BLOCKS from HXC schema ...
  Reading table HXC_RETRIEVAL_RANGES from HXC schema ...
  Reading table HXC_TIME_ATTRIBUTES from HXC schema ...
  Reading table HXC_RETRIEVAL_RANGE_RESOURCES from HXC schema ...
  Reading table HXC_TRANSACTIONS from HXC schema ...
  Reading table HXC_APP_PERIOD_SUMMARY from HXC schema ...
  Reading table HXC_DEPOSIT_PROCESSES from HXC schema ...
  Reading table HXC_TRANSACTION_DETAILS from HXC schema ...
  Reading table HXC_MAPPING_COMP_USAGES from HXC schema ...
  Reading table HXC_TIME_SOURCES from HXC schema ...
  Reading table HXC_MAPPING_COMPONENTS from HXC schema ...
  Reading table HXC_RETRIEVAL_PROCESSES from HXC schema ...
  Reading table HXC_RETRIEVAL_RULES from HXC schema ...
  Reading table HXC_RETRIEVAL_RULE_COMPS from HXC schema ...
  Reading table HXC_TIME_RECIPIENTS from HXC schema ...
  Reading table HXC_APPROVAL_STYLES from HXC schema ...
  Reading table HXC_DATA_APP_RULE_USAGES from HXC schema ...
  Reading table HXC_TIME_ATTRIBUTE_USAGES from HXC schema ...
  Reading table HXC_APPROVAL_PERIOD_SETS from HXC schema ...
  Reading table HXC_APPROVAL_PERIOD_COMPS from HXC schema ...
  Reading table HXC_RECURRING_PERIODS from HXC schema ...
  Reading table HXC_BLD_BLK_INFO_TYPES from HXC schema ...
  Reading table HXC_BLD_BLK_INFO_TYPE_USAGES from HXC schema ...
  Reading table HXC_MAPPINGS from HXC schema ...
  Reading table HXC_PREF_DEFINITIONS from HXC schema ...
  Reading table HXC_RESOURCE_RULES from HXC schema ...
  Reading table HXC_ALIAS_VALUES from HXC schema ...
  Reading table HXC_ALIAS_VALUES_TL from HXC schema ...
  Reading table HXC_TIME_ENTRY_RULES from HXC schema ...
  Reading table HXC_ENTITY_GROUPS from HXC schema ...
  Reading table HXC_ENTITY_GROUP_COMPS from HXC schema ...
  Reading table HXC_DEBUG from HXC schema ...
  Reading table HXC_DEBUG_TEXT from HXC schema ...
  Reading table HXC_LAYOUTS from HXC schema ...
  Reading table HXC_LAYOUTS_TL from HXC schema ...
  Reading table HXC_LAYOUT_COMPONENTS from HXC schema ...
  Reading table HXC_LAYOUT_COMP_QUALIFIERS from HXC schema ...
  Reading table HXC_LAYOUT_COMP_DEFINITIONS from HXC schema ...
  Reading table HXC_LAYOUT_COMP_PROMPTS from HXC schema ...
  Reading table HXC_TIME_CATEGORIES from HXC schema ...
  Reading table HXC_TIME_CATEGORY_COMPS from HXC schema ...
  Reading table HXC_PREF_HIERARCHIES from HXC schema ...
  Reading table HXC_ALIAS_TYPE_COMPONENTS from HXC schema ...
  Reading table HXC_TK_TIMEKEEPER_SUBMITS from HXC schema ...
  Reading table HXC_ALIAS_DEFINITIONS from HXC schema ...
  Reading table HXC_ALIAS_DEFINITIONS_TL from HXC schema ...
  Reading table HXC_ERRORS from HXC schema ...
  Reading table HXC_TK_GROUPS from HXC schema ...
  Reading table HXC_ALIAS_TYPES from HXC schema ...
  Reading table HXC_TK_GROUP_QUERIES from HXC schema ...
  Reading table HXC_TK_GROUP_QUERY_CRITERIA from HXC schema ...
  Reading table HXC_APPROVAL_COMPS from HXC schema ...
  Reading table HXC_TIMECARD_SUMMARY from HXC schema ...
  Reading table HXC_AP_DETAIL_LINKS from HXC schema ...
  Reading table HXC_TC_AP_LINKS from HXC schema ...
  Reading table HXC_LOCKER_TYPES from HXC schema ...
  Reading table HXC_LOCKING_RULES from HXC schema ...
  Reading table HXC_LOCKS from HXC schema ...
  Reading table HXC_SEEDDATA_BY_LEVEL from HXC schema ...
  Reading table HXC_LATEST_DETAILS from HXC schema ...
  Reading table HXC_TEMP_TIMECARDS from HXC schema ...
  Reading table HXC_DATA_SETS from HXC schema ...
  Reading table HXC_TIME_ATTRIBUTE_USAGES_BK from HXC schema ...
  Reading table HXC_TIME_ATTRIBUTES_BK from HXC schema ...
  Reading table HXC_TIME_CATEGORY_COMP_SQL from HXC schema ...
  Reading table HXC_TEMPLATE_SUMMARY from HXC schema ...

  AD Worker - aduobbrt2: INFO: ORA-03211: The segment does not exist or is not in a valid state
  ORA-06512: at "SYS.DBMS_SPACE", line 152
  ORA-06512: at line 2

  AD Worker - aduortrb2: ERROR: Failed to read table from RDBMS

  AD Worker - aiccep: ERROR: Unable to read objects from RDBMS





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