Details
-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
6.3.15, 6.4.12, Archived Jira Cloud, 7.0.0, 7.6.15, 8.5.6, 7.13.18, 8.5.11, 8.20.6, 8.20.10, 8.20.14
-
6.03
-
155
-
Severity 3 - Minor
-
22
-
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
- Add an Activity Stream to a Dashboard
- 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
- relates to
-
JRACLOUD-41617 SQL Exception on Activity Stream when Using Global Filters for Multiple Usernames
- Closed
- cloned by
-
AO-631 Loading...
- is duplicated by
-
DELTA-1120 Loading...