Systems down!

[MarillionFan]

Clientco IT is in a major tizzy. A warroom has been set up. The bridge is open. Spock is checking sensors.

They deployed a number of changes to one of our systems, one of them was a simple 'add new field to form, rename label on old field to something else and rename label on new field to old label on other field'.

Should be simple. No idiot writes integration code checking the label name of fields on a form right?

So as they have rescinded my administration access to the dev/production instance to check code because of SOX, to make sure I wrote a lengthy note in my business request that the development team should ensure that the renaming of a field does not impact any other systems & they need to ensure that there is no impact mainly to the external support system.

It's gone down & this change is the culprit and 5 hours later but they still don't know exactly why.

Schadenfreude?

[mudskipper]

New fieldname conflicts with another fieldname from a different table, so the underlying select now has an ambiguous column name?

[MarillionFan]

New fieldname conflicts with another fieldname from a different table, so the underlying select now has an ambiguous column name?

It's not the column name as in the database, it's the text label on the form!

The new database field name has a u_ in front of it though, so they think it' either the label (which is how the platform can work) or someone used a *name* on the integration.

Looking forward for the RCA as everyone is looking at each other for why nobody tested it when it had been explicitly written down by the business as a possible gotcha.

[Old Hack]

I had a client who when told their data wasn't clean enough to get into the database, as the triggers were catching the iffy data, ordered the triggers to be turned off so they could get the data in.

It had other triggers which copied the data into archive tables too if it was manipulated, which, later on, would be used to roll-back on errors.

3 years worth of work cleaning it all up.

Now that was some meeting when that came out into the open

[Mich the Tester]

I think your only rescue might be to call up Suity.

[mudskipper]

Looking forward for the RCA as everyone is looking at each other for why nobody tested it when it had been explicitly written down by the business as a possible gotcha.

Don't you have a change control doc? Who signed off the testing?

[Mich the Tester]

Don't you have a change control doc? Who signed off the testing?

Not me guv.

[Old Greg]

I think your only rescue might be to call up Suity.

I ain't gettin' on no plane with that crazy fool.

[suityou01]

I think your only rescue might be to call up Suity.

Busy, sod off.

HTH

[minestrone]

Hawd on...


The forms fields have variable names and they are correct but it is the on screen text labels beside the fields are wrong and that is killing the system?

Jesus ****!