Database Administration (MOSC)

MOSC Banner

msc_phub_pkg.build_items_from_pds.exception:ORA-08103: object no longer exists

edited Jun 14, 2020 5:03AM in Database Administration (MOSC) 4 commentsAnswered

Hi SMEs

We have R12.1.3 and VCP installed standalone instance along with APCC and Demantra. Recent days we are facing error in Refresh APCC Materialized Views program in data collection intermittently with following shows in log file

Log file shows

2020-06-01 20:30:27: Refreshing MV : MSC_PHUB_RESOURCES_MV ends

2020-06-01 20:30:27: msc_phub_pkg.build_items_from_pds(-1)

2020-06-01 20:30:27: msc_phub_pkg.manage_partitions(3, 2, -1, 4)

2020-06-01 20:30:27: msc_phub_pkg.manage_table_partition(3, MSC_APCC_ITEM_D, -1, 4)

2020-06-01 20:30:27: alter table MSC_APCC_ITEM_D truncate partition APCC_ITEM_D_0

2020-06-01 20:30:28: msc_phub_pkg.manage_table_partition(3, MSC_APCC_PEG_ITEM_D, -1, 4)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center