Issues Sending

[Aden]

Hi, i am getting this error when trying to send a message using frontline sms version 1.6. can anyone help me out with this?

 

class org.springframework.jdbc.UncategorizedSQLException :: Hibernate operation: could not insert: [net.frontlinesms.data.domain.FrontlineMessage]; uncategorized SQLException for SQL [insert into message (id, binaryMessageContent, date, dtype, recipientMsisdn, recipientSmsPort, retriesRemaining, senderMsisdn, smsPartsCount, smscReference, status, textContent, type) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [90006]; error code [90006]; NULL not allowed for column "DISPATCHDATE"; SQL statement:
insert into message (id, binaryMessageContent, date, dtype, recipientMsisdn, recipientSmsPort, retriesRemaining, senderMsisdn, smsPartsCount, smscReference, status, textContent, type) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90006-127]; nested exception is org.h2.jdbc.JdbcSQLException: NULL not allowed for column "DISPATCHDATE"; SQL statement:
insert into message (id, binaryMessageContent, date, dtype, recipientMsisdn, recipientSmsPort, retriesRemaining, senderMsisdn, smsPartsCount, smscReference, status, textContent, type) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90006-127]
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
    at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
    at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
    at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:694)
    at net.frontlinesms.data.repository.hibernate.BaseHibernateDao.saveWithoutDuplicateHandling(BaseHibernateDao.java:68)
    at net.frontlinesms.data.repository.hibernate.HibernateMessageDao.saveMessage(HibernateMessageDao.java:242)
    at net.frontlinesms.FrontlineSMS.sendMessage(FrontlineSMS.java:448)
    at net.frontlinesms.FrontlineSMS.sendTextMessage(FrontlineSMS.java:490)
    at net.frontlinesms.ui.UiGeneratorController.sendMessage(UiGeneratorController.java:754)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at thinlet.Thinlet.invokeImpl(Thinlet.java:4585)
    at thinlet.Thinlet.invoke(Thinlet.java:4554)
    at thinlet.Thinlet.handleMouseEvent(Thinlet.java:3836)
    at thinlet.Thinlet.processEvent(Thinlet.java:2946)
    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.<unknown>(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.<unknown>(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)
Caused by: class org.h2.jdbc.JdbcSQLException :: NULL not allowed for column "DISPATCHDATE"; SQL statement:
insert into message (id, binaryMessageContent, date, dtype, recipientMsisdn, recipientSmsPort, retriesRemaining, senderMsisdn, smsPartsCount, smscReference, status, textContent, type) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90006-127]
    at org.h2.message.Message.getSQLException(Message.java:110)
    at org.h2.message.Message.<init>(SQLException.class:0)
    at org.h2.message.Message.getSQLException(Message.java:74)
    at org.h2.table.Column.validateConvertUpdateSequence(Column.java:296)
    at org.h2.table.Table.validateConvertUpdateSequence(Table.java:599)
    at org.h2.command.dml.Insert.insertRows(Insert.java:116)
    at org.h2.command.dml.Insert.update(Insert.java:82)
    at org.h2.command.CommandContainer.update(CommandContainer.java:71)
    at org.h2.command.Command.executeUpdate(Command.java:199)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:129)
    at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator$.java:94)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2186)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2666)
    at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
    at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)
    at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
    at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
    at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
    at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:562)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:550)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:546)
    at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:697)
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
    at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
    at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:694)
    at net.frontlinesms.data.repository.hibernate.BaseHibernateDao.saveWithoutDuplicateHandling(BaseHibernateDao.java:68)
    at net.frontlinesms.data.repository.hibernate.HibernateMessageDao.saveMessage(HibernateMessageDao.java:242)
    at net.frontlinesms.FrontlineSMS.sendMessage(FrontlineSMS.java:448)
    at net.frontlinesms.FrontlineSMS.sendTextMessage(FrontlineSMS.java:490)
    at net.frontlinesms.ui.UiGeneratorController.sendMessage(UiGeneratorController.java:754)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at thinlet.Thinlet.invokeImpl(Thinlet.java:4585)
    at thinlet.Thinlet.invoke(Thinlet.java:4554)
    at thinlet.Thinlet.handleMouseEvent(Thinlet.java:3836)
    at thinlet.Thinlet.processEvent(Thinlet.java:2946)
    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.<unknown>(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.<unknown>(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)

[Geoffrey Muchai]

Hello Aden,

I have looked through this stack trace and I would like to know whether you recently updated your version of FrontlineSMS. If not, what version are you running? I would also like to know whether you have knowingly fiddled with your database structure.

Regards,

Geoffrey

[Aden]

Dear Geoffrey,

I am using version 1.6.16.3

I have Knowingly fiddled with my database structure.

Thanks

Aden.

[Aden]

Dear Geoffrey,

I am using version 1.6.16.3

I have Knowingly fiddled with my database structure.

Thanks

Aden

[Geoffrey Muchai]

Hi Aden,

If this is the case, then I would advise you to drop the "DISPATCHDATE" column and restart the application.

Regards,

Geoffrey

[Aden]

Dear Geoffrey,

I have not seen the ''DISPATCHDATE'' column. Please advise.

Thanks,

Aden

[Geoffrey Muchai]

Hello Aden,

Which table were you looking in?

Regards,

Geoffrey

[Aden]

Hello Geoffrey,

iam looking the home page of fronlineSMS.

[Geoffrey Muchai]

Hello Aden,

Would you care to tell me how you are going about the process of sending the SMS and the point at which the error is raised. I would also like to know how what modifications you made to the database structure.

I look forward to resolving this problem so that you can continue using frontlinesms well.

Regards,

Geoffrey

[Aden]

Dear Geoffrey,

I go to send sms, write and click send, i get an alart showing unexpected error.

thanks 

aden

[Geoffrey Muchai]

Hi Aden,

Kindly sent us a copy of your database and after backing it up, delete it and restart the application. It should automatically recreate the database. If this problem persists, kindly reinstall the application.

If the problem still persists, kindly get back to us and we will see what to do then.

Regards,

Geoffrey

[Aden]

 Hi 

I dont have your email adress

aden