JIRA Issues Macro Does Not Work When Using JIRA as Trusted Application Due to 'org.springframework.dao.IncorrectResultSizeDataAccessException' Skip to End of Metadata
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
THe JIRA Issues Macro does not render results. The following appears in the atlassian-confluence.log:
1
2
3
4
5
6
7
8
9
10
2008-05-18 11:16:14,263 DEBUG [http-8040-Processor22] [sf.hibernate.type.StringType] nullSafeGet returning 'confluence:159392' as column: ALIAS
..
2008-05-18 11:16:14,315 DEBUG [http-8040-Processor22] [sf.hibernate.type.StringType] nullSafeGet returning 'confluence:159392' as column: ALIAS
..
2008-05-18 11:16:14,321 DEBUG [http-8040-Processor22] [sf.hibernate.type.StringType] nullSafeGet returning 'confluence:159392' as column: ALIAS
2008-05-18 11:16:14,324 ERROR [http-8040-Processor22] [renderer.v2.components.MacroRendererComponent] processMacro Unexpected error formatting macro: jiraissues
-- url: /confluence/dwr/exec/WysiwygConverter.convertToPreview.dwr | userName: evgenyz
org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 2, actual 3
at com.atlassian.confluence.security.persistence.dao.hibernate.HibernateKeyStoreDao.getKeyPair(HibernateKeyStoreDao.java:35)
Cause
Confluence is a trusted application for itself, therefore a second public key was created. When using the JIRA Issues macro, 3 keys (instead of 2) are retrieved from the database.
Resolution
Delete one of the public key entries in the KEYSTORE table. Start with a SELECT statement:
1
SELECT * FROM KEYSTORE;
Use a DELETE statement to delete the entry. If you delete too many entries, simply reset the trust in the user interface.
Was this helpful?