#1 Can't add assessment.

[Carwyn Edwards]

I have a simple database based on the backup.sql set up
(backup.sql is broken for postgresql btw) but get the
following error when I try and add assessments:

Sep 24, 2003 3:07:41 PM [ERROR ] : Could not
establish list of assessments(#7)Sep 24, 2003 3:07:41
PM [ERROR ] : "uk.ac.warwick.coresoft.DataBaseException:
CoreSoft database error:
selectUniqueInteger(component,maxmark,code='Root' AND
assessment_code='cw1' AND module_code='CS2' AND
year_of_study_code='03/04' AND delivery_code='A')
returned 0 hits"
Sep 24, 2003 3:07:41 PM [ERROR ] :
uk.ac.warwick.coresoft.DataBaseImplCore.selectUniqueInteger(DataBaseImplCore.java:241)
uk.ac.warwick.coresoft.DataBase.getComponentMaxMark(DataBase.java:3402)
uk.ac.warwick.coresoft.GenericComponent.<init>(GenericComponent.java:191)
uk.ac.warwick.coresoft.MultiComponent.<init>(MultiComponent.java:88)
uk.ac.warwick.coresoft.Assessment.<init>(Assessment.java:222)
uk.ac.warwick.coresoft.DeliveredModule.getAssessments(DeliveredModule.java:552)
uk.ac.warwick.dcs.cobalt.boss.server.StaffServerImpl.validate(StaffServerImpl.java:788)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
sun.rmi.transport.Transport$1.run(Transport.java:148)
java.security.AccessController.doPrivileged(Native Method)
sun.rmi.transport.Transport.serviceCall(Transport.java:144)
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
java.lang.Thread.run(Thread.java:534)

I'm debugging it at the moment.

[David Buckley]

Logged In: YES
user_id=85916

Did you change any of the module codes in the backup.sql file?

I think the problem you're having here is that the code
expects every assessment to have a "root" component in the
components table, and the code currently doesn't attempt to
fix the problem should one not exist. If you've changed the
module code of the assignment but not the corresponding
component, BOSS won't be able to load information on the
component, hence the exception.

If you're just trying to set up a basic database, it's
probably a better idea to use the populate.sql file in the
SQL directory, which will create the bare minimum you need
to fire up BOSS. You can add all the extra assignments etc.
later.