SQL problem saving reports
| Status: |
Open |
Complete: |
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)
|