Using 8.3 with MariaDB

[gijsvb]

Hi,

I'm trying to use the new 8.3 version with my MariaDB database, I get an error message stating BASDB.DV_RES doesn't exist.

This message pops up when I try to create a new BS, A new BS minor version or try to delete a BS.

The BASDB and BASDBTEST databases are created and populated with several tables, so the user to connect to MariaDB has the rigths to create databases en tables.

Is there a SQL script to create the DV_RES table?

Regards,

Gijs van Ballegooijen.

[aware_support]

This definitely works for us. So it must be the difference in our versions of Maria DB. DV_RES is a system table - if it hasn't been created something is seriously wrong.

Can you please delete all Aware IM created database manually and run Aware IM again. If you still have the same problem please attach the output of the Aware IM Server

[gijsvb]

Hi,

I deleted the BASDB en BASDBTEST databases and restarted the server. Attached the startuplog.txt and a sql dump of the BASDB database created.

Regards,

Gijs van Ballegooijen.

[gijsvb]

Not sure the file attachment succeeded so now one by one

[gijsvb]

Still not sure my attachments get through. Now startup log text in message:

gvb@server:~/AwareIM/bin$ bash shutdown.sh
AwareIM is now shutdown.
gvb@server:~/AwareIM/bin$ bash startAwareIMNoGUI.sh
gvb@server:~/AwareIM/bin$ Overall status: Aware IM starting ...
Process status: Tomcat: Starting...
Starting Tomcat server java -Xmx128m -Djava.endorsed.dirs=../Tomcat/common/endorsed -classpath ../JDK/lib/tools.jar:../Tomcat/bin/bootstrap.jar:../Tomcat/bin/tomcat-juli.jar -Dcatalina.base=../Tomcat -Dcatalina.home=../Tomcat -Djava.io.tmpdir=../Tomcat/temp org.apache.catalina.startup.Bootstrap start
Connecting to URL http://localhost:8080
Connection to URL: first exception is Connection refused (Connection refused)
java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538)
at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:463)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:558)
at sun.net.www.http.HttpClient.<init>(HttpClient.java:242)
at sun.net.www.http.HttpClient.New(HttpClient.java:339)
at sun.net.www.http.HttpClient.New(HttpClient.java:357)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:1220)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1156)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1050)
at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:984)
at com.bas.install.Pinger.A(Unknown Source)
at com.bas.install.Pinger.B(Unknown Source)
at com.bas.basserver.bsmanager.J.R(Unknown Source)
at com.bas.basserver.bsmanager.J.B(Unknown Source)
at com.bas.basserver.bsmanager.J.A(Unknown Source)
at com.bas.basserver.bsmanager.NonGUIServerMonitorCallback.main(Unknown Source)
Tomcat: May 31, 2019 12:41:58 PM org.apache.catalina.startup.SetAllPropertiesRule begin
Tomcat: WARNING: [SetAllPropertiesRule]{Server/Service/Connector/SSLHostConfig/Certificate} Setting property 'certificateChainfile' to '/AwareIM/Tomcat/conf/chain.pem' did not find a matching property.
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: Server version: Apache Tomcat/8.5.24
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: Server built: Nov 27 2017 13:05:30 UTC
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: Server number: 8.5.24.0
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: OS Name: Linux
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: OS Version: 4.15.0-50-generic
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: Architecture: amd64
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: Java Home: /usr/lib/jvm/java-8-oracle/jre
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: JVM Version: 1.8.0_201-b09
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: JVM Vendor: Oracle Corporation
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: CATALINA_BASE: /AwareIM/Tomcat
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: CATALINA_HOME: /AwareIM/Tomcat
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: Command line argument: -Xmx128m
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: Command line argument: -Djava.endorsed.dirs=../Tomcat/common/endorsed
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: Command line argument: -Dcatalina.base=../Tomcat
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: Command line argument: -Dcatalina.home=../Tomcat
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.VersionLoggerListener log
Tomcat: INFO: Command line argument: -Djava.io.tmpdir=../Tomcat/temp
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
Tomcat: INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib]
Tomcat: May 31, 2019 12:41:59 PM org.apache.coyote.AbstractProtocol init
Tomcat: INFO: Initializing ProtocolHandler ["http-nio-8080"]
Process status: Tomcat: Ok
Tomcat: May 31, 2019 12:41:59 PM org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
Tomcat: INFO: Using a shared selector for servlet write/read
Process status: Aware IM Server: Starting...
Startup timeout is: 0
Hello world. About to start the Server
Tomcat: May 31, 2019 12:41:59 PM org.apache.coyote.AbstractProtocol init
Tomcat: INFO: Initializing ProtocolHandler ["https-jsse-nio-8443"]
SLF4J: This version of SLF4J requires log4j version 1.2.12 or later. See also http://www.slf4j.org/codes.html#log4j_version
- Using Persistence Adapter: MemoryPersistenceAdapter
- Apache ActiveMQ 5.8.0 (localhost, ID:server-45761-1559299319601-0:1) is starting
Tomcat: May 31, 2019 12:41:59 PM org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
Tomcat: INFO: Using a shared selector for servlet write/read
Tomcat: May 31, 2019 12:41:59 PM org.apache.coyote.AbstractProtocol init
Tomcat: INFO: Initializing ProtocolHandler ["ajp-nio-8009"]
Tomcat: May 31, 2019 12:41:59 PM org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
Tomcat: INFO: Using a shared selector for servlet write/read
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.Catalina load
Tomcat: INFO: Initialization processed in 1257 ms
- Listening for connections at: tcp://server.bgncloud.nl:61616
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.core.StandardService startInternal
Tomcat: INFO: Starting service [Catalina]
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.core.StandardEngine startInternal
Tomcat: INFO: Starting Servlet Engine: Apache Tomcat/8.5.24
Tomcat: May 31, 2019 12:41:59 PM org.apache.catalina.startup.HostConfig deployDirectory
Tomcat: INFO: Deploying web application directory [/AwareIM/Tomcat/webapps/AwareIM]
- Connector tcp://server.bgncloud.nl:61616 Started
- Apache ActiveMQ 5.8.0 (localhost, ID:server-45761-1559299319601-0:1) started
- For help or more information please see: http://activemq.apache.org
- Temporary Store limit is 51200 mb, whilst the temporary data directory: /AwareIM/bin/activemq-data/localhost/tmp_storage only has 25709 mb of usable space
INFO: Calling System.runFinalizersOnExit (true)
INFO: Default locale for machine is en_US
INFO: Default timezone for machine is Europe/Amsterdam
INFO: Property InputAdaptor1.LocaleISOLanguageCode set to 'en'
INFO: Property InputAdaptor1.LocaleISOCountryCode set to 'US'
WARN: Retaining default locale
INFO: Property InputAdaptor1.TimeZone set to 'Europe/Amsterdam'
WARN: Retaining default timezone
INFO: Property InputAdaptor1.Logging.LoggingTimeInfo set to 'true'
INFO: Property InputAdaptor1.Logging.LoggingThreadInfo set to 'false'
INFO: Property InputAdaptor1.Logging.LoggingPackageInfo set to 'false'
INFO: Property InputAdaptor1.Logging.RemoteLogSetting set to 'FATAL'
INFO: Checking RemoteLogger
INFO: Logger status=OutputLogger status: loggingTimeInfo = true loggingThreadInfo = false loggingPackageInfo = false logLevel for [DEFAULT] is [INFO]
INFO: Property InputAdaptor1.LogStdout set to 'false'
INFO: InputAdaptor1 creating Controller as instance of com.bas.openadaptor.NonTransactionalController
INFO: InputAdaptor1 Initializing Controller
TRACE: Constructing SimpleController
INFO: InputAdaptor1.Controller setting propsPrefix to InputAdaptor1.Controller
INFO: InputAdaptor1.Controller Creating Security Manager
INFO: InputAdaptor1.Controller No Security Policy in use
TRACE: SimpleController InputAdaptor1.Controller init complete
INFO: InputAdaptor1 creating PipelineController as instance of org.openadaptor.adaptor.STPipelineController
INFO: No timeout for component initialization.
TRACE: SimpleComponent QS init complete
TRACE: org.openadaptor.adaptor.jms.JMSSource propsPrefix=InputAdaptor1.QS
TRACE: org.openadaptor.adaptor.jms.JMSSource RetryLimit=-1
TRACE: org.openadaptor.adaptor.jms.JMSSource RetryDelay=100000
INFO: org.openadaptor.adaptor.jms.JMSSource Initialising JMS Queue/Topic Listener InputAdaptor1.QS
TRACE: your JMS vendor implementation of QueueConnectionFactory.createQueueConnection() returns a class which is an instance of TopicConnection as well as an instance of QueueConnection
INFO: org.openadaptor.adaptor.jms.JMSSource Initialisation succeeded for Queue/Topic defaultinputqueue
TRACE: SimpleComponent IP init complete
TRACE: SimpleComponent CS init complete
TRACE: AbstractWriter CS init complete
INFO: InputAdaptor1.Controller linking QS to IP
INFO: InputAdaptor1.Controller linking IP to CS
INFO: Calling System.runFinalizersOnExit (true)
INFO: Default locale for machine is en_US
INFO: Default timezone for machine is Europe/Amsterdam
INFO: Property OutputAdaptor1.LocaleISOLanguageCode set to 'en'
INFO: Property OutputAdaptor1.LocaleISOCountryCode set to 'US'
WARN: Retaining default locale
INFO: Property OutputAdaptor1.TimeZone set to 'Europe/Amsterdam'
WARN: Retaining default timezone
INFO: Property OutputAdaptor1.Logging.LoggingTimeInfo set to 'true'
INFO: Property OutputAdaptor1.Logging.LoggingThreadInfo set to 'false'
INFO: Property OutputAdaptor1.Logging.LoggingPackageInfo set to 'false'
INFO: Property OutputAdaptor1.Logging.RemoteLogSetting set to 'FATAL'
INFO: Checking RemoteLogger
INFO: Logger status=OutputLogger status: loggingTimeInfo = true loggingThreadInfo = false loggingPackageInfo = false logLevel for [DEFAULT] is [INFO]
INFO: Property OutputAdaptor1.LogStdout set to 'false'
INFO: OutputAdaptor1 creating Controller as instance of com.bas.openadaptor.SingleSourceCtrler
INFO: OutputAdaptor1 Initializing Controller
TRACE: Constructing SimpleController
INFO: OutputAdaptor1.Controller setting propsPrefix to OutputAdaptor1.Controller
INFO: OutputAdaptor1.Controller Creating Security Manager
INFO: OutputAdaptor1.Controller No Security Policy in use
TRACE: SimpleController OutputAdaptor1.Controller init complete
INFO: OutputAdaptor1 creating PipelineController as instance of org.openadaptor.adaptor.STPipelineController
INFO: No timeout for component initialization.
TRACE: SimpleComponent OS init complete
TRACE: SimpleComponent OP init complete
TRACE: SimpleComponent TS init complete
TRACE: AbstractWriter TS init complete
TRACE: org.openadaptor.adaptor.jms.JMSSink propsPrefix=OutputAdaptor1.TS
TRACE: org.openadaptor.adaptor.jms.JMSSink RetryLimit=-1
TRACE: org.openadaptor.adaptor.jms.JMSSink RetryDelay=100000
TRACE: org.openadaptor.adaptor.jms.JMSSink MessageType=Object
INFO: org.openadaptor.adaptor.jms.JMSSink Initialising JMS Queue/Topic OutputAdaptor1.TS
TRACE: org.openadaptor.adaptor.jms.JMSPublisher propsPrefix=OutputAdaptor1.TS.Publisher
TRACE: org.openadaptor.adaptor.jms.JMSPublisher MessageMode=TOPIC
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JNDI_PROVIDER_URL=tcp://server.bgncloud.nl:61616
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMDI_FACTORY=org.apache.activemq.jndi.ActiveMQInitialContextFactory
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMS_TOPIC_FACTORY=ConnectionFactory
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMS_TOPIC=dynamicTopics/defaultoutputtopic
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.ClientID=null
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.OverrideExistingClientID=false
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.Transacted=true
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.DeliveryMode=2
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.Priority=5
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.TimeToLive=0
TRACE: org.openadaptor.adaptor.jms.JMSPublisher - establishing JMS connection
TRACE: your JMS vendor implementation of TopicConnectionFactory.createTopicConnection() returns a class which is an instance of QueueConnection as well as an instance of TopicConnection
INFO: org.openadaptor.adaptor.jms.JMSSink Initialisation succeeded for Queue/Topic defaultoutputtopic
INFO: OutputAdaptor1.Controller linking OS to OP
INFO: OutputAdaptor1.Controller linking OP to TS
INFO: Calling System.runFinalizersOnExit (true)
INFO: Default locale for machine is en_US
INFO: Default timezone for machine is Europe/Amsterdam
INFO: Property InputAdaptor2.LocaleISOLanguageCode set to 'en'
INFO: Property InputAdaptor2.LocaleISOCountryCode set to 'US'
WARN: Retaining default locale
INFO: Property InputAdaptor2.TimeZone set to 'Europe/Amsterdam'
WARN: Retaining default timezone
INFO: Property InputAdaptor2.Logging.LoggingTimeInfo set to 'true'
INFO: Property InputAdaptor2.Logging.LoggingThreadInfo set to 'false'
INFO: Property InputAdaptor2.Logging.LoggingPackageInfo set to 'false'
INFO: Property InputAdaptor2.Logging.RemoteLogSetting set to 'FATAL'
INFO: Checking RemoteLogger
INFO: Logger status=OutputLogger status: loggingTimeInfo = true loggingThreadInfo = false loggingPackageInfo = false logLevel for [DEFAULT] is [INFO]
INFO: Property InputAdaptor2.LogStdout set to 'false'
INFO: InputAdaptor2 creating Controller as instance of com.bas.openadaptor.NonTransactionalController
INFO: InputAdaptor2 Initializing Controller
TRACE: Constructing SimpleController
INFO: InputAdaptor2.Controller setting propsPrefix to InputAdaptor2.Controller
INFO: InputAdaptor2.Controller Creating Security Manager
INFO: InputAdaptor2.Controller No Security Policy in use
TRACE: SimpleController InputAdaptor2.Controller init complete
INFO: InputAdaptor2 creating PipelineController as instance of org.openadaptor.adaptor.STPipelineController
INFO: No timeout for component initialization.
TRACE: SimpleComponent QS init complete
TRACE: org.openadaptor.adaptor.jms.JMSSource propsPrefix=InputAdaptor2.QS
TRACE: org.openadaptor.adaptor.jms.JMSSource RetryLimit=-1
TRACE: org.openadaptor.adaptor.jms.JMSSource RetryDelay=100000
INFO: org.openadaptor.adaptor.jms.JMSSource Initialising JMS Queue/Topic Listener InputAdaptor2.QS
TRACE: your JMS vendor implementation of QueueConnectionFactory.createQueueConnection() returns a class which is an instance of TopicConnection as well as an instance of QueueConnection
INFO: org.openadaptor.adaptor.jms.JMSSource Initialisation succeeded for Queue/Topic skinputqueue
TRACE: SimpleComponent IP init complete
TRACE: SimpleComponent CS init complete
TRACE: AbstractWriter CS init complete
INFO: InputAdaptor2.Controller linking QS to IP
INFO: InputAdaptor2.Controller linking IP to CS
INFO: Calling System.runFinalizersOnExit (true)
INFO: Default locale for machine is en_US
INFO: Default timezone for machine is Europe/Amsterdam
INFO: Property OutputAdaptor2.LocaleISOLanguageCode set to 'en'
INFO: Property OutputAdaptor2.LocaleISOCountryCode set to 'US'
WARN: Retaining default locale
INFO: Property OutputAdaptor2.TimeZone set to 'Europe/Amsterdam'
WARN: Retaining default timezone
INFO: Property OutputAdaptor2.Logging.LoggingTimeInfo set to 'true'
INFO: Property OutputAdaptor2.Logging.LoggingThreadInfo set to 'false'
INFO: Property OutputAdaptor2.Logging.LoggingPackageInfo set to 'false'
INFO: Property OutputAdaptor2.Logging.RemoteLogSetting set to 'FATAL'
INFO: Checking RemoteLogger
INFO: Logger status=OutputLogger status: loggingTimeInfo = true loggingThreadInfo = false loggingPackageInfo = false logLevel for [DEFAULT] is [INFO]
INFO: Property OutputAdaptor2.LogStdout set to 'false'
INFO: OutputAdaptor2 creating Controller as instance of com.bas.openadaptor.SingleSourceCtrler
INFO: OutputAdaptor2 Initializing Controller
TRACE: Constructing SimpleController
INFO: OutputAdaptor2.Controller setting propsPrefix to OutputAdaptor2.Controller
INFO: OutputAdaptor2.Controller Creating Security Manager
INFO: OutputAdaptor2.Controller No Security Policy in use
TRACE: SimpleController OutputAdaptor2.Controller init complete
INFO: OutputAdaptor2 creating PipelineController as instance of org.openadaptor.adaptor.STPipelineController
INFO: No timeout for component initialization.
TRACE: SimpleComponent OS init complete
TRACE: SimpleComponent OP init complete
TRACE: SimpleComponent TS init complete
TRACE: AbstractWriter TS init complete
TRACE: org.openadaptor.adaptor.jms.JMSSink propsPrefix=OutputAdaptor2.TS
TRACE: org.openadaptor.adaptor.jms.JMSSink RetryLimit=-1
TRACE: org.openadaptor.adaptor.jms.JMSSink RetryDelay=100000
TRACE: org.openadaptor.adaptor.jms.JMSSink MessageType=Object
INFO: org.openadaptor.adaptor.jms.JMSSink Initialising JMS Queue/Topic OutputAdaptor2.TS
TRACE: org.openadaptor.adaptor.jms.JMSPublisher propsPrefix=OutputAdaptor2.TS.Publisher
TRACE: org.openadaptor.adaptor.jms.JMSPublisher MessageMode=TOPIC
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JNDI_PROVIDER_URL=tcp://server.bgncloud.nl:61616
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMDI_FACTORY=org.apache.activemq.jndi.ActiveMQInitialContextFactory
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMS_TOPIC_FACTORY=ConnectionFactory
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMS_TOPIC=dynamicTopics/skoutputtopic
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.ClientID=null
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.OverrideExistingClientID=false
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.Transacted=true
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.DeliveryMode=2
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.Priority=5
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.TimeToLive=0
TRACE: org.openadaptor.adaptor.jms.JMSPublisher - establishing JMS connection
TRACE: your JMS vendor implementation of TopicConnectionFactory.createTopicConnection() returns a class which is an instance of QueueConnection as well as an instance of TopicConnection
INFO: org.openadaptor.adaptor.jms.JMSSink Initialisation succeeded for Queue/Topic skoutputtopic
INFO: OutputAdaptor2.Controller linking OS to OP
INFO: OutputAdaptor2.Controller linking OP to TS
INFO: Calling System.runFinalizersOnExit (true)
INFO: Default locale for machine is en_US
INFO: Default timezone for machine is Europe/Amsterdam
INFO: Property InputAdaptor3.LocaleISOLanguageCode set to 'en'
INFO: Property InputAdaptor3.LocaleISOCountryCode set to 'US'
WARN: Retaining default locale
INFO: Property InputAdaptor3.TimeZone set to 'Europe/Amsterdam'
WARN: Retaining default timezone
INFO: Property InputAdaptor3.Logging.LoggingTimeInfo set to 'true'
INFO: Property InputAdaptor3.Logging.LoggingThreadInfo set to 'false'
INFO: Property InputAdaptor3.Logging.LoggingPackageInfo set to 'false'
INFO: Property InputAdaptor3.Logging.RemoteLogSetting set to 'FATAL'
INFO: Checking RemoteLogger
INFO: Logger status=OutputLogger status: loggingTimeInfo = true loggingThreadInfo = false loggingPackageInfo = false logLevel for [DEFAULT] is [INFO]
INFO: Property InputAdaptor3.LogStdout set to 'false'
INFO: InputAdaptor3 creating Controller as instance of com.bas.openadaptor.NonTransactionalController
INFO: InputAdaptor3 Initializing Controller
TRACE: Constructing SimpleController
INFO: InputAdaptor3.Controller setting propsPrefix to InputAdaptor3.Controller
INFO: InputAdaptor3.Controller Creating Security Manager
INFO: InputAdaptor3.Controller No Security Policy in use
TRACE: SimpleController InputAdaptor3.Controller init complete
INFO: InputAdaptor3 creating PipelineController as instance of org.openadaptor.adaptor.STPipelineController
INFO: No timeout for component initialization.
TRACE: SimpleComponent QS init complete
TRACE: org.openadaptor.adaptor.jms.JMSSource propsPrefix=InputAdaptor3.QS
TRACE: org.openadaptor.adaptor.jms.JMSSource RetryLimit=-1
TRACE: org.openadaptor.adaptor.jms.JMSSource RetryDelay=100000
INFO: org.openadaptor.adaptor.jms.JMSSource Initialising JMS Queue/Topic Listener InputAdaptor3.QS
TRACE: your JMS vendor implementation of QueueConnectionFactory.createQueueConnection() returns a class which is an instance of TopicConnection as well as an instance of QueueConnection
INFO: org.openadaptor.adaptor.jms.JMSSource Initialisation succeeded for Queue/Topic notifinqueue
TRACE: SimpleComponent IP init complete
TRACE: SimpleComponent CS init complete
TRACE: AbstractWriter CS init complete
INFO: InputAdaptor3.Controller linking QS to IP
INFO: InputAdaptor3.Controller linking IP to CS
INFO: Calling System.runFinalizersOnExit (true)
INFO: Default locale for machine is en_US
INFO: Default timezone for machine is Europe/Amsterdam
INFO: Property OutputAdaptor3.LocaleISOLanguageCode set to 'en'
INFO: Property OutputAdaptor3.LocaleISOCountryCode set to 'US'
WARN: Retaining default locale
INFO: Property OutputAdaptor3.TimeZone set to 'Europe/Amsterdam'
WARN: Retaining default timezone
INFO: Property OutputAdaptor3.Logging.LoggingTimeInfo set to 'true'
INFO: Property OutputAdaptor3.Logging.LoggingThreadInfo set to 'false'
INFO: Property OutputAdaptor3.Logging.LoggingPackageInfo set to 'false'
INFO: Property OutputAdaptor3.Logging.RemoteLogSetting set to 'FATAL'
INFO: Checking RemoteLogger
INFO: Logger status=OutputLogger status: loggingTimeInfo = true loggingThreadInfo = false loggingPackageInfo = false logLevel for [DEFAULT] is [INFO]
INFO: Property OutputAdaptor3.LogStdout set to 'false'
INFO: OutputAdaptor3 creating Controller as instance of com.bas.openadaptor.SingleSourceCtrler
INFO: OutputAdaptor3 Initializing Controller
TRACE: Constructing SimpleController
INFO: OutputAdaptor3.Controller setting propsPrefix to OutputAdaptor3.Controller
INFO: OutputAdaptor3.Controller Creating Security Manager
INFO: OutputAdaptor3.Controller No Security Policy in use
TRACE: SimpleController OutputAdaptor3.Controller init complete
INFO: OutputAdaptor3 creating PipelineController as instance of org.openadaptor.adaptor.STPipelineController
INFO: No timeout for component initialization.
TRACE: SimpleComponent OS init complete
TRACE: SimpleComponent OP init complete
TRACE: SimpleComponent TS init complete
TRACE: AbstractWriter TS init complete
TRACE: org.openadaptor.adaptor.jms.JMSSink propsPrefix=OutputAdaptor3.TS
TRACE: org.openadaptor.adaptor.jms.JMSSink RetryLimit=-1
TRACE: org.openadaptor.adaptor.jms.JMSSink RetryDelay=100000
TRACE: org.openadaptor.adaptor.jms.JMSSink MessageType=Object
INFO: org.openadaptor.adaptor.jms.JMSSink Initialising JMS Queue/Topic OutputAdaptor3.TS
TRACE: org.openadaptor.adaptor.jms.JMSPublisher propsPrefix=OutputAdaptor3.TS.Publisher
TRACE: org.openadaptor.adaptor.jms.JMSPublisher MessageMode=TOPIC
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JNDI_PROVIDER_URL=tcp://server.bgncloud.nl:61616
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMDI_FACTORY=org.apache.activemq.jndi.ActiveMQInitialContextFactory
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMS_TOPIC_FACTORY=ConnectionFactory
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMS_TOPIC=dynamicTopics/notifouttopic
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.ClientID=null
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.OverrideExistingClientID=false
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.Transacted=true
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.DeliveryMode=2
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.Priority=5
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.TimeToLive=0
TRACE: org.openadaptor.adaptor.jms.JMSPublisher - establishing JMS connection
TRACE: your JMS vendor implementation of TopicConnectionFactory.createTopicConnection() returns a class which is an instance of QueueConnection as well as an instance of TopicConnection
INFO: org.openadaptor.adaptor.jms.JMSSink Initialisation succeeded for Queue/Topic notifouttopic
INFO: OutputAdaptor3.Controller linking OS to OP
INFO: OutputAdaptor3.Controller linking OP to TS
INFO: InputAdaptor3.Controller running
INFO: OutputAdaptor3.Controller running
TRACE: OutputAdaptor3.Controller - Starting thread for Source OS
INFO: Calling System.runFinalizersOnExit (true)
INFO: Default locale for machine is en_US
INFO: Default timezone for machine is Europe/Amsterdam
INFO: Property Timer_NOTIF_0.LocaleISOLanguageCode set to 'en'
INFO: Property Timer_NOTIF_0.LocaleISOCountryCode set to 'US'
WARN: Retaining default locale
INFO: Property Timer_NOTIF_0.TimeZone set to 'Europe/Amsterdam'
WARN: Retaining default timezone
INFO: Property Timer_NOTIF_0.Logging.LoggingTimeInfo set to 'true'
INFO: Property Timer_NOTIF_0.Logging.LoggingThreadInfo set to 'false'
INFO: Property Timer_NOTIF_0.Logging.LoggingPackageInfo set to 'false'
INFO: Property Timer_NOTIF_0.Logging.RemoteLogSetting set to 'FATAL'
INFO: Checking RemoteLogger
INFO: Logger status=OutputLogger status: loggingTimeInfo = true loggingThreadInfo = false loggingPackageInfo = false logLevel for [DEFAULT] is [INFO]
INFO: Property Timer_NOTIF_0.LogStdout set to 'false'
INFO: Timer_NOTIF_0 creating Controller as instance of com.bas.openadaptor.SingleSourceCtrler
INFO: Timer_NOTIF_0 Initializing Controller
TRACE: Constructing SimpleController
INFO: Timer_NOTIF_0.Controller setting propsPrefix to Timer_NOTIF_0.Controller
INFO: Timer_NOTIF_0.Controller Creating Security Manager
INFO: Timer_NOTIF_0.Controller No Security Policy in use
TRACE: SimpleController Timer_NOTIF_0.Controller init complete
INFO: Timer_NOTIF_0 creating PipelineController as instance of org.openadaptor.adaptor.STPipelineController
INFO: No timeout for component initialization.
TRACE: InputAdaptor3.Controller - Starting thread for Source QS
INFO: OS running in callback mode
INFO: QS running in listen mode
TRACE: SimpleComponent TS init complete
TRACE: SimpleComponent QS init complete
TRACE: AbstractWriter QS init complete
TRACE: org.openadaptor.adaptor.jms.JMSSink propsPrefix=Timer_NOTIF_0.QS
TRACE: org.openadaptor.adaptor.jms.JMSSink RetryLimit=-1
TRACE: org.openadaptor.adaptor.jms.JMSSink RetryDelay=100000
TRACE: org.openadaptor.adaptor.jms.JMSSink MessageType=Object
INFO: org.openadaptor.adaptor.jms.JMSSink Initialising JMS Queue/Topic Timer_NOTIF_0.QS
TRACE: org.openadaptor.adaptor.jms.JMSPublisher propsPrefix=Timer_NOTIF_0.QS.Publisher
TRACE: org.openadaptor.adaptor.jms.JMSPublisher MessageMode=Queue
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JNDI_PROVIDER_URL=tcp://server.bgncloud.nl:61616
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMDI_FACTORY=org.apache.activemq.jndi.ActiveMQInitialContextFactory
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMS_QUEUE_FACTORY=ConnectionFactory
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMS_QUEUE=dynamicQueues/notifinqueue
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.ClientID=null
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.OverrideExistingClientID=false
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.Transacted=true
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.DeliveryMode=2
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.Priority=5
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.TimeToLive=0
TRACE: org.openadaptor.adaptor.jms.JMSPublisher - establishing JMS connection
INFO: InputAdaptor1.Controller running
INFO: OutputAdaptor2.Controller running
TRACE: InputAdaptor1.Controller - Starting thread for Source QS
INFO: InputAdaptor2.Controller running
TRACE: your JMS vendor implementation of QueueConnectionFactory.createQueueConnection() returns a class which is an instance of TopicConnection as well as an instance of QueueConnection
INFO: OutputAdaptor1.Controller running
TRACE: InputAdaptor2.Controller - Starting thread for Source QS
INFO: org.openadaptor.adaptor.jms.JMSSink Initialisation succeeded for Queue/Topic notifinqueue
INFO: Timer_NOTIF_0.Controller linking TS to QS
INFO: org.openadaptor.adaptor.jms.JMSSource Start processing JMS Queue/Topic notifinqueue
TRACE: OutputAdaptor2.Controller - Starting thread for Source OS
INFO: QS running in listen mode
INFO: OS running in callback mode
INFO: Calling System.runFinalizersOnExit (true)
INFO: Default locale for machine is en_US
INFO: Default timezone for machine is Europe/Amsterdam
INFO: Property BAS_PostedMessages.LocaleISOLanguageCode set to 'en'
INFO: Property BAS_PostedMessages.LocaleISOCountryCode set to 'US'
WARN: Retaining default locale
INFO: Property BAS_PostedMessages.TimeZone set to 'Europe/Amsterdam'
WARN: Retaining default timezone
INFO: Property BAS_PostedMessages.Logging.LoggingTimeInfo set to 'true'
INFO: Property BAS_PostedMessages.Logging.LoggingThreadInfo set to 'false'
INFO: Property BAS_PostedMessages.Logging.LoggingPackageInfo set to 'false'
INFO: Property BAS_PostedMessages.Logging.RemoteLogSetting set to 'FATAL'
INFO: Checking RemoteLogger
INFO: Logger status=OutputLogger status: loggingTimeInfo = true loggingThreadInfo = false loggingPackageInfo = false logLevel for [DEFAULT] is [INFO]
INFO: Property BAS_PostedMessages.LogStdout set to 'false'
INFO: BAS_PostedMessages creating Controller as instance of com.bas.openadaptor.SingleSourceCtrler
INFO: BAS_PostedMessages Initializing Controller
TRACE: Constructing SimpleController
INFO: BAS_PostedMessages.Controller setting propsPrefix to BAS_PostedMessages.Controller
INFO: BAS_PostedMessages.Controller Creating Security Manager
INFO: BAS_PostedMessages.Controller No Security Policy in use
TRACE: SimpleController BAS_PostedMessages.Controller init complete
INFO: BAS_PostedMessages creating PipelineController as instance of org.openadaptor.adaptor.STPipelineController
INFO: No timeout for component initialization.
INFO: Timer_NOTIF_0.Controller running
TRACE: OutputAdaptor1.Controller - Starting thread for Source OS
TRACE: Timer_NOTIF_0.Controller - Starting thread for Source TS
INFO: QS running in listen mode
TRACE: SimpleComponent OS init complete
TRACE: SimpleComponent QS init complete
TRACE: AbstractWriter QS init complete
TRACE: org.openadaptor.adaptor.jms.JMSSink propsPrefix=BAS_PostedMessages.QS
TRACE: org.openadaptor.adaptor.jms.JMSSink RetryLimit=-1
TRACE: org.openadaptor.adaptor.jms.JMSSink RetryDelay=100000
TRACE: org.openadaptor.adaptor.jms.JMSSink MessageType=Object
INFO: org.openadaptor.adaptor.jms.JMSSink Initialising JMS Queue/Topic BAS_PostedMessages.QS
TRACE: org.openadaptor.adaptor.jms.JMSPublisher propsPrefix=BAS_PostedMessages.QS.Publisher
TRACE: org.openadaptor.adaptor.jms.JMSPublisher MessageMode=Queue
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JNDI_PROVIDER_URL=tcp://server.bgncloud.nl:61616
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMDI_FACTORY=org.apache.activemq.jndi.ActiveMQInitialContextFactory
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMS_QUEUE_FACTORY=ConnectionFactory
TRACE: org.openadaptor.adaptor.jms.JMSPublisher JMS_QUEUE=dynamicQueues/skinputqueue
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.ClientID=null
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.OverrideExistingClientID=false
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.Transacted=true
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.DeliveryMode=2
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.Priority=5
TRACE: org.openadaptor.adaptor.jms.JMSPublisher Publisher.TimeToLive=0
TRACE: org.openadaptor.adaptor.jms.JMSPublisher - establishing JMS connection
INFO: org.openadaptor.adaptor.jms.JMSSource Start processing JMS Queue/Topic defaultinputqueue
INFO: org.openadaptor.adaptor.jms.JMSSource Start processing JMS Queue/Topic skinputqueue
INFO: TS running in polling mode
INFO: OS running in callback mode
TRACE: your JMS vendor implementation of QueueConnectionFactory.createQueueConnection() returns a class which is an instance of TopicConnection as well as an instance of QueueConnection
INFO: org.openadaptor.adaptor.jms.JMSSink Initialisation succeeded for Queue/Topic skinputqueue
INFO: BAS_PostedMessages.Controller linking OS to QS
INFO: BAS_PostedMessages.Controller running
TRACE: BAS_PostedMessages.Controller - Starting thread for Source OS
log4j:ERROR Could not find value for key log4j.appender.A_TEST
log4j:ERROR Could not instantiate appender named "A_TEST".
INFO: OS running in callback mode
log4j:ERROR Could not instantiate class [org.apache.log4j.NullAppender].
java.lang.ClassNotFoundException: org.apache.log4j.NullAppender
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at org.apache.log4j.helpers.Loader.loadClass(Loader.java:160)
at org.apache.log4j.helpers.OptionConverter.instantiateByClassName(OptionConverter.java:309)
at org.apache.log4j.helpers.OptionConverter.instantiateByKey(OptionConverter.java:112)
at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:620)
at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:603)
at org.apache.log4j.PropertyConfigurator.parseCatsAndRenderers(PropertyConfigurator.java:524)
at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:408)
at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:307)
at org.apache.log4j.PropertyConfigurator.configure(PropertyConfigurator.java:315)
at com.bas.basserver.persistence.log.C.<init>(Unknown Source)
at com.bas.basserver.persistence.PersistenceManager.initialise(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.bsmanager.O.B(Unknown Source)
at com.bas.basserver.bsmanager.J$_C.run(Unknown Source)
at java.lang.Thread.run(Thread.java:748)
log4j:ERROR Could not instantiate appender named "A_BGND".
Unable to connect to the existing database Could not establish connection with the data base Unknown database 'BASDB'
Creating main data base...
Database created.
Initialising LDAP Persister
LDAP SEARCH LIMIT value is null
Unable to connect to the existing testing database Could not establish connection with the data base Unknown database 'BASDBTEST'
Creating database for testing...
Database created.
Initialising LDAP Persister
LDAP SEARCH LIMIT value is null
'PublicHolidays' property not found in property file

Creating database tables...

Database tables have been created
Installing predefined objects...
java.sql.SQLSyntaxErrorException: (conn=555) Table 'BASDB.DV_RES' doesn't exist
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)
at org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:530)
at com.bas.basserver.persistence.X.C(Unknown Source)
at com.bas.basserver.documents.C.A(Unknown Source)
at com.bas.basserver.domainmanager.DomainManager.A(Unknown Source)
at com.bas.basserver.domainmanager.DomainManager.createPredefinedDomains(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.bsmanager.O.B(Unknown Source)
at com.bas.basserver.bsmanager.J$_C.run(Unknown Source)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Table 'BASDB.DV_RES' doesn't exist
Query is: SELECT DataKey FROM DV_RES WHERE DataKey LIKE 'DefaultApplication_1.0/%'
java thread: Thread-0
at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:126)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:222)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:350)
... 10 more
com.bas.basserver.persistence.PersistenceException: Error reading resources for folder DefaultApplication_1.0 (conn=555) Table 'BASDB.DV_RES' doesn't exist
at com.bas.basserver.persistence.X.C(Unknown Source)
at com.bas.basserver.documents.C.A(Unknown Source)
at com.bas.basserver.domainmanager.DomainManager.A(Unknown Source)
at com.bas.basserver.domainmanager.DomainManager.createPredefinedDomains(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.bsmanager.O.B(Unknown Source)
at com.bas.basserver.bsmanager.J$_C.run(Unknown Source)
at java.lang.Thread.run(Thread.java:748)

Creating database tables for testing...

Database tables have been created


Aware IM, Version 8.3 (Build 2615)
Copyright 2002-2019 Awaresoft Pty Ltd

Product ID 673d795b5a717fe0ddbf

This product includes the following software:

1. Java-COM Bridge(Jacob)
Copyright (c) 1999 Dan Adler, 315 E72 St. NY, NY, 10021, USA. mailto:[email protected]. All rights reserved.

2. Kendo UI - JavaScript Library
Copyright (c) 2002-2018, Telerik
All rights reserved.

3. NullSoft Install System
Copyright (c) 1999-2003 Nullsoft, Inc.

4. Open Adaptor
Copyright (c) 2001 Public Software Foundation as Trustee. All rights reserved.

5. Jasper Reports
Copyright (c) 2001-2018 Teodor Danciu [email protected]

6. JGraph - The JFC/Swing Graph Component
Copyright (c) 2001-2002

7.MySQL Connector/J 5.1.46
Copyright(c) MySQL AB.

8.Java Service Wrapper
Copyright(c) 1999, 2018 Tanuki Software Inc.

9.Page Guide. Copyright (c) 2018 Tracelytics, AppNeta

10.Java-APNS library. Copyright 2018, Mahmood Ali. All rights reserved.

This product also includes software developed by the Apache Software Foundation (http://www.apache.org/).



com.bas.basserver.persistence.PersistenceException: Business object BAS_UDP not found in business space version
at com.bas.basserver.persistence.PersistenceManager$_A.A(Unknown Source)
at com.bas.basserver.persistence.PersistenceManager.executeQuery(Unknown Source)
at com.bas.basserver.executionengine.X.A(Unknown Source)
at com.bas.basserver.executionengine.X.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.doExecuteQuery(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.executeQuery(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.buildUDP(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.buildUDP(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.postInitialise(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.bsmanager.O.B(Unknown Source)
at com.bas.basserver.bsmanager.J$_C.run(Unknown Source)
at java.lang.Thread.run(Thread.java:748)
com.bas.basserver.executionengine.ExecutionException: Internal error. Business object BAS_UDP not found in business space version
at com.bas.basserver.executionengine.X.A(Unknown Source)
at com.bas.basserver.executionengine.X.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.doExecuteQuery(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.executeQuery(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.buildUDP(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.buildUDP(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.postInitialise(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.bsmanager.O.B(Unknown Source)
at com.bas.basserver.bsmanager.J$_C.run(Unknown Source)
at java.lang.Thread.run(Thread.java:748)
2019-05-31 12:42:01,753 ERROR -Exception when loading user defined processes. User defined processes will not work
Server started...
Process status: Aware IM Server: Ok
Process status: Not started
Overall status: Aware IM is active
Tomcat: May 31, 2019 12:42:03 PM org.apache.jasper.servlet.TldScanner scanJars
Tomcat: INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

gvb@server:~/AwareIM/bin$
Tomcat: May 31, 2019 12:42:24 PM org.apache.catalina.util.SessionIdGeneratorBase createSecureRandom
Tomcat: WARNING: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [21,335] milliseconds.
Tomcat: Path of logonAdmin.html is /AwareIM/Tomcat/webapps/AwareIM/logonAdmin.html
Tomcat: Setting web app dir to /AwareIM/Tomcat/webapps/AwareIM/
Tomcat: Setting lib dir to /AwareIM
Tomcat: May 31, 2019 12:42:24 PM org.apache.jasper.EmbeddedServletOptions <init>
Tomcat: SEVERE: The scratchDir you specified: [/AwareIM/Tomcat/work/Catalina/localhost/AwareIM] is unusable.
Tomcat: May 31, 2019 12:42:24 PM org.apache.catalina.startup.HostConfig deployDirectory
Tomcat: INFO: Deployment of web application directory [/AwareIM/Tomcat/webapps/AwareIM] has finished in [24,691] ms
Tomcat: May 31, 2019 12:42:24 PM org.apache.catalina.startup.HostConfig deployDirectory
Tomcat: INFO: Deploying web application directory [/AwareIM/Tomcat/webapps/manager]
Tomcat: May 31, 2019 12:42:24 PM org.apache.jasper.EmbeddedServletOptions <init>
Tomcat: SEVERE: The scratchDir you specified: [/AwareIM/Tomcat/work/Catalina/localhost/manager] is unusable.
Tomcat: May 31, 2019 12:42:24 PM org.apache.catalina.startup.HostConfig deployDirectory
Tomcat: INFO: Deployment of web application directory [/AwareIM/Tomcat/webapps/manager] has finished in [30] ms
Tomcat: May 31, 2019 12:42:24 PM org.apache.catalina.startup.HostConfig deployDirectory
Tomcat: INFO: Deploying web application directory [/AwareIM/Tomcat/webapps/host-manager]
Tomcat: May 31, 2019 12:42:24 PM org.apache.jasper.EmbeddedServletOptions <init>
Tomcat: SEVERE: The scratchDir you specified: [/AwareIM/Tomcat/work/Catalina/localhost/host-manager] is unusable.
Tomcat: May 31, 2019 12:42:24 PM org.apache.catalina.startup.HostConfig deployDirectory
Tomcat: INFO: Deployment of web application directory [/AwareIM/Tomcat/webapps/host-manager] has finished in [24] ms
Tomcat: May 31, 2019 12:42:24 PM org.apache.coyote.AbstractProtocol start
Tomcat: INFO: Starting ProtocolHandler ["http-nio-8080"]
Tomcat: May 31, 2019 12:42:24 PM org.apache.coyote.AbstractProtocol start
Tomcat: INFO: Starting ProtocolHandler ["https-jsse-nio-8443"]
Tomcat: May 31, 2019 12:42:24 PM org.apache.coyote.AbstractProtocol start
Tomcat: INFO: Starting ProtocolHandler ["ajp-nio-8009"]
Tomcat: May 31, 2019 12:42:24 PM org.apache.catalina.startup.Catalina start
Tomcat: INFO: Server startup in 24828 ms

[gijsvb]

And the database tables created:

-- MySQL dump 10.13 Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: bgncloud.nl Database: BASDB
-- ------------------------------------------------------
-- Server version 5.5.5-10.1.38-MariaDB-0ubuntu0.18.04.2

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `BAS_IDGEN`
--

DROP TABLE IF EXISTS `BAS_IDGEN`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `BAS_IDGEN` (
`MAX_ID` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `BAS_IDGEN`
--

LOCK TABLES `BAS_IDGEN` WRITE;
/*!40000 ALTER TABLE `BAS_IDGEN` DISABLE KEYS */;
INSERT INTO `BAS_IDGEN` VALUES (1);
/*!40000 ALTER TABLE `BAS_IDGEN` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `BAS_SYSTEM`
--

DROP TABLE IF EXISTS `BAS_SYSTEM`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `BAS_SYSTEM` (
`P1` varchar(100) DEFAULT NULL,
`P2` varchar(100) DEFAULT NULL,
`P3` varchar(100) DEFAULT NULL,
`P4` varchar(100) DEFAULT NULL,
`P5` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `BAS_SYSTEM`
--

LOCK TABLES `BAS_SYSTEM` WRITE;
/*!40000 ALTER TABLE `BAS_SYSTEM` DISABLE KEYS */;
INSERT INTO `BAS_SYSTEM` VALUES ('673d795b5a717fe0ddbf',NULL,'e2cfc1b3503439752b900c8e06c68d01','DefaultApplication','0.9948259108450725');
/*!40000 ALTER TABLE `BAS_SYSTEM` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `BAS_SYSTEM2`
--

DROP TABLE IF EXISTS `BAS_SYSTEM2`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `BAS_SYSTEM2` (
`P1` varchar(100) DEFAULT NULL,
`P2` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `BAS_SYSTEM2`
--

LOCK TABLES `BAS_SYSTEM2` WRITE;
/*!40000 ALTER TABLE `BAS_SYSTEM2` DISABLE KEYS */;
/*!40000 ALTER TABLE `BAS_SYSTEM2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ConfigToolUsers`
--

DROP TABLE IF EXISTS `ConfigToolUsers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ConfigToolUsers` (
`Acl` int(11) DEFAULT NULL,
`LoginName` varchar(80) DEFAULT NULL,
`Password` varchar(250) DEFAULT NULL,
`BusinessSpaces` mediumblob
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ConfigToolUsers`
--

LOCK TABLES `ConfigToolUsers` WRITE;
/*!40000 ALTER TABLE `ConfigToolUsers` DISABLE KEYS */;
INSERT INTO `ConfigToolUsers` VALUES (0,'admin','5f4db43b5ad965aa1dfd27a2c8feb1e7',NULL);
/*!40000 ALTER TABLE `ConfigToolUsers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT`
--

DROP TABLE IF EXISTS `DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT` (
`ID` int(11) NOT NULL,
`BASVERSION` int(11) DEFAULT NULL,
`BASTIMESTAMP` datetime DEFAULT NULL,
`UDD_AccessLevels` varchar(250) DEFAULT NULL,
`UDD_Template_DOCTYPE` varchar(200) DEFAULT NULL,
`UDD_Template_DOCDATA` longblob,
`UDD_Name` varchar(50) DEFAULT NULL,
`UDD_Type` varchar(50) DEFAULT NULL,
`UDD_ObjName` varchar(80) DEFAULT NULL,
`UDD_QueryString` mediumtext,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT`
--

LOCK TABLES `DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT` WRITE;
/*!40000 ALTER TABLE `DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `DEFAULTAPPLICATION_BAS_USERDEFINEDDOCUMENT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY`
--

DROP TABLE IF EXISTS `DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY` (
`ID` int(11) NOT NULL,
`BASVERSION` int(11) DEFAULT NULL,
`BASTIMESTAMP` datetime DEFAULT NULL,
`UDQ_Name` varchar(50) DEFAULT NULL,
`UDQ_AccessLevels` varchar(250) DEFAULT NULL,
`UDQ_Query` mediumblob,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY`
--

LOCK TABLES `DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY` WRITE;
/*!40000 ALTER TABLE `DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY` DISABLE KEYS */;
/*!40000 ALTER TABLE `DEFAULTAPPLICATION_BAS_USERDEFINEDQUERY` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DEFAULTAPPLICATION_REGULARUSER`
--

DROP TABLE IF EXISTS `DEFAULTAPPLICATION_REGULARUSER`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DEFAULTAPPLICATION_REGULARUSER` (
`ID` int(11) NOT NULL,
`BASVERSION` int(11) DEFAULT NULL,
`BASTIMESTAMP` datetime DEFAULT NULL,
`AccessLevel` varchar(50) DEFAULT NULL,
`Theme` varchar(80) DEFAULT NULL,
`TimeZone` varchar(80) DEFAULT NULL,
`Password` varchar(40) DEFAULT NULL,
`RTL` bit(1) DEFAULT NULL,
`SessionTimeout` int(11) DEFAULT NULL,
`LoginName` varchar(40) DEFAULT NULL,
`Locale` varchar(50) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DEFAULTAPPLICATION_REGULARUSER`
--

LOCK TABLES `DEFAULTAPPLICATION_REGULARUSER` WRITE;
/*!40000 ALTER TABLE `DEFAULTAPPLICATION_REGULARUSER` DISABLE KEYS */;
INSERT INTO `DEFAULTAPPLICATION_REGULARUSER` VALUES (1,1,'2019-05-31 12:42:01','Administrator',NULL,NULL,'5f4db43b5ad965aa1dfd27a2c8feb1e7',NULL,NULL,'admin',NULL);
/*!40000 ALTER TABLE `DEFAULTAPPLICATION_REGULARUSER` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DEFAULTAPPLICATION_SYSTEMSETTINGS`
--

DROP TABLE IF EXISTS `DEFAULTAPPLICATION_SYSTEMSETTINGS`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DEFAULTAPPLICATION_SYSTEMSETTINGS` (
`ID` int(11) NOT NULL,
`BASVERSION` int(11) DEFAULT NULL,
`BASTIMESTAMP` datetime DEFAULT NULL,
`OutgoingEmailSSL` bit(1) DEFAULT NULL,
`UDPAcls` varchar(3) DEFAULT NULL,
`OutgoingEmailPort` int(11) DEFAULT NULL,
`OutgoingEmailFromAddress` varchar(50) DEFAULT NULL,
`GoogleMapsKey` varchar(150) DEFAULT NULL,
`OutgoingEmailUserName` varchar(50) DEFAULT NULL,
`OutgoingEmailTLS` bit(1) DEFAULT NULL,
`IncomingEmailUserName` varchar(50) DEFAULT NULL,
`OutgoingEmailPassword` varchar(50) DEFAULT NULL,
`IncomingEmailPassword` varchar(50) DEFAULT NULL,
`IncomingEmailSSL` bit(1) DEFAULT NULL,
`IncomingEmailProtocol` varchar(15) DEFAULT NULL,
`IncomingEmailHost` varchar(50) DEFAULT NULL,
`OutgoingEmailHost` varchar(50) DEFAULT NULL,
`IncomingEmailPort` int(11) DEFAULT NULL,
`IncomingEmailTLS` bit(1) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DEFAULTAPPLICATION_SYSTEMSETTINGS`
--

LOCK TABLES `DEFAULTAPPLICATION_SYSTEMSETTINGS` WRITE;
/*!40000 ALTER TABLE `DEFAULTAPPLICATION_SYSTEMSETTINGS` DISABLE KEYS */;
/*!40000 ALTER TABLE `DEFAULTAPPLICATION_SYSTEMSETTINGS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DOMAINS`
--

DROP TABLE IF EXISTS `DOMAINS`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DOMAINS` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`DATA` mediumblob,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DOMAINS`
--

LOCK TABLES `DOMAINS` WRITE;
/*!40000 ALTER TABLE `DOMAINS` DISABLE KEYS */;
INSERT INTO `DOMAINS` VALUES (1,'xœ…T\ÍoEY{›\ÔnKš\0•@  \rmhY*’[š´K\ÄF&M\å\ÈBX%\Z\ïN\ì\rû1̾u·P{Ÿ\äc\'$.ü=UH•8 DopD´R\̯?„Y\É?\ï̼y¿÷\Þ\ï½\Ýý\ÌD™X¶­XðˆyL`,-!‹[[\Ü\ÅĪû¡¸­v.띭O¿õšU6˜¨A¯Ž0WS*#*#*uûòº2«f¬qLK­%sq\Èu÷Ë«»3¿\×\\º,Hy‚ðHm‹uY%E?¨¼Î’²V ¼•\É,Xtb\rNf|h\î\é•\ß(€±¥ fÞ²\"‰¥±#yÒ‰/ž©kS\n\Ë\êWD(®²Pe7cóM–¸$D\à»ý8B0[ñ\Õ|‹Ú–!os9ó\Ûö\Î\ß7?|E…쀩CVyO\íVÓ°\Å\å»_<Qþü׏€L(¶ „©†m\Æ2LR ó\ÍÚ¸J\r+T½söÁ‹7ν\Ýwd$\ï\Âû\0\Z\Í%e ˜š¡°`- hÔ‘!\×\æ%Š#SY\Û=5\ï\'ÛŸ\Ý\Þ=¿c@\á-(ûÉšôCý._\É.—‰*’j\Ô÷T{‚Qú•:J?jS/œÇ²\ìg\Ü\ë1\Ù\å_v~ºúóMŠ58¼\áv¸û÷\èDG]¨A‰¡ò\ÚJ‘ºcf¤;\Zœ„®\Ö\à\ÈЂú\"¿WŒ”¾ô~,\Ô=\Ó\Ã\î\éݼó\Õ{\Í\Õ\ï&\nPp\à¨\Ës}¼\îD®\ä!ÐC<\Ðo—\â4\Â&”ó%\éƒ0\Û\É;—KkD©T\Î\rz}‘|r\ë\Ío¦“ù ¯gI\Åu\êôX\ê\'·ò\Ú\é»÷¾^\Ø6À\Ín0§\'\Æ\ÎiL]š\Ñ\Å}T¡š¤\'\ÚD:\Ð\É }þÁ\Ã#¦¦\Zƒ³/\î±<Ù³¤^³y\âJZ\ïµäš·g«Ð¨½1\âqJ“¯û!\ß\ã´\"\è\Éþ£\ÍMÁ3\Ϝѡ\Ì\Ìœ\"8Mð\\†pÈŽC\æGŽú\Þ5œ>ˆñ¥™ô4½0¬Mdôö\§\ÎewIn,_YExٍC«\Å+\é0\É=\ËÓ´–G›~;•úc坤f}T–WEÿ=ž‡7™\Ò\êI\Ý)E^\Z)(Á\ä¾õA‚gû7\ì‹{Xß·a\î׍\à°NoŒ“\æs\Îóƒ›6Á‚W .\\\Ä^%X\"XT”†5\ÊòôöV');
/*!40000 ALTER TABLE `DOMAINS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DOMAINVERSIONS`
--

DROP TABLE IF EXISTS `DOMAINVERSIONS`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DOMAINVERSIONS` (
`DNAME` char(50) DEFAULT NULL,
`VERSIONSTR` char(30) DEFAULT NULL,
`DATA` mediumblob
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DOMAINVERSIONS`
--

LOCK TABLES `DOMAINVERSIONS` WRITE;
/*!40000 ALTER TABLE `DOMAINVERSIONS` DISABLE KEYS */;
INSERT INTO `DOMAINVERSIONS` VALUES ('DefaultApplication','1.0','..... TEXT DELETED by ME .....');
/*!40000 ALTER TABLE `DOMAINVERSIONS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DVHISTORIES`
--

DROP TABLE IF EXISTS `DVHISTORIES`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DVHISTORIES` (
`DNAME` char(50) DEFAULT NULL,
`VERSIONSTR` char(30) DEFAULT NULL,
`EVENTTYPE` tinyint(4) DEFAULT NULL,
`EVENTTIME` datetime DEFAULT NULL,
`DESCR` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DVHISTORIES`
--

LOCK TABLES `DVHISTORIES` WRITE;
/*!40000 ALTER TABLE `DVHISTORIES` DISABLE KEYS */;
INSERT INTO `DVHISTORIES` VALUES ('DefaultApplication','1.0',0,'2019-05-31 12:42:01','Blank version created'),('DefaultApplication','1.1',0,'2019-05-31 12:42:01','Created from version 1.0');
/*!40000 ALTER TABLE `DVHISTORIES` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DV_SYNC_LOG`
--

DROP TABLE IF EXISTS `DV_SYNC_LOG`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DV_SYNC_LOG` (
`AwEventId` int(11) DEFAULT NULL,
`AwEventName` varchar(60) DEFAULT NULL,
`AwUserId` int(11) DEFAULT NULL,
`CalendarId` varchar(100) DEFAULT NULL,
`SyncTime` datetime DEFAULT NULL,
`VEventId` varchar(100) DEFAULT NULL,
`VendorId` varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DV_SYNC_LOG`
--

LOCK TABLES `DV_SYNC_LOG` WRITE;
/*!40000 ALTER TABLE `DV_SYNC_LOG` DISABLE KEYS */;
/*!40000 ALTER TABLE `DV_SYNC_LOG` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `EXECUTION_CONTEXTS`
--

DROP TABLE IF EXISTS `EXECUTION_CONTEXTS`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `EXECUTION_CONTEXTS` (
`ID` int(11) DEFAULT NULL,
`DATA` tinyblob,
`LONGDATA` mediumblob,
`PGID` int(11) DEFAULT NULL,
`PROCNAME` varchar(50) DEFAULT NULL,
`POLLING` bit(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `EXECUTION_CONTEXTS`
--

LOCK TABLES `EXECUTION_CONTEXTS` WRITE;
/*!40000 ALTER TABLE `EXECUTION_CONTEXTS` DISABLE KEYS */;
/*!40000 ALTER TABLE `EXECUTION_CONTEXTS` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2019-05-31 12:47:05

[aware_support]

Thank you. It's very strange. Looks like all tables have been created properly except DV_RES. Not sure how this is possible. We'll investigate early next week.

[Jaymer]

so in the mean time, you should be able to manually create it?
the structure at least, but you won't have a value for the initial DataKey record.

[aware_support]

You can try but if one of the system tables hasn't been created it's an indication of a serious issue, so you may have problems elsewhere even if you fix this one.

Mind you, it works flawlessly for us (and a few other people) on Windows. So it can be either Linux-specific or MariaDB version-specific.

[gijsvb]

The problem is a combination of MariaDB 10.1 and InnoDB as a default database.

I installed AwareIM on a different system using MyISAM as a default database. DV_RES was created on that system. Changing the storage engine from MyISAM to InnoDB lead to this error:
ERROR 1071: Specified key was too long; max key length is 767 bytes
SQL Statement:
ALTER TABLE `BASDB`.`DV_RES`
ENGINE = InnoDB

Because the DataKey is defined as VARCHAR(250) with charset utf8mb4, this lead to a 4*250=1000 bytes key. Which exceeds the InnoDB limit of 767 bytes in MariaDB 10.1.

i now have a DV_RES stored in MyISAM and the system seems to work, have to import data into my AwareIM system.

[aware_support]

MYISAM tables are not the best choice - they are not transactional, as far as I know.

What is this 767 limit? Is there a way to make it bigger?

[gijsvb]

Hi,

The 767 max key-length restriction on InnoDB tables is lifted to 3000 for MariaDB 10.2 and higher. The default MariaDB for Ubuntu and other debian distributions is still 10.1. That's why my system has 10.1 installed.

Is there a problem to change the character set of this key field to utf8 instead of utf8mb4? This would reduce the size of the key.

Regards,

Gijs.

P.S. On a system with MyISAM as default storage engine, some tables are created in InnoDB and some are in MyISAM:
InnoDB: BAS_IDGEN, BAS_SYSTEM, BAS_SYSTEM2, DOMAINS, DOMAINVERSIONS, DVHISTORIES, EXECUTION_CONTEXTS
MyISAM: ConfigToolUsers, DV_RES, DV_SYNC_LOG