Topic
6 replies Latest Post - ‏2013-08-30T18:29:12Z by jmblaise
jmblaise
jmblaise
4 Posts
ACCEPTED ANSWER

Pinned topic Various errors in OPM 5.3 logs

‏2013-07-17T15:29:45Z |

Hello,

I have upgraded an OPM 5.2 installation to 5.3 and I have some questions about errors in log files (please see below):

* what should I do to solve license check ?

* is the error on BUFFERPOOL a problem ?

* I get so illegal exceptions, impact Major or Critical, is this really that level ?

Regarding the logs, I found I had to prune myself entries dating 2012 or 2011. Do you have a mechanism to only keep 6 months old logs ?

Thanks for your answers & Best regards

 

======================= jccdiag.log =========================
2013-07-12 14:13:42.322
License check was performed against server XXXXXX (the monitored server), calling the V9+ license procedure failed: ErrorCode=-805 SQLState=51002
Server version: SQL09078
Driver version: 3.66.46

2013-07-17 10:31:42.847
License check was performed against server 127.0.0.1 (the server hosting PERFDB), calling the V9+ license procedure failed: ErrorCode=-805 SQLState=51002
Server version: SQL09078
Driver version: 3.66.46

======================= DS_System.0 =========================
DS_System       (317)   Jul 10, 2013 12:13:44 PM        ERROR    updateSchema failed for: snapshotRepContributor
java.sql.BatchUpdateException: Syntax error: Encountered "BUFFERPOOL" at line 1, column 9.
        at org.apache.derby.impl.jdbc.EmbedStatement.executeBatch(Unknown Source)
        at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
        at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
        at com.ibm.datatools.config.cfgutils.DDLRunner.parseAndRunDDL(DDLRunner.java:421)
        at com.ibm.datatools.config.cfgutils.DDLRunner.execute(DDLRunner.java:341)
        at com.ibm.datatools.config.cfgutils.DDLRunner.runDDlsWithDBName(DDLRunner.java:293)
        at com.ibm.datatools.config.cfgutils.ConfigUtils.runDDlsWithDBName(ConfigUtils.java:226)
        at com.ibm.datatools.common.repository.mgr.RepositoryContributor.runSQLFromFile(RepositoryContributor.java:326)
        at com.ibm.datatools.common.repository.mgr.RepositoryContributor.updateSchema(RepositoryContributor.java:582)
        at com.ibm.datatools.common.repository.mgr.RepositoryContributor.initializeFallBack(RepositoryContributor.java:632)
        at com.ibm.datatools.common.repository.mgr.RepositoryContributor.init(RepositoryContributor.java:737)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
        at java.lang.reflect.Method.invoke(Method.java:613)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1413)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1374)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1334)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
        at java.security.AccessController.doPrivileged(AccessController.java:252)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:221)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:729)
        at org.springframework.osgi.context.support.AbstractDelegatedExecutionApplicationContext.completeRefresh(AbstractDelegatedExecutionApplicationContext
.java:276)
        at org.springframework.osgi.extender.internal.dependencies.startup.DependencyWaiterApplicationContextExecutor$CompleteRefreshTask.run(DependencyWaite
rApplicationContextExecutor.java:145)
        at java.lang.Thread.run(Thread.java:780)
Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "BUFFERPOOL" at line 1, column 9.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeBatchElement(Unknown Source)
        ... 32 more
Caused by: java.sql.SQLException: Syntax error: Encountered "BUFFERPOOL" at line 1, column 9.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
        ... 40 more
Caused by: ERROR 42X01: Syntax error: Encountered "BUFFERPOOL" at line 1, column 9.
        at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
        at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source)
        at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
        at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)

db2level ==> "DB2 v9.7.0.8"

========================= dsserver.log =============================================
STARTED Health and Snapshot Contribution Management services
HTTPContextRegistry started: /jobmanager
HTTPContextRegistry started: /dbblackout
[err] SQL Error: Syntax error: Encountered "BUFFERPOOL" at line 1, column 9.;  SQLState: 42X01;  Vendor Error Code: 20000.
[err] java.sql.BatchUpdateException: Syntax error: Encountered "BUFFERPOOL" at line 1, column 9.
[err]   at org.apache.derby.impl.jdbc.EmbedStatement.executeBatch(Unknown Source)
[err]   at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
[err]   at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
[err]   at com.ibm.datatools.config.cfgutils.DDLRunner.parseAndRunDDL(DDLRunner.java:421)
[err]   at com.ibm.datatools.config.cfgutils.DDLRunner.execute(DDLRunner.java:341)
[err]   at com.ibm.datatools.config.cfgutils.DDLRunner.runDDlsWithDBName(DDLRunner.java:293)
[err]   at com.ibm.datatools.config.cfgutils.ConfigUtils.runDDlsWithDBName(ConfigUtils.java:226)
[err]   at com.ibm.datatools.common.repository.mgr.RepositoryContributor.runSQLFromFile(RepositoryContributor.java:326)
[err]   at com.ibm.datatools.common.repository.mgr.RepositoryContributor.updateSchema(RepositoryContributor.java:582)
[err]   at com.ibm.datatools.common.repository.mgr.RepositoryContributor.initializeFallBack(RepositoryContributor.java:632)
[err]   at com.ibm.datatools.common.repository.mgr.RepositoryContributor.init(RepositoryContributor.java:737)
[err]   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[err]   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)
[err]   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
[err]   at java.lang.reflect.Method.invoke(Method.java:613)
[err]   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1413)
[err]   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1374)
[err]   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1334)
[err]   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
[err]   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
[err]   at java.security.AccessController.doPrivileged(AccessController.java:252)
[err]   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
[err]   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
[err]   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:221)
[err]   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
[err]   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
[err]   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
[err]   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
[err]   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:729)
[err]   at org.springframework.osgi.context.support.AbstractDelegatedExecutionApplicationContext.completeRefresh(AbstractDelegatedExecutionApplicationContext
.java:276)
[err]   at org.springframework.osgi.extender.internal.dependencies.startup.DependencyWaiterApplicationContextExecutor$CompleteRefreshTask.run(DependencyWaite
rApplicationContextExecutor.java:145)
[err]   at java.lang.Thread.run(Thread.java:780)
[err] Caused by:
[err] java.sql.SQLSyntaxErrorException: Syntax error: Encountered "BUFFERPOOL" at line 1, column 9.
[err]   at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
[err]   at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
HTTPContextRegistry started: /healthsnapshot
[err]   at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
[err]   at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
[err]   at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
[err]   at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
[err]   at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
[err]   at org.apache.derby.impl.jdbc.EmbedStatement.executeBatchElement(Unknown Source)
[err]   ... 32 more
[err] Caused by:
[err] java.sql.SQLException: Syntax error: Encountered "BUFFERPOOL" at line 1, column 9.

==================================== datatools.log ============================================
2013-07-05 11:04:22,695 [SpringOsgiExtenderThread-139] com.ibm.datatools.perf.console.core.datasource.impl.RSDatasourceProviderImpl  - TIME     : 2013-07-05T
11:04:22.694+0200       IMPACT  : Critical
ACTION   : INIT          OBJECT  : DataBase   OBJINFO : "PERFDB"
STATUS   : Success       FUNCTION: com.ibm.datatools.perf.console.core.datasource.impl.RSDatasourceProviderImpl.initRepoDataSource()
THREAD ID: 1373015062663 SEQ     : 3

2013-07-05 16:05:46,395 [Default Executor-thread-47] com.ibm.datatools.perf.repository.RsApiTracer  - TIME     : 2013-07-05T16:05:46.394+0200       IMPACT  :
 Critical
ACTION   : CONNECT       OBJECT  : DataBase   OBJINFO : "FATAL :: com.ibm.datatools.perf.repository.api.config.impl.profiles.AbstractMonitoringProfile :: jav
a.lang.IllegalArgumentException: The argument value '0' is not applicable for the snapshot sampling down shift factor, it must not be less than 1. Profile: C
IMOS_INFORMATION_PROFILE"
STATUS   : Start         FUNCTION: com.ibm.datatools.perf.repository.RsApiTracer
THREAD ID: 1373033146395 SEQ     : 0

2013-07-10 12:13:39,335 [SpringOsgiExtenderThread-142] com.ibm.datatools.perf.console.core.datasource.impl.RSDatasourceProviderImpl  - TIME     : 2013-07-10T
12:13:39.334+0200       IMPACT  : Critical
ACTION   : CREATE        OBJECT  : Connection OBJINFO : "__PERFDB__"
STATUS   : Success       FUNCTION: com.ibm.datatools.perf.console.core.datasource.impl.RSDatasourceProviderImpl
THREAD ID: 1373451219317 SEQ     : 2
CONTEXT  : Repository Profile does not exist: __PERFDB__ Creating ...

2013-07-10 12:13:42,844 [SpringOsgiExtenderThread-139] com.ibm.datatools.perf.repository.RsApiTracer  - TIME     : 2013-07-10T12:13:42.842+0200       IMPACT
 : Major
ACTION   : CONNECT       OBJECT  : DataBase   OBJINFO : "ERROR :: com.ibm.datatools.perf.repository.RsApiTraceWriter :: 1|HOSTCONN     |MetaInfoTable: Node w
ith name PKGCACHE has no valid parent node"
STATUS   : Start         FUNCTION: com.ibm.datatools.perf.repository.RsApiTracer
THREAD ID: 1373451219521 SEQ     : 4


 

  • jmblaise
    jmblaise
    4 Posts
    ACCEPTED ANSWER

    Re: Various errors in OPM 5.3 logs

    ‏2013-07-30T22:03:42Z  in response to jmblaise

    Hi,

    I was expecting this forum to be monitored seriously by IBM, but I guess I will ask all these questions by opening a PMR.

    Disapointing ...

    Regards,

    JMB

    • MarkTaylorODS
      MarkTaylorODS
      1 Post
      ACCEPTED ANSWER

      Re: Various errors in OPM 5.3 logs

      ‏2013-08-13T04:11:15Z  in response to jmblaise

      JM Blaise,

      I apologize that your post has been neglected.   I'll have someone from OPM L3/Development dig into this one very soon unless you've opened a PMR already.   I appreciate your patience and sorry for the frustration.

      Mark Taylor - OPM development

       

      • KaranKaruppiah
        KaranKaruppiah
        24 Posts
        ACCEPTED ANSWER

        Re: Various errors in OPM 5.3 logs

        ‏2013-08-14T23:45:17Z  in response to MarkTaylorODS

        Hi JM Blaise,

        First of all sorry for the late response.

        For license, you have to install new license when you move into different release like moving from 5.2 to 5.3.

        Do you still have other 2 issues you specified above?

        If so, we need more traces to analysis the problem. Hence, can you please open a PMR and send us the more traces by running collector.sh ot collector.bat based on your OS from the install directory /opt/IBM/OPM/support/collector.sh

        I'll be more than happy to help you if you have any additional questions.

        thanks

        Karan

         

         

        • jmblaise
          jmblaise
          4 Posts
          ACCEPTED ANSWER

          Re: Various errors in OPM 5.3 logs

          ‏2013-08-30T15:34:46Z  in response to KaranKaruppiah

          Hi Karan,

          Thanks for your reply, I have created PMR 84372,664,706 and my customer has uploaded the collect.

          Regarding the license, I have applied the activation license from OPM5.3, that's why I am surprised about the error. The issues are still there when I restart OPM.

          As  I wrote also previously, I would like to know if there is a pruning mechanism to keep 1 month log data, because there is no interest to have more and I would like to keep the scope of log files to a minimum.

          Best regards,

          JMB

          • KaranKaruppiah
            KaranKaruppiah
            24 Posts
            ACCEPTED ANSWER

            Re: Various errors in OPM 5.3 logs

            ‏2013-08-30T17:18:17Z  in response to jmblaise

            Hi JMB,

            Thanks for opening a PMR to work with the questions/error message you have.

            Did you migrate same edition to same edition? Like enterprise 5.2 to enterprise 5.3 ...

            If you migrate from one release to another release with in the same version and same edition (as mentioned above) then no need to install new license. Please clarify what is your scenario?

            Regarding, pruning the log file, unfortunately we do not have any automatic pruning  at this point in time. It can be done manually. For License issue, we can work with you through  the PMR you opened since it may need to review your logs/traces etc.,

            thanks

            Karan

             

            • jmblaise
              jmblaise
              4 Posts
              ACCEPTED ANSWER

              Re: Various errors in OPM 5.3 logs

              ‏2013-08-30T18:29:12Z  in response to KaranKaruppiah

              Hi Karan,

              I upgraded 5.2 with 5.3 running the install-on-Aix binary, and then I used the activation binary for the license. Btw, if license is there in 5.2 and does not need to be updated, there should not be 2 choices for installation (without license and with license), and a message could be issued to tell it's not necessary to run the activation binary.

              For pruning the logs, could you create a feature request for that please ?

              The support asked me to re-run the migration, but I would like to understand why it would be necessary, and what this is supposed to run as actions.

              Thanks,

              JMB