[Health] Health Specialty: Key (specialty)=(32) is not present in table "gnuhealth_hp_specialty".

[ronald munjoma]

Dear All,

I tried to update my local install to test the GNU Health professional auto fill functionality and I am getting the below trace back

[Tue Aug 06 15:43:13 2013] ERROR:sql:Wrong SQL: ALTER TABLE "gnuhealth_physician" ADD FOREIGN KEY ("specialty") REFERENCES "gnuhealth_hp_specialty" ON DELETE SET NULL

Traceback (most recent call last):

  File "./trytond", line 109, in <module>

    trytond.server.TrytonServer(options).run()

  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/server.py", line 131, in run

    Pool(db_name).init(update=update, lang=lang)

  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/pool.py", line 134, in init

    lang=lang)

  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/modules/__init__.py", line 391, in load_modules

    load_module_graph(graph, pool, lang)

  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/modules/__init__.py", line 229, in load_module_graph

    cls.__register__(module)

  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/model/modelsql.py", line 151, in __register__

    table.add_fk(field_name, ref, field.ondelete)

  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/backend/postgresql/table.py", line 301, in add_fk

    'ON DELETE ' + on_delete)

  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/backend/postgresql/database.py", line 308, in execute

    res = self.cursor.execute(sql)

psycopg2.IntegrityError: insert or update on table "gnuhealth_physician" violates foreign key constraint "gnuhealth_physician_specialty_fkey"

DETAIL:  Key (specialty)=(32) is not present in table "gnuhealth_hp_specialty".

Thanks and Regards

Ronald Munjoma