By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement . We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Hi, I'm trying to install the latest Thingsboard version for Windows, but without success. I always get the following error.
I'm hoping for help.

log4j:WARN No appenders could be found for logger (hsqldb.db.HSQLDB62F929FE31.ENGINE).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Starting ThingsBoard Installation...
Installing DataBase schema...
Installing SQL DataBase schema...
Loading system data...
Unexpected error during ThingsBoard installation!
org.thingsboard.server.dao.exception.DataValidationException: User with email ' [email protected] ' already present in database!
at org.thingsboard.server.dao.user.UserServiceImpl$1.validateDataImpl(UserServiceImpl.java:262)
at org.thingsboard.server.dao.user.UserServiceImpl$1.validateDataImpl(UserServiceImpl.java:212)
at org.thingsboard.server.dao.service.DataValidator.validate(DataValidator.java:38)
at org.thingsboard.server.dao.user.UserServiceImpl.saveUser(UserServiceImpl.java:91)
at org.thingsboard.server.service.install.DefaultSystemDataLoaderService.createUser(DefaultSystemDataLoaderService.java:253)
at org.thingsboard.server.service.install.DefaultSystemDataLoaderService.createSysAdmin(DefaultSystemDataLoaderService.java:122)
at org.thingsboard.server.install.ThingsboardInstallService.performInstall(ThingsboardInstallService.java:126)
at org.thingsboard.server.ThingsboardInstallApplication.main(ThingsboardInstallApplication.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:521)
Unexpected error during ThingsBoard installation!
ThingsBoard installation failed!

Can you please provide your thingsboard.yml config file? # HSQLDB DAO Configuration section only.
Do you have %SQL_DATA_FOLDER% environment variable set?
User with email '[email protected]' already present in database! means that it was added on previous run. If you have deleted the database file and the error still persists, this means that you did not remove the right one.
btw, just to check - you have unpacked .zip archive and run install.bat , correct? Latest version is 1.4.0 or built from source?

I've gotten the same error and fixed it by removing the unzipped directory and extracting the archive again and everything went fine after that.

which unzipped directory?

nexpected error during ThingsBoard installation!
org.thingsboard.server.dao.exception.DataValidationException: User with email ' [email protected] ' already present in database!
at org.thingsboard.server.dao.user.UserServiceImpl$1.validateDataImpl(UserServiceImpl.java:409)
at org.thingsboard.server.dao.user.UserServiceImpl$1.validateDataImpl(UserServiceImpl.java:359)
at org.thingsboard.server.dao.service.DataValidator.validate(DataValidator.java:41)
at org.thingsboard.server.dao.user.UserServiceImpl.saveUser(UserServiceImpl.java:116)
at org.thingsboard.server.service.install.DefaultSystemDataLoaderService.createUser(DefaultSystemDataLoaderService.java:249)
at org.thingsboard.server.service.install.DefaultSystemDataLoaderService.createSysAdmin(DefaultSystemDataLoaderService.java:110)
at org.thingsboard.server.install.ThingsboardInstallService.performInstall(ThingsboardInstallService.java:185)
at org.thingsboard.server.ThingsboardInstallApplication.main(ThingsboardInstallApplication.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:51)
at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:597)
Unexpected error during ThingsBoard installation!
ThingsBoard installation failed!

Thanks. Tried the same however getting the following error

Upgrading thingsboard ...
"--fromVersion parameter is invalid or unspecified!"
"Usage: upgrade.bat --fromVersion {VERSION}"

Thingsboard uses /usr/share/thingsboard/data/.firstLaunch file to see if installation is needed on startup. If .firstLaunch file exists, Thingsboard will just start, but if does not exist, Thingsboard will try to install and populate database.

If you already have Thingsboard database configured, just create empty .firstLaunch file in /usr/share/thingsboard/data directory and error will not occur anymore.

Check this link to see how it works: