IC SunsetThe developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this community and its apps will no longer be available. More details available on our FAQ.
Topic
  • 3 replies
  • Latest Post - ‏2017-11-30T00:33:10Z by sgarcia0033
Jose_G_Torres
Jose_G_Torres
1 Post

Pinned topic Unable to install 3.5.3 on WebSphere 8.5.5.11 & DB2 10.5.0.8

‏2017-10-26T21:17:42Z | 3.5.3 db2 install tririga webphere

Hello Everyone,

I am attempting a clean install of TRIRIGA 3.5.3 and according to the logs it appears that the installation was successful within the was-ant.log but receive this error in the ant.log. 

 

copy-from-old-install:
     [copy] Copying 885 files to /home/jogee/tririgaWS-3.5.3.x
     [copy] Warning: /config does not exist.
     [copy] Warning: /config/licenses does not exist.
     [java] [Ignorable] Skipping because one of these files may not exist: /config/TRIRIGADB.properties , /home/jogee/tririgaWS-3.5.3.x/config/TRIRIGADB.properties
     [java] Java Result: 255
     [java] [Ignorable] Skipping because one of these files may not exist: /config/TRIRIGAWEB.properties , /home/jogee/tririgaWS-3.5.3.x/config/TRIRIGAWEB.properties
     [java] Java Result: 255
     [java] [Ignorable] Skipping because one of these files may not exist: /config/TRIRIGACRYSTAL.properties , /home/jogee/tririgaWS-3.5.3.x/config/TRIRIGACRYSTAL.properties
     [java] Java Result: 255

 

When I access the application I was unable to pull up the login page.  Checking the server logs I noticed these errors.

 

2017-10-26 12:26:43,703 ERROR [com.tririga.web.servlet.SpringWebInitServlet](server.startup : 1) ERROR BeansException initializing Spring Application Context
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'upgradeScripts' defined in class path resource [com/tririga/platform/spring/upgrade.xml]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.tririga.platform.upgrade.UpgradeScripts]: Factory method 'doUpgrade' threw exception; nested exception is org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select value from environment_properties where environment=? and property=?]; SQL state [51002]; error code [-805]; DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLIDR1.SYSSH200 0X5359534C564C3031, DRIVER=4.18.60; nested exception is com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLIDR1.SYSSH200 0X5359534C564C3031, DRIVER=4.18.60

...

Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.tririga.platform.upgrade.UpgradeScripts]: Factory method 'doUpgrade' threw exception; nested exception is org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select value from environment_properties where environment=? and property=?]; SQL state [51002]; error code [-805]; DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLIDR1.SYSSH200 0X5359534C564C3031, DRIVER=4.18.60; nested exception is com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLIDR1.SYSSH200 0X5359534C564C3031, DRIVER=4.18.60
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:189)
        at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:588)
        ... 42 more
Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select value from environment_properties where environment=? and property=?]; SQL state [51002]; error code [-805]; DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLIDR1.SYSSH200 0X5359534C564C3031, DRIVER=4.18.60; nested exception is com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLIDR1.SYSSH200 0X5359534C564C3031, DRIVER=4.18.60

The old thing is that when I did a 3.5.3 WebSphere Liberty install, it worked perfectly. 

Here are my software specs.

  • Websphere 8.5.5.11 - Using default profile.
  • DB2 10.5.0.8
  • Redhat Linux 7.4 for both TRIRIGA and DB2
  • IBM SDK 1.8 - 8.0.3.0-WS-IBMWASJAVA-Linux

 

Any suggestions would be great.  Thanks in advanced!



Jose

  • sgarcia0033
    sgarcia0033
    32 Posts

    Re: Unable to install 3.5.3 on WebSphere 8.5.5.11 & DB2 10.5.0.8

    ‏2017-10-27T19:41:48Z  

    copy-from-old-install:
         [copy] Copying 885 files to /home/jogee/tririgaWS-3.5.3.x
         [copy] Warning: /config does not exist.
         [copy] Warning: /config/licenses does not exist

     

    Seems to indicate that you selected upgrade not new install.  Are you sure you selected new install?  Some of the environment properties that are needed to start up do not seem to be available.  Did the database get created or are you pointing at an existing database?  what happens if you do a

    select * from environment_properties on the database you are using? 

     

    The DB2 exception you are receiving seems to indicate you are running out of statement handles, but I am having a hard time seeing this happen with a successful install. 

  • jkabage
    jkabage
    2 Posts

    Re: Unable to install 3.5.3 on WebSphere 8.5.5.11 & DB2 10.5.0.8

    ‏2017-11-27T18:39:01Z  

    We are facing same exact issue!!! Was there any resolution to this issue?

    Much appreciated.

  • sgarcia0033
    sgarcia0033
    32 Posts

    Re: Unable to install 3.5.3 on WebSphere 8.5.5.11 & DB2 10.5.0.8

    ‏2017-11-30T00:33:10Z  
    • jkabage
    • ‏2017-11-27T18:39:01Z

    We are facing same exact issue!!! Was there any resolution to this issue?

    Much appreciated.

    I would suggest you both submit a PMR to get help directly from support.  The information being provide is not everything needed to debug this issue.