Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-41617

Adding multiple users to username field in a Global Filter for Activity Streams throws 'parameter index out of range'

    XMLWordPrintable

Details

    Description

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      Summary

      When configuring Global Filters for Activity Streams, the username textbox is a free text field. Adding more than one user separated by commas causes a SQL Exception in the logs.

      Steps to Reproduce

      1. Add an Activity Stream to a Dashboard
      2. Add a Global filter with the configuration below:
        • Username is/is not [*user1, user2*]

      Obs: The usernames may be valid or invalid ones and the exception still happens.

      Expected Results

      No exception in the logs.

      Actual Results

      The following exception is thrown in the atlassian-jira.log file:
      MySQL:

      2015-01-14 15:58:09,739 StreamsCompletionService::thread-21 ERROR user 958x1381x1 158u8c6 10.60.4.135 /plugins/servlet/streams [atlassian.streams.internal.LocalActivityProvider] Exception building feed
      com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
      Database:
      	- name:MySQL
      	- version:5.6.21-log
      	- minor version:6
      	- major version:5
      Driver:
      	- name:MySQL Connector Java
      	- version:mysql-connector-java-5.1.26 ( Revision: ${bzr.revision-id} )
      
      java.sql.SQLException: Parameter index out of range (51 > number of parameters, which is 50).
      	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:179)
      	at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.find(DelegatingActiveObjects.java:93)  <+2>
      

      PostgreSQL

      2015-10-21 15:59:30,806 StreamsCompletionService::thread-1993 ERROR user 959x74842x1 17b6pej 192.168.10.137 /plugins/servlet/streams [atlassian.streams.internal.LocalActivityProvider] Exception building feed
      com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
      Database:
              - name:PostgreSQL
              - version:9.4.0
              - minor version:4
              - major version:9
      Driver:
              - name:PostgreSQL Native Driver
              - version:PostgreSQL 9.0 JDBC4 (build 801)
      org.postgresql.util.PSQLException: The column index is out of range: 65, number of columns: 64.
              at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:185)
              at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:335)  <+2> (DelegatingMethodAccessorImpl.java:43)
      

      PostgreSQL (JIRA 7)

      2015-10-21 16:00:59,187 StreamsCompletionService::thread-98 ERROR user 960x4399x1 az6hzx 192.168.10.174 /plugins/servlet/streams [c.a.streams.internal.LocalActivityProvider] Exception building feed
      com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
      Database:
      	- name:PostgreSQL
      	- version:9.4.0
      	- minor version:4
      	- major version:9
      Driver:
      	- name:PostgreSQL Native Driver
      	- version:PostgreSQL 9.0 JDBC4 (build 801)
      org.postgresql.util.PSQLException: The column index is out of range: 14, number of columns: 13.
      	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:136)
      	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:291)
      

      MSSQL:

      2018-01-22 20:34:23,563 StreamsCompletionService::thread-2873 ERROR user 1234x612273x2 tk2oxy 172.25.5.228 /plugins/servlet/streams [c.a.streams.internal.LocalActivityProvider] Exception building feed
      com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
      Database:
      	- name:Microsoft SQL Server
      	- version:11.00.5058
      	- minor version:0
      	- major version:11
      Driver:
      	- name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
      	- version:1.3.1
      java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.
      	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:142)
      	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:296)

      Oracle:

      2018-01-29 12:29:56,983 StreamsCompletionService::thread-3319 ERROR user 749x698817x6 1a3866b 139.149.61.99 /plugins/servlet/streams [c.a.streams.internal.LocalActivityProvider] Exception building feed
      com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
      Database:
      	- name:Oracle
      	- version:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
      With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
      Data Mining and Real Application Testing options
      	- minor version:2
      	- major version:11
      Driver:
      	- name:Oracle JDBC driver
      	- version:11.2.0.2.0
      java.sql.SQLException: Invalid column index
      	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:142)
      	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:296)
      

      Notes

      Although the exception is written to the logs, the Activity Stream applies the global filter correctly.

      Workaround

      Important: This workaround might prevent troubleshooting real problems with the Activity Stream, since any errors will be suppressed.

      Set the logging level for the package below to OFF:

      • com.atlassian.streams.internal.LocalActivityProvider

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jrahmadiputra Julian (Inactive)
              Votes:
              76 Vote for this issue
              Watchers:
              108 Start watching this issue

              Dates

                Created:
                Updated: