Purging TRIRIGA records from a business object


Charlie McGarvey: Need to purge TRIRIGA records? Here is a script to delete all the records from a Business Object (use carefully!). Then from the Admin Console, Database Manager choose the Cleanup BO option.

UPDATE IBS_SPEC SET
UPDATED_DATE = GETDATE() - 62,
OBJECT_STATE = NULL,
OBJECT_ID = 0 - SPEC_ID
WHERE SPEC_ID IN
(SELECT SPEC_ID
FROM dbo.T_TRI_TABLENAME)

Do not delete the T_TRI_TABLENAME records directly.

Continue reading →

5 thoughts on “Purging TRIRIGA records from a business object

  1. Pingback: TRIRIGAFEEDIA | Recovering TRIRIGA records with scripts

  2. Pingback: Top Ten TRIRIGAFEEDIA posts of 2015 | TRIRIGAFEEDIA

  3. Pingback: Top Ten TRIRIGAFEEDIA posts of January 2016 | TRIRIGAFEEDIA

  4. Pingback: Top Ten TRIRIGAFEEDIA posts of February 2016 | TRIRIGAFEEDIA

  5. Pingback: Top Ten TRIRIGAFEEDIA posts of March 2016 | TRIRIGAFEEDIA

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