--- Installation --- Installation started at 2023-12-15 15:11:14 AEDT (+1100) --- installerinfo.txt --- Installer built at 2023-12-04 14:13:23 AEDT (+1100) java.version: 1.8.0_211 os.name: Linux os.version: 4.4.0-210-generic build.version: 9.10 code.version: 20231204 --- end installerinfo.txt --- Detected Total Memory: 68425691136 [YFGUIInstaller] language selected: en [YFImgPacksPanel] Packs selected: core, tutorial, [YFLicenceFilePanel] Licence file not specified [YFGeneralOptionsNewPanel] option.serverport: 8080 [YFGeneralOptionsNewPanel] option.appmemory: 51318 [YFGeneralOptionsNewPanel] option.winservice: false Found driver file yfres/jdbc-drivers/postgresql-42.5.0.jar Found driver file yfres/jdbc-drivers/mssql-jdbc-9.4.0.jre8.jar Found driver file yfres/jdbc-drivers/jtds-1.2.8_svn.jar Found driver file yfres/jdbc-drivers/hsqldb.jar URLs [file:/C:/Users/anilk/AppData/Local/Temp/driver653110722096091075jar, file:/C:/Users/anilk/AppData/Local/Temp/driver3198890380424865030jar, file:/C:/Users/anilk/AppData/Local/Temp/driver5367282769956217642jar, file:/C:/Users/anilk/AppData/Local/Temp/driver1871650920309411641jar] Got driver class org.hsqldb.jdbcDriver 2 7 Found driver file yfres/jdbc-drivers/postgresql-42.5.0.jar Found driver file yfres/jdbc-drivers/mssql-jdbc-9.4.0.jre8.jar Found driver file yfres/jdbc-drivers/jtds-1.2.8_svn.jar Found driver file yfres/jdbc-drivers/hsqldb.jar URLs [file:/C:/Users/anilk/AppData/Local/Temp/driver6425765892045520935jar, file:/C:/Users/anilk/AppData/Local/Temp/driver2140954230454915115jar, file:/C:/Users/anilk/AppData/Local/Temp/driver5989398152028684403jar, file:/C:/Users/anilk/AppData/Local/Temp/driver2820998043921957570jar] Couldn't load driver class com.mysql.jdbc.Driver for mysql Found driver file yfres/jdbc-drivers/postgresql-42.5.0.jar Found driver file yfres/jdbc-drivers/mssql-jdbc-9.4.0.jre8.jar Found driver file yfres/jdbc-drivers/jtds-1.2.8_svn.jar Found driver file yfres/jdbc-drivers/hsqldb.jar URLs [file:/C:/Users/anilk/AppData/Local/Temp/driver9216231187955277261jar, file:/C:/Users/anilk/AppData/Local/Temp/driver151104281417945699jar, file:/C:/Users/anilk/AppData/Local/Temp/driver198697016495345268jar, file:/C:/Users/anilk/AppData/Local/Temp/driver7827039573419421565jar] Got driver class com.mysql.jdbc.Driver 8 0 [YFDBDetailsPanel] Connection test successful connection-url: jdbc:mysql://127.0.0.1:3306/YellowfinDB?characterEncoding=utf8 database-major-version: 8 database-minor-version: 1 database-product-name: MySQL database-product-version: 8.1.0 driver-class: com.mysql.jdbc.Driver driver-major-version: 8 driver-minor-version: 0 driver-name: MySQL Connector/J driver-version: mysql-connector-j-8.0.32 (Revision: fa4912a849140828e48162a2c396c8df0091bed7) jdbc-major-version: 4 jdbc-minor-version: 2 [YFTargetPanel] option.installpath: C:\Users\anilk\Yellowfin 9.10 [YFDBTypePanel] option.db.dbtype: MySQL --- Yellowfin installation information --- Date: 2023-12-15 15:13:31 (+1100) $Id: Installer.java,v 1.32 2014/10/08 03:49:55 steve Exp $ java.version: 1.8.0_391 java.class.path: C:\Users\anilk\Downloads\yellowfin-9.10.0.1-20231204-full.exe java.library.path: C:\Program Files\Java\jre-1.8\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;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:\Windows\System32\OpenSSH\;C:\Program Files\dotnet\;C:\Program Files\PuTTY\;C:\Program Files\Docker\Docker\resources\bin;C:\ProgramData\chocolatey\bin;;C:\minikube;C:\Program Files\PostgreSQL\15\bin;C:\Softwares\Strawberry\c\bin;C:\Softwares\Strawberry\perl\site\bin;C:\Softwares\Strawberry\perl\bin;C:\Users\anilk\AppData\Local\Programs\Python\Python39\Scripts\;C:\Users\anilk\AppData\Local\Programs\Python\Python39\;C:\Users\anilk\AppData\Local\Programs\Python\Launcher\;C:\Users\anilk\AppData\Local\Microsoft\WindowsApps;C:\Users\anilk\AppData\Local\Atlassian\SourceTree\git_local\bin;C:\Dev\jdk-11.0.9+11\bin;C:\Dev\gradle-7.4\bin;C:\Softwares\apache-maven-3.9.1\bin;C:\Softwares\New folder\httpd-2.4.55-o111s-x64-vs17\Apache24\bin;C:\Softwares\Istio;C:\Program Files (x86)\Windows Kits\10\bin\x64;C:\Program Files\MySQL\MySQL Server 8.0\bin;C:\Softwares\Strawberry\perl\site\lib;C:\Softwares\Strawberry\perl\site\bin;C:\PostgreSQL\15\bin;;C:\Program Files\Java\jre-1.8\bin;. os.name: Windows 10 os.arch: amd64 os.version: 10.0 freeMemory: 445.6mb totalMemory: 568.0mb maxMemory: 14.2gb Installation Options: option.appmemory: 51318 option.db.createdb: false option.db.createuser: false option.db.dbausername: option.db.dbname: YellowfinDB option.db.dbtype: MySQL option.db.hostname: 127.0.0.1 option.db.jdbcdriverfiles: C:\Users\anilk\Desktop\mysql-connector-j-8.0.32.jar option.db.port: 3306 option.db.username: picasso_system option.ignorebuilddatecheck: false option.ignorebuildversioncheck: false option.ignoreschemaversioncheck: false option.installpath: C:\Users\anilk\Yellowfin 9.10 option.javahome: C:\Program Files\Java\jre-1.8 option.serverport: 8080 option.totalspacerequired: 834398421 option.winservice: false Extracting distribution Unzipping yfres/yellowfin.zip to: C:\Users\anilk\Yellowfin 9.10 Unzipping yfres/skiteam.zip to: C:\Users\anilk\Yellowfin 9.10 Writing uninstaller Cleaning up installation Updating configuration Setting up database Loading xml from com/hof/dataload/yellowfinschema.xml Creating tables Creating AccessClassList com.hof.dbtool.DBException: Error executing update ERR_UPDATEQUERY Query: CREATE TABLE AccessClassList ( IpOrg INT, RoleCode TINYTEXT(40), AccessLevelCode TINYTEXT(40), ACLSeqNbr INT, FunctionName TINYTEXT(256), FunctionTypeCode TINYTEXT(40), SortOrder INT ) engine = INNODB at com.hof.dbtool.DBInterface.executeUpdate(DBInterface.java:90) at com.hof.dbtool.MysqlDB.createTable(MysqlDB.java:411) at com.hof.xmltool.XMLCreateSchema.createSchema(XMLCreateSchema.java:397) at com.hof.xmltool.XMLCreateSchema.createSchema(XMLCreateSchema.java:193) at com.hof.installer.process.job.CreateTablesJob.run(CreateTablesJob.java:180) at com.hof.installer.izpack.IzpackFullProcessJob.runJob(IzpackFullProcessJob.java:168) at com.hof.installer.izpack.panels.YFProcessPanel$YFProcessPanelWorker.run(YFProcessPanel.java:266) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(40), AccessLevelCode TINYTEXT(40), ACLSeqNbr INT, FunctionName TINYTEXT(256), F' at line 1 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1334) at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2084) at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1245) at com.hof.dbtool.DBInterface.executeUpdate(DBInterface.java:82) ... 7 more Installation Failed