Error assigning DID to a customer

Skip to first unread message

Justin Hannah

Jun 19, 2023, 11:11:36 PM6/19/23
to dnl-class4-user

(raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (psycopg2.errors.UndefinedTable) relation "did_client_log" does not exist LINE 1: INSERT INTO did_client_log (did, client_id, buy_billing_plan...

Getting this error popup when trying to assign a DID to a customer.

Also, the only country available in Country drop down is Canada.  In Configuration -> Code Deck List there is US but the list is empty, also A-Z is empty too.

Justin Hannah

Jun 23, 2023, 1:39:31 PM6/23/23
to dnl-class4-user
Fixed this with some help from Anne, also troubleshooting packages myself.

Some Rocky Linux dependency hell fixes:

#Disable system postgresql module and use postgres15 client
sudo dnf -qy module disable postgresql

# Lack of this package prevents postgres15 from installing successfully
dnf --enablerepo=powertools install perl-IPC-Run -y

# psql - Was missing this table in the current rocky RPMs please fix
CREATE TABLE public.did_client_log (
    id integer NOT NULL,
    did character varying(50) NOT NULL,
    client_id integer,
    assigned_on timestamp with time zone,
    assigned_by integer,
    released_on timestamp with time zone DEFAULT now(),
    released_by integer,
    assign_method smallint,
    release_method smallint,
    created_on timestamp with time zone DEFAULT now(),
    sell_billing_plan_id integer,
    egress_res_id integer,
    ingress_res_id integer,
    start_date timestamp with time zone,
    buy_billing_plan_id integer

#  But then this problem occurs... ERROR Null Value In Column "Id" Of Relation "DidClientLog" Violates Not-Null Constraint Detail: Failing Row Contains (Null, 17028880001, 2, 2023-06-23 09:33:58.065066-05, 1, Null, Null, 0, Null, 2023-06-23 09:33:58.122461-05, 1, Null, 1, Null, 2). with = passed in , does not exist in the Database

# Some help from ChatGPT our lord and savior came up with this fix:

class4_dnl=# ALTER TABLE public.did_client_log DROP COLUMN id;
class4_dnl=# ALTER TABLE public.did_client_log
class4_dnl-# ADD COLUMN id integer DEFAULT nextval('public.did_client_log_id_seq') NOT NULL;

NOW, I found a different UI bug where in normal DID repository listing you can not un-reserve a DID (uncheck and save does nothing).  You have to go to DID Vendor first, and click the View DIDs button which takes you to https://switch-host/#/origination/did_repository_list/by_vendor/1 and on this page the repo checkbox works right.  Can you please fix this in the code on the regular DID repo page.

Anne Kwong

Jun 25, 2023, 8:04:59 PM6/25/23
to Justin Hannah, dnl-class4-user
Hi Justin

Thanks alot for your update and contribution to this group.

This is a temporary issue and will be totally eliminated once our
redesigned DID routing module is done with testing.

Anne Kwong
Chief Architect
> --
> Useful Links:
> Get Help -
> Tutorial -
> Video Training -
> User Manual -
> ---
> You received this message because you are subscribed to the Google Groups "dnl-class4-user" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to
> To view this discussion on the web visit

Pradeep Patidar

Aug 14, 2023, 7:04:05 PM8/14/23
to dnl-class4-user

Our DID redesgined is still in progress but now we fixed the DID assignment issue.

Now user can assign the DIDs to the client without any error.


Reply all
Reply to author
0 new messages