[Defect] SQL problem saving reports

Status: [ ] Open Complete: [Incomplete] Incomplete
Importance: [ ]   Urgency: [ ]  
Severity: [ ]   Frequency: [ ]  
Release: [ ]  

Description

4583359 [AWT-EventQueue-1] ERROR: hsqldb.TrackerHSQLDatabase – {reportTimeSpan=Today,reportSources=[],reportUserID=159,customData={},revision=175,modifiedDate=Fri Dec 25 11:26:35 PST 2009,deleted=false,name=3rd party test,createdDate=Fri Dec 25 11:26:35 PST 2009,createdBy=159,id=292,type=Report}
java.sql.SQLException: Attempt to insert null into a non-nullable column: column: INQUIRY_ID table: REPORT in statement [INSERT INTO report(id, user_id, sources, inquiry_id, time_span, start_date, end_date) VALUES (?, ?, ?, ?, ?, ?, ?)]

at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at agiletrack.server.persistence.DatabaseResourceProvider.executeUpdate(DatabaseResourceProvider.java:123) at agiletrack.server.persistence.GenericSQLDatabase.createRecord(GenericSQLDatabase.java:908) at agiletrack.server.persistence.GenericSQLDatabase.saveRecord(GenericSQLDatabase.java:428) at agiletrack.server.persistence.TrackerCachedPersistence.saveRecord(TrackerCachedPersistence.java:100) at agiletrack.server.TrackerModel.saveRecord(TrackerModel.java:443) at agiletrack.server.controller.TrackerLocalAccess.save(TrackerLocalAccess.java:64) at agiletrack.client.controller.TrackerServerBridge.saveRecord(TrackerServerBridge.java:125) at agiletrack.data.TrackerEnhancedLoaderDefault.saveRecord(TrackerEnhancedLoaderDefault.java:139) at agiletrack.data.TrackerEnhancedLoaderDefault.createReport(TrackerEnhancedLoaderDefault.java:558) at agiletrack.client.controller.TrackerSession.createReport(TrackerSession.java:415) at agiletrack.client.view.widgets.tray.ReportPanel.internalOnSave(ReportPanel.java:403) at agiletrack.client.view.widgets.tray.RecordPanel.onSave(RecordPanel.java:650) at agiletrack.client.view.widgets.tray.ReportPanel.internalOnCreate(ReportPanel.java:414) at agiletrack.client.view.widgets.tray.RecordPanel.onCreate(RecordPanel.java:659) at agiletrack.client.view.widgets.tray.RecordPanel$27.actionPerformed(RecordPanel.java:734) 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.dispatchEvent(Unknown Source) at agiletrack.awt.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:54) 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)

You can add comments to this issue, but you must be logged in. If you already have an account, you can login now. If you need to create an account, you may also register now.