java.lang.Exception: altering.. to type IncomingEmailHost

Rennur

Created a new 'number' attribute in SystemSettings, getting this error trying to make version available for testing:

Server output:
Column 'WaitingTimeTreshold' not found.
Column 'WaitingTimeTreshold' not found.
com.bas.basserver.persistence.PersistenceException: Error persisting business object SystemSettings Unknown column 'WaitingTimeTreshold' in 'field list'

Exception com.bas.basserver.persistence.PersistenceException trying to commit transaction Error persisting business object SystemSettings Unknown column 'WaitingTimeTreshold' in 'field list'
2013-09-26 11:08:55,741 ERROR CR#mh -Transaction exception Error persisting business object SystemSettings Unknown column 'WaitingTimeTreshold' in 'field list'

2013-09-26 11:11:22,667 ERROR CR#admin -Exception while undoing test publish Error reading business space version from persistence Illegal operation on empty result set.

CONFIG OUTPUT:

java.lang.Exception: Aware IM server encountered the following error .Error altering column WaitingTimeTreshold for table BASTESTDOMAINCR_SYSTEMSETTINGS to type IncomingEmailHost varchar(50) Unknown column 'WaitingTimeTreshold' in 'bastestdomaincr_systemsettings'
at com.bas.uiconfiguration.model.D.A(Unknown Source)
at com.bas.uiconfiguration.model.D.A(Unknown Source)
at com.bas.uiconfiguration.command.DomainVersionTestCommand.D(Unknown Source)
at com.bas.uiconfiguration.command.B.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Powerm

Just go to your Mysql Table and add that "WaitingTimeTreshold" field.
Seems it has not been created during testing....

Rennur

Thanks Powerm, that seems to be the case.

In the error message, why would the "WaitingTimeTreshold' attribute be trying to change to 'IncomingEmailHost' varchar (50)?

Just found this a bit puzzeling.

Powerm

Well it is more Mysql trying to change a field that has not been created during the bsv tables creating by AwareIM.

"Error altering column WaitingTimeTreshold for table BASTESTDOMAINCR_SYSTEMSETTINGS"