Critical Error Pop up at Client App Check-In

[Angel]

Hi dear,

what could probably be the problem. pls advise.


backend log screen shows as below

org.jdom.JDOMException: Error on line 1: The root element is required in a well-formed document.
        at org.jdom.input.SAXBuilder.build(SAXBuilder.java:367)
        at org.jdom.input.SAXBuilder.build(SAXBuilder.java:740)
        at newgen.presentation.component.ServletConnector.sendRequest(ServletConnector.java:223)
        at newgen.presentation.MainFrame.setInitialData(MainFrame.java:244)
        at newgen.presentation.MainFrame.<init>(MainFrame.java:103)
        at newgen.presentation.MainFrame.getInstance(MainFrame.java:114)
        at newgen.presentation.LoginFrame.bnLoginActionPerformed(LoginFrame.java:443)
        at newgen.presentation.LoginFrame.access$400(LoginFrame.java:45)
        at newgen.presentation.LoginFrame$5.actionPerformed(LoginFrame.java:390)
        at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
        at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
        at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
        at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
        at java.awt.Component.processMouseEvent(Unknown Source)
        at javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Unknown Source)
        at java.awt.Container.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Window.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
        at java.awt.EventQueue.access$500(Unknown Source)
        at java.awt.EventQueue$3.run(Unknown Source)
        at java.awt.EventQueue$3.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
        at java.awt.EventQueue$4.run(Unknown Source)
        at java.awt.EventQueue$4.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; The root element is required in a well-formed document.
        at org.apache.xerces.framework.XMLParser.reportError(XMLParser.java:1056)
        at org.apache.xerces.framework.XMLDocumentScanner.reportFatalXMLError(XMLDocumentScanner.java:626)
        at org.apache.xerces.framework.XMLDocumentScanner$XMLDeclDispatcher.endOfInput(XMLDocumentScanner.java:842)
        at org.apache.xerces.framework.XMLDocumentScanner.endOfInput(XMLDocumentScanner.java:418)
        at org.apache.xerces.validators.common.XMLValidator.sendEndOfInputNotifications(XMLValidator.java:582)
        at org.apache.xerces.readers.DefaultEntityHandler.changeReaders(DefaultEntityHandler.java:1026)
        at org.apache.xerces.readers.XMLEntityReader.changeReaders(XMLEntityReader.java:168)
        at org.apache.xerces.readers.AbstractCharReader.changeReaders(AbstractCharReader.java:150)
        at org.apache.xerces.readers.AbstractCharReader.lookingAtChar(AbstractCharReader.java:217)
        at org.apache.xerces.framework.XMLDocumentScanner$XMLDeclDispatcher.dispatch(XMLDocumentScanner.java:742)
        at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381)
        at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:948)
        at org.jdom.input.SAXBuilder.build(SAXBuilder.java:354)
        ... 44 more
Caused by: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; The root element is required in a well-formed document.
        at org.apache.xerces.framework.XMLParser.reportError(XMLParser.java:1056)
        at org.apache.xerces.framework.XMLDocumentScanner.reportFatalXMLError(XMLDocumentScanner.java:626)
        at org.apache.xerces.framework.XMLDocumentScanner$XMLDeclDispatcher.endOfInput(XMLDocumentScanner.java:842)
        at org.apache.xerces.framework.XMLDocumentScanner.endOfInput(XMLDocumentScanner.java:418)
        at org.apache.xerces.validators.common.XMLValidator.sendEndOfInputNotifications(XMLValidator.java:582)
        at org.apache.xerces.readers.DefaultEntityHandler.changeReaders(DefaultEntityHandler.java:1026)
        at org.apache.xerces.readers.XMLEntityReader.changeReaders(XMLEntityReader.java:168)
        at org.apache.xerces.readers.AbstractCharReader.changeReaders(AbstractCharReader.java:150)
        at org.apache.xerces.readers.AbstractCharReader.lookingAtChar(AbstractCharReader.java:217)
        at org.apache.xerces.framework.XMLDocumentScanner$XMLDeclDispatcher.dispatch(XMLDocumentScanner.java:742)
        at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381)
        at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:948)
        at org.jdom.input.SAXBuilder.build(SAXBuilder.java:354)
        at org.jdom.input.SAXBuilder.build(SAXBuilder.java:740)
        at newgen.presentation.component.ServletConnector.sendRequest(ServletConnector.java:223)
        at newgen.presentation.MainFrame.setInitialData(MainFrame.java:244)
        at newgen.presentation.MainFrame.<init>(MainFrame.java:103)
        at newgen.presentation.MainFrame.getInstance(MainFrame.java:114)
        at newgen.presentation.LoginFrame.bnLoginActionPerformed(LoginFrame.java:443)
        at newgen.presentation.LoginFrame.access$400(LoginFrame.java:45)
        at newgen.presentation.LoginFrame$5.actionPerformed(LoginFrame.java:390)
        at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
        at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
        at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
        at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
        at java.awt.Component.processMouseEvent(Unknown Source)
        at javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Unknown Source)
        at java.awt.Container.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Window.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
        at java.awt.EventQueue.access$500(Unknown Source)
        at java.awt.EventQueue$3.run(Unknown Source)
        at java.awt.EventQueue$3.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
        at java.awt.EventQueue$4.run(Unknown Source)
        at java.awt.EventQueue$4.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.run(Unknown Source)

[Angel]

I tried that but in vain.

http://ngl.70.s1.nabble.com/critical-error-appeared-when-i-was-using-the-search-catalogue-tp7576607p7576613.html

[Angel]

Only NGL Client app has the issues.
Workbench has no issue checking in.

[Angel]

This is the backend server message

org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.loader.Loader.doList(Loader.java:2536)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
        at org.hibernate.loader.Loader.list(Loader.java:2271)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at ejb.objectmodel.administration.ADM_CO_MATERIAL_TYPEBean.findAll(ADM_CO_MATERIAL_TYPEBean.java:81)
        at ejb.bprocess.util.NewGenBean.initialLoadup(NewGenBean.java:217)
        at servlet.util.NewGenServlet.processRequest(NewGenServlet.java:92)
        at servlet.util.NewGenServlet.doPost(NewGenServlet.java:433)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:662)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "adm_co_material_type" does not exist
  Position: 105
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
        at org.hibernate.loader.Loader.doQuery(Loader.java:802)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
        at org.hibernate.loader.Loader.doList(Loader.java:2533)
        ... 25 more
java.lang.NullPointerException
        at ejb.bprocess.util.NewGenBean.initialLoadup(NewGenBean.java:218)
        at servlet.util.NewGenServlet.processRequest(NewGenServlet.java:92)
        at servlet.util.NewGenServlet.doPost(NewGenServlet.java:433)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:662)

[Angel]

ERROR: relation "adm_co_material_type" does not exist ??

[Angel]

Postgresql version is 9.0

[Angel]

Seems like the database related issue(missing table adm_co_material_type) according to this
https://linuxhint.com/postgres-relation-does-not-exist/

and this test query

[Verus Open Source Support]

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);

[Angel]

Hi dear,

Thanks for your reply.
The problem must have been database restoration.
Missing several tables some how during migration.
Now it is working fine.

Thanks.