--
--
You received this message because you are subscribed to the Google Groups "sipxcom-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sipxcom-user...@googlegroups.com.
To post to this group, send email to sipxco...@googlegroups.com.
Visit this group at https://groups.google.com/group/sipxcom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/sipxcom-users/3f014b7a-f328-41e8-8675-845bd5ab03fc%40googlegroups.com.
DoH! I posted it to the wrong thread.  My apologies.
To view this discussion on the web visit https://groups.google.com/d/msgid/sipxcom-users/CAAHujP4c%3Dh9xBUOsW7h70JeW7b3tJnZ8y%2BKfsCaPFg%3Dz9EsBSg%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sipxcom-users/a160a0e3-0dc2-4b16-bb6b-24809c379d0c%40googlegroups.com.
Oh, maybe I didn’t respond to the wrong thread.  I did two updates last night, one is giving me that same 503 message. It has internet access, as my update was done remote. I don’t recall if I rebooted the server or not though.  I have bigger issues on the second one, as the primary partition has plenty of disc space, bit it appears to be using a Backup partition that ran out of space.  Status of sipXecs shows some missing packages. Â
Â
I don’t have remote access to fill in more details – but will shortly.
Â
The site with the 503 has a sipxecs status that looks decent. There are several services that don’t come up, SAA, paging. Sipxconfig looks good – which is what normally I see not up completely on startup showing the 503.
Â
From: sipxco...@googlegroups.com [mailto:sipxco...@googlegroups.com]
On Behalf Of George Niculae
Sent: Thursday, December 20, 2018 7:22 AM
To: Peter Krautle <pmkr...@gmail.com>
Cc: sipxcom-users <sipxco...@googlegroups.com>
Subject: Re: [sipxcom-users] Re: sipXcom 18.04.1
Â
What errors do you get in sipxconfig?
Â
GeorgeÂ
To view this discussion on the web visit https://groups.google.com/d/msgid/sipxcom-users/CALLzRjbQXrFyQNEGALc%2Bq-dpVvtTE4HtQvJXRVdz4RPrTkj8Wg%40mail.gmail.com.
So updated a system last night.  I made an adjustment to the DNS this morning by adding an external DNS option – not sure it helps but there wasn’t one there beyond the customers domain controllers.  The system now shows a good status on all sipXcom components.  However, the 503 error is still given when trying to open the web gui.
Â
Here is what the sipxconfig log contains -Â Â Â "2018-12-20T17:22:58.157000Z":1:JAVA:INFO:phonesd.domainname.com:main:00000000:DynamicSessionFactoryBean:"Building new Hibernate SessionFactory"
"2018-12-20T17:23:05.481000Z":2:JAVA:INFO:phonesd.domainname.com:main:00000000:ReplicationManagerImpl:"Starting parallel regeneration of mongo group of 56 entities on 2 threads using chunks of 1000 users"
"2018-12-20T17:23:06.126000Z":3:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 415"
"2018-12-20T17:23:06.443000Z":4:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 413"
"2018-12-20T17:23:06.708000Z":5:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 428"
"2018-12-20T17:23:06.902000Z":6:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 440"
"2018-12-20T17:23:06.910000Z":7:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 441"
"2018-12-20T17:23:07.402000Z":8:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed james"
"2018-12-20T17:23:07.413000Z":9:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 435"
"2018-12-20T17:23:07.619000Z":10:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 446"
"2018-12-20T17:23:07.735000Z":11:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 449"
"2018-12-20T17:23:07.743000Z":12:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 450"
"2018-12-20T17:23:07.804000Z":13:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 451"
"2018-12-20T17:23:07.900000Z":14:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 454"
"2018-12-20T17:23:08.051000Z":15:JAVA:INFO:phonesd.domainname.com:pool-11-thread-1:00000000:ReplicationManagerImpl:"Replication: removed 457"
"2018-12-20T17:23:08.195000Z":16:JAVA:INFO:phonesd.domainname.com:main:00000000:ReplicationManagerImpl:"Regeneration of entities finished in 2s | 0m."
"2018-12-20T17:23:08.197000Z":17:JAVA:INFO:phonesd.domainname.com:main:00000000:ReplicationManagerImpl:"Starting parallel regeneration of mongo group of 38 entities on 2 threads using chunks of 1000 users"
"2018-12-20T17:23:08.679000Z":18:JAVA:INFO:phonesd.domainname.com:main:00000000:ReplicationManagerImpl:"Regeneration of entities finished in 0s | 0m."
"2018-12-20T17:23:08.819000Z":19:JAVA:INFO:phonesd.domainname.com:main:00000000:ReplicationManagerImpl:"Replication: removed Voip.ms.test"
"2018-12-20T17:23:09.634000Z":21:JAVA:INFO:phonesd.domainname.com:main:00000000:auditlog:"Replicated in Mongo DBDatabase regeneration to phonesd.domainname.com"
"2018-12-20T17:23:09.898000Z":22:JAVA:INFO:phonesd.domainname.com:main:00000000:SetupManagerImpl:"2 setup listeners will be called again"
"2018-12-20T17:23:09.898000Z":23:JAVA:INFO:phonesd.domainname.com:main:00000000:SetupManagerImpl:"0 setup listeners will be called again"
"2018-12-20T17:23:09.898000Z":24:JAVA:INFO:phonesd.domainname.com:main:00000000:ConfigManagerImpl:"Configuration work to do. Notifying providers."
"2018-12-20T17:23:09.915000Z":25:JAVA:INFO:phonesd.domainname.com:Thread-21:00000000:SimpleCommandRunner:"/usr/bin/mongodb-status --full"
"2018-12-20T17:23:09.916000Z":26:JAVA:INFO:phonesd.domainname.com:main:00000000:ResLimitsConfiguration:"Write FEATURED resource limits"
"2018-12-20T17:23:10.122000Z":27:JAVA:INFO:phonesd.domainname.com:Thread-21:00000000:SimpleCommandRunner:"/usr/bin/mongodb-analyzer"
"2018-12-20T17:23:13.703000Z":29:JAVA:INFO:phonesd.domainname.com:pool-1-thread-1:00000000:auditlog:"Replicated: 1 - Publish finished replication event ..."
"2018-12-20T17:23:14.927000Z":30:JAVA:INFO:phonesd.domainname.com:pool-7-thread-1:00000000:CheckDST:"Checking DST..."
"2018-12-20T17:23:19.472000Z":31:JAVA:WARNING:phonesd.domainname.com:main:00000000:AbstractSetting:"Cannot find setting: im-portal in user-portal"
"2018-12-20T17:23:19.997000Z":32:JAVA:WARNING:phonesd.domainname.com:main:00000000:RulesXmlFile:"Cannot read from external mapping rules file: "
"2018-12-20T17:23:20.001000Z":33:JAVA:WARNING:phonesd.domainname.com:main:00000000:RulesXmlFile:"Cannot read from external mapping rules file: "
"2018-12-20T17:23:20.657000Z":34:JAVA:INFO:phonesd.domainname.com:main:00000000:ConfigManagerImpl:"Running Signal XMPP configuration change"
"2018-12-20T17:23:40.894000Z":1:JAVA:INFO:phonesd.domainname.com:main:00000000:DynamicSessionFactoryBean:"Building new Hibernate SessionFactory"
"2018-12-20T17:23:50.855000Z":2:JAVA:WARNING:phonesd.domainname.com:main:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 42703"
"2018-12-20T17:23:50.855000Z":3:JAVA:ERR:phonesd.domainname.com:main:00000000:JDBCExceptionReporter:"ERROR: column this_.value_storage_id does not exist"
"2018-12-20T17:23:50.857000Z":4:JAVA:WARNING:phonesd.domainname.com:main:00000000:WebAppContext:"Failed startup of context o.e.j.w.WebAppContext@9c241d7{/sipxconfig,file:/var/sipxdata/tmp/sipxconfig/webapp/,STARTING}{/usr/share/java/sipXecs/sipXconfig/sipxconfig.war}"
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.ldap_connection_id as ldap1_50_5_, this_.host as host50_5_, this_.port as port50_5_, this_.principal as principal50_5_, this_.timeout as timeout50_5_, this_.secret as secret50_5_, this_.use_tls as use7_50_5_, this_.cron_schedule_id as cron8_50_5_, this_.value_storage_id as value9_50_5_, cronschedu2_.cron_schedule_id as cron1_59_0_, cronschedu2_.cron_string as cron2_59_0_, cronschedu2_.enabled as enabled59_0_, valuestora3_.value_storage_id as value1_70_1_, valuestora3_1_.name as name72_1_, valuestora3_1_.description as descript3_72_1_, valuestora3_1_.resource as resource72_1_, valuestora3_1_.weight as weight72_1_, valuestora3_1_.branch_id as branch6_72_1_, case when valuestora3_1_.group_id is not null then 1 when valuestora3_.value_storage_id is not null then 0 end as clazz_1_, branch4_.branch_id as branch1_101_2_, branch4_.name as name101_2_, branch4_.description as descript3_101_2_, branch4_.phone_number as phone4_101_2_, branch4_.fax_number as fax5_101_2_, branch4_.time_zone as time6_101_2_, branch4_.address_id as address7_101_2_, branch4_.fallback_branch_id as fallback8_101_2_, address5_.address_id as address1_86_3_, address5_.street as street86_3_, address5_.zip as zip86_3_, address5_.city as city86_3_, address5_.country as country86_3_, address5_.state as state86_3_, address5_.office_designation as office7_86_3_, branch6_.branch_id as branch1_101_4_, branch6_.name as name101_4_, branch6_.description as descript3_101_4_, branch6_.phone_number as phone4_101_4_, branch6_.fax_number as fax5_101_4_, branch6_.time_zone as time6_101_4_, branch6_.address_id as address7_101_4_, branch6_.fallback_branch_id as fallback8_101_4_ from ldap_connection this_ left outer join cron_schedule cronschedu2_ on this_.cron_schedule_id=cronschedu2_.cron_schedule_id left outer join value_storage valuestora3_ on this_.value_storage_id=valuestora3_.value_storage_id left outer join group_storage valuestora3_1_ on valuestora3_.value_storage_id=valuestora3_1_.group_id left outer join branch branch4_ on valuestora3_1_.branch_id=branch4_.branch_id left outer join address address5_ on branch4_.address_id=address5_.address_id left outer join branch branch6_ on branch4_.fallback_branch_id=branch6_.branch_id]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
               at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635)
               at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
               at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
               at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
               at org.springframework.orm.hibernate3.HibernateTemplate.loadAll(HibernateTemplate.java:584)
               at org.sipfoundry.sipxconfig.bulk.ldap.LdapManagerImpl.getAllConnectionParams(LdapManagerImpl.java:326)
               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
               at java.lang.reflect.Method.invoke(Method.java:606)
               at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
               at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
               at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
               at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111)
               at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
               at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
               at com.sun.proxy.$Proxy38.getAllConnectionParams(Unknown Source)
               at org.sipfoundry.sipxconfig.bulk.ldap.LdapImportTrigger.onApplicationEvent(LdapImportTrigger.java:53)
               at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:98)
               at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:333)
               at org.sipfoundry.sipxconfig.site.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:35)
               at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:800)
               at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:446)
               at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:792)
               at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:296)
               at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1359)
               at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1352)
               at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:744)
               at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:497)
               at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
               at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125)
               at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
               at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:60)
               at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:154)
               at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
               at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125)
               at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
               at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:60)
               at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
               at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125)
               at org.eclipse.jetty.server.Server.start(Server.java:358)
               at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
               at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:60)
               at org.eclipse.jetty.server.Server.doStart(Server.java:325)
               at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
               at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1250)
               at java.security.AccessController.doPrivileged(Native Method)
               at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1174)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
               at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
               at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
               at org.hibernate.loader.Loader.doList(Loader.java:2545)
               at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
               at org.hibernate.loader.Loader.list(Loader.java:2271)
               at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
               at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
               at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
               at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:590)
               at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:1)
               at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
               ... 45 more
Caused by: org.postgresql.util.PSQLException: ERROR: column this_.value_storage_id does not exist
               at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
               at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
               at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
               at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
               at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
               at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
               at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
               at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
               at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
               at org.hibernate.loader.Loader.doQuery(Loader.java:802)
               at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
               at org.hibernate.loader.Loader.doList(Loader.java:2542)
               ... 53 more
"2018-12-20T17:24:00.796000Z":5:JAVA:INFO:phonesd.domainname.com:pool-7-thread-1:00000000:CheckDST:"Checking DST..."
"2018-12-20T17:24:45.983000Z":1:JAVA:INFO:phonesd.domainname.com:main:00000000:DynamicSessionFactoryBean:"Building new Hibernate SessionFactory"
"2018-12-20T17:24:56.043000Z":2:JAVA:WARNING:phonesd.domainname.com:main:00000000:JDBCExceptionReporter:"SQL Error: 0, SQLState: 42703"
"2018-12-20T17:24:56.043000Z":3:JAVA:ERR:phonesd.domainname.com:main:00000000:JDBCExceptionReporter:"ERROR: column this_.value_storage_id does not exist"
"2018-12-20T17:24:56.051000Z":4:JAVA:WARNING:phonesd.domainname.com:main:00000000:WebAppContext:"Failed startup of context o.e.j.w.WebAppContext@256c128d{/sipxconfig,file:/var/sipxdata/tmp/sipxconfig/webapp/,STARTING}{/usr/share/java/sipXecs/sipXconfig/sipxconfig.war}"
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.ldap_connection_id as ldap1_50_5_, this_.host as host50_5_, this_.port as port50_5_, this_.principal as principal50_5_, this_.timeout as timeout50_5_, this_.secret as secret50_5_, this_.use_tls as use7_50_5_, this_.cron_schedule_id as cron8_50_5_, this_.value_storage_id as value9_50_5_, cronschedu2_.cron_schedule_id as cron1_59_0_, cronschedu2_.cron_string as cron2_59_0_, cronschedu2_.enabled as enabled59_0_, valuestora3_.value_storage_id as value1_70_1_, valuestora3_1_.name as name72_1_, valuestora3_1_.description as descript3_72_1_, valuestora3_1_.resource as resource72_1_, valuestora3_1_.weight as weight72_1_, valuestora3_1_.branch_id as branch6_72_1_, case when valuestora3_1_.group_id is not null then 1 when valuestora3_.value_storage_id is not null then 0 end as clazz_1_, branch4_.branch_id as branch1_101_2_, branch4_.name as name101_2_, branch4_.description as descript3_101_2_, branch4_.phone_number as phone4_101_2_, branch4_.fax_number as fax5_101_2_, branch4_.time_zone as time6_101_2_, branch4_.address_id as address7_101_2_, branch4_.fallback_branch_id as fallback8_101_2_, address5_.address_id as address1_86_3_, address5_.street as street86_3_, address5_.zip as zip86_3_, address5_.city as city86_3_, address5_.country as country86_3_, address5_.state as state86_3_, address5_.office_designation as office7_86_3_, branch6_.branch_id as branch1_101_4_, branch6_.name as name101_4_, branch6_.description as descript3_101_4_, branch6_.phone_number as phone4_101_4_, branch6_.fax_number as fax5_101_4_, branch6_.time_zone as time6_101_4_, branch6_.address_id as address7_101_4_, branch6_.fallback_branch_id as fallback8_101_4_ from ldap_connection this_ left outer join cron_schedule cronschedu2_ on this_.cron_schedule_id=cronschedu2_.cron_schedule_id left outer join value_storage valuestora3_ on this_.value_storage_id=valuestora3_.value_storage_id left outer join group_storage valuestora3_1_ on valuestora3_.value_storage_id=valuestora3_1_.group_id left outer join branch branch4_ on valuestora3_1_.branch_id=branch4_.branch_id left outer join address address5_ on branch4_.address_id=address5_.address_id left outer join branch branch6_ on branch4_.fallback_branch_id=branch6_.branch_id]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
               at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635)
               at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
               at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
               at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
               at org.springframework.orm.hibernate3.HibernateTemplate.loadAll(HibernateTemplate.java:584)
               at org.sipfoundry.sipxconfig.bulk.ldap.LdapManagerImpl.getAllConnectionParams(LdapManagerImpl.java:326)
               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
               at java.lang.reflect.Method.invoke(Method.java:606)
               at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
               at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
               at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
               at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111)
               at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
               at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
               at com.sun.proxy.$Proxy38.getAllConnectionParams(Unknown Source)
               at org.sipfoundry.sipxconfig.bulk.ldap.LdapImportTrigger.onApplicationEvent(LdapImportTrigger.java:53)
               at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:98)
               at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:333)
               at org.sipfoundry.sipxconfig.site.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:35)
               at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:800)
               at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:446)
               at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:792)
               at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:296)
               at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1359)
               at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1352)
               at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:744)
               at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:497)
               at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
               at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125)
               at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
               at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:60)
               at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:154)
               at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
               at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125)
               at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
               at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:60)
               at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
               at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:125)
               at org.eclipse.jetty.server.Server.start(Server.java:358)
               at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107)
               at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:60)
               at org.eclipse.jetty.server.Server.doStart(Server.java:325)
               at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
               at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1250)
               at java.security.AccessController.doPrivileged(Native Method)
               at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1174)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
               at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
               at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
               at org.hibernate.loader.Loader.doList(Loader.java:2545)
               at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
               at org.hibernate.loader.Loader.list(Loader.java:2271)
               at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
               at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
               at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
               at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:590)
               at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:1)
               at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
               ... 45 more
Caused by: org.postgresql.util.PSQLException: ERROR: column this_.value_storage_id does not exist
               at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
               at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
               at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
               at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
               at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
               at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
               at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
               at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
               at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
               at org.hibernate.loader.Loader.doQuery(Loader.java:802)
               at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
               at org.hibernate.loader.Loader.doList(Loader.java:2542)
               ... 53 more
"2018-12-20T17:25:06.015000Z":5:JAVA:INFO:phonesd.domainname.com:pool-7-thread-1:00000000:CheckDST:"Checking DST..."
Â
From: sipxco...@googlegroups.com [mailto:sipxco...@googlegroups.com] On Behalf Of George Niculae
Sent: Thursday, December 20, 2018 7:22 AM
To: Peter Krautle <pmkr...@gmail.com>
Cc: sipxcom-users <sipxco...@googlegroups.com>
Subject: Re: [sipxcom-users] Re: sipXcom 18.04.1
Â
What errors do you get in sipxconfig?
Â
GeorgeÂ
Â
To post to this group, send email to sipxco..@googlegroups.com.
Visit this group at https://groups.google.com/group/sipxcom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/sipxcom-users/3f014b7a-f328-41e8-8675-845bd5ab03fc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "sipxcom-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sipxcom-user...@googlegroups.com.
To post to this group, send email to sipxcom-users@googlegroupscom.
Visit this group at https://groups.google.com/group/sipxcom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/sipxcom-users/a160a0e3-0dc2-4b16-bb6b-24809c379d0c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to a topic in the Google Groups "sipxcom-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/sipxcom-users/mnP-NxjM2-Q/unsubscribe.
To unsubscribe from this group and all its topics, send an email to sipxcom-user...@googlegroups.com.
To post to this group, send email to sipxco...@googlegroups.com.
Visit this group at https://groups.google.com/group/sipxcom-users.
To view this discussion on the web visit https://groupsgoogle.com/d/msgid/sipxcom-users/CALLzRjbQXrFyQNEGALc%2Bq-dpVvtTE4HtQvJXRVdz4RPrTkj8Wg%40mail.gmail.com.