One of the tables not loading in postgres [May 09]

Discord-Discussions
21

:person_tipping_hand: o1lab replied

If you click 5 times on the white space seen on to right of ā€˜Moreā€™

22

:person_tipping_hand: o1lab replied

you will see few buttons pop open

23

:person_tipping_hand: o1lab replied

you can click debug button

24

:person_tipping_hand: o1lab replied

it will then show - model json for that particular table

25

:person_tipping_hand: o1lab replied

could you please DM that model json

26

:raising_hand_man: marco_santulli replied

ok I will do it, also I see this, not sure it matters:

27

:raising_hand_man: marco_santulli replied

fae59e0.js:2 Table ā€˜undefinedā€™ is not found in the table list

(anonymous) @ fae59e0.js:2

f @ ec125e7.js:2

(anonymous) @ ec125e7.js:2

D.forEach.t. @ ec125e7.js:2

r @ 1f77400.js:2

l @ 1f77400.js:2

(anonymous) @ 1f77400.js:2

(anonymous) @ 1f77400.js:2

ActLoadMeta @ fae59e0.js:2

(anonymous) @ 1f77400.js:2

m.dispatc

28

:person_tipping_hand: o1lab replied

probably this might be causing itā€¦ do you see that table exists in your postgres ?

29

:raising_hand_man: marco_santulli replied

yes, also I tried doing a reload on metadata

30

:raising_hand_man: marco_santulli replied

(I canā€™t do that debug thing on that table because when I select the table the front-end becomes unresponsive)

31

:person_tipping_hand: o1lab replied

ah ok

32

:person_tipping_hand: o1lab replied

please DM create table command for that particular table

33

:person_tipping_hand: o1lab replied

will see if we are missing something while migrating

34

:raising_hand_man: marco_santulli replied

or rather not unresponsive, but events donā€™t work, the UI is alive but when you click on something nothing happens

35

:raising_hand_man: marco_santulli replied

CREATE TABLE public.fornitori (

id serial4 NOT NULL,

ā€œIDAccountFornitoreā€ varchar NOT NULL,

created_at timestamp NULL DEFAULT now(),

updated_at timestamp NULL DEFAULT now(),

ā€œCodiceFiscaleā€ varchar NULL,

ā€œEmailAddressā€ varchar NULL,

ā€œRagioneSocialeā€ varchar NULL,

ā€œScadenzaDurcā€ date NULL,

ā€œUltimoDurcā€ text NULL,

ā€œIsPrimeā€ bool NULL,

ā€œIsActiveā€ bool NULL,

ā€œNazioneā€ varchar NULL,

fornitori_id int4 NULL,

ā€œisInailRegolareā€ bool NULL,

ā€œisInpsRegolareā€ bool NULL,

ā€œStatusā€ varchar NULL,

ā€œLastRefreshā€ timestamp NULL DEFAULT now(),

ā€œActionā€ varchar NULL,

sapid varchar NULL,

statusdurc varchar NULL,

ā€œSourceā€ varchar NULL,

statusdurcdate timestamp NULL,

statusdurccommento varchar NULL,

note varchar NULL,

isbloccatosap bool NULL DEFAULT false,

ultimodurc text NULL,

lastrefresh timestamp NULL,

isbloccatosapreason varchar NULL,

CONSTRAINT fornitori_pkey PRIMARY KEY (id),

CONSTRAINT fornitori_un UNIQUE (ā€œIDAccountFornitoreā€),

CONSTRAINT fornitori_fornitori_id_foreign FOREIGN KEY (fornitori_id) REFERENCES public.fornitori(id)

);

36

:raising_hand_man: marco_santulli replied

create trigger xc_trigger_fornitori_updated_at before

update

on

public.fornitori for each row execute function xc_au_fornitori_updated_at();

37

:person_tipping_hand: o1lab replied

ok, thank you

donā€™t see anything which should cause the problem

38

:raising_hand_man: marco_santulli replied

it seems like a front-end issue

39

:raising_hand_man: marco_santulli replied

because the API responds correctly

40

:raising_hand_man: marco_santulli replied

{list: [{Id: 6634, IDAccountFornitore: ā€œ4320ā€, CreatedAt: ā€œ2022-03-21T16:15:37.093Zā€,ā€¦},ā€¦],ā€¦}

list: [{Id: 6634, IDAccountFornitore: ā€œ4320ā€, CreatedAt: ā€œ2022-03-21T16:15:37.093Zā€,ā€¦},ā€¦]

pageInfo: {totalRows: 57, page: 1, pageSize: ā€œ25ā€, isFirstPage: true, isLastPage: false}