Error assigning DID to a customer

[Justin Hannah]

ERROR

(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]

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;
ALTER TABLE
class4_dnl=# ALTER TABLE public.did_client_log
class4_dnl-# ADD COLUMN id integer DEFAULT nextval('public.did_client_log_id_seq') NOT NULL;
ALTER TABLE

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]

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.

Thanks,
Anne Kwong
Chief Architect
Denovolab

> --
> Useful Links:
> Get Help - http://support.denovolab.com
> Tutorial - http://cookbook.denovolab.com
> Video Training - https://www.youtube.com/channel/UCIVrN4OSdY-r4l_FA4ekIBA
> User Manual - http://doc.denovolab.com
> ---
> 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 dnl-class4-us...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/dnl-class4-user/fa77dc2b-bfdb-4eb9-b091-1818a000a6a8n%40googlegroups.com.

[Pradeep Patidar]

Hello,

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.