[Topic] Creat report problem

Hello, i have a problem when creating the report, it said:

Attempt to insert null into a non-nullable column: INQUIRY_ID table: REPORT in statement [INSERT into REPORT

Is there anything i miss to setup or other possibility cause this?

Also, when i try to see Help > about Agile Track
it just pop-up a blank screen, is it correct?

"AgileTrack Version 1.2.0 Released"
OS (Windows xp, sp2)
Java platform (Standard edition 6 (build 1.6.0_07-b06)

—Posted by max on Aug 16, 2008

I tried reproducing the error a couple ways and so far haven't found anything.

Could you check to see if there is a stack trace in the log files—agiletrack-info.log or agiletrack-client.log—and post it here?

Also, what database are you using—HSQLDB, MySQL, or SQLServer?

Thanks.

—Posted by Adam Lane on Aug 17, 2008 at 10:21:32 AM

Thanks for you information, yes, i found the log file and i am using the HSQLDB. But i think i miss to setup some inquires from the "show administrator" tab, once i create a inquire, the error gone.

Below is the contents of the log file (i think the first part):

573437 [AWT-EventQueue-1] ERROR: persistence.GenericFullTextIndexer – Problem performing search
org.apache.lucene.queryParser.ParseException: Lexical error at line 1, column 1. Encountered: "*" (42), after : ""

at org.apache.lucene.queryParser.QueryParser.parse(QueryParser.java:125) at agiletrack.server.persistence.GenericFullTextIndexer.search(GenericFullTextIndexer.java:271) at agiletrack.server.persistence.GenericSQLDatabase.findIssues(GenericSQLDatabase.java:1018) at agiletrack.server.persistence.GenericSQLDatabase.findIssues(GenericSQLDatabase.java:1454) at agiletrack.server.persistence.GenericSQLDatabase.findRecords(GenericSQLDatabase.java:565) at agiletrack.server.persistence.TrackerCachedPersistence.findRecords(TrackerCachedPersistence.java:152) at agiletrack.server.TrackerModel.findRecords(TrackerModel.java:823) at agiletrack.server.controller.TrackerLocalAccess.search(TrackerLocalAccess.java:95) at agiletrack.client.controller.TrackerServerBridge.findInternalRecords(TrackerServerBridge.java:387) at agiletrack.client.controller.TrackerServerBridge.findRecords(TrackerServerBridge.java:208) at agiletrack.data.report.ReportDataGenerator.setReport(ReportDataGenerator.java:96) at agiletrack.client.view.widgets.tray.ReportPanel$5.actionPerformed(ReportPanel.java:220) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6041) at javax.swing.JComponent.processMouseEvent(JComponent.java:3265) at java.awt.Component.processEvent(Component.java:5806) at java.awt.Container.processEvent(Container.java:2058) at java.awt.Component.dispatchEventImpl(Component.java:4413) at java.awt.Container.dispatchEventImpl(Container.java:2116) at java.awt.Component.dispatchEvent(Component.java:4243) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916) at java.awt.Container.dispatchEventImpl(Container.java:2102) at java.awt.Window.dispatchEventImpl(Window.java:2440) at java.awt.Component.dispatchEvent(Component.java:4243) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at agiletrack.awt.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:54) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160) at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
—Posted by max on Aug 18, 2008 at 10:12:25 AM


You may post a reply to this topic, but you must be logged in. If you already have an account, you may login now. If you need to create an account, you may also register now.