FrontlineSMS

FrontlineSMS let users send, receive and manage SMS over a mobile network.

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)

Views: 212

Reply to This

Replies to This Discussion

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

Dear Geoffrey,

I am using version 1.6.16.3

I have Knowingly fiddled with my database structure.

Thanks

Aden.

Dear Geoffrey,

I am using version 1.6.16.3

I have Knowingly fiddled with my database structure.

Thanks

Aden

Hi Aden,

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

Regards,

Geoffrey

Dear Geoffrey,

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

Thanks,

Aden

Hello Aden,

Which table were you looking in?

Regards,

Geoffrey

Hello Geoffrey,

iam looking the home page of fronlineSMS.

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

Dear Geoffrey,

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

thanks 

aden

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

 Hi 

I dont have your email adress

aden

RSS

Photos

  • Add Photos
  • View All

© 2014   Created by FrontlineSMS Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service