unable to start server

[Ankur Rangwala]

Hello 

i am getting below error while running server-start.

INFO    [main]          06 Aug 2021 21:20:03 GMT Exporting TRIGGERREASON

INFO    [main]          06 Aug 2021 21:20:03 GMT Exporting TRIGGERREASONID

INFO    [main]          06 Aug 2021 21:20:03 GMT Exporting TRIGGERREASONJOBID

INFO    [main]          06 Aug 2021 21:20:03 GMT Exporting TRIGGERSEQNO

INFO    [main]          06 Aug 2021 21:20:03 GMT Exporting TRIGGERTYPE

INFO    [main]          06 Aug 2021 21:20:03 GMT Exporting LAST_WARNING

INFO    [main]          06 Aug 2021 21:20:03 GMT Exporting WORKDIR

INFO    [main]          06 Aug 2021 21:20:03 GMT JDBC Driver used : PostgreSQL Native Driver

INFO    [main]          06 Aug 2021 21:20:03 GMT Acquire repository lock for 1628284803324

INFO    [main]          06 Aug 2021 21:20:03 GMT Lock Acquisition for 1628284803324 failed

ERROR   [main]          06 Aug 2021 21:20:03 GMT Error while getting Ticket: ERROR: relation "repository_lock" does not exist

  Position: 8

ERROR   [main]          06 Aug 2021 21:20:03 GMT ****************** Start Stacktrace *********************

ERROR   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:168)

ERROR   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.RenewTicketThread.getTicket(RenewTicketThread.java:207)

ERROR   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.Server.initRenewTicketThread(Server.java:113)

ERROR   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.Server.serverMain(Server.java:460)

ERROR   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.BICServer.main(BICServer.java:144)

ERROR   [main]          06 Aug 2021 21:20:03 GMT ****************** End Stacktrace   *********************

ERROR   [main]          06 Aug 2021 21:20:03 GMT Error while getting Ticket

ERROR   [main]          06 Aug 2021 21:20:03 GMT ****************** Start Stacktrace *********************

ERROR   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:168)

ERROR   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.exception.FatalException.<init>(FatalException.java:50)

ERROR   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.RenewTicketThread.getTicket(RenewTicketThread.java:208)

ERROR   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.Server.initRenewTicketThread(Server.java:113)

ERROR   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.Server.serverMain(Server.java:460)

ERROR   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.BICServer.main(BICServer.java:144)

ERROR   [main]          06 Aug 2021 21:20:03 GMT ****************** End Stacktrace   *********************

FATAL   [main]          06 Aug 2021 21:20:03 GMT Fatal exception while loading Repository:

Error while getting Ticket

FATAL   [main]          06 Aug 2021 21:20:03 GMT ****************** Start Stacktrace *********************

FATAL   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:168)

FATAL   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.Server.serverMain(Server.java:469)

FATAL   [main]          06 Aug 2021 21:20:03 GMT de.independit.scheduler.BICServer.main(BICServer.java:144)

FATAL   [main]          06 Aug 2021 21:20:03 GMT ****************** End Stacktrace   *********************

INFO    [Shutdown]      06 Aug 2021 21:20:03 GMT ***********************************************

INFO    [Shutdown]      06 Aug 2021 21:20:03 GMT **                                           **

INFO    [Shutdown]      06 Aug 2021 21:20:03 GMT ** U N G R A C E F U L   S H U T D O W N ! ! **

INFO    [Shutdown]      06 Aug 2021 21:20:03 GMT **                                           **

INFO    [Shutdown]      06 Aug 2021 21:20:03 GMT ***********************************************

INFO    [Shutdown]      06 Aug 2021 21:20:03 GMT Release repository lock from 1628284803324

ERROR   [Shutdown]      06 Aug 2021 21:20:03 GMT Error while unlocking repository

ERROR   [Shutdown]      06 Aug 2021 21:20:03 GMT ****************** Start Stacktrace *********************

ERROR   [Shutdown]      06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:168)

ERROR   [Shutdown]      06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.ShutdownThread.SDMSrun(ShutdownThread.java:102)

ERROR   [Shutdown]      06 Aug 2021 21:20:03 GMT de.independit.scheduler.server.util.SDMSThread.run(SDMSThread.java:225)

ERROR   [Shutdown]      06 Aug 2021 21:20:03 GMT ****************** End Stacktrace   *********************

INFO    [Shutdown]      06 Aug 2021 21:20:03 GMT Shutdown completed

[scrolllog] Waiting for child (20979) to terminate

[scrolllog] Child exited with state 1

[scrolllog] Try to restart child (child terminated with exit code <> 0)

Thanks and Regards

Ankur

[Ronald Jeninga]

Hi Ankur,

if the system can't find the REPOSITORY_LOCK table, it is either using the wrong schema, or something went wrong in setting up the schema.

Could you please check which tables and views are present in the database schema you've cconfigured?

If you don't find any tables or views, you've simply forgotten to create the schema. You'll find instructions in the installation guide on how to setup the schema.

If only the REPOSITORY_LOCK table is missing, it would be extremely interesting to find out how that could happen.

Especially if you've been using the system for a while already, it seems impossible that a table simply vanishes from a database.

If you didn't use the system yet, the easiest way to get it right is to drop and recreate the schema, following the instructions from the installation guide.

HTH

Ronald