Internal error. Column 'Docket_Signature_DOCTYPE' not found

Rennur

Created a Picture attribute with signature ticked and When I tried to create the Object I get an internal error.

The attribute exists in the BSV but AwareIM did not create this field in the database.

Server output:

Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
Column 'Docket_Signature_DOCTYPE' not found.
com.bas.basserver.executionengine.ExecutionException: Operation error.

..... list of open connector error here .....

2014-05-28 13:15:57,885 ERROR Reply#13#BASTestDomainCR#5e3b7df4d47fdb7001153d0e576f4743    -Execution Exception after resuming a process message Operation error.

2014-05-28 13:15:57,888 ERROR Reply#13#BASTestDomainCR#5e3b7df4d47fdb7001153d0e576f4743    -18 Resumed process NewDocketSUPPLY_2COL has failed. Message is Operation error. Sending failure reply


com.bas.basserver.executionengine.ExecutionException: Internal error. Error persisting business object Docket_Supply Unknown column 'Docket_Signature_DOCTYPE' in 'field list'


..... more open connector error here .....


2014-05-28 13:18:07,662 ERROR Reply#14#BASTestDomainCR#5e3b7df4d47fdb7001153d0e576f4743    -Execution Exception after resuming a process message Internal error. Error persisting business object Docket_Supply Unknown column 'Docket_Signature_DOCTYPE' in 'field list'

2014-05-28 13:18:07,665 ERROR Reply#14#BASTestDomainCR#5e3b7df4d47fdb7001153d0e576f4743    -18 Resumed process NewDocketSUPPLY_2COL has failed. Message is Internal error. Error persisting business object Docket_Supply Unknown column 'Docket_Signature_DOCTYPE' in 'field list' Sending failure reply

Then, I delete the attribute and Integrity check finds Internal error, Press CTRL+I.

Duplicate IDs encountered. How and Why?

I apply the magic CTRL+I fix and voila, everything goes up the shits.

2014-05-28 13:36:48,156 ERROR CR#admin -Exception while undoing test publish Error reading business space version from persistence Illegal operation on empty result set.

Server encountered an exception Error dropping columns for table BASTESTDOMAINCR_DOCKET_SUPPLY Can't DROP 'Docket_Signature_DOCTYPE'; check that column/key exists

Well it doesn't exists as it was never created in the first place.

Had that a few times before and both times had to restore the whole app form scratch.

I have to do it again.

Rennur

I don't think much can be done, luckily I back up regularly.

I've renamed and deleted some BOs prior to the error, so use caution when renaming BOs, especially if they are part of a BO Group.

I wish we could pinpoint the exact cause.

Rennur

AGGGGAAAAIIINNNNN FFS :evil:

Attributes are not created if in a BO group and if you choose YES to update all in the group.

Rennur

Added the columns for the Signature attribute manually. Seems to have fixed it