Re: Critical Error Pop up at Client App Check-In

Posted by Verus Open Source Support on Jan 16, 2024; 5:47am
URL: http://ngl.70.s1.nabble.com/Critical-Error-Pop-up-at-Client-App-Check-In-tp7577798p7577807.html

Dear Angel.

Tell me the NGL Version & Java version installed.

Run the below sql query in the database for missing adm_co_material_type Table

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_with_oids = true;

    material_type_id integer NOT NULL,
    material_type character varying(100)
);


ALTER TABLE public.adm_co_material_type OWNER TO postgres;

COPY public.adm_co_material_type (material_type_id, material_type) FROM stdin;
1 Architectural Drawing
2 Archival Manuscript/Mixed Material
3 Videotape
4 Atlas
5 Audio Recording
6 Audio Tape
7 Blue prints
8 Book (Print, Microform, Electronic, etc.)
9 Sound Recordings
10 Cartographic Material
11 Cartographic Material (Manuscript)
12 CD-ROM
13 Compact Disc (Audio)
14 Computer File
15 Digital File
16 Drawing
17 Electronic Resource
18 Engineering Drawing
19 Film
20 Filmstrip
21 Fine Print
22 Globe
23 Journal Publication
24 Language Material
25 Magazine
26 Manuscript Cartographic Material
27 Manuscript Material
28 Manuscript Music
29 Map
30 Microform
31 Mixed Material
32 Moving Image or Slide/Transparency
33 Motion Picture
34 Music (Manuscript)
35 Music (Printed)
36 Music Sound Recording
37 Newspaper
38 Nonmusic Sound Recording
39 Painting
40 Pamphlet
41 Periodical
42 Photograph, Print, Drawing
43 Photonegative
44 Postcard
45 Portrait
46 Poster
47 Print
48 Printed Music
49 Projected Medium
50 Recording, Music
51 Recording, Nonmusic
52 Serial (Periodical, Newspaper, etc.)
53 Sheet Music
54 Slide
55 Software, Computer
56 Sound Recording, Music
57 Sound Recording, Nonmusic
58 Spoken Word Recording
59 Television Program
60 Transparency
61 Two-dimensional Nonprojectable Graphic
62 Videorecording
63 Reference material
\.

ALTER TABLE ONLY public.adm_co_material_type
    ADD CONSTRAINT adm_co_material_type_pkey PRIMARY KEY (material_type_id);