Not able to see metafresh UI on my Ubuntu 16.04 LTS machine using docker. Getting error not able to initialize base language

english
webui

#1

Hello,
I am new to metafresh i installed using docker-compose but not able to see web-UI.I have configure web-api environment variable as “http://localhost:8080” also done changes in config.js file but still getting error. web_api docker container Error:

METASFRESH-INFO: metasfresh-webui-api |  (v5.64.2-503+release) | SpringBoot version  (v1.5.3.RELEASE)
BUILD-INFO: build [503], tag [jenkins-metasfresh-webui-release-503], job [metasfresh-webui/release]
            https://jenkins.metasfresh.com/job/metasfresh-webui/job/release/503/


2018-07-11 18:35:55.907  INFO 15 --- [           main] ationConfigEmbeddedWebApplicationContext : Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@750e2b97: startup date [Wed Jul 11 18:35:55 IST 2018]; root of context hierarchy
2018-07-11 18:36:08.500  INFO 15 --- [           main] f.a.AutowiredAnnotationBeanPostProcessor : JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
2018-07-11 18:36:08.888  INFO 15 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.amqp.rabbit.annotation.RabbitBootstrapConfiguration' of type [org.springframework.amqp.rabbit.annotation.RabbitBootstrapConfiguration$$EnhancerBySpringCGLIB$$9c56b24c] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-07-11 18:36:09.352  INFO 15 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.ws.config.annotation.DelegatingWsConfiguration' of type [org.springframework.ws.config.annotation.DelegatingWsConfiguration$$EnhancerBySpringCGLIB$$7a82b91d] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-07-11 18:36:09.571  INFO 15 --- [           main] .w.s.a.s.AnnotationActionEndpointMapping : Supporting [WS-Addressing August 2004, WS-Addressing 1.0]
2018-07-11 18:36:10.416  INFO 15 --- [           main] s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat initialized with port(s): 8080 (http)
2018-07-11 18:36:10.432  INFO 15 --- [           main] o.apache.catalina.core.StandardService   : Starting service Tomcat
2018-07-11 18:36:10.434  INFO 15 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet Engine: Apache Tomcat/8.5.14
2018-07-11 18:36:10.600  INFO 15 --- [ost-startStop-1] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2018-07-11 18:36:10.600  INFO 15 --- [ost-startStop-1] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 14693 ms
2018-07-11 18:36:11.774  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.ServletRegistrationBean  : Mapping servlet: 'dispatcherServlet' to [/]
2018-07-11 18:36:11.776  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.ServletRegistrationBean  : Mapping servlet: 'messageDispatcherServlet' to [/services/*]
2018-07-11 18:36:11.795  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'metricsFilter' to: [/*]
2018-07-11 18:36:11.798  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'characterEncodingFilter' to: [/*]
2018-07-11 18:36:11.798  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'springSessionRepositoryFilter' to: [/*]
2018-07-11 18:36:11.798  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'hiddenHttpMethodFilter' to: [/*]
2018-07-11 18:36:11.799  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'httpPutFormContentFilter' to: [/*]
2018-07-11 18:36:11.809  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'requestContextFilter' to: [/*]
2018-07-11 18:36:11.810  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'webRequestLoggingFilter' to: [/*]
2018-07-11 18:36:11.811  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'CORSFilter' to: [/*]
2018-07-11 18:36:11.811  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'servletLoggingFilter' to: [/*]
2018-07-11 18:36:11.811  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'addMissingHeadersFilter' to: [/*]
2018-07-11 18:36:11.811  INFO 15 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean   : Mapping filter: 'applicationContextIdFilter' to: [/*]
2018-07-11 18:36:11.980  INFO 15 --- [           main] o.s.s.c.ThreadPoolTaskScheduler          : Initializing ExecutorService  'webuiTaskScheduler'
Changing log level null->WARN (4 root loggers affected)
2018-07-11 18:36:12.529  INFO 15 --- [g-Init-Reporter] com.mchange.v2.log.MLog                  : MLog clients using slf4j logging.
2018-07-11 18:36:12.779  INFO 15 --- [           main] com.mchange.v2.c3p0.C3P0Registry         : Initializing c3p0-0.9.5 [built 02-January-2015 13:25:04 -0500; debug? true; trace: 10]
2018-07-11 18:36:13.120  INFO 15 --- [           main] c.m.v.c.i.AbstractPoolBackedDataSource   : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 2, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> de.metas.connection.impl.DB_PostgreSQL_ConnectionCustomizer, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> AdempiereDS, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.postgresql.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceUseNamedDriverClass -> false, identityToken -> 1bqq1hi9w124xwudbh72de|2dba05b1, idleConnectionTestPeriod -> 1200, initialPoolSize -> 10, jdbcUrl -> jdbc:postgresql://db:5432/metasfresh?encoding=UNICODE, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1200, maxIdleTimeExcessConnections -> 1200, maxPoolSize -> 150, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, preferredTestQuery -> SELECT Version FROM AD_System, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
2018-07-11 18:36:13.616  WARN 15 --- [           main] org.compiere.model.MLanguage             : Cannot initialize base language. Skip.

org.adempiere.exceptions.AdempiereException: Assumption failure: Base AD_Language shall be defined in database
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at org.adempiere.util.Check.mkEx(Check.java:108)
	at org.adempiere.util.Check.throwOrLogEx(Check.java:119)
	at org.adempiere.util.Check.assume(Check.java:163)
	at org.adempiere.util.Check.assumeNotEmpty(Check.java:309)
	at org.adempiere.util.Check.assumeNotEmpty(Check.java:293)
	at de.metas.i18n.impl.LanguageDAO.retrieveBaseLanguage(LanguageDAO.java:87)
	at org.compiere.model.MLanguage.lambda$setBaseLanguage$0(MLanguage.java:62)
	at de.metas.i18n.Language.lambda$setBaseLanguage$0(Language.java:325)
	at org.adempiere.util.lang.ExtendedMemorizingSupplier.get(ExtendedMemorizingSupplier.java:65)
	at de.metas.i18n.Language.getBaseLanguage(Language.java:307)
	at org.compiere.model.MLanguage.setBaseLanguage(MLanguage.java:68)
	at org.compiere.Adempiere.startup(Adempiere.java:729)
	at de.metas.ui.web.WebRestApiApplication.adempiere(WebRestApiApplication.java:102)
	at de.metas.ui.web.WebRestApiApplication$$EnhancerBySpringCGLIB$$a0a16afa.CGLIB$adempiere$0(<generated>)
	at de.metas.ui.web.WebRestApiApplication$$EnhancerBySpringCGLIB$$a0a16afa$$FastClassBySpringCGLIB$$abad8507.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
	at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:358)
	at de.metas.ui.web.WebRestApiApplication$$EnhancerBySpringCGLIB$$a0a16afa.adempiere(<generated>)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:162)
	at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:588)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1173)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1067)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066)
	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1095)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066)
	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1095)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)
	at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122)
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:737)
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:370)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:314)
	at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:134)
	at de.metas.ui.web.WebRestApiApplication.main(WebRestApiApplication.java:87)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	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.JarLauncher.main(JarLauncher.java:51)

2018-07-11 18:36:13.793  WARN 15 --- [           main] ationConfigEmbeddedWebApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'purchaseCandidateReminderScheduler' defined in URL [jar:file:/opt/metasfresh-webui-api/metasfresh-webui-api.jar!/BOOT-INF/classes!/de/metas/purchasecandidate/reminder/PurchaseCandidateReminderScheduler.class]: Unsatisfied dependency expressed through constructor parameter 1; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'viewsRepository' defined in URL [jar:file:/opt/metasfresh-webui-api/metasfresh-webui-api.jar!/BOOT-INF/classes!/de/metas/ui/web/view/ViewsRepository.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'Adempiere' defined in de.metas.ui.web.WebRestApiApplication: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.compiere.Adempiere]: Factory method 'adempiere' threw exception; nested exception is org.adempiere.exceptions.DBException: POInfo not found for AD_System
2018-07-11 18:36:13.793  INFO 15 --- [           main] o.s.s.c.ThreadPoolTaskScheduler          : Shutting down ExecutorService 'webuiTaskScheduler'
2018-07-11 18:36:13.798  INFO 15 --- [           main] o.apache.catalina.core.StandardService   : Stopping service Tomcat
2018-07-11 18:36:13.813  INFO 15 --- [           main] utoConfigurationReportLoggingInitializer : 

Error starting ApplicationContext. To display the auto-configuration report re-run your application with 'debug' enabled.
2018-07-11 18:36:13.825 ERROR 15 --- [           main] o.s.boot.SpringApplication               : Application startup failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'purchaseCandidateReminderScheduler' defined in URL [jar:file:/opt/metasfresh-webui-api/metasfresh-webui-api.jar!/BOOT-INF/classes!/de/metas/purchasecandidate/reminder/PurchaseCandidateReminderScheduler.class]: Unsatisfied dependency expressed through constructor parameter 1; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'viewsRepository' defined in URL [jar:file:/opt/metasfresh-webui-api/metasfresh-webui-api.jar!/BOOT-INF/classes!/de/metas/ui/web/view/ViewsRepository.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'Adempiere' defined in de.metas.ui.web.WebRestApiApplication: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.compiere.Adempiere]: Factory method 'adempiere' threw exception; nested exception is org.adempiere.exceptions.DBException: POInfo not found for AD_System
	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749)
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1095)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)
	at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122)
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:737)
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:370)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:314)
	at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:134)
	at de.metas.ui.web.WebRestApiApplication.main(WebRestApiApplication.java:87)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	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.JarLauncher.main(JarLauncher.java:51)
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'viewsRepository' defined in URL [jar:file:/opt/metasfresh-webui-api/metasfresh-webui-api.jar!/BOOT-INF/classes!/de/metas/ui/web/view/ViewsRepository.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'Adempiere' defined in de.metas.ui.web.WebRestApiApplication: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.compiere.Adempiere]: Factory method 'adempiere' threw exception; nested exception is org.adempiere.exceptions.DBException: POInfo not found for AD_System
	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749)
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1095)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)


#2

Hi,

can you post the output of
docker ps
please.

cheers,
Norbert


Docker - docker pull metasfresh/metasfresh-webapi
Suchschlüssel für Produkte eingeben
#3

Hi metasnw … I’m facing the same issue, but on debian 9.7:
docker ps shows:

CONTAINER ID        IMAGE                       COMMAND                  CREATED             STATUS                                  PORTS                                      NAMES
8e6c4f17ecd0        metasfreshdocker_webui      "/start_webui.sh"        18 minutes ago      Up 14 minutes                           0.0.0.0:80->80/tcp, 0.0.0.0:443->443/tcp   metasfreshdocker_webui_1
7ffb2f7180d7        metasfreshdocker_webapi     "/opt/metasfresh-web…"   18 minutes ago      Restarting (1) 44 seconds ago                                                      metasfreshdocker_webapi_1
231b8731463d        metasfreshdocker_app        "/opt/metasfresh/sta…"   18 minutes ago      Restarting (1) Less than a second ago                                              metasfreshdocker_app_1
42693ce26514        metasfreshdocker_db         "/docker-entrypoint.…"   19 minutes ago      Up 14 minutes                           5432/tcp                                   metasfreshdocker_db_1
3d7375593838        metasfreshdocker_rabbitmq   "docker-entrypoint.s…"   19 minutes ago      Up 14 minutes                           4369/tcp, 5671-5672/tcp, 25672/tcp         metasfreshdocker_rabbitmq_1
7fa78686eaf1        metasfreshdocker_search     "/docker-entrypoint.…"   19 minutes ago      Up 14 minutes                           9200/tcp, 9300/tcp                         metasfreshdocker_search_1

#4

hi,

can you please post the output of:
docker-compose logs app
docker-compose logs webapi

cheers,
Norbert


#5

app:

app_1       | [INFO ] CommandlineParams - config=Config(canRun=true, rolloutDirName=./.., settingsFile=null, scriptFileName=null, scriptsApplierListener=de.metas.migration.applier.impl.NullScriptsApplierListener@769c9116, justMarkScriptAsExecuted=false, checkVersions=true, storeVersion=true, failIfRolloutIsGreaterThanDB=true, templateDBName=null, newDBName=null)
app_1       | [INFO ] SettingsLoader - No settings file specified; looking for
app_1       | [INFO ] SettingsLoader - Loaded settings from file /root/local_settings.properties
app_1       | [INFO ] RolloutMigrate - Settings={METASFRESH_DB_USER=metasfresh, INSTALL_DIR=/opt, METASFRESH_DB_PASSWORD=******, METASFRESH_DB_NAME=metasfresh, ROLLOUT_USER=metasfresh, METASFRESH_APPS_SERVER=app, METASFRESH_HOME=/opt/metasfresh, METASFRESH_DB_SERVER=db}
app_1       | [INFO ] SQLDatabaseScriptsRegistry - Scripts registry is using in memory database. To switch it of set '-DUseInMemoryScriptsRegistry=false'
app_1       | [INFO ] DBVersionGetter - Could not retrieve the DB version
app_1       | [INFO ] RolloutMigrate - Duration: 196ms (Thu Jan 31 22:22:15 CET 2019)
app_1       | [INFO ] RolloutMigrate - Done.
app_1       | Exception in thread "main" de.metas.migration.cli.DBVersionGetter$CantRetrieveDBVersionException: Could not retrieve the DB version; selectSql=SELECT DBVersion FROM public.AD_System
app_1       | 	at de.metas.migration.cli.DBVersionGetter.retrieveDBVersion(DBVersionGetter.java:83)
app_1       | 	at de.metas.migration.cli.RolloutMigrate.run0(RolloutMigrate.java:82)
app_1       | 	at de.metas.migration.cli.RolloutMigrate.run(RolloutMigrate.java:56)
app_1       | 	at de.metas.migration.cli.Main.main(Main.java:61)
app_1       | Caused by: org.postgresql.util.PSQLException: ResultSet not positioned properly, perhaps you need to call next.
app_1       | 	at org.postgresql.jdbc.PgResultSet.checkResultSet(PgResultSet.java:2767)
app_1       | 	at org.postgresql.jdbc.PgResultSet.getString(PgResultSet.java:1878)
app_1       | 	at de.metas.migration.cli.DBVersionGetter.retrieveDBVersion0(DBVersionGetter.java:91)
app_1       | 	at de.metas.migration.cli.DBVersionGetter.retrieveDBVersion(DBVersionGetter.java:60)

webapi:

webapi_1    | 22:25:34.637 [main] DEBUG com.mchange.v2.cfg.MConfig - The configuration file for resource identifier 'hocon:/reference,/application,/c3p0,/' could not be found. Skipping.
webapi_1    | java.io.FileNotFoundException: HOCON lib (typesafe-config) is not available. Also, no resource available at '/reference,/application,/c3p0,/' for HOCON identifier 'hocon:/reference,/application,/c3p0,/'.
webapi_1    | 	at com.mchange.v2.cfg.BasicMultiPropertiesConfig.configSource(BasicMultiPropertiesConfig.java:86)
webapi_1    | 	at com.mchange.v2.cfg.BasicMultiPropertiesConfig.firstInit(BasicMultiPropertiesConfig.java:184)
webapi_1    | 	at com.mchange.v2.cfg.BasicMultiPropertiesConfig.<init>(BasicMultiPropertiesConfig.java:110)
webapi_1    | 	at com.mchange.v2.cfg.ConfigUtils.read(ConfigUtils.java:63)
webapi_1    | 	at com.mchange.v2.cfg.MConfig$CSManager.recreateFromKey(MConfig.java:153)
webapi_1    | 	at com.mchange.v1.cachedstore.NoCleanupCachedStore.find(NoCleanupCachedStore.java:63)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
webapi_1    | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
webapi_1    | 	at java.lang.reflect.Method.invoke(Method.java:498)
webapi_1    | 	at com.mchange.v1.lang.Synchronizer$1.invoke(Synchronizer.java:58)
webapi_1    | 	at com.sun.proxy.$Proxy6.find(Unknown Source)
webapi_1    | 	at com.mchange.v2.cfg.MConfig.readVmConfig(MConfig.java:75)
webapi_1    | 	at com.mchange.v2.cfg.MConfig.readVmConfig(MConfig.java:81)
webapi_1    | 	at com.mchange.v2.resourcepool.BasicResourcePool.<clinit>(BasicResourcePool.java:60)
webapi_1    | 	at com.mchange.v2.resourcepool.BasicResourcePoolFactory.createPool(BasicResourcePoolFactory.java:340)
webapi_1    | 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.<init>(C3P0PooledConnectionPool.java:671)
webapi_1    | 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooledConnectionPool(C3P0PooledConnectionPoolManager.java:952)
webapi_1    | 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:397)
webapi_1    | 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:414)
webapi_1    | 	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
webapi_1    | 	at org.compiere.db.DB_PostgreSQL.getCachedConnection(DB_PostgreSQL.java:448)
webapi_1    | 	at org.compiere.db.CConnection.getConnection(CConnection.java:1075)
webapi_1    | 	at org.compiere.db.CConnection.testDatabase(CConnection.java:775)
webapi_1    | 	at org.compiere.db.CConnection.testDatabaseIfNeeded(CConnection.java:802)
webapi_1    | 	at org.compiere.db.CConnection.createInstance(CConnection.java:113)
webapi_1    | 	at org.compiere.db.CConnection.get(CConnection.java:88)
webapi_1    | 	at org.compiere.Adempiere.startup(Adempiere.java:766)
webapi_1    | 	at de.metas.ui.web.WebRestApiApplication.main(WebRestApiApplication.java:96)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
webapi_1    | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
webapi_1    | 	at java.lang.reflect.Method.invoke(Method.java:498)
webapi_1    | 	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
webapi_1    | 	at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
webapi_1    | 	at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
webapi_1    | 	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
webapi_1    | 22:25:34.642 [main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool@5a56cdac config: [start -> 10; min -> 5; max -> 150; inc -> 3; num_acq_attempts -> 2; acq_attempt_delay -> 1000; check_idle_resources_delay -> 1200000; max_resource_age -> 0; max_idle_time -> 1200000; excess_max_idle_time -> 1200000; destroy_unreturned_resc_time -> 0; expiration_enforcement_delay -> 300000; break_on_acquisition_failure -> false; debug_store_checkout_exceptions -> false]
webapi_1    | 22:25:34.642 [main] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager - Created new pool for auth, username (masked): 'me******'.
webapi_1    | 22:25:34.642 [main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - acquire test -- pool size: 0; target_pool_size: 10; desired target? 1
webapi_1    | 22:25:34.643 [main] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - awaitAvailable(): [unknown]
webapi_1    | 22:25:35.155 [main] WARN org.compiere.model.MLanguage - Cannot initialize base language. Skip.
webapi_1    | org.adempiere.exceptions.AdempiereException: Assumption failure: Base AD_Language shall be defined in database
webapi_1    | 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
webapi_1    | 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
webapi_1    | 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
webapi_1    | 	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
webapi_1    | 	at de.metas.util.Check.mkEx(Check.java:115)
webapi_1    | 	at de.metas.util.Check.throwOrLogEx(Check.java:130)
webapi_1    | 	at de.metas.util.Check.assume(Check.java:182)
webapi_1    | 	at de.metas.util.Check.assumeNotEmpty(Check.java:333)
webapi_1    | 	at de.metas.util.Check.assumeNotEmpty(Check.java:318)
webapi_1    | 	at de.metas.i18n.impl.LanguageDAO.retrieveBaseLanguage(LanguageDAO.java:86)
webapi_1    | 	at org.compiere.model.MLanguage.lambda$setBaseLanguage$0(MLanguage.java:62)
webapi_1    | 	at de.metas.i18n.Language.lambda$setBaseLanguage$0(Language.java:333)
webapi_1    | 	at org.adempiere.util.lang.ExtendedMemorizingSupplier.get(ExtendedMemorizingSupplier.java:65)
webapi_1    | 	at de.metas.i18n.Language.getBaseLanguage(Language.java:315)
webapi_1    | 	at org.compiere.model.MLanguage.setBaseLanguage(MLanguage.java:68)
webapi_1    | 	at org.compiere.Adempiere.startup(Adempiere.java:768)
webapi_1    | 	at de.metas.ui.web.WebRestApiApplication.main(WebRestApiApplication.java:96)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
webapi_1    | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
webapi_1    | 	at java.lang.reflect.Method.invoke(Method.java:498)
webapi_1    | 	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
webapi_1    | 	at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
webapi_1    | 	at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
webapi_1    | 	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
webapi_1    | Exception in thread "main" java.lang.reflect.InvocationTargetException
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
webapi_1    | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
webapi_1    | 	at java.lang.reflect.Method.invoke(Method.java:498)
webapi_1    | 	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
webapi_1    | 	at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
webapi_1    | 	at org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
webapi_1    | 	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
webapi_1    | Caused by: org.adempiere.exceptions.DBException: POInfo not found for AD_System
webapi_1    | 	at org.adempiere.ad.dao.impl.TypedSqlQuery.getPOInfo(TypedSqlQuery.java:156)
webapi_1    | 	at org.adempiere.ad.dao.impl.TypedSqlQuery.buildSQL(TypedSqlQuery.java:1200)
webapi_1    | 	at org.adempiere.ad.dao.impl.TypedSqlQuery.firstOnly(TypedSqlQuery.java:474)
webapi_1    | 	at org.adempiere.ad.dao.impl.AbstractTypedQuery.firstOnly(AbstractTypedQuery.java:57)
webapi_1    | 	at org.adempiere.ad.service.impl.SystemBL.get(SystemBL.java:64)
webapi_1    | 	at org.adempiere.ad.service.impl.SystemBL_$$_jvstf5d_1._d3get(SystemBL_$$_jvstf5d_1.java)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
webapi_1    | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
webapi_1    | 	at java.lang.reflect.Method.invoke(Method.java:498)
webapi_1    | 	at org.adempiere.util.proxy.impl.JavaAssistInterceptor.invokeForJavassist0(JavaAssistInterceptor.java:106)
webapi_1    | 	at org.adempiere.util.proxy.impl.JavaAssistInterceptor.access$000(JavaAssistInterceptor.java:45)
webapi_1    | 	at org.adempiere.util.proxy.impl.JavaAssistInterceptor$3.invoke(JavaAssistInterceptor.java:228)
webapi_1    | 	at org.adempiere.ad.service.impl.SystemBL_$$_jvstf5d_1.get(SystemBL_$$_jvstf5d_1.java)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
webapi_1    | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
webapi_1    | 	at java.lang.reflect.Method.invoke(Method.java:498)
webapi_1    | 	at org.adempiere.util.proxy.impl.InvocationContext.proceed(InvocationContext.java:67)
webapi_1    | 	at org.adempiere.util.proxy.impl.InvocationContext.call(InvocationContext.java:81)
webapi_1    | 	at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:5065)
webapi_1    | 	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3716)
webapi_1    | 	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2424)
webapi_1    | 	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2298)
webapi_1    | 	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2211)
webapi_1    | 	at com.google.common.cache.LocalCache.get(LocalCache.java:4154)
webapi_1    | 	at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:5060)
webapi_1    | 	at de.metas.cache.CCache.get(CCache.java:504)
webapi_1    | 	at de.metas.cache.interceptor.CacheInterceptor.invokeCache(CacheInterceptor.java:243)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
webapi_1    | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
webapi_1    | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
webapi_1    | 	at java.lang.reflect.Method.invoke(Method.java:498)
webapi_1    | 	at org.adempiere.util.proxy.impl.JavaAssistInterceptorInstance.invoke(JavaAssistInterceptorInstance.java:82)
webapi_1    | 	at org.adempiere.util.proxy.impl.JavaAssistInterceptor.invokeForJavassist0(JavaAssistInterceptor.java:121)
webapi_1    | 	at org.adempiere.util.proxy.impl.JavaAssistInterceptor.access$000(JavaAssistInterceptor.java:45)
webapi_1    | 	at org.adempiere.util.proxy.impl.JavaAssistInterceptor$3.invoke(JavaAssistInterceptor.java:228)
webapi_1    | 	at org.adempiere.ad.service.impl.SystemBL_$$_jvstf5d_1.get(SystemBL_$$_jvstf5d_1.java)
webapi_1    | 	at org.compiere.Adempiere.startupEnvironment(Adempiere.java:808)
webapi_1    | 	at org.compiere.Adempiere.startup(Adempiere.java:784)
webapi_1    | 	at de.metas.ui.web.WebRestApiApplication.main(WebRestApiApplication.java:96)
webapi_1    | 	... 8 more

#6

Hi @chdrsto
To me this strongly looks like the database did not import properly.

Can you try installing a new database? This is achieved by simply:

docker-compose down
rm -rf ./volumes/db #BEWARE: this will delete your database. If you got important data in there, backup that folder to a different location
docker-compose up -d

If the app- and webapi-service then crash again (check by using docker ps after a minute or two and note the “Restarting” in “STATUS”), you might want to inspect the database-container by using:
docker-compose logs -f db

This might narrow down any issues.

We didn’t test metasfresh-docker on Debian but since it’s not that far off from Ubuntu and because docker is relatively independent of the OS, it would really surprise me if it’s because of the OS.


#7

Hi julian.bischof

Thanks for the hint.
Indeed, the database got somehow corrupted. I was not aware that the initial load takes about 10’ to create and load the database.

BR
Dragan


#8

Hi @chdrsto

I’m glad you managed to solve the issue.

The import process basically extracts the compressed postgresql-dump and imports it to an empty database. So it’s highly depends on two factors:
a) the speed of the underlying storage (./volumes/db)
We have pretty good experience with running it on an SSD since it’s faster for the initial data to be written on the storage
b) CPU-Speed/-Threads
Since Postgresql needs to extract the database from the compressed file, the operation will be much faster, if the CPU clockspeed is higher (same as extracting “simple” tar.gz or zip-files). Also, since the CPU is being used by the host and the other containers: the more threads you can spare for the docker-stack, the better.

Cheers, Julian.


#9

Oh, I see.
Then it is understandable slow, since my metasfresh instance runs from a Docker within a KVM virtual machine.
Thanks for the explaination.

Best regards
Dragan