"Room availability is not available for classes."

[Matt Lambie]

When viewing the Timetable Grid with an in-memory solution I see a warning message indicating that room availability is not available for classes. The timetable doesn't show any events, and I also note the problem: 

>>>FATAL: Unable to load input data, reason: <<<
java.lang.NullPointerException: null

Does anyone know why room availability is not available for classes? All of the rooms are managed wtihin UniTime (there's no external integration).

Thanks,

Matt

[Tomáš Müller]

Hi Matt,

Is there any error in the Tomcat log?

Regards,

Tomas

--
You received this message because you are subscribed to the Google Groups "UniTime Discussion Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to unitime-discu...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/unitime-discuss/618b1bac-8ed0-440d-bff6-308d6bea4132n%40googlegroups.com.

[Matt Lambie]

The room availbility information becomes available when a timetable is solved and accepted, it seems, so that error has cleared.

Hhowever the Tomcat logs still show an error when attempting to run the solver, reloading the input. Including the surrounding log entries:

10-Dec-25 05:20:56.398 [http-nio-8080-exec-7] INFO  heuristics.StandardNeighbourSelection> Using org.cpsolver.coursett.heuristics.LectureSelection
10-Dec-25 05:20:56.398 [http-nio-8080-exec-7] INFO  heuristics.StandardNeighbourSelection> Using org.cpsolver.coursett.heuristics.PlacementSelection
10-Dec-25 05:20:56.398 [http-nio-8080-exec-7] INFO  heuristics.StandardNeighbourSelection> Using org.cpsolver.coursett.heuristics.LectureSelection
10-Dec-25 05:20:56.398 [http-nio-8080-exec-7] INFO  solver.Solver> Using org.cpsolver.coursett.heuristics.UniversalPerturbationsCounter
10-Dec-25 05:20:56.398 [http-nio-8080-exec-7] INFO  solver.Solver> Using org.cpsolver.ifs.extension.ConflictStatistics
10-Dec-25 05:20:56.400 [Thread-106] INFO  util.Progress> [Loading input data ...]
10-Dec-25 05:20:56.696 [Thread-106] FATAL util.Progress> Unable to load input data, reason:
java.lang.NullPointerException
10-Dec-25 05:20:56.697 [Thread-106] INFO  util.Progress> [Awaiting commands ...]
10-Dec-25 05:20:59.207 [http-nio-8080-exec-5] INFO  solver.Solver> Using org.cpsolver.ifs.termination.MPPTerminationCondition
10-Dec-25 05:20:59.207 [http-nio-8080-exec-5] INFO  solver.Solver> Using org.cpsolver.coursett.heuristics.TimetableComparator
10-Dec-25 05:20:59.207 [http-nio-8080-exec-5] INFO  solver.Solver> Using org.cpsolver.ifs.algorithms.SimpleSearch
10-Dec-25 05:20:59.207 [http-nio-8080-exec-5] INFO  heuristics.StandardNeighbourSelection> Using org.cpsolver.coursett.heuristics.PlacementSelection
10-Dec-25 05:20:59.207 [http-nio-8080-exec-5] INFO  heuristics.StandardNeighbourSelection> Using org.cpsolver.coursett.heuristics.LectureSelection
10-Dec-25 05:20:59.207 [http-nio-8080-exec-5] INFO  heuristics.StandardNeighbourSelection> Using org.cpsolver.coursett.heuristics.PlacementSelection

--

Noting that there appears to be an error much further up the chain, when UniTime attempts to upgrade the database from version 273 to 274. I'm running this instance of UniTime via Docker Compose, so the database was created on first launch. Is this likely to be related? I use Course Projections within a Curriculum because I am timetabling for a student cohort and this is working. Error in the logs when attempting to apply the index: 

10-Dec-25 02:49:16.373 [main] WARN  util.DatabaseUpdate> Cause: Table 'timetable.STUDENT_ENRL' doesn't exist
10-Dec-25 02:49:16.387 [main] INFO  util.DatabaseUpdate>     UniTime Database version increased to: 274
10-Dec-25 02:49:16.392 [main] INFO  util.DatabaseUpdate> New UniTime database version: 273

[Tomáš Müller]

I'm not sure why the error isn't showing in the logs; it usually is. It typically appears on the solver log page as well.

The individual database update scripts are available at github.com/UniTime/unitime/tree/master/Documentation/Database/MySQL/Changes. The change from version 273 to 274 is in the file 274 Student Enrollments Index.sql. The missing table is being created by schema.sql. The issue may be that your MySQL is configured with case-sensitive table names (this is based on the operating system settings, unless lower_case_table_names is set in my.cnf, which ensures all table names are lowercase). To be sure, I will update the table name to lowercase.

Regards,

Tomas

To view this discussion visit https://groups.google.com/d/msgid/unitime-discuss/ae773a79-3785-4745-8d13-1cc5f24dc969n%40googlegroups.com.