Installations of sipFoundry Canary that are being upgraded to sipXcom will require a special procedure to ensure full DB compatibility. So, the recommended upgrade method would generally be as follows:
psql -U postgres SIPXCONFIG alter table e911 rename to e911_erl; ALTER TABLE e911_erl RENAME COLUMN e911_id TO erl_id; create sequence erl_seq; ALTER TABLE e911_erl ADD column ip_addr_start character varying; ALTER TABLE e911_erl ADD column ip_addr_end character varying; \q service sipxconfig restart
At this point you're installation will have the corrected DB structure for sipXcom and therefore be functioning normally. To confirm that the installation is now functioning correctly from a DB perspective, log into the sipXcom system UI and send profiles to the server. Ensure that this completes without error in the Job Status page.
Note: Testing of this method was not performed for a case where data existed in the original e911 table from the sipFoundry system.