Can you remove invalid database objects after platform upgrade?


After a platform upgrade, certain invalid Database Views appear. But the TRIRIGA application works fine. So are these Database Views safe to remove? Here’s the list of Database Views:

  • M_TRIPAYMENTAUDITSETUP
  • M_TRISERVICEMATRIX
  • V_CLASSIFICATION
  • V_LOCATION
  • V_TRIASSET
  • V_TRIBUDGET
  • V_TRICOMMON
  • V_TRICOSTCODE
  • V_TRICOSTITEM
  • V_TRICOSTITEMLINK2
  • V_TRIINSPECTION
  • V_TRIPEOPLE
  • V_TRIPRODUCTSANDSERVICES
  • V_TRIPROJECT
  • V_TRIPROPOSAL
  • V_TRISETUP
  • V_TRISPECIFICATION
  • V_TRISUBMITTAL
  • V_TRITASK

The above invalid Database Views are doing fine in the minor platform releases, but are never in use. They were used for older pass-through BOs that newer 10.x application versions do not use. Consult with your DBA to drop the Database Views. They can always be recreated when you need them.

Continue reading

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s