APOLLO & ECW/JP2 Discussions

Wondering how others have configured their ERDAS APOLLO server or what data they are crawling? The ERDAS APOLLO Discussion board is a place to find information, share ideas and more. Join the community, connect, contribute and share.
Showing results for 
Search instead for 
Do you mean 
Reply
Contributor
Posts: 38
Registered: ‎01-11-2017
Accepted Solution

Appolo Installation Error

I am installing Appolo on brand new Windows Server 2012. at the end of configuration I am getting the following error. as shown in the image.

 

The database initiazation/upgrade failed.

 

The configuration parameters database update failed.

 

I have an Appolo Advantage Concurrent license installed on a network license server.

 

What could be the problem here as its very difficult to find out from the log file.

 

Configuration Error.png

 

On the log  it says incompatible version for JDBC:

 

     [java] 2018-01-21 11:55:01,745 - org.springframework.beans.factory.BeanCrea
tionException: Error creating bean with name 'sessionFactory' defined in class p
ath resource [META-INF/apollo/babel-hibernate-beans.xml]: Cannot resolve referen
ce to bean 'dataSource' while setting bean property 'dataSource'; nested excepti
on is org.springframework.beans.factory.BeanCreationException: Error creating be
an with name 'dataSource' defined in class path resource [com/erdas/apollo/confi
g/ds/ds.xml]: Bean instantiation via constructor failed; nested exception is org
.springframework.beans.BeanInstantiationException: Failed to instantiate [com.za
xxer.hikari.HikariDataSource]: Constructor threw exception; nested exception is
java.lang.Error: Incompatible version of libocijdbc[Jdbc:121020, Jdbc-OCI:122010

 

 

Buildfile: C:\Program Files\Hexagon\ERDAS APOLLO\tools\schema-generator\build.xml
-init:
    [mkdir] Created dir: C:\Program Files\Hexagon\ERDAS APOLLO\tools\schema-generator\target
     [copy] Copying 7 files to C:\Program Files\Hexagon\ERDAS APOLLO\tools\schema-generator\target\resources
upgrade:
     [java] 2018-01-04 10:37:45,419 - Exception encountered during context initialization - cancelling refresh attempt
     [java] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [META-INF/apollo/babel-hibernate-beans.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/erdas/apollo/config/ds/ds.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Constructor threw exception; nested exception is java.lang.Error: Incompatible version of libocijdbc[Jdbc:121020, Jdbc-OCI:122010
     [java]     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
     [java]     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
     [java]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1477)
     [java]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1222)
     [java]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
     [java]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
     [java]     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
     [java]     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
     [java]     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
     [java]     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
     [java]     at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:736)
     [java]     at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
     [java]     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
     [java]     at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
     [java]     at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
     [java]     at com.erdas.rsp.babel.upgrade.service.BabelSchemaManagerInvoker.main(BabelSchemaManagerInvoker.java:178)
     [java] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/erdas/apollo/config/ds/ds.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Constructor threw exception; nested exception is java.lang.Error: Incompatible version of libocijdbc[Jdbc:121020, Jdbc-OCI:122010
     [java]     at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:275)
     [java]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1139)
     [java]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1042)
     [java]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
     [java]     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
     [java]     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
     [java]     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
     [java]     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
     [java]     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
     [java]     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
     [java]     ... 15 more
     [java] Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Constructor threw exception; nested exception is java.lang.Error: Incompatible version of libocijdbc[Jdbc:121020, Jdbc-OCI:122010
     [java]     at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:163)
     [java]     at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122)
     [java]     at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:267)
     [java]     ... 24 more
     [java] Caused by: java.lang.Error: Incompatible version of libocijdbc[Jdbc:121020, Jdbc-OCI:122010
     [java]     at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:4126)
     [java]     at java.security.AccessController.doPrivileged(Native Method)
     [java]     at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:4119)
     [java]     at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:312)
     [java]     at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
     [java]     at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:54)
     [java]     at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
     [java]     at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
     [java]     at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
     [java]     at com.zaxxer.hikari.pool.BaseHikariPool.addConnection(BaseHikariPool.java:444)
     [java]     at com.zaxxer.hikari.pool.BaseHikariPool.initializeConnections(BaseHikariPool.java:548)
     [java]     at com.zaxxer.hikari.pool.BaseHikariPool.<init>(BaseHikariPool.java:172)
     [java]     at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:60)
     [java]     at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:48)
     [java]     at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:80)
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
     [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
     [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
     [java]     at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147)
     [java]     ... 26 more

Staff
Posts: 135
Registered: ‎05-31-2016

Re: Appolo Installation Error

Can you upload the complete installation log file?

Contributor
Posts: 38
Registered: ‎01-11-2017

Re: Appolo Installation Error

Please see the attached log.

Staff
Posts: 135
Registered: ‎05-31-2016

Re: Appolo Installation Error

Looks like there is a problem connection to Oracle.

 

Can you connect to your Oracle database using SQL Developer

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

 

 

Contributor
Posts: 38
Registered: ‎01-11-2017

Re: Appolo Installation Error

I am able to connect using SQL developer and sql plus.

SQLDevScreen.png

ConnectionDialog.png

Staff
Posts: 135
Registered: ‎05-31-2016

Re: Appolo Installation Error

Unfortunately I have not done many installations using Oracle so I have not seen this error before. Hopefully someone that uses Oracle regularly may be able help a bit more.

 

If you can connect to the Oracle server from your Apollo server using SQL Developer and SQLPlus than I would assume that you have the Oracle client installed and your TNSNames configured properly. Although if you are using a 32bit version of SQL Developer and SQLPlus then this may still be the problem.

 

Have another look at the Oracle prerequisites and make sure you have not missed anything 

https://hexagongeospatial.fluidtopics.net/reader/mTU~cgWbwQvAN0vZ2~kvMw/K9DGInkkdEyVWD7qXVFIFQ

 

 

Moderator
Moderator
Posts: 342
Registered: ‎11-16-2015

Re: Appolo Installation Error

Right, please check first if you have all the needed Oracle components.

See doc: "ERDAS APOLLO requires the installation of the Oracle Call Interface OCI client libraries and Oracle Data Provider for .NET (ODP.NET) on the ERDAS APOLLO server in order to use an Oracle catalog database, or to crawl vector features in an Oracle database. "

Contributor
Posts: 38
Registered: ‎01-11-2017

Re: Appolo Installation Error

I am using 64 bit SQL developer.

 

Also I tried installing the latest ODAC 12 and also tried with ODAC 11g (both 64 bit) without any luck.

 

Installer is creating the required tables in the database. but finally throws error with config-updater application.

 

Online help is not of much use as it does not mention any version information there.

 

Anyone knows any environment variables to be set?

 

I believe the error is with JDBC trying to connect with OCI. Which version of JDBC to use?

 

 

Contributor
Posts: 38
Registered: ‎01-11-2017

Re: Appolo Installation Error

I was able get the configuration right by using thin client instead of OCI.

We had a RAC setup for oracle and I managed to get TNS for single node from DBA.

Now I have the configuration run without issues. but catalog applicaion is not running.

I have posted a different entry for that error.