U N G R A C E F U L S H U T D O W N ! ! after upgrading to 2.10

patrik....@gmail.com

unread,

Mar 1, 2023, 8:35:26 AM3/1/23

to schedulix

Hello,

I just upgraded to 2.10 and I am getting error after trying to start the server.

This is the error that repeats in the log:

ERROR [Thread-0] 01 Mar 2023 13:33:29 GMT SQL Error : Unknown column 'ENABLE_CONDITION' in 'field list'
ERROR [Thread-0] 01 Mar 2023 13:33:29 GMT ****************** Start Stacktrace *********************
ERROR [Thread-0] 01 Mar 2023 13:33:29 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:162)
ERROR [Thread-0] 01 Mar 2023 13:33:29 GMT de.independit.scheduler.server.exception.FatalException.<init>(FatalException.java:50)
ERROR [Thread-0] 01 Mar 2023 13:33:29 GMT de.independit.scheduler.server.repository.TableLoader.SDMSrun(SDMSRepository.java:437)
ERROR [Thread-0] 01 Mar 2023 13:33:29 GMT de.independit.scheduler.server.util.SDMSThread.run(SDMSThread.java:219)
ERROR [Thread-0] 01 Mar 2023 13:33:29 GMT ****************** End Stacktrace *********************
INFO [Thread-1] 01 Mar 2023 13:33:29 GMT Read 6, Loaded 6 rows for GROUPS
INFO [Thread-1] 01 Mar 2023 13:33:29 GMT Read 15885, Loaded 15885 rows for RESOURCE_REQUIREMENT
INFO [Thread-1] 01 Mar 2023 13:33:29 GMT Read 9, Loaded 9 rows for INTERVAL_DISPATCHER
INFO [Thread-1] 01 Mar 2023 13:33:29 GMT Read 62, Loaded 62 rows for SCOPE
INFO [Thread-1] 01 Mar 2023 13:33:29 GMT Read 57, Loaded 57 rows for INTERVAL_SELECTION
INFO [Thread-1] 01 Mar 2023 13:33:29 GMT Read 438, Loaded 438 rows for RUNNABLE_QUEUE
ERROR [Thread-1] 01 Mar 2023 13:33:29 GMT SQL Error : Table 'schedulixdb.USER_PARAMETER' doesn't exist
ERROR [Thread-1] 01 Mar 2023 13:33:29 GMT ****************** Start Stacktrace *********************
ERROR [Thread-1] 01 Mar 2023 13:33:29 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:162)
ERROR [Thread-1] 01 Mar 2023 13:33:29 GMT de.independit.scheduler.server.exception.FatalException.<init>(FatalException.java:50)
ERROR [Thread-1] 01 Mar 2023 13:33:29 GMT de.independit.scheduler.server.repository.TableLoader.SDMSrun(SDMSRepository.java:437)
ERROR [Thread-1] 01 Mar 2023 13:33:29 GMT de.independit.scheduler.server.util.SDMSThread.run(SDMSThread.java:219)
ERROR [Thread-1] 01 Mar 2023 13:33:29 GMT ****************** End Stacktrace *********************
FATAL [main] 01 Mar 2023 13:33:29 GMT Fatal exception while loading Repository:
SQL Error : Table 'schedulixdb.USER_PARAMETER' doesn't exist
FATAL [main] 01 Mar 2023 13:33:29 GMT ****************** Start Stacktrace *********************
FATAL [main] 01 Mar 2023 13:33:29 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:162)
FATAL [main] 01 Mar 2023 13:33:29 GMT de.independit.scheduler.server.Server.serverMain(Server.java:469)
FATAL [main] 01 Mar 2023 13:33:29 GMT de.independit.scheduler.BICServer.main(BICServer.java:144)
FATAL [main] 01 Mar 2023 13:33:29 GMT ****************** End Stacktrace *********************
INFO [Shutdown] 01 Mar 2023 13:33:29 GMT ***********************************************
INFO [Shutdown] 01 Mar 2023 13:33:29 GMT ** **
INFO [Shutdown] 01 Mar 2023 13:33:29 GMT ** U N G R A C E F U L S H U T D O W N ! ! **
INFO [Shutdown] 01 Mar 2023 13:33:29 GMT ** **
INFO [Shutdown] 01 Mar 2023 13:33:29 GMT ***********************************************
INFO [Shutdown] 01 Mar 2023 13:33:29 GMT Release repository lock from 1677677603706
INFO [Shutdown] 01 Mar 2023 13:33:29 GMT Shutdown completed

Do you have an idea about what can be causing this issue and how to fix it?

Dieter Stubler

unread,

Mar 1, 2023, 8:47:22 AM3/1/23

to schedulix

Hi Patrik,

did you run the upgrade sql script on your repository database?

patrik....@gmail.com

unread,

Mar 1, 2023, 8:57:48 AM3/1/23

to schedulix

Hello,

I did run it. Here are errors from the upgrade sql (everything else finished with Query OK)

ERROR 1051 (42S02) at line 145 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown table 'schedulixdb.SCI_ENTITY_VARIABLE'
ERROR 1054 (42S22) at line 146 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown column 'IS_LONG' in 'field list'
ERROR 1060 (42S21) at line 210 in file: 'generated-upgrade-2.9-to-2.10.sql': Duplicate column name 'IS_DISABLED'
ERROR 1051 (42S02) at line 405 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown table 'schedulixdb.SCI_EXTENTS'
ERROR 1146 (42S02) at line 406 in file: 'generated-upgrade-2.9-to-2.10.sql': Table 'schedulixdb.EXTENTS' doesn't exist
ERROR 1051 (42S02) at line 801 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown table 'schedulixdb.SCI_C_PARAMETER_DEFINITION'
ERROR 1051 (42S02) at line 802 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown table 'schedulixdb.SCI_V_PARAMETER_DEFINITION'
ERROR 1054 (42S22) at line 803 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown column 'IS_LONG' in 'field list'
ERROR 1054 (42S22) at line 821 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown column 'IS_LONG' in 'field list'
ERROR 1051 (42S02) at line 1011 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown table 'schedulixdb.SCI_C_RESOURCE_REQUIREMENT'
ERROR 1051 (42S02) at line 1012 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown table 'schedulixdb.SCI_V_RESOURCE_REQUIREMENT'
ERROR 1054 (42S22) at line 1013 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown column 'IGNORE_ON_RERUN' in 'field list'
ERROR 1054 (42S22) at line 1035 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown column 'IGNORE_ON_RERUN' in 'field list'
ERROR 1060 (42S21) at line 1329 in file: 'generated-upgrade-2.9-to-2.10.sql': Duplicate column name 'ENABLE_CONDITION'
ERROR 1051 (42S02) at line 1526 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown table 'schedulixdb.SCI_SUBMITTED_ENTITY_STATS'
ERROR 1146 (42S02) at line 1527 in file: 'generated-upgrade-2.9-to-2.10.sql': Table 'schedulixdb.SUBMITTED_ENTITY_STATS' doesn't exist
ERROR 1051 (42S02) at line 1718 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown table 'schedulixdb.SCI_USERS'
ERROR 1054 (42S22) at line 1719 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown column 'CONNECTION_TYPE' in 'field list'
ERROR 1051 (42S02) at line 1732 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown table 'schedulixdb.SCI_USER_EQUIV'
ERROR 1146 (42S02) at line 1733 in file: 'generated-upgrade-2.9-to-2.10.sql': Table 'schedulixdb.USER_EQUIV' doesn't exist
ERROR 1050 (42S01) at line 1747 in file: 'generated-upgrade-2.9-to-2.10.sql': Table 'USER_EXTENTS' already exists
ERROR 1061 (42000) at line 1757 in file: 'generated-upgrade-2.9-to-2.10.sql': Duplicate key name 'PK_USER_EXTENTS'
ERROR 1050 (42S01) at line 1774 in file: 'generated-upgrade-2.9-to-2.10.sql': Table 'USER_PARAMETER' already exists
ERROR 1061 (42000) at line 1785 in file: 'generated-upgrade-2.9-to-2.10.sql': Duplicate key name 'PK_USER_PARAMETER'
ERROR 1051 (42S02) at line 1800 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown table 'schedulixdb.SCI_C_VERSIONED_EXTENTS'
ERROR 1051 (42S02) at line 1801 in file: 'generated-upgrade-2.9-to-2.10.sql': Unknown table 'schedulixdb.SCI_V_VERSIONED_EXTENTS'
ERROR 1146 (42S02) at line 1802 in file: 'generated-upgrade-2.9-to-2.10.sql': Table 'schedulixdb.VERSIONED_EXTENTS' doesn't exist
ERROR 1146 (42S02) at line 1814 in file: 'generated-upgrade-2.9-to-2.10.sql': Table 'schedulixdb.VERSIONED_EXTENTS' doesn't exist

Dieter Stubler

unread,

Mar 1, 2023, 9:04:32 AM3/1/23

to schedulix

did you run schedulix 2.9 before upgrading to 2.10?

if upgrading from 2.8 to 2.10 you have to run both upgrade scripts 2.8 to 2.9 and 2.9 2.10.

Strange is that in the server log you find:

SQL Error : Table 'schedulixdb.USER_PARAMETER' doesn't exist

but in your update log you see:

Table 'USER_PARAMETER' already exists

Did you run the upgrade script before trying to start the server ?

patrik....@gmail.com

unread,

Mar 1, 2023, 9:06:22 AM3/1/23

to schedulix

Hello,

I run the upgrade script before starting the server. The errors from upgrade script are in my previous message.

I was upgrading from 2.9 to 2.10. We were experiencing no issues with 2.9.
I already tried to run 2.8 to 2.9 and then 2.9 to 2.10 but it didn`t help.
I still have the same error.

Dieter Stubler

unread,

Mar 1, 2023, 9:11:48 AM3/1/23

to schedulix

This is strange.

Are you sure you upgraded the same database your schedulix server uses ?
Please connect to your RDBMS using the credentials from the schedulix.conf file and check for existence of the table USER_PARAMETER.

patrik....@gmail.com

unread,

Mar 1, 2023, 9:21:04 AM3/1/23

to schedulix

Hello,

thank you for spotting that I am upgrading incorrect database.
I would never notice the typo.
Now everything works smoothly.
Thanks and have an amazing day!

patrik....@gmail.com

unread,

Mar 21, 2023, 3:47:14 AM3/21/23

to schedulix

Hello! It looked like update was successful but right now we are not able to start the server.
Do you have an idea what could be causing this issue?
Also, after update I have set the SDMSservers file to version professional (also server.conf on the server) but the GUI still shows as basic. Is there some other place I need to update to get to professional version?

INFO [main] 21 Mar 2023 07:43:08 GMT **************************************************************************
INFO [main] 21 Mar 2023 07:43:08 GMT Copyright : Copyright (c) 2002-2017 independIT Integrative Technologies GmbH
INFO [main] 21 Mar 2023 07:43:08 GMT Build-Date : 01.03.2023 13:15
INFO [main] 21 Mar 2023 07:43:08 GMT Level : OPEN
INFO [main] 21 Mar 2023 07:43:08 GMT Build : 3e77240a85e50ed4b26e189e4542eb150f71240a
INFO [main] 21 Mar 2023 07:43:08 GMT Company : independIT Integrative Technologies GmbH
INFO [main] 21 Mar 2023 07:43:08 GMT Program-Version : 2.10
INFO [main] 21 Mar 2023 07:43:08 GMT Created-By : 1.8.0_121 (Oracle Corporation)
INFO [main] 21 Mar 2023 07:43:08 GMT Manifest-Version : 1.1
INFO [main] 21 Mar 2023 07:43:08 GMT **************************************************************************
INFO [main] 21 Mar 2023 07:43:08 GMT ** BICsuite!Server
INFO [main] 21 Mar 2023 07:43:08 GMT ** Version 2.10
INFO [main] 21 Mar 2023 07:43:08 GMT ** Copyright (C) 2000-2002 topIT Informationstechnologie GmbH
INFO [main] 21 Mar 2023 07:43:08 GMT ** Copyright (C) 2003-2014 independIT Integrative Technologies GmbH
INFO [main] 21 Mar 2023 07:43:08 GMT **************************************************************************
INFO [main] 21 Mar 2023 07:43:08 GMT Commandline Start Options:
INFO [main] 21 Mar 2023 07:43:08 GMT /home/schedulix/etc/server.conf
INFO [main] 21 Mar 2023 07:43:08 GMT UserThreads=1000
INFO [main] 21 Mar 2023 07:43:08 GMT JdbcDriver=com.mysql.jdbc.Driver
INFO [main] 21 Mar 2023 07:43:08 GMT ArchiveSMEColumns=ALL
INFO [main] 21 Mar 2023 07:43:08 GMT TrustStore=/home/bicsuite/etc/certs/srvkeystore
INFO [main] 21 Mar 2023 07:43:08 GMT TxRetryCount=3
INFO [main] 21 Mar 2023 07:43:08 GMT SingleServer=true
INFO [main] 21 Mar 2023 07:43:08 GMT CompatibilityLevel=PROFESSIONAL
INFO [main] 21 Mar 2023 07:43:08 GMT History=14400
INFO [main] 21 Mar 2023 07:43:08 GMT ParameterHandling=liberal
INFO [main] 21 Mar 2023 07:43:08 GMT PriorityLowerBound=10
INFO [main] 21 Mar 2023 07:43:08 GMT ArchiveHierarchyColumns=ALL
INFO [main] 21 Mar 2023 07:43:08 GMT ServicePort=2505
INFO [main] 21 Mar 2023 07:43:08 GMT TimerWakeup=30
INFO [main] 21 Mar 2023 07:43:08 GMT PriorityDelay=1
INFO [main] 21 Mar 2023 07:43:08 GMT KeyStore=/home/bicsuite/etc/certs/srvkeystore
INFO [main] 21 Mar 2023 07:43:08 GMT ArchiveAuditColumns=ALL
INFO [main] 21 Mar 2023 07:43:08 GMT CodePage=latin1
INFO [main] 21 Mar 2023 07:43:08 GMT DbUrl=***************************************************************
INFO [main] 21 Mar 2023 07:43:08 GMT TimerTimeout=10
INFO [main] 21 Mar 2023 07:43:08 GMT ArchiveDependencyColumns=ALL
INFO [main] 21 Mar 2023 07:43:08 GMT ClientAuthorization=true
INFO [main] 21 Mar 2023 07:43:08 GMT DbLoaders=2
INFO [main] 21 Mar 2023 07:43:08 GMT RunMode=PRODUCTION
INFO [main] 21 Mar 2023 07:43:08 GMT Port=2506
INFO [main] 21 Mar 2023 07:43:08 GMT CalendarEntries=250
INFO [main] 21 Mar 2023 07:43:08 GMT TimerHorizon=2
INFO [main] 21 Mar 2023 07:43:08 GMT HistoryLimit=21600
INFO [main] 21 Mar 2023 07:43:08 GMT ScheduleWakeup=30
INFO [main] 21 Mar 2023 07:43:08 GMT DbUser=schedulix
INFO [main] 21 Mar 2023 07:43:08 GMT ArchiveVariableColumns=ALL
INFO [main] 21 Mar 2023 07:43:08 GMT MinHistoryCount=0
INFO [main] 21 Mar 2023 07:43:08 GMT CalendarHorizon=90
INFO [main] 21 Mar 2023 07:43:08 GMT TimerSuspendLimit=15
INFO [main] 21 Mar 2023 07:43:08 GMT Hostname=54.40.187.141
INFO [main] 21 Mar 2023 07:43:08 GMT WorkerThreads=2
INFO [main] 21 Mar 2023 07:43:08 GMT DbHistory=0
INFO [main] 21 Mar 2023 07:43:08 GMT Archive=false
INFO [main] 21 Mar 2023 07:43:08 GMT TriggerHardLimit=100
INFO [main] 21 Mar 2023 07:43:08 GMT TriggerSoftLimit=50
INFO [main] 21 Mar 2023 07:43:08 GMT MaxHistoryCount=0
INFO [main] 21 Mar 2023 07:43:08 GMT TraceLevel=2
INFO [main] 21 Mar 2023 07:43:08 GMT ArchiveKillJobColumns=ALL
INFO [main] 21 Mar 2023 07:43:08 GMT TimerRecalc=1
INFO [main] 21 Mar 2023 07:43:08 GMT GCWakeup=240
INFO [main] 21 Mar 2023 07:43:08 GMT SessionTimeout=0
INFO [main] 21 Mar 2023 07:43:08 GMT Using internal Authentication
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting ENVIRONMENT
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting ERRORLOG
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting EXPFINALTIME
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting EXPRUNTIME
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting FINISHTIME
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting ISRESTARTABLE
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting JOBID
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting JOBNAME
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting JOBSTATE
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting JOBTAG
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting KEY
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting LOGFILE
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting MASTERID
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting MERGEDSTATE
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting PARENTID
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting PID
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting RERUNSEQ
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting RESOURCETIME
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting RUNNABLETIME
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting SCOPENAME
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting SDMSHOST
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting SDMSPORT
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting SEID
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting SEOWNER
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting STARTTIME
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting STATE
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting SUBMITGROUP
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting SUBMITTER
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting SUBMITTIME
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting SYNCTIME
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting SYSDATE
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERBASE
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERBASEID
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERBASEJOBID
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERNAME
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERNEWSTATE
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERORIGIN
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERORIGINID
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERORIGINJOBID
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGEROLDSTATE
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERREASON
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERREASONID
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERREASONJOBID
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERSEQNO
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting TRIGGERTYPE
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting LAST_WARNING
INFO [main] 21 Mar 2023 07:43:08 GMT Exporting WORKDIR
INFO [main] 21 Mar 2023 07:43:09 GMT JDBC Driver used : MySQL Connector Java
INFO [main] 21 Mar 2023 07:43:09 GMT Acquire repository lock for 1679384588793
INFO [main] 21 Mar 2023 07:43:09 GMT Lock Acquisition for 1679384588793 failed
INFO [main] 21 Mar 2023 07:43:09 GMT Ticket values Read: 1679384581746, 1679384582103
INFO [main] 21 Mar 2023 07:43:09 GMT ticket deleted .....
INFO [main] 21 Mar 2023 07:43:09 GMT Acquire repository lock for 1679384588793
INFO [main] 21 Mar 2023 07:43:09 GMT Starting Renew Ticket Thread
INFO [Thread-0] 21 Mar 2023 07:43:14 GMT TableLoader 0 started
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT TableLoader 1 started
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT Read 6, Loaded 6 rows for GROUPS
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT Read 15885, Loaded 15885 rows for RESOURCE_REQUIREMENT
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT Read 9, Loaded 9 rows for INTERVAL_DISPATCHER
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT Read 62, Loaded 62 rows for SCOPE
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT Read 65, Loaded 65 rows for INTERVAL_SELECTION
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT Read 529, Loaded 529 rows for RUNNABLE_QUEUE
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT Read 0, Loaded 0 rows for USER_PARAMETER
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT Read 9, Loaded 9 rows for EVENT
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT Read 9, Loaded 9 rows for SCHEDULED_EVENT
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT Read 0, Loaded 0 rows for EXTENTS
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT Read 0, Loaded 0 rows for TRIGGER_QUEUE
INFO [Thread-1] 21 Mar 2023 07:43:14 GMT Read 0, Loaded 0 rows for USER_EXTENTS
INFO [Thread-1] 21 Mar 2023 07:43:15 GMT Read 3, Loaded 3 rows for RESOURCE_STATE_PROFILE
INFO [Thread-1] 21 Mar 2023 07:43:15 GMT Read 0, Loaded 0 rows for KILL_JOB
INFO [Thread-1] 21 Mar 2023 07:43:15 GMT Read 24, Loaded 24 rows for SCHEDULE
INFO [Thread-1] 21 Mar 2023 07:43:15 GMT Read 1, Loaded 1 rows for PERSISTENT_VALUE
INFO [Thread-0] 21 Mar 2023 07:43:15 GMT Read 57733, Loaded 57733 rows for SCHEDULING_HIERARCHY
INFO [Thread-0] 21 Mar 2023 07:43:15 GMT Read 30, Loaded 30 rows for GRANTS
INFO [Thread-0] 21 Mar 2023 07:43:15 GMT Read 4, Loaded 4 rows for RESOURCE_STATE_MAP_PROF
INFO [Thread-0] 21 Mar 2023 07:43:15 GMT Read 23987, Loaded 23987 rows for FOLDER
INFO [Thread-0] 21 Mar 2023 07:43:15 GMT Read 3408, Loaded 3408 rows for DEPENDENCY_DEFINITION
INFO [Thread-1] 21 Mar 2023 07:43:16 GMT Read 89645, Loaded 89645 rows for TRIGGER_DEFINITION
INFO [Thread-1] 21 Mar 2023 07:43:16 GMT Read 6, Loaded 6 rows for RESOURCE_STATE
INFO [Thread-1] 21 Mar 2023 07:43:16 GMT Read 0, Loaded 0 rows for RESOURCE_TEMPLATE
INFO [Thread-0] 21 Mar 2023 07:43:16 GMT Read 35273, Loaded 35273 rows for SCHEDULING_ENTITY
INFO [Thread-1] 21 Mar 2023 07:43:16 GMT Read 361, Loaded 361 rows for DEPENDENCY_STATE
INFO [Thread-1] 21 Mar 2023 07:43:16 GMT Read 31182, Loaded 31182 rows for SUBMITTED_ENTITY
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 89169, Loaded 89169 rows for TRIGGER_STATE
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 31, Loaded 31 rows for INTERVALL
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 0, Loaded 0 rows for USER_EQUIV
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 0, Loaded 0 rows for EXIT_STATE_TRANS_PROFILE
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 312, Loaded 312 rows for CALENDAR
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 12181, Loaded 12181 rows for DEPENDENCY_INSTANCE
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 57, Loaded 57 rows for EXIT_STATE_MAPPING
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 15, Loaded 15 rows for EXIT_STATE_PROFILE
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 7, Loaded 7 rows for USERS
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 0, Loaded 0 rows for NICE_PROFILE_ENTRY
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 31, Loaded 31 rows for EXIT_STATE_DEFINITION
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 42, Loaded 42 rows for ENVIRONMENT
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 7, Loaded 7 rows for RESOURCE_REQ_STATES
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 0, Loaded 0 rows for NICE_PROFILE
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 12, Loaded 12 rows for EXIT_STATE_MAPPING_PROFILE
INFO [Thread-1] 21 Mar 2023 07:43:17 GMT Read 21, Loaded 21 rows for NAMED_ENVIRONMENT
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 30781, Loaded 30781 rows for HIERARCHY_INSTANCE
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 5, Loaded 5 rows for INTERVAL_HIERARCHY
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 12, Loaded 12 rows for MEMBER
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 6, Loaded 6 rows for RESOURCE_STATE_MAPPING
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 267, Loaded 267 rows for NAMED_RESOURCE
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 0, Loaded 0 rows for ENTITY_VARIABLE
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 56, Loaded 56 rows for OBJECT_COMMENT
INFO [Thread-1] 21 Mar 2023 07:43:25 GMT Read 256607, Loaded 256607 rows for PARAMETER_DEFINITION
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 49, Loaded 49 rows for RESOURCE_VARIABLE
INFO [Thread-1] 21 Mar 2023 07:43:25 GMT Read 182, Loaded 182 rows for SCOPE_CONFIG
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 0, Loaded 0 rows for TEMPLATE_VARIABLE
INFO [Thread-1] 21 Mar 2023 07:43:25 GMT Read 1, Loaded 1 rows for RESOURCE_ALLOCATION
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 0, Loaded 0 rows for IGNORED_DEPENDENCY
INFO [Thread-1] 21 Mar 2023 07:43:25 GMT Read 7, Loaded 7 rows for RESOURCE_STATE_DEFINITION
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 2044, Loaded 2044 rows for SME_COUNTER
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 0, Loaded 0 rows for VERSIONED_EXTENTS
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 0, Loaded 0 rows for EXIT_STATE_TRANSLATION
INFO [Thread-1] 21 Mar 2023 07:43:25 GMT Read 0, Loaded 0 rows for SUBMITTED_ENTITY_STATS
INFO [Thread-1] 21 Mar 2023 07:43:25 GMT Read 46, Loaded 46 rows for EXIT_STATE
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 156, Loaded 156 rows for SCOPE_CONFIG_ENVMAPPING
INFO [Thread-1] 21 Mar 2023 07:43:25 GMT Read 0, Loaded 0 rows for TRIGGER_PARAMETER
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 7, Loaded 7 rows for FOOTPRINT
INFO [Thread-1] 21 Mar 2023 07:43:25 GMT Read 0, Loaded 0 rows for EVENT_PARAMETER
INFO [Thread-0] 21 Mar 2023 07:43:25 GMT Read 15497, Loaded 15497 rows for RESSOURCE
INFO [main] 21 Mar 2023 07:43:25 GMT Initializing System Threads
INFO [main] 21 Mar 2023 07:43:26 GMT Starting 3 Worker Threads
INFO [main] 21 Mar 2023 07:43:26 GMT Starting Init Repository Thread
MESSAGE [2,InitRepositoryThread(Worker0)] 21 Mar 2023 07:43:26 GMT Server Execution time for class de.independit.scheduler.server.DoCheckRepository : 22 ms -- Start Committing
MESSAGE [2,InitRepositoryThread(Worker0)] 21 Mar 2023 07:43:26 GMT Execution time for class de.independit.scheduler.server.DoCheckRepository : 23 ms
INFO [main] 21 Mar 2023 07:43:26 GMT Starting Scheduling Thread
INFO [main] 21 Mar 2023 07:43:26 GMT Starting Time Scheduling Thread
INFO [main] 21 Mar 2023 07:43:26 GMT Starting Trigger Thread
INFO [main] 21 Mar 2023 07:43:26 GMT Starting Garbage Collection Thread
INFO [main] 21 Mar 2023 07:43:26 GMT Starting Notifier Thread
INFO [main] 21 Mar 2023 07:43:26 GMT Starting Listener Thread(s)
MESSAGE [2,Notifier(Worker1)] 21 Mar 2023 07:43:26 GMT Execution time for class de.independit.scheduler.server.DoNotify : 2 ms
MESSAGE [2,Notifier(Worker2)] 21 Mar 2023 07:43:26 GMT Execution time for class de.independit.scheduler.server.DoNotify : 1 ms
INFO [main] 21 Mar 2023 07:43:26 GMT SSL communication Listener disabled
INFO [main] 21 Mar 2023 07:43:26 GMT -- SDMS -- Server -- Systems -- ready --
MESSAGE [2,SchedulingThread(Worker0)] 21 Mar 2023 07:43:26 GMT Server Execution time for class de.independit.scheduler.server.DoSchedule : 35 ms -- Start Committing
ERROR [Worker0] 21 Mar 2023 07:43:26 GMT Error while setting Ticket (no rows updated)
ERROR [Worker0] 21 Mar 2023 07:43:26 GMT ****************** Start Stacktrace *********************
ERROR [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:162)
ERROR [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.exception.FatalException.<init>(FatalException.java:50)
ERROR [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.RenewTicketThread.renewTicket(RenewTicketThread.java:274)
ERROR [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.repository.SDMSTransaction.commitOrRollback(SDMSTransaction.java:256)
ERROR [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.repository.SDMSTransaction.commit(SDMSTransaction.java:148)
ERROR [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.WorkerThread.SDMSrun(WorkerThread.java:158)
ERROR [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.util.SDMSThread.run(SDMSThread.java:219)
ERROR [Worker0] 21 Mar 2023 07:43:26 GMT ****************** End Stacktrace *********************
FATAL [Worker0] 21 Mar 2023 07:43:26 GMT Error while setting Ticket (no rows updated)
FATAL [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.RenewTicketThread.renewTicket(RenewTicketThread.java:274)
FATAL [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.repository.SDMSTransaction.commitOrRollback(SDMSTransaction.java:256)
FATAL [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.repository.SDMSTransaction.commit(SDMSTransaction.java:148)
FATAL [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.WorkerThread.SDMSrun(WorkerThread.java:158)
FATAL [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.util.SDMSThread.run(SDMSThread.java:219)
FATAL [Worker0] 21 Mar 2023 07:43:26 GMT ****************** Start Stacktrace *********************
FATAL [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:166)
FATAL [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.WorkerThread.SDMSrun(WorkerThread.java:228)
FATAL [Worker0] 21 Mar 2023 07:43:26 GMT de.independit.scheduler.server.util.SDMSThread.run(SDMSThread.java:219)
FATAL [Worker0] 21 Mar 2023 07:43:26 GMT ****************** End Stacktrace *********************
INFO [Shutdown] 21 Mar 2023 07:43:26 GMT ***********************************************
INFO [Shutdown] 21 Mar 2023 07:43:26 GMT ** **
INFO [Shutdown] 21 Mar 2023 07:43:26 GMT ** U N G R A C E F U L S H U T D O W N ! ! **
INFO [Shutdown] 21 Mar 2023 07:43:26 GMT ** **
INFO [Shutdown] 21 Mar 2023 07:43:26 GMT ***********************************************
INFO [Shutdown] 21 Mar 2023 07:43:26 GMT Release repository lock from 1679384588793
INFO [Shutdown] 21 Mar 2023 07:43:26 GMT Shutdown completed
[scrolllog] Waiting for child (8066) to terminate
[scrolllog] Child exited with state 1
[scrolllog] Try to restart child (child terminated with exit code <> 0)

Dieter Stubler

unread,

Mar 21, 2023, 8:43:14 AM3/21/23

to schedulix

Hi Patrik,

looks like there is another server already running on the same database respository. If you start a second server on the same repository and have set singeServer option for both servers they will start to play jojo.
Using schedulix, you cannot set the Edition to PROFESSIONAL because this requires to Upgrade to the commercial BICsuite PROFESSIONAL Edition.

Regards
Dieter

Reply all

Reply to author

Forward