How the see what RTB is trying to do when update schema fail

Posted by cverbiest on 01-Dec-2016 02:24

Schema update fails with following error

---------------------------
Roundtable Schema Update (Press HELP to view stack trace)
---------------------------
** Field TRJNL CMPID is a component of an Index. (185)
---------------------------
OK Help
---------------------------

I think a renamed field causes this.

How can I see which df rtb is trying to load ?

All Replies

Posted by Jeff Ledbetter on 01-Dec-2016 07:06

Is this via _update.w or from the tabletop?

Posted by cverbiest on 01-Dec-2016 09:22

should have mentioned : tabletop

I skipped the table that failed, and did the rest of the update

afterwards I ran an incremental df with the db from source workspace

no changes to that table were found in the df, only some field position updates.

AFAIK the change was a rename of an indexed field

Posted by Jeff Ledbetter on 01-Dec-2016 09:45

From the tabletop,there are no DFs produced. If you select the item in the tree with the error and choose the 'Show Errors' button, you should see more detail but it may be not as specific as you need. I'm not aware of any current schema update issues. If you know the steps that caused this, please pass along.

Posted by cverbiest on 01-Dec-2016 09:59

Hi Jeff,

thank you for the info, I don't know the history of the changes for that table. I was just the one updating the schema :-(

Posted by Jeff Ledbetter on 01-Dec-2016 10:06

Ok. The Compare option for the PFILE could be of help to see the differences between the versions. Let me know if you find anything.

Posted by cverbiest on 01-Dec-2016 10:50

pfile is version 010001 compare with 010000 shows a new field BKSL-TRJNL-CMPID and an index on that field.

Posted by Jeff Ledbetter on 01-Dec-2016 10:53

So there was no rename?

Posted by cverbiest on 01-Dec-2016 10:56

No, just confused by the fact that the progress error message shows the field label instead of the field-name when referring to a field. I'm out-of-office for the next couple of days.

Posted by Jeff Ledbetter on 01-Dec-2016 10:59

Ok. I quickly tried to dupe using both scenarios without luck. :-\

This thread is closed