Looks like a sql issue with branch: one.xxx.yyy.com:main:00000000:JDBCExceptionReporter :"ERROR: relation \"branch\" does not exist" "2010-02
I didn't have thhis same issue with an inplace upgrade but have not installed a 4.1.8 iso yet. ============================ Tony Graziano, Manager Telephone: 434.984.8430 Fax: 434.984.8431 Email: [email protected] LAN/Telephony/Security and Control Systems Helpdesk: Telephone: 434.984.8426 Fax: 434.984.8427 Helpdesk Contract Customers: http://www.myitdepartment.net/gethelp/ ----- Original Message ----- From: [email protected] <[email protected]> To: Sipx-users list <[email protected]> Sent: Mon Feb 22 16:00:43 2010 Subject: [sipx-users] 4.1.6.018058 ISO issue Has anyone successfully run the 4.1.6.018058 ISO? After install, when I visit the web GUI, I get: HTTP ERROR: 404 /sipxconfig Not Found RequestURI=/sipxconfig Powered by Jetty:// sipxconfig.log says the following: "2010-02-22T20:51:11.619000Z":1:JAVA:INFO:pbx.phone.xxx.yyy.com:main:00000000:DynamicSessionFactoryBean:"Building new Hibernate SessionFactory" "2010-02-22T20:51:28.839000Z":2:JAVA:INFO:pbx.phone.xxx.yyy.com:main:00000000:FirstRunTask:"Handling task first-run" "2010-02-22T20:51:28.839000Z":3:JAVA:INFO:pbx.phone.xxx.yyy.com:main:00000000:FirstRunTask:"Executing first run tasks..." "2010-02-22T20:51:28.840000Z":4:JAVA:INFO:pbx.phone.xxx.yyy.com:main:00000000:DomainManagerImpl:"Attempting to load initial domain-config from /etc/sipxpbx):""2010-02-22T20:51:28.870000Z":5:JAVA:WARNING:pbx.phone.xxx.yyy.com:main:00000000:JDBCExceptionRepo rter:"SQL Error: 0, SQLState: 42P01" "2010-02-22T20:51:28.870000Z":6:JAVA:ERR:pbx.phone.xxx.yyy.com:main:00000000:JDBCExceptionReporter :"ERROR: relation \"branch\" does not exist" "2010-02-22T20:51:36.324000Z":7:JAVA:WARNING:pbx.phone.xxx.yyy.com:main:00000000:Server:"EXCEPTION " org.mortbay.util.MultiException[org.springframework.dao.InvalidDataAccessResourceUsageException: coul d not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execu te query] at org.mortbay.http.HttpServer.doStart(HttpServer.java:731) at org.mortbay.util.Container.start(Container.java:72) at org.mortbay.jetty.Server.main(Server.java:433) org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exce ption is org.hibernate.exception.SQLGrammarException: could not execute query Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2220) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2108) at org.hibernate.loader.Loader.list(Loader.java:2103) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1570) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.jav a:535) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:369) at org.springframework.orm.hibernate3.HibernateTemplate.loadAll(HibernateTemplate.java:531) at org.sipfoundry.sipxconfig.admin.commserver.LocationsManagerImpl.getLocations(Unknown Sourc e) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMet hodInvocation.java:172) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:1 04) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvoc ation.java:161) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203) at $Proxy2.getLocations(Unknown Source) at org.sipfoundry.sipxconfig.domain.DomainManagerImpl.getAlliasesFromDomainConfig(Unknown Sou rce) at org.sipfoundry.sipxconfig.domain.DomainManagerImpl.parseDomainConfig(Unknown Source) at org.sipfoundry.sipxconfig.domain.DomainManagerImpl.initializeDomain(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMet hodInvocation.java:172) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvoc ation.java:139) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:104) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvoc ation.java:161) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203) at $Proxy6.initializeDomain(Unknown Source) at org.sipfoundry.sipxconfig.admin.FirstRunTask.runTask(Unknown Source) at org.sipfoundry.sipxconfig.admin.FirstRunTask.onApplicationEvent(Unknown Source) at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77) at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75) at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246) at org.sipfoundry.sipxconfig.site.ContextLoaderListener.contextInitialized(Unknown Source) at org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationContext.java:497) at org.mortbay.util.Container.start(Container.java:72) at org.mortbay.http.HttpServer.doStart(HttpServer.java:753) at org.mortbay.util.Container.start(Container.java:72) at org.mortbay.jetty.Server.main(Server.java:433) Caused by: org.postgresql.util.PSQLException: ERROR: relation "branch" 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:187) at org.hibernate.loader.Loader.getResultSet(Loader.java:1791) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2217) ... 46 more Thanks. _______________________________________________ sipx-users mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-users Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-users sipXecs IP PBX -- http://www.sipfoundry.org/
