RoundhousE does not update its own Tables

[BiggerNoise]

Bit ironic really :)

We started with an old version of RH on our servers. Now when we get errors, we get the barf that RH cannot insert into the errors table (message is truncated).

Looks like Message field in the ScriptRunErrors table was changed from nvarchar(255) to ntext a while back, but RH doesn't version its own tables so we get the log barf instead of the real error message.

I can take a look at this, unfortunately, it may lead to a state of infinite recursion.

[ferventcoder]

Unfortunately it's a limitation of nh that it doesn't change existing columns very well.

[ferventcoder]

What we can do is add something to explicitly make the change to the table if the size is not correct.

[BiggerNoise]

Cool, I will get around to taking a look at this.

[BiggerNoise]

sorry on the close, finger fumble

[ferventcoder]

They shouldn't be so close together...lol

[ferventcoder]

Originally the thought was to go with NHibernate and Fluent NHibernate because they would provide the most surface into internal upgrades. We may want to explore options here at some point, but we can add a database specific upgrade task for now to handle when we do things that nh doesn't pick up.