" /> UCS can't start (DB = Microsoft SQL Server) - Genesys CTI User Forum

Author Topic: UCS can't start (DB = Microsoft SQL Server)  (Read 2753 times)

Offline berserkzas

  • Newbie
  • *
  • Posts: 8
  • Karma: 0
UCS can't start (DB = Microsoft SQL Server)
« on: October 18, 2023, 07:15:13 AM »
Advertisement
Hi all,
I have a problem when starting UCS application. after a while, the program stops working on its own.
The UCS database is in Microsoft SQL Server.
Can anyone help me?
Here is the last part of my ucs log:
Application Name: UCS
Application Type: CONTACT_SERVER
Application Host (config spec): Demosrv2016
Application Id: 134
Application Version: 8.5.300.43
Application Backup: None
Application Connections:
MessageServer (MESSAGE_SERVER) on Demosrv2016
DAP_UCS_JDBC (DB_SERVER:mssql) on Demosrv2016
Timezone Display name: Pacific Standard Time
Timezone UTC offset: 07:00:00
UTC Start Time: 2023-10-18T21:03:02.026
Running Time (DDD:HH:MM:SS): 000:00:00:04
UTC Time: 2023-10-18T21:03:06.683
Local Time: 2023-10-18T14:03:06.683
Memory Usage (bytes): 56623088 / 134217728
Host Info: Windows Server 2016
Host Architecture: amd64
OS Version: 10.0
JVM Encoding: Cp1252
Start Folder: C:\GCTI\UCS
File: D:\Logs\UCS\UCS.20231018_140306_536.log
Java Vendor: Oracle Corporation
Java Version: 1.8.0_291
Java Home: C:\Program Files\Java\jdk1.8.0_291\jre
Java Arguments: [-server, -Xmx2048M, -Djava.rmi.dgc.leaseValue=60000, -Djava.library.path=C:\Program Files\Java\jdk1.8.0_291/lib, -Dtkv.multibytes=true, -XX:+HeapDumpOnOutOfMemoryError, -XX:+ExplicitGCInvokesConcurrent, -XX:+UseG1GC, -XX:MaxGCPauseMillis=200, -XX:InitiatingHeapOccupancyPercent=45, -XX:+UseStringDeduplication]
Environment Variables: {LOCALAPPDATA=C:\Windows\system32\config\systemprofile\AppData\Local, PROCESSOR_LEVEL=6, USERDOMAIN=WORKGROUP, JAVA_HOME=C:\Program Files\Java\jre1.8.0_361, ALLUSERSPROFILE=C:\ProgramData, PROCESSOR_ARCHITECTURE=AMD64, PSModulePath=C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules\, SystemDrive=C:, =C:=C:\GCTI\UCS, APPDATA=C:\Windows\system32\config\systemprofile\AppData\Roaming, USERNAME=DEMOSRV2016$, ProgramFiles(x86)=C:\Program Files (x86), CommonProgramFiles=C:\Program Files\Common Files, Path=C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\DTS\Binn\;D:\Software\1_Prepare Server Environment\apache-maven-3.9.4\bin;C:\Windows\system32\config\systemprofile\AppData\Local\Microsoft\WindowsApps, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, OS=Windows_NT, COMPUTERNAME=DEMOSRV2016, PROCESSOR_REVISION=3f02, CommonProgramW6432=C:\Program Files\Common Files, ComSpec=C:\Windows\system32\cmd.exe, ProgramData=C:\ProgramData, ProgramW6432=C:\Program Files, SystemRoot=C:\Windows, TEMP=C:\Windows\TEMP, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 63 Stepping 2, GenuineIntel, USERPROFILE=C:\Windows\system32\config\systemprofile, TMP=C:\Windows\TEMP, CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files, ProgramFiles=C:\Program Files, PUBLIC=C:\Users\Public, NUMBER_OF_PROCESSORS=2, windir=C:\Windows}
System Variables: {java.runtime.name=Java(TM) SE Runtime Environment, org.quartz.scheduler.skipUpdateCheck=true, sun.boot.library.path=C:\Program Files\Java\jdk1.8.0_291\jre\bin, java.vm.version=25.291-b10, java.vm.vendor=Oracle Corporation, java.vendor.url=http://java.oracle.com/, path.separator=;, java.vm.name=Java HotSpot(TM) 64-Bit Server VM, file.encoding.pkg=sun.io, user.country=US, user.script=, sun.os.patch.level=, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\GCTI\UCS, com.genesyslab.platform.commons.connection.factory.class=com.genesyslab.platform.commons.connection.impl.netty4.Netty4ConnectionFactory, java.runtime.version=1.8.0_291-b10, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, org.jboss.logging.provider=slf4j, java.endorsed.dirs=C:\Program Files\Java\jdk1.8.0_291\jre\lib\endorsed, os.arch=amd64, java.rmi.dgc.leaseValue=60000, java.io.tmpdir=C:\Windows\TEMP\, line.separator= n, com.genesyslab.platform.commons.log.loggerFactory=log4j2, java.vm.specification.vendor=Oracle Corporation, java.util.logging.manager=org.apache.logging.log4j.jul.LogManager, user.variant=, os.name=Windows Server 2016, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.8.0_291/lib, sun.nio.ch.bugLevel=, java.specification.name=Java Platform API Specification, java.class.version=52.0, sun.management.compiler=HotSpot 64-Bit Tiered Compilers, os.version=10.0, org.restlet.engine.loggerFacadeClass=org.restlet.ext.slf4j.Slf4jLoggerFacade, user.home=C:\Windows\system32\config\systemprofile, user.timezone=America/Los_Angeles, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.8, log4j2-config-profile=log4j2.xml, java.class.path=./lib/antlr-2.7.7.jar;./lib/apptemplate-900.7.4.jar;./lib/apptemplate-log4j2-900.7.4.jar;./lib/aspectjrt-1.9.3.jar;./lib/aspectjweaver-1.9.3.jar;./lib/bc-fips-1.0.1.jar;./lib/bctls-fips-1.0.8.jar;./lib/cal-8.5.300.43.jar;./lib/comappblock-900.7.4.jar;./lib/commonLib.jar;./lib/commons-900.7.4.jar;./lib/commons-codec-1.9.jar;./lib/commons-fileupload-1.3.3.jar;./lib/commons-io-2.2.jar;./lib/commons-lang3-3.9.jar;./lib/commons-logging-1.2.jar;./lib/commons-text-1.6.jar;./lib/commonsappblock-900.7.4.jar;./lib/configurationprotocol-900.7.4.jar;./lib/connection-900.7.4.jar;./lib/contactsprotocol-900.7.4.jar;./lib/db2-10.1.jar;./lib/dsw_api_java.jar;./lib/dsw_extension_core.jar;./lib/dsw_transformers.jar;./lib/FastInfoset-1.2.15.jar;./lib/fastjson-1.2.62.jar;./lib/findbugs-3.0.1.jar;./lib/guava-27.1-jre.jar;./lib/HikariCP-3.3.1.jar;./lib/httpclient-4.5.2.jar;./lib/httpcore-4.4.4.jar;./lib/icc-utils-8.5.300.43.jar;./lib/istack-commons-runtime-3.0.7.jar;./lib/jakarta-regexp-1.4.jar;./lib/jakarta.activation-1.2.1.jar;./lib/javax.activation-api-1.2.0.jar;./lib/javax.annotation-api-1.3.jar;./lib/javax.servlet-api-3.1.0.jar;./lib/jaxb-api-2.3.1.jar;./lib/jaxb-runtime-2.3.1.jar;./lib/jericho-html-3.4.jar;./lib/jetty-client-9.4.18.v20190429.jar;./lib/jetty-http-9.4.18.v20190429.jar;./lib/jetty-io-9.4.18.v20190429.jar;./lib/jetty-server-9.4.18.v20190429.jar;./lib/jetty-util-9.4.18.v20190429.jar;./lib/json-20180813.jar;./lib/jsr305-3.0.2.jar;./lib/kvlistbinding-900.7.4.jar;./lib/kvlists-900.7.4.jar;./lib/kvlists.jar;./lib/libidn-1.15.jar;./lib/log4j-api-2.11.2.jar;./lib/log4j-core-2.11.2.jar;./lib/log4j-jcl-2.11.2.jar;./lib/log4j-jul-2.11.2.jar;./lib/log4j-slf4j-impl-2.11.2.jar;./lib/logging-900.7.4.jar;./lib/lucene-analyzers-common-4.5.1.jar;./lib/lucene-core-4.5.1.jar;./lib/lucene-queries-4.5.1.jar;./lib/lucene-queryparser-4.5.1.jar;./lib/lucene-sandbox-4.5.1.jar;./lib/mailapi-1.6.3.jar;./lib/managementprotocol-900.7.4.jar;./lib/messagebrokerappblock-900.7.4.jar;./lib/metrics-core-4.0.5.jar;./lib/metrics-healthchecks-4.0.5.jar;./lib/metrics-jmx-4.0.5.jar;./lib/metrics-jvm-4.0.5.jar;./lib/metrics-zabbix-0.0.5.jar;./lib/mssql-jdbc-7.2.2.jre8.jar;./lib/netty-all-4.1.42.Final.jar;./lib/ojdbc8.jar;./lib/ons.jar;./lib/opencsv-4.6.jar;./lib/openmediaprotocol-900.7.4.jar;./lib/org.restlet-2.4.1.jar;./lib/org.restlet.ext.fileupload-2.4.1.jar;./lib/org.restlet.ext.jetty-2.4.1.jar;./lib/org.restlet.ext.json-2.4.1.jar;./lib/org.restlet.ext.slf4j-2.4.1.jar;./lib/org.restlet.ext.xml-2.4.1.jar;./lib/outboundprotocol-900.7.4.jar;./lib/postgresql-42.2.5.jar;./lib/protocol-900.7.4.jar;./lib/protocolmanagerappblock-900.7.4.jar;./lib/quartz-2.3.2.jar;./lib/reportingprotocol-900.7.4.jar;./lib/routingprotocol-900.7.4.jar;./lib/slf4j-api-1.7.26.jar;./lib/spring-aop-4.3.23.RELEASE.jar;./lib/spring-beans-4.3.23.RELEASE.jar;./lib/spring-context-4.3.23.RELEASE.jar;./lib/spring-core-4.3.23.RELEASE.jar;./lib/spring-expression-4.3.23.RELEASE.jar;./lib/spring-jdbc-4.3.23.RELEASE.jar;./lib/spring-tx-4.3.23.RELEASE.jar;./lib/StatLib.jar;./lib/statserver.jar;./lib/stax-ex-1.8.jar;./lib/system-900.7.4.jar;./lib/txw2-2.3.1.jar;./lib/ucp.jar;./lib/ucserver-8.5.300.43.jar;./lib/voiceprotocol-900.7.4.jar;./lib/warmstandbyappblock-900.7.4.jar;./lib/webmediaprotocol-900.7.4.jar;./lib/xstream-1.4.11.1.jar;./lib/zabbix-sender-0.0.5.jar;, user.name=DEMOSRV2016$, java.vm.specification.version=1.8, java.home=C:\Program Files\Java\jdk1.8.0_291\jre, sun.arch.data.model=64, user.language=en, java.specification.vendor=Oracle Corporation, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.8.0_291, java.ext.dirs=C:\Program Files\Java\jdk1.8.0_291\jre\lib\ext;C:\Windows\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jdk1.8.0_291\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_291\jre\lib\rt.jar;C:\Program Files\Java\jdk1.8.0_291\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.8.0_291\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_291\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_291\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_291\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_291\jre\classes, org.jboss.as.logging.per-deployment=false, java.vendor=Oracle Corporation, sun.stderr.encoding=cp437, file.separator=\, java.vendor.url.bug=http://bugreport.sun.com/bugreport/, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, psdk.config.tls=false, tkv.multibytes=true, sun.stdout.encoding=cp437, sun.desktop=windows, sun.cpu.isalist=amd64}
Application Options: {
  { settings ['synchronize-screening-rules' [str] = "true", 'reporting-interval' [str] = "00:00:30", 'log-memory-usage' [str] = "true", 'third-party-pool-size' [str] = "50", 'max-select-count' [str] = "2000", 'reporting-event-queue-size' [str] = "4000", 'srl-cache-load-attachment-summary' [str] = "true", 'fieldcode-format-locale' [str] = "", 'openmedia-create-full-interaction' [str] = "false", 'synchronize-standard-responses' [str] = "true", 'allow-missing-index' [str] = "true", 'convert-idn-to-unicode' [str] = "false", 'ucsapi-duplex-mode' [str] = "false", 'log-db-flow-rate' [str] = "true", 'synchronize-ixn-attributes' [str] = "true", 'synchronize-ixn-metadata-attributes' [str] = "true", 'allow-additional-column' [str] = "true", 'archiving-task-pool-size' [str] = "4", 'enable-rmi' [str] = "false", 'ucsapi-loopback-timeout' [str] = "10000", 'synchronize-cache' [str] = "true", 'reporting-notifier-pool-size' [str] = "30", 'primary-attribute-lookup-strategy' [str] = "true", 'third-party-max-queueing-time' [str] = "15000", 'synchronize-contact-metadata-attributes' [str] = "true", 'enable-reporting' [str] = "false", 'ucsapi-backlog' [str] = "0", 'archiving-nb-records-per-task' [str] = "1000", 'replace-blank-fieldcode' [str] = "false", 'retry-on-deadlock' [str] = "2", ]}
  { cview ['enabled' [str] = "false", 'data-validation' [str] = "false", 'start-mode' [str] = "maintenance", 'metadata-cache' [str] = "true", 'ip-address' [str] = "", 'base-url' [str] = "", 'metrics-ui' [str] = "", 'tenant-id' [str] = "101", ]}
  { log-filter ['default-filter-type' [str] = "hide", ]}
  { log ['debug' [str] = "false", 'enable-access-log' [str] = "false", 'expire' [str] = "5", 'access-log-path' [str] = "access.log", 'verbose' [str] = "standard", 'trace' [str] = "false", 'standard' [str] = "false", 'segment' [str] = "20000", 'log-background-activity' [str] = "true", 'access-log-rolling-period' [str] = "'.'yyyy-MM-dd", 'access-log-apptype-filter-out' [str] = "", 'buffering' [str] = "false", 'messagefile' [str] = "ContactServer.lms", 'all' [str] = "D:\Logs\UCS\UCS", 'access-log-apptype-filter-in' [str] = "", 'log-body' [str] = "false", 'time-format' [str] = "ISO8601", ]}
  { index.contact ['enabled' [str] = "true", 'index-rebuild' [str] = "if-new", 'max-results' [str] = "10", 'description' [str] = "Contacts", 'storage-path' [str] = "", ]}
  { index.interaction ['enabled' [str] = "true", 'index-rebuild' [str] = "if-new", 'max-results' [str] = "10", 'description' [str] = "Interactions", 'storage-path' [str] = "", ]}
  { index ['enabled' [str] = "true", 'shared' [str] = "false", ]}
  { index.srl ['enabled' [str] = "true", 'index-rebuild' [str] = "if-new", 'max-results' [str] = "10", 'description' [str] = "Standard Responses", 'storage-path' [str] = "", ]}
  { ports ['ucsapi' [str] = "", ]}
  { business-attributes ['map-names' [str] = "false", ]}
  { authentication ['enabled' [str] = "false", 'password' [str] = "", 'mode' [str] = "single-user", 'username' [str] = "", 'use-role' [str] = "false", ]}
}
2023-10-18T14:03:06,673 Std 04503 [Ucs-Main  ] <[]> Connected to CONFIG_SERVER 'confserv - tcp://Demosrv2016:2020' at host 'Demosrv2016', port 2020
2023-10-18T14:03:06,685 Std 05200 [Ucs-Main  ] <[]> Ucs-Main. Version Config Server
2023-10-18T14:03:07,013 Std 05060 [Ucs-Main  ] <[]> Application started
2023-10-18T14:03:07,014 Std 05201 [Ucs-Main  ] <[]> Copyright (c) 2003-2019 Genesys Telecommunications Laboratories, Inc.
2023-10-18T14:03:07,015 Std 20002 [Ucs-Main  ] <[]> Running 'UCS' with Config Server running on host 'Demosrv2016', port 2020
2023-10-18T14:03:07,017 Std 05200 [Ucs-Main  ] <[]> antlr-2.7.7.jar (./lib/antlr-2.7.7.jar). Version not available
2023-10-18T14:03:07,018 Std 05200 [Ucs-Main  ] <[]> PSDK :: Application Template Application Block (./lib/apptemplate-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,020 Std 05200 [Ucs-Main  ] <[]> PSDK :: Application Template AB Log4j2 Plugin (./lib/apptemplate-log4j2-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,021 Std 05200 [Ucs-Main  ] <[]> AspectJ Runtime Classes (./lib/aspectjrt-1.9.3.jar). Version 1.9.3
2023-10-18T14:03:07,022 Std 05200 [Ucs-Main  ] <[]> AspectJ Weaver Classes (./lib/aspectjweaver-1.9.3.jar). Version 1.9.3
2023-10-18T14:03:07,043 Std 05200 [Ucs-Main  ] <[]> bc-fips-1.0.1.jar (./lib/bc-fips-1.0.1.jar). Version 1.0.1
2023-10-18T14:03:07,052 Std 05200 [Ucs-Main  ] <[]> bctls-fips-1.0.8.jar (./lib/bctls-fips-1.0.8.jar). Version 1.0.8
2023-10-18T14:03:07,052 Std 05200 [Ucs-Main  ] <[]> Universal Contact Server (./lib/cal-8.5.300.43.jar). Version 8.5.300.43
2023-10-18T14:03:07,054 Std 05200 [Ucs-Main  ] <[]> PSDK :: Configuration Object Model Application Block (./lib/comappblock-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,055 Std 05200 [Ucs-Main  ] <[]> CommonLib package (./lib/commonLib.jar). Version 7.1.000.07
2023-10-18T14:03:07,057 Std 05200 [Ucs-Main  ] <[]> PSDK :: Common Utils (./lib/commons-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,059 Std 05200 [Ucs-Main  ] <[]> Apache Commons Codec (./lib/commons-codec-1.9.jar). Version 1.9
2023-10-18T14:03:07,066 Std 05200 [Ucs-Main  ] <[]> Apache Commons FileUpload (./lib/commons-fileupload-1.3.3.jar). Version 1.3.3
2023-10-18T14:03:07,067 Std 05200 [Ucs-Main  ] <[]> Commons IO (./lib/commons-io-2.2.jar). Version 2.2
2023-10-18T14:03:07,068 Std 05200 [Ucs-Main  ] <[]> Apache Commons Lang (./lib/commons-lang3-3.9.jar). Version 3.9
2023-10-18T14:03:07,069 Std 05200 [Ucs-Main  ] <[]> Apache Commons Logging (./lib/commons-logging-1.2.jar). Version 1.2
2023-10-18T14:03:07,070 Std 05200 [Ucs-Main  ] <[]> Apache Commons Text (./lib/commons-text-1.6.jar). Version 1.6
2023-10-18T14:03:07,071 Std 05200 [Ucs-Main  ] <[]> PSDK :: Common Application Block (./lib/commonsappblock-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,072 Std 05200 [Ucs-Main  ] <[]> PSDK :: Configuration Protocol (./lib/configurationprotocol-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,073 Std 05200 [Ucs-Main  ] <[]> PSDK :: Commons Connection (./lib/connection-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,074 Std 05200 [Ucs-Main  ] <[]> PSDK :: Universal Contact Server Protocol (./lib/contactsprotocol-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,075 Std 05200 [Ucs-Main  ] <[]> db2-10.1.jar (./lib/db2-10.1.jar). Version not available
2023-10-18T14:03:07,077 Std 05200 [Ucs-Main  ] <[]>    "Genesys MCR SSJE DSW API" (./lib/dsw_api_java.jar). Version "7.5.000.00"
2023-10-18T14:03:07,077 Std 05200 [Ucs-Main  ] <[]>    "Genesys MCR SSJE DSW Core" (./lib/dsw_extension_core.jar). Version "7.5.000.00"
2023-10-18T14:03:07,078 Std 05200 [Ucs-Main  ] <[]>    "Genesys MCR SSJE DSW API" (./lib/dsw_transformers.jar). Version "7.5.000.00"
2023-10-18T14:03:07,078 Std 05200 [Ucs-Main  ] <[]> ITU-T Rec. X.891 | ISO/IEC 24824-1 (Fast Infoset) (./lib/FastInfoset-1.2.15.jar). Version 1.2.15
2023-10-18T14:03:07,080 Std 05200 [Ucs-Main  ] <[]> fastjson-1.2.62.jar (./lib/fastjson-1.2.62.jar). Version not available
2023-10-18T14:03:07,084 Std 05200 [Ucs-Main  ] <[]> findbugs-3.0.1.jar (./lib/findbugs-3.0.1.jar). Version not available
2023-10-18T14:03:07,086 Std 05200 [Ucs-Main  ] <[]> guava-27.1-jre.jar (./lib/guava-27.1-jre.jar). Version 27.1.0.jre
2023-10-18T14:03:07,088 Std 05200 [Ucs-Main  ] <[]> HikariCP-3.3.1.jar (./lib/HikariCP-3.3.1.jar). Version 3.3.1
2023-10-18T14:03:07,089 Std 05200 [Ucs-Main  ] <[]> HttpComponents Apache HttpClient (./lib/httpclient-4.5.2.jar). Version 4.5.2
2023-10-18T14:03:07,090 Std 05200 [Ucs-Main  ] <[]> HttpComponents Apache HttpCore (./lib/httpcore-4.4.4.jar). Version 4.4.4
2023-10-18T14:03:07,091 Std 05200 [Ucs-Main  ] <[]> Universal Contact Server (./lib/icc-utils-8.5.300.43.jar). Version 8.5.300.43
2023-10-18T14:03:07,095 Std 05200 [Ucs-Main  ] <[]> istack-commons-runtime-3.0.7.jar (./lib/istack-commons-runtime-3.0.7.jar). Version 3.0.7
2023-10-18T14:03:07,096 Std 05200 [Ucs-Main  ] <[]> jakarta-regexp-1.4.jar (./lib/jakarta-regexp-1.4.jar). Version not available
2023-10-18T14:03:07,096 Std 05200 [Ucs-Main  ] <[]> JavaBeans(TM) Activation Framework Specification (./lib/jakarta.activation-1.2.1.jar). Version 1.2.1
2023-10-18T14:03:07,097 Std 05200 [Ucs-Main  ] <[]> javax.activation.javax.activation-api (./lib/javax.activation-api-1.2.0.jar). Version 1.2.0
2023-10-18T14:03:07,098 Std 05200 [Ucs-Main  ] <[]> javax.annotation-api-1.3.jar (./lib/javax.annotation-api-1.3.jar). Version 1.3
2023-10-18T14:03:07,099 Std 05200 [Ucs-Main  ] <[]> javax.servlet-api-3.1.0.jar (./lib/javax.servlet-api-3.1.0.jar). Version 3.1.0
2023-10-18T14:03:07,100 Std 05200 [Ucs-Main  ] <[]> jaxb-api (./lib/jaxb-api-2.3.1.jar). Version 2.3.0
2023-10-18T14:03:07,101 Std 05200 [Ucs-Main  ] <[]> Java Architecture for XML Binding (./lib/jaxb-runtime-2.3.1.jar). Version 2.3.1
2023-10-18T14:03:07,104 Std 05200 [Ucs-Main  ] <[]> jericho-html-3.4.jar (./lib/jericho-html-3.4.jar). Version not available
2023-10-18T14:03:07,105 Std 05200 [Ucs-Main  ] <[]> jetty-client-9.4.18.v20190429.jar (./lib/jetty-client-9.4.18.v20190429.jar). Version 9.4.18.v20190429
2023-10-18T14:03:07,106 Std 05200 [Ucs-Main  ] <[]> jetty-http-9.4.18.v20190429.jar (./lib/jetty-http-9.4.18.v20190429.jar). Version 9.4.18.v20190429
2023-10-18T14:03:07,110 Std 05200 [Ucs-Main  ] <[]> jetty-io-9.4.18.v20190429.jar (./lib/jetty-io-9.4.18.v20190429.jar). Version 9.4.18.v20190429
2023-10-18T14:03:07,111 Std 05200 [Ucs-Main  ] <[]> jetty-server-9.4.18.v20190429.jar (./lib/jetty-server-9.4.18.v20190429.jar). Version 9.4.18.v20190429
2023-10-18T14:03:07,112 Std 05200 [Ucs-Main  ] <[]> jetty-util-9.4.18.v20190429.jar (./lib/jetty-util-9.4.18.v20190429.jar). Version 9.4.18.v20190429
2023-10-18T14:03:07,113 Std 05200 [Ucs-Main  ] <[]> json-20180813.jar (./lib/json-20180813.jar). Version 20180813.0.0
2023-10-18T14:03:07,114 Std 05200 [Ucs-Main  ] <[]> jsr305-3.0.2.jar (./lib/jsr305-3.0.2.jar). Version 3.0.2
2023-10-18T14:03:07,115 Std 05200 [Ucs-Main  ] <[]> PSDK :: Key-Value Lists Binding Engine (./lib/kvlistbinding-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,116 Std 05200 [Ucs-Main  ] <[]> PSDK :: Key-Value Lists (./lib/kvlists-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,117 Std 05200 [Ucs-Main  ] <[]> kvlists package (./lib/kvlists.jar). Version 7.1.000.02
2023-10-18T14:03:07,118 Std 05200 [Ucs-Main  ] <[]> libidn-1.15.jar (./lib/libidn-1.15.jar). Version not available
2023-10-18T14:03:07,120 Std 05200 [Ucs-Main  ] <[]> Apache Log4j API (./lib/log4j-api-2.11.2.jar). Version 2.11.2
2023-10-18T14:03:07,123 Std 05200 [Ucs-Main  ] <[]> Apache Log4j Core (./lib/log4j-core-2.11.2.jar). Version 2.11.2
2023-10-18T14:03:07,125 Std 05200 [Ucs-Main  ] <[]> Apache Log4j Commons Logging Bridge (./lib/log4j-jcl-2.11.2.jar). Version 2.11.2
2023-10-18T14:03:07,129 Std 05200 [Ucs-Main  ] <[]> Apache Log4j JUL Adapter (./lib/log4j-jul-2.11.2.jar). Version 2.11.2
2023-10-18T14:03:07,130 Std 05200 [Ucs-Main  ] <[]> Apache Log4j SLF4J Binding (./lib/log4j-slf4j-impl-2.11.2.jar). Version 2.11.2
2023-10-18T14:03:07,131 Std 05200 [Ucs-Main  ] <[]> PSDK :: Logging Component (./lib/logging-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,133 Std 05200 [Ucs-Main  ] <[]> Lucene Search Engine: analyzers-common (./lib/lucene-analyzers-common-4.5.1.jar). Version 4.5.1 1533280 - mark - 2013-10-17 21:40:20
2023-10-18T14:03:07,134 Std 05200 [Ucs-Main  ] <[]> Lucene Search Engine: core (./lib/lucene-core-4.5.1.jar). Version 4.5.1 1533280 - mark - 2013-10-17 21:40:03
2023-10-18T14:03:07,135 Std 05200 [Ucs-Main  ] <[]> Lucene Search Engine: queries (./lib/lucene-queries-4.5.1.jar). Version 4.5.1 1533280 - mark - 2013-10-17 21:41:29
2023-10-18T14:03:07,136 Std 05200 [Ucs-Main  ] <[]> Lucene Search Engine: queryparser (./lib/lucene-queryparser-4.5.1.jar). Version 4.5.1 1533280 - mark - 2013-10-17 21:41:33
2023-10-18T14:03:07,136 Std 05200 [Ucs-Main  ] <[]> Lucene Search Engine: sandbox (./lib/lucene-sandbox-4.5.1.jar). Version 4.5.1 1533280 - mark - 2013-10-17 21:41:42
2023-10-18T14:03:07,137 Std 05200 [Ucs-Main  ] <[]> com.sun.mail.mailapi (./lib/mailapi-1.6.3.jar). Version 1.6.3
2023-10-18T14:03:07,138 Std 05200 [Ucs-Main  ] <[]> PSDK :: Management Protocol (./lib/managementprotocol-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,140 Std 05200 [Ucs-Main  ] <[]> PSDK :: Message Broker Application Block (./lib/messagebrokerappblock-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,141 Std 05200 [Ucs-Main  ] <[]> metrics-core-4.0.5.jar (./lib/metrics-core-4.0.5.jar). Version 4.0.5
2023-10-18T14:03:07,141 Std 05200 [Ucs-Main  ] <[]> metrics-healthchecks-4.0.5.jar (./lib/metrics-healthchecks-4.0.5.jar). Version 4.0.5
2023-10-18T14:03:07,142 Std 05200 [Ucs-Main  ] <[]> metrics-jmx-4.0.5.jar (./lib/metrics-jmx-4.0.5.jar). Version 4.0.5
2023-10-18T14:03:07,144 Std 05200 [Ucs-Main  ] <[]> metrics-jvm-4.0.5.jar (./lib/metrics-jvm-4.0.5.jar). Version 4.0.5
2023-10-18T14:03:07,145 Std 05200 [Ucs-Main  ] <[]> metrics-zabbix-0.0.5.jar (./lib/metrics-zabbix-0.0.5.jar). Version not available
2023-10-18T14:03:07,146 Std 05200 [Ucs-Main  ] <[]> mssql-jdbc-7.2.2.jre8.jar (./lib/mssql-jdbc-7.2.2.jre8.jar). Version 7.2.2
2023-10-18T14:03:07,147 Std 05200 [Ucs-Main  ] <[]> netty-all-4.1.42.Final.jar (./lib/netty-all-4.1.42.Final.jar). Version 4.1.42.Final
2023-10-18T14:03:07,148 Std 05200 [Ucs-Main  ] <[]> JDBC (./lib/ojdbc8.jar). Version 19.3.0.0.0
2023-10-18T14:03:07,149 Std 05200 [Ucs-Main  ] <[]> ons.jar (./lib/ons.jar). Version not available
2023-10-18T14:03:07,152 Std 05200 [Ucs-Main  ] <[]> opencsv-4.6.jar (./lib/opencsv-4.6.jar). Version 4.6.0
2023-10-18T14:03:07,154 Std 05200 [Ucs-Main  ] <[]> PSDK :: Open Media Protocol (./lib/openmediaprotocol-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,158 Std 05200 [Ucs-Main  ] <[]> org.restlet-2.4.1.jar (./lib/org.restlet-2.4.1.jar). Version not available
2023-10-18T14:03:07,159 Std 05200 [Ucs-Main  ] <[]> org.restlet.ext.fileupload-2.4.1.jar (./lib/org.restlet.ext.fileupload-2.4.1.jar). Version not available
2023-10-18T14:03:07,159 Std 05200 [Ucs-Main  ] <[]> org.restlet.ext.jetty-2.4.1.jar (./lib/org.restlet.ext.jetty-2.4.1.jar). Version not available
2023-10-18T14:03:07,160 Std 05200 [Ucs-Main  ] <[]> org.restlet.ext.json-2.4.1.jar (./lib/org.restlet.ext.json-2.4.1.jar). Version not available
2023-10-18T14:03:07,161 Std 05200 [Ucs-Main  ] <[]> org.restlet.ext.slf4j-2.4.1.jar (./lib/org.restlet.ext.slf4j-2.4.1.jar). Version not available
2023-10-18T14:03:07,164 Std 05200 [Ucs-Main  ] <[]> org.restlet.ext.xml-2.4.1.jar (./lib/org.restlet.ext.xml-2.4.1.jar). Version not available
2023-10-18T14:03:07,165 Std 05200 [Ucs-Main  ] <[]> PSDK :: Outbound Protocol (./lib/outboundprotocol-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,166 Std 05200 [Ucs-Main  ] <[]> JDBC (./lib/postgresql-42.2.5.jar). Version 42.2.5
2023-10-18T14:03:07,167 Std 05200 [Ucs-Main  ] <[]> PSDK :: Common Protocol (./lib/protocol-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,167 Std 05200 [Ucs-Main  ] <[]> PSDK :: Protocol Manager Application Block (./lib/protocolmanagerappblock-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,168 Std 05200 [Ucs-Main  ] <[]> quartz-2.3.2.jar (./lib/quartz-2.3.2.jar). Version 2.3.2
2023-10-18T14:03:07,170 Std 05200 [Ucs-Main  ] <[]> PSDK :: Reporting Protocol (./lib/reportingprotocol-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,171 Std 05200 [Ucs-Main  ] <[]> PSDK :: Routing Protocol (./lib/routingprotocol-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,172 Std 05200 [Ucs-Main  ] <[]> slf4j-api-1.7.26.jar (./lib/slf4j-api-1.7.26.jar). Version 1.7.26
2023-10-18T14:03:07,173 Std 05200 [Ucs-Main  ] <[]> spring-aop-4.3.23.RELEASE.jar (./lib/spring-aop-4.3.23.RELEASE.jar). Version 4.3.23.RELEASE
2023-10-18T14:03:07,174 Std 05200 [Ucs-Main  ] <[]> spring-beans-4.3.23.RELEASE.jar (./lib/spring-beans-4.3.23.RELEASE.jar). Version 4.3.23.RELEASE
2023-10-18T14:03:07,175 Std 05200 [Ucs-Main  ] <[]> spring-context-4.3.23.RELEASE.jar (./lib/spring-context-4.3.23.RELEASE.jar). Version 4.3.23.RELEASE
2023-10-18T14:03:07,176 Std 05200 [Ucs-Main  ] <[]> spring-core-4.3.23.RELEASE.jar (./lib/spring-core-4.3.23.RELEASE.jar). Version 4.3.23.RELEASE
2023-10-18T14:03:07,176 Std 05200 [Ucs-Main  ] <[]> spring-expression-4.3.23.RELEASE.jar (./lib/spring-expression-4.3.23.RELEASE.jar). Version 4.3.23.RELEASE
2023-10-18T14:03:07,178 Std 05200 [Ucs-Main  ] <[]> spring-jdbc-4.3.23.RELEASE.jar (./lib/spring-jdbc-4.3.23.RELEASE.jar). Version 4.3.23.RELEASE
2023-10-18T14:03:07,179 Std 05200 [Ucs-Main  ] <[]> spring-tx-4.3.23.RELEASE.jar (./lib/spring-tx-4.3.23.RELEASE.jar). Version 4.3.23.RELEASE
2023-10-18T14:03:07,179 Std 05200 [Ucs-Main  ] <[]> JavaStatLib (./lib/StatLib.jar). Version 7.0.100.07
2023-10-18T14:03:07,181 Std 05200 [Ucs-Main  ] <[]>    "StatServer Java SDK Classes" (./lib/statserver.jar). Version "1.0"
2023-10-18T14:03:07,183 Std 05200 [Ucs-Main  ] <[]> stax-ex-1.8.jar (./lib/stax-ex-1.8.jar). Version 1.8
2023-10-18T14:03:07,185 Std 05200 [Ucs-Main  ] <[]> PSDK :: System (./lib/system-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,186 Std 05200 [Ucs-Main  ] <[]> Java Architecture for XML Binding (./lib/txw2-2.3.1.jar). Version 2.3.1
2023-10-18T14:03:07,190 Std 05200 [Ucs-Main  ] <[]> ucp.jar (./lib/ucp.jar). Version 19.3.0.0.0
2023-10-18T14:03:07,191 Std 05200 [Ucs-Main  ] <[]> Universal Contact Server (./lib/ucserver-8.5.300.43.jar). Version 8.5.300.43
2023-10-18T14:03:07,192 Std 05200 [Ucs-Main  ] <[]> PSDK :: Voice Protocol (./lib/voiceprotocol-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,193 Std 05200 [Ucs-Main  ] <[]> PSDK :: Warm Standby Application Block (./lib/warmstandbyappblock-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,195 Std 05200 [Ucs-Main  ] <[]> PSDK :: WebMedia Protocol (./lib/webmediaprotocol-900.7.4.jar). Version 9.0.007.04
2023-10-18T14:03:07,198 Std 05200 [Ucs-Main  ] <[]> XStream Core (./lib/xstream-1.4.11.1.jar). Version 1.4.11.1
2023-10-18T14:03:07,199 Std 05200 [Ucs-Main  ] <[]> zabbix-sender-0.0.5.jar (./lib/zabbix-sender-0.0.5.jar). Version not available
2023-10-18T14:03:07,199 Std 20040 [Ucs-Main  ] <[]> Java: version 1.8.0_291 (Oracle Corporation).
2023-10-18T14:03:07,200 Std 20041 [Ucs-Main  ] <[]> Java Runtime Environment: Java(TM) SE Runtime Environment, version 1.8.0_291-b10.
2023-10-18T14:03:07,200 Std 20003 [Ucs-Main  ] <[]> Java Virtual Machine: Java HotSpot(TM) 64-Bit Server VM release 25.291-b10 (Oracle Corporation) - mixed mode.
2023-10-18T14:03:07,205 Std 20004 [Ucs-Main  ] <[]> JVM default encoding: 'Cp1252'.
2023-10-18T14:03:07,710 Std 21136 [Ucs-Main  ] <[]> Using '7200' for transaction timeout to be consistent with query and long query timeout.
2023-10-18T14:03:11,120 Alr 09900 [Ucs-Main  ] <[]> Unrecoverable error from while initializing DAPs:The database must use a compatibility level equal or below 120
java.sql.SQLException: The database must use a compatibility level equal or below 120
at com.genesyslab.sql.microsoft.SqlServerDataSource.isDatabaseVersionOK(SqlServerDataSource.java:322) ~[ucserver-8.5.300.43.jar:8.5.300.43]
at com.genesyslab.icc.contactserver.ContactServerEngine.initDataSources(ContactServerEngine.java:834) ~[ucserver-8.5.300.43.jar:8.5.300.43]
at com.genesyslab.icc.contactserver.ContactServerEngine.initUcs(ContactServerEngine.java:524) ~[ucserver-8.5.300.43.jar:8.5.300.43]
at com.genesyslab.icc.contactserver.ContactServerEngine.initInstance(ContactServerEngine.java:475) ~[ucserver-8.5.300.43.jar:8.5.300.43]
at com.genesyslab.icc.contactserver.ContactServerEngine.lambda$main$17(ContactServerEngine.java:232) ~[ucserver-8.5.300.43.jar:8.5.300.43]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_291]
2023-10-18T14:03:11,128 Std 09900 [Ucs-Main  ] <[]> Abnormal server exit, code:-22

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2755
  • Karma: 44
Re: UCS can't start (DB = Microsoft SQL Server)
« Reply #1 on: October 18, 2023, 12:32:58 PM »
The reason is prettly clear [quote]The database must use a compatibility level equal or below 120[/quote]. You have to set compatibility mode on your database - MS SQL Management Studio -> select Database properties -> Options -> Compatibility Level -> choose 120

Offline berserkzas

  • Newbie
  • *
  • Posts: 8
  • Karma: 0
Re: UCS can't start (DB = Microsoft SQL Server)
« Reply #2 on: October 18, 2023, 04:02:22 PM »
thank you so much. I can fix this error because of you.