Add doc that *no count* setting should not be checked for MS SQL Server

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Fixed
    • 3.6.2
    • Component/s: None
    • None

      Add a doc that the no count setting should not be set for MS SQL Server.

      Further details on this setting are available at:

      http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_3ed0.asp

      This setting will result in errors where JIRA attempts to retrieve the next sequential ID based on the value returned from executed statements. The doc should include screenshots as how to unset this setting following these instructions:

      This can be verified by clicking on the server from within the SQL Server Management screen. From here, please select the Connections option and verify
      that the no count setting is not checked within the Default connection options section.

      The following stacktrace relates to this issue and should be referenced in the doc:

      2006-05-03 15:51:24,331 INFO [atlassian.jira.upgrade.ConsistencyCheckImpl] Could not find Issue Cache Listener, adding.
      
      2006-05-03 15:51:26,088 WARN [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] first select failed: trying to add row, result set was 
      empty for sequence: ListenerConfig
      
      2006-05-03 15:51:26,093 WARN [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.fillBank] first select failed: trying to add row, result set was empty for sequence: ListenerConfig
      
      2006-05-03 15:51:26,094 ERROR [ofbiz.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null
      
      2006-05-03 15:51:26,112 ERROR [atlassian.jira.upgrade.ConsistencyCheckImpl] Error adding listener: org.ofbiz.core.entity.GenericEntityException: while 
      inserting: [GenericEntity:ListenerConfig][clazz,com.atlassian.jira.event.listeners.cache.IssueCacheListener][name,Issue Cache Listener][id,null] (SQL 
      exception while executing the following:INSERT INTO listenerconfig (ID, CLAZZ, listenername) VALUES (?, ?, ?) (Cannot insert the value NULL into column 
      'ID', table 'Jira36Test.JiraUser.listenerconfig'; column does not allow nulls. INSERT fails.))
      
      org.ofbiz.core.entity.GenericEntityException: while inserting: 
      [GenericEntity:ListenerConfig][clazz,com.atlassian.jira.event.listeners.cache.IssueCacheListener][name,Issue Cache Listener][id,null] (SQL Exception while 
      executing the following:INSERT INTO listenerconfig (ID, CLAZZ, listenername) VALUES (?, ?, ?) (Cannot insert the value NULL into column 'ID', table 'Jira36Test.JiraUser.listenerconfig'; column does not allow nulls. INSERT fails.))
      
          at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:123)
          at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
          at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
          at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470)
          at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450)
          at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77)
          at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61)
          at com.atlassian.jira.action.admin.ListenerCreate.execute(ListenerCreate.java:22)
          at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
          at com.atlassian.core.action.DefaultActionDispatcher.execute(DefaultActionDispatcher.java:34)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.ensureSingleListener(ConsistencyCheckImpl.java:669)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkCacheListener(ConsistencyCheckImpl.java:563)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkDataConsistency(ConsistencyCheckImpl.java:306)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkConsistency(ConsistencyCheckImpl.java:295)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.initialise(ConsistencyCheckImpl.java:164)
          at com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher.java:27)
          at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)
          at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)
          at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
          at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
          at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
          at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:603)
          at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:493)
          at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1195)
          at sun.reflect.GeneratedMethodAccessor341.invoke(Unknown Source)
       
      org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO listenerconfig (ID, CLAZZ, listenername) 
      VALUES (?, ?, ?) (Cannot insert the value NULL into column 'ID', table 'Jira36Test.JiraUser.listenerconfig'; column does not allow nulls. INSERT fails.)
          at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:375)
          at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:115)
          at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
          at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
          at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470)
          at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450)
          at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77)
          at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61)
          at com.atlassian.jira.action.admin.ListenerCreate.execute(ListenerCreate.java:22)
          at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
          at com.atlassian.core.action.DefaultActionDispatcher.execute(DefaultActionDispatcher.java:34)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.ensureSingleListener(ConsistencyCheckImpl.java:669)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkCacheListener(ConsistencyCheckImpl.java:563)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkDataConsistency(ConsistencyCheckImpl.java:306)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkConsistency(ConsistencyCheckImpl.java:295)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.initialise(ConsistencyCheckImpl.java:164)
          at com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher.java:27)
          at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)
         at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)
          at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
          at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
          at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
          at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:603)
          at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:493)
          at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1195)
          at sun.reflect.GeneratedMethodAccessor341.invoke(Unknown Source)
      
      java.sql.SQLException: Cannot insert the value NULL into column 'ID', table 'Jira36Test.JiraUser.listenerconfig'; column does not allow nulls. INSERT fails.
          at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
          at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
          at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
          at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
          at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
          at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
          at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
          at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
          at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:373)
          at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:115)
          at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
          at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
          at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470)
          at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450)
          at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77)
          at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61)
          at com.atlassian.jira.action.admin.ListenerCreate.execute(ListenerCreate.java:22)
          at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
          at com.atlassian.core.action.DefaultActionDispatcher.execute(DefaultActionDispatcher.java:34)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.ensureSingleListener(ConsistencyCheckImpl.java:669)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkCacheListener(ConsistencyCheckImpl.java:563)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkDataConsistency(ConsistencyCheckImpl.java:306)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.checkConsistency(ConsistencyCheckImpl.java:295)
          at com.atlassian.jira.upgrade.ConsistencyCheckImpl.initialise(ConsistencyCheckImpl.java:164)
          at com.atlassian.jira.upgrade.ConsistencyLauncher.contextInitialized(ConsistencyLauncher.java:27)
          at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)
          at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)
          at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
          at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
          at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
          at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:603)
          at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:493)
          at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1195)
          at sun.reflect.GeneratedMethodAccessor341.invoke(Unknown Source)
      

              Assignee:
              Unassigned
              Reporter:
              Keith Brophy
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1.5h
                  1.5h