org.ofbiz.core.util.GeneralRuntimeException: Error getting the next result (Protocol violation: [ 46, ])

Atlassian JIRA | Andriy Yakovlev [Atlassian] | 8 months ago
  1. 0

    h3. Summary JIRA 7 is shipped with Oracle JDBC driver 12.1.0.1.0: {{ojdbc7-12.1.0.1.jar}} Oracle Driver 12.1.0.1 throws error _Protocol violation_ during connection to Database. h3. Environment * JIRA 7.x * Database Oracle 12c Enterprise Edition Release 12.1.0.1.0 or 12.1.0.2 h3. Steps to Reproduce # Setup JIRA and connect it to DB # Add some data (we don't have this specific set of data) # Run reindex h3. Expected Results It works fine. h3. Actual Results The below exception is thrown in the jira.log file: {noformat} 2016-04-13 21:37:52,114 JiraTaskExectionThread-4 ERROR jiraadmins 1271x19429x1 1lemfi1 10.98.60.21 /secure/admin/IndexReIndex.jspa [c.a.j.util.index.CompositeIndexLifecycleManager] Reindex All FAILED. Indexer: DefaultIndexManager: paths: [/jiraindex/infra711/jiraindex/caches/indexes/comments, /jiraindex/infra711/jiraindex/caches/indexes/issues, /jiraindex/infra711/jiraindex/caches/indexes/changes, /jiraindex/infra711/jiraindex/caches/indexes/worklogs, /jiraindex/infra711/jiraindex/caches/indexes/plugins/atlassian-subversion-revisions] org.ofbiz.core.util.GeneralRuntimeException: Error getting the next result (Protocol violation: [ 46, ]) at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:251) at com.atlassian.jira.ofbiz.DefaultOfBizListIterator.next(DefaultOfBizListIterator.java:100) at com.atlassian.jira.ofbiz.WrappingOfBizListIterator.next(WrappingOfBizListIterator.java:68) at com.atlassian.jira.issue.util.DatabaseIssuesIterator.pullNextIssue(DatabaseIssuesIterator.java:97) at com.atlassian.jira.issue.util.DatabaseIssuesIterator.populateNextIssueIfNull(DatabaseIssuesIterator.java:68) at com.atlassian.jira.issue.util.DatabaseIssuesIterator.hasNext(DatabaseIssuesIterator.java:51) at com.atlassian.jira.issue.util.DatabaseIssuesIterable.foreach(DatabaseIssuesIterable.java:55) at com.atlassian.jira.issue.index.DefaultIssueIndexer.perform(DefaultIssueIndexer.java:282) at com.atlassian.jira.issue.index.DefaultIssueIndexer.indexIssuesBatchMode(DefaultIssueIndexer.java:151) at com.atlassian.jira.issue.index.DefaultIndexManager.doIndexIssuesInBatchMode(DefaultIndexManager.java:984) at com.atlassian.jira.issue.index.DefaultIndexManager.doStopTheWorldReindex(DefaultIndexManager.java:961) at com.atlassian.jira.issue.index.DefaultIndexManager.lambda$reIndexAll$0(DefaultIndexManager.java:326) at com.atlassian.jira.issue.index.DefaultIndexManager.withReindexLock(DefaultIndexManager.java:359) at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexAll(DefaultIndexManager.java:326) at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexAll(DefaultIndexManager.java:258) ... Caused by: java.sql.SQLException: Protocol violation: [ 46, ] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:669) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1022) at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:1008) at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:972) at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:572) at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:191) at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:191) at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:245) ... 33 more {noformat} h3. Notes May be related to Oracle Clob bug. See: * https://confluence.atlassian.com/confkb/java-sql-sqlexception-protocol-violation-caught-while-accessing-a-page-and-oracle-db-is-used-781393258.html * https://confluence.atlassian.com/pages/viewpage.action?pageId=780863295 * http://stackoverflow.com/questions/22785120/oracle-clob-reader-issue-protocol-violation * http://stackoverflow.com/questions/4685021/sqlexception-protocol-violation-oracle-jdbc-driver-issue/35343994#35343994 Conflicts with: https://jira.atlassian.com/browse/JRA-60007 h3.Workaround * Update Oracle driver from *12.1.0.1* to *12.1.0.2* version. ** Download *12.1.0.2* from here [Oracle Database 12.1.0.2 JDBC |http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html] ** Delete current driver {{ojdbc7-12.1.0.1.jar}} from <JIRA_INSTALL>/lib/ folder ** Upload new driver to <JIRA_INSTALL>/lib/ folder

    Atlassian JIRA | 8 months ago | Andriy Yakovlev [Atlassian]
    org.ofbiz.core.util.GeneralRuntimeException: Error getting the next result (Protocol violation: [ 46, ])
  2. 0

    h3. Summary JIRA 7 is shipped with Oracle JDBC driver 12.1.0.1.0: {{ojdbc7-12.1.0.1.jar}} Oracle Driver 12.1.0.1 throws error _Protocol violation_ during connection to Database. h3. Environment * JIRA 7.x * Database Oracle 12c Enterprise Edition Release 12.1.0.1.0 or 12.1.0.2 h3. Steps to Reproduce # Setup JIRA and connect it to DB # Add some data (we don't have this specific set of data) # Run reindex h3. Expected Results It works fine. h3. Actual Results The below exception is thrown in the jira.log file: {noformat} 2016-04-13 21:37:52,114 JiraTaskExectionThread-4 ERROR jiraadmins 1271x19429x1 1lemfi1 10.98.60.21 /secure/admin/IndexReIndex.jspa [c.a.j.util.index.CompositeIndexLifecycleManager] Reindex All FAILED. Indexer: DefaultIndexManager: paths: [/jiraindex/infra711/jiraindex/caches/indexes/comments, /jiraindex/infra711/jiraindex/caches/indexes/issues, /jiraindex/infra711/jiraindex/caches/indexes/changes, /jiraindex/infra711/jiraindex/caches/indexes/worklogs, /jiraindex/infra711/jiraindex/caches/indexes/plugins/atlassian-subversion-revisions] org.ofbiz.core.util.GeneralRuntimeException: Error getting the next result (Protocol violation: [ 46, ]) at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:251) at com.atlassian.jira.ofbiz.DefaultOfBizListIterator.next(DefaultOfBizListIterator.java:100) at com.atlassian.jira.ofbiz.WrappingOfBizListIterator.next(WrappingOfBizListIterator.java:68) at com.atlassian.jira.issue.util.DatabaseIssuesIterator.pullNextIssue(DatabaseIssuesIterator.java:97) at com.atlassian.jira.issue.util.DatabaseIssuesIterator.populateNextIssueIfNull(DatabaseIssuesIterator.java:68) at com.atlassian.jira.issue.util.DatabaseIssuesIterator.hasNext(DatabaseIssuesIterator.java:51) at com.atlassian.jira.issue.util.DatabaseIssuesIterable.foreach(DatabaseIssuesIterable.java:55) at com.atlassian.jira.issue.index.DefaultIssueIndexer.perform(DefaultIssueIndexer.java:282) at com.atlassian.jira.issue.index.DefaultIssueIndexer.indexIssuesBatchMode(DefaultIssueIndexer.java:151) at com.atlassian.jira.issue.index.DefaultIndexManager.doIndexIssuesInBatchMode(DefaultIndexManager.java:984) at com.atlassian.jira.issue.index.DefaultIndexManager.doStopTheWorldReindex(DefaultIndexManager.java:961) at com.atlassian.jira.issue.index.DefaultIndexManager.lambda$reIndexAll$0(DefaultIndexManager.java:326) at com.atlassian.jira.issue.index.DefaultIndexManager.withReindexLock(DefaultIndexManager.java:359) at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexAll(DefaultIndexManager.java:326) at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexAll(DefaultIndexManager.java:258) ... Caused by: java.sql.SQLException: Protocol violation: [ 46, ] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:669) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1022) at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:1008) at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:972) at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:572) at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:191) at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:191) at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:245) ... 33 more {noformat} h3. Notes May be related to Oracle Clob bug. See: * https://confluence.atlassian.com/confkb/java-sql-sqlexception-protocol-violation-caught-while-accessing-a-page-and-oracle-db-is-used-781393258.html * https://confluence.atlassian.com/pages/viewpage.action?pageId=780863295 * http://stackoverflow.com/questions/22785120/oracle-clob-reader-issue-protocol-violation * http://stackoverflow.com/questions/4685021/sqlexception-protocol-violation-oracle-jdbc-driver-issue/35343994#35343994 Conflicts with: https://jira.atlassian.com/browse/JRA-60007 h3.Workaround * Update Oracle driver from *12.1.0.1* to *12.1.0.2* version. ** Download *12.1.0.2* from here [Oracle Database 12.1.0.2 JDBC |http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html] ** Delete current driver {{ojdbc7-12.1.0.1.jar}} from <JIRA_INSTALL>/lib/ folder ** Upload new driver to <JIRA_INSTALL>/lib/ folder

    Atlassian JIRA | 8 months ago | Andriy Yakovlev [Atlassian]
    org.ofbiz.core.util.GeneralRuntimeException: Error getting the next result (Protocol violation: [ 46, ])
  3. 0

    h3. Summary When upgrading from JIRA 6.x to JIRA 7.x on Oracle database, there will be inconsistency errors on column type for column {{PARAMETERS}}. The error is affecting the {{clusteredjob}} table which stores cron expression for JIRA 7.0+. In JIRA 6.x, the column type is {{LONG RAW}} while in JIRA 7.x is {{BLOB}} h3. Environment JIRA connected to supported Oracle database h3. Steps to Reproduce # Install JIRA 6.4.12 with Oracle 12c database # Inspect the column type for column "PARAMETERS" of table "clusteredjob" # Upgrade to JIRA 7.0.0 via Rapid Upgrade Method # Check the logs for the error message h3. Expected Results No error for the UpgradeTask h3. Actual Results The following errors can be found in {{catalina.out}}: {noformat} 2015-11-24 17:47:11,692 localhost-startStop-1 INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Driver Name is Oracle JDBC driver 2015-11-24 17:47:11,692 localhost-startStop-1 INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Driver Version is 11.2.0.2.0 2015-11-24 17:47:12,921 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "PARAMETERS" of table "clusteredjob" of entity "ClusteredJob" is of type "LONG RAW" in the database, but is defined as type "BLOB" in the entity definition. {noformat} {noformat} 2015-11-24 17:49:43,216 localhost-startStop-1 ERROR [c.a.j.p.dvcs.scheduler.DvcsScheduler] Unexpected error during launch org.ofbiz.core.util.GeneralRuntimeException: Error creating GenericValue (SQL Exception while getting value: (Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor)) at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:253) at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:49) at com.atlassian.jira.ofbiz.DefaultOfBizListIterator$LookaheadIterator.<init>(DefaultOfBizListIterator.java:228) at com.atlassian.jira.ofbiz.DefaultOfBizListIterator$LookaheadIterator.<init>(DefaultOfBizListIterator.java:220) at com.atlassian.jira.ofbiz.DefaultOfBizListIterator.iterator(DefaultOfBizListIterator.java:212) at com.atlassian.jira.ofbiz.WrappingOfBizListIterator.iterator(WrappingOfBizListIterator.java:146) at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.forEach(SelectQueryImpl.java:245) at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.consumeWith(SelectQueryImpl.java:227) at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.singleValue(SelectQueryImpl.java:199) at com.atlassian.jira.scheduler.OfBizClusteredJobDao.find(OfBizClusteredJobDao.java:93) at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.getJobDetails(CaesiumSchedulerService.java:212) at com.atlassian.scheduler.core.DelegatingSchedulerService.getJobDetails(DelegatingSchedulerService.java:97) at com.atlassian.scheduler.compat.clustered.ClusteredCompatibilityPluginScheduler.getJobInfo(ClusteredCompatibilityPluginScheduler.java:121) at com.atlassian.scheduler.compat.AutoDetectingCompatibilityPluginScheduler.getJobInfo(AutoDetectingCompatibilityPluginScheduler.java:83) at com.atlassian.jira.plugins.dvcs.scheduler.DvcsScheduler.scheduleJob(DvcsScheduler.java:95) at com.atlassian.jira.plugins.dvcs.scheduler.DvcsScheduler.onStart(DvcsScheduler.java:79) at com.atlassian.jira.plugins.dvcs.scheduler.DvcsScheduler$1.run(DvcsScheduler.java:59) at com.atlassian.jira.plugins.dvcs.scheduler.SchedulerLauncher.runSingleJob(SchedulerLauncher.java:144) at com.atlassian.jira.plugins.dvcs.scheduler.SchedulerLauncher.onLifecycleEvent(SchedulerLauncher.java:133) at com.atlassian.jira.plugins.dvcs.scheduler.SchedulerLauncher.onStart(SchedulerLauncher.java:73) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager$4.consume(DefaultLifecycleManager.java:310) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager$4.consume(DefaultLifecycleManager.java:306) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.notifyLifecyleAware(DefaultLifecycleManager.java:344) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.notifyOnStartIfStartedAndEnabled(DefaultLifecycleManager.java:304) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.access$300(DefaultLifecycleManager.java:50) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager$3.evaluate(DefaultLifecycleManager.java:261) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager$3.evaluate(DefaultLifecycleManager.java:257) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.notifyLifecycleAwares(DefaultLifecycleManager.java:286) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.notifyStartableLifecycleAwares(DefaultLifecycleManager.java:255) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.startIfApplicationSetup(DefaultLifecycleManager.java:241) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.start(DefaultLifecycleManager.java:230) at com.atlassian.sal.jira.lifecycle.JiraLifecycleManager.onJiraStart(JiraLifecycleManager.java:68) ... 3 filtered at java.lang.reflect.Method.invoke(Method.java:497) at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:36) at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$1$1.run(AsynchronousAbleEventDispatcher.java:48) at com.google.common.util.concurrent.MoreExecutors$DirectExecutorService.execute(MoreExecutors.java:299) at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:107) at com.atlassian.event.internal.EventPublisherImpl.invokeListeners(EventPublisherImpl.java:160) at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:79) at com.atlassian.plugin.event.impl.DefaultPluginEventManager.broadcast(DefaultPluginEventManager.java:84) at com.atlassian.jira.upgrade.PluginUpgradeLauncher.start(PluginUpgradeLauncher.java:35) at com.atlassian.jira.startup.ActiveServicesLauncher.start(ActiveServicesLauncher.java:57) at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$175(DefaultJiraLauncher.java:140) at com.atlassian.jira.startup.DefaultJiraLauncher$$Lambda$14/681048280.run(Unknown Source) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:356) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:226) at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:126) at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$173(DefaultJiraLauncher.java:92) at com.atlassian.jira.startup.DefaultJiraLauncher$$Lambda$1/105253432.run(Unknown Source) at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:90) at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:84) ... 5 filtered at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while getting value: (Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:706) at org.ofbiz.core.entity.EntityListIterator.currentGenericValue(EntityListIterator.java:169) at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:246) ... 63 more Caused by: java.sql.SQLException: Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor at oracle.jdbc.driver.Accessor.getBLOB(Accessor.java:1270) at oracle.jdbc.driver.OracleResultSetImpl.getBLOB(OracleResultSetImpl.java:1623) at oracle.jdbc.driver.OracleResultSetImpl.getBlob(OracleResultSetImpl.java:585) at org.apache.commons.dbcp.DelegatingResultSet.getBlob(DelegatingResultSet.java:550) at org.apache.commons.dbcp.DelegatingResultSet.getBlob(DelegatingResultSet.java:550) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getBlobAsByteArray(SqlJdbcUtil.java:741) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:701) ... 65 more {noformat} h3.Workaround # Identify the latest XML backup from the {{[$JIRA_HOME|https://confluence.atlassian.com/display/JIRA/JIRA+Home+Directory]/export}} directory # Create a new user as per the [Connecting JIRA to Oracle|https://confluence.atlassian.com/jira/connecting-jira-to-oracle-185729461.html] guide # Install a new JIRA 7.0.0 instance and connect it to the new Oracle user # Import the XML backup

    Atlassian JIRA | 1 year ago | Chung Park Chan [Atlassian]
    org.ofbiz.core.util.GeneralRuntimeException: Error creating GenericValue (SQL Exception while getting value: (Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    h3. Summary When upgrading from JIRA 6.x to JIRA 7.x on Oracle database, there will be inconsistency errors on column type for column {{PARAMETERS}}. The error is affecting the {{clusteredjob}} table which stores cron expression for JIRA 7.0+. In JIRA 6.x, the column type is {{LONG RAW}} while in JIRA 7.x is {{BLOB}} h3. Environment JIRA connected to supported Oracle database h3. Steps to Reproduce # Install JIRA 6.4.12 with Oracle 12c database # Inspect the column type for column "PARAMETERS" of table "clusteredjob" # Upgrade to JIRA 7.0.0 via Rapid Upgrade Method # Check the logs for the error message h3. Expected Results No error for the UpgradeTask h3. Actual Results The following errors can be found in {{catalina.out}}: {noformat} 2015-11-24 17:47:11,692 localhost-startStop-1 INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Driver Name is Oracle JDBC driver 2015-11-24 17:47:11,692 localhost-startStop-1 INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Driver Version is 11.2.0.2.0 2015-11-24 17:47:12,921 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "PARAMETERS" of table "clusteredjob" of entity "ClusteredJob" is of type "LONG RAW" in the database, but is defined as type "BLOB" in the entity definition. {noformat} {noformat} 2015-11-24 17:49:43,216 localhost-startStop-1 ERROR [c.a.j.p.dvcs.scheduler.DvcsScheduler] Unexpected error during launch org.ofbiz.core.util.GeneralRuntimeException: Error creating GenericValue (SQL Exception while getting value: (Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor)) at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:253) at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:49) at com.atlassian.jira.ofbiz.DefaultOfBizListIterator$LookaheadIterator.<init>(DefaultOfBizListIterator.java:228) at com.atlassian.jira.ofbiz.DefaultOfBizListIterator$LookaheadIterator.<init>(DefaultOfBizListIterator.java:220) at com.atlassian.jira.ofbiz.DefaultOfBizListIterator.iterator(DefaultOfBizListIterator.java:212) at com.atlassian.jira.ofbiz.WrappingOfBizListIterator.iterator(WrappingOfBizListIterator.java:146) at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.forEach(SelectQueryImpl.java:245) at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.consumeWith(SelectQueryImpl.java:227) at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.singleValue(SelectQueryImpl.java:199) at com.atlassian.jira.scheduler.OfBizClusteredJobDao.find(OfBizClusteredJobDao.java:93) at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.getJobDetails(CaesiumSchedulerService.java:212) at com.atlassian.scheduler.core.DelegatingSchedulerService.getJobDetails(DelegatingSchedulerService.java:97) at com.atlassian.scheduler.compat.clustered.ClusteredCompatibilityPluginScheduler.getJobInfo(ClusteredCompatibilityPluginScheduler.java:121) at com.atlassian.scheduler.compat.AutoDetectingCompatibilityPluginScheduler.getJobInfo(AutoDetectingCompatibilityPluginScheduler.java:83) at com.atlassian.jira.plugins.dvcs.scheduler.DvcsScheduler.scheduleJob(DvcsScheduler.java:95) at com.atlassian.jira.plugins.dvcs.scheduler.DvcsScheduler.onStart(DvcsScheduler.java:79) at com.atlassian.jira.plugins.dvcs.scheduler.DvcsScheduler$1.run(DvcsScheduler.java:59) at com.atlassian.jira.plugins.dvcs.scheduler.SchedulerLauncher.runSingleJob(SchedulerLauncher.java:144) at com.atlassian.jira.plugins.dvcs.scheduler.SchedulerLauncher.onLifecycleEvent(SchedulerLauncher.java:133) at com.atlassian.jira.plugins.dvcs.scheduler.SchedulerLauncher.onStart(SchedulerLauncher.java:73) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager$4.consume(DefaultLifecycleManager.java:310) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager$4.consume(DefaultLifecycleManager.java:306) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.notifyLifecyleAware(DefaultLifecycleManager.java:344) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.notifyOnStartIfStartedAndEnabled(DefaultLifecycleManager.java:304) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.access$300(DefaultLifecycleManager.java:50) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager$3.evaluate(DefaultLifecycleManager.java:261) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager$3.evaluate(DefaultLifecycleManager.java:257) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.notifyLifecycleAwares(DefaultLifecycleManager.java:286) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.notifyStartableLifecycleAwares(DefaultLifecycleManager.java:255) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.startIfApplicationSetup(DefaultLifecycleManager.java:241) at com.atlassian.sal.core.lifecycle.DefaultLifecycleManager.start(DefaultLifecycleManager.java:230) at com.atlassian.sal.jira.lifecycle.JiraLifecycleManager.onJiraStart(JiraLifecycleManager.java:68) ... 3 filtered at java.lang.reflect.Method.invoke(Method.java:497) at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:36) at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$1$1.run(AsynchronousAbleEventDispatcher.java:48) at com.google.common.util.concurrent.MoreExecutors$DirectExecutorService.execute(MoreExecutors.java:299) at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:107) at com.atlassian.event.internal.EventPublisherImpl.invokeListeners(EventPublisherImpl.java:160) at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:79) at com.atlassian.plugin.event.impl.DefaultPluginEventManager.broadcast(DefaultPluginEventManager.java:84) at com.atlassian.jira.upgrade.PluginUpgradeLauncher.start(PluginUpgradeLauncher.java:35) at com.atlassian.jira.startup.ActiveServicesLauncher.start(ActiveServicesLauncher.java:57) at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$175(DefaultJiraLauncher.java:140) at com.atlassian.jira.startup.DefaultJiraLauncher$$Lambda$14/681048280.run(Unknown Source) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:356) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:226) at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:126) at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$173(DefaultJiraLauncher.java:92) at com.atlassian.jira.startup.DefaultJiraLauncher$$Lambda$1/105253432.run(Unknown Source) at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:90) at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:84) ... 5 filtered at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while getting value: (Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:706) at org.ofbiz.core.entity.EntityListIterator.currentGenericValue(EntityListIterator.java:169) at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:246) ... 63 more Caused by: java.sql.SQLException: Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor at oracle.jdbc.driver.Accessor.getBLOB(Accessor.java:1270) at oracle.jdbc.driver.OracleResultSetImpl.getBLOB(OracleResultSetImpl.java:1623) at oracle.jdbc.driver.OracleResultSetImpl.getBlob(OracleResultSetImpl.java:585) at org.apache.commons.dbcp.DelegatingResultSet.getBlob(DelegatingResultSet.java:550) at org.apache.commons.dbcp.DelegatingResultSet.getBlob(DelegatingResultSet.java:550) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getBlobAsByteArray(SqlJdbcUtil.java:741) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.getValue(SqlJdbcUtil.java:701) ... 65 more {noformat} h3.Workaround # Identify the latest XML backup from the {{[$JIRA_HOME|https://confluence.atlassian.com/display/JIRA/JIRA+Home+Directory]/export}} directory # Create a new user as per the [Connecting JIRA to Oracle|https://confluence.atlassian.com/jira/connecting-jira-to-oracle-185729461.html] guide # Install a new JIRA 7.0.0 instance and connect it to the new Oracle user # Import the XML backup

    Atlassian JIRA | 1 year ago | Chung Park Chan
    org.ofbiz.core.util.GeneralRuntimeException: Error creating GenericValue (SQL Exception while getting value: (Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CLongRawAccessor))
  6. 0

    JIRA - User - Error starting up JIRA 4.1.2

    nabble.com | 9 months ago
    org.ofbiz.core.util.GeneralRuntimeException: Error getting the next result (IO Error: Connection reset)

    Root Cause Analysis

    1. org.ofbiz.core.util.GeneralRuntimeException

      Error getting the next result (Protocol violation: [ 46, ])

      at org.ofbiz.core.entity.EntityListIterator.next()
    2. org.ofbiz.core
      EntityListIterator.next
      1. org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:251)
      1 frame
    3. com.atlassian.jira
      DefaultIndexManager.reIndexAll
      1. com.atlassian.jira.ofbiz.DefaultOfBizListIterator.next(DefaultOfBizListIterator.java:100)
      2. com.atlassian.jira.ofbiz.WrappingOfBizListIterator.next(WrappingOfBizListIterator.java:68)
      3. com.atlassian.jira.issue.util.DatabaseIssuesIterator.pullNextIssue(DatabaseIssuesIterator.java:97)
      4. com.atlassian.jira.issue.util.DatabaseIssuesIterator.populateNextIssueIfNull(DatabaseIssuesIterator.java:68)
      5. com.atlassian.jira.issue.util.DatabaseIssuesIterator.hasNext(DatabaseIssuesIterator.java:51)
      6. com.atlassian.jira.issue.util.DatabaseIssuesIterable.foreach(DatabaseIssuesIterable.java:55)
      7. com.atlassian.jira.issue.index.DefaultIssueIndexer.perform(DefaultIssueIndexer.java:282)
      8. com.atlassian.jira.issue.index.DefaultIssueIndexer.indexIssuesBatchMode(DefaultIssueIndexer.java:151)
      9. com.atlassian.jira.issue.index.DefaultIndexManager.doIndexIssuesInBatchMode(DefaultIndexManager.java:984)
      10. com.atlassian.jira.issue.index.DefaultIndexManager.doStopTheWorldReindex(DefaultIndexManager.java:961)
      11. com.atlassian.jira.issue.index.DefaultIndexManager.lambda$reIndexAll$0(DefaultIndexManager.java:326)
      12. com.atlassian.jira.issue.index.DefaultIndexManager.withReindexLock(DefaultIndexManager.java:359)
      13. com.atlassian.jira.issue.index.DefaultIndexManager.reIndexAll(DefaultIndexManager.java:326)
      14. com.atlassian.jira.issue.index.DefaultIndexManager.reIndexAll(DefaultIndexManager.java:258)
      14 frames