Database Error on SLA creation

[lentferj]

Dear all,

I am trying out OTRS:ITSM (2.4.9/2.1.1) with a PostgreSQL 8.4.5 backend. I followed the installation document and according to the package manager everything is installed correclty.

When I want to add a new SLA I receive this error:
ERROR: OTRS-CGI-10 Perl: 5.12.2 OS: dragonfly Time: Tue Nov 30 23:37:51 2010

Message: ERROR: null value in column "service_id" violates not-null constraint, SQL: 'INSERT INTO sla (name, calendar_name, first_response_time, first_response_notify, update_time, update_notify, solution_time, solution_notify, valid_id, comments, create_time, create_by, change_time, change_by, type_id, min_time_bet_incidents) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?, ?, ?)'

Traceback (41323):
Module: Kernel::System::SLA::SLAAdd (v1.5) Line: 506
Module: Kernel::Modules::AdminSLA::Run (v1.5) Line: 270
Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819
Module: ModPerl::ROOT::ModPerl::Registry::usr_pkg_share_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 48
Module: (eval) (v1.88) Line: 204
Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

-----

If I understand it correctly the column service_id exists in table "sla" but it is assigned no value in the INSERT statement, which violates the constraint.

Is this a bug or am I missing something / doing something wrong?

Thanks a lot in advance for any help!

Jan

[lentferj]

Hmm...

It seems I have not correctly and completley installed the database upgrades from 2.2 to 2.3 and finally 2.4. After cross-checking the schemas and applying the differences again the error is gone.

Sorry for the noise

Jan