com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, positionseq, GADGET_XML, COLOR FROM dbo.portletconfiguration WHERE (GADGET_XML = ? ) (The data types ntext and nvarchar are incompatible in the equal to operator.)

Atlassian JIRA | Taiwo Akindele [Atlassian] | 3 years ago
  1. 0

    *Steps to reproduce* * Setup a JIRA installation with SQL server as the database * Install the Wallboard plugin (current version is v.1.8.4) *Results* * The wallboard plugin is installed successfully as expected * The wallboard plugin appears to be functional as expected * The following errors are thrown in the logs on installing the plugin, and during subsequent JIRA restarts {code} 2014-05-29 23:41:23,246 localhost-startStop-1 ERROR [sal.core.upgrade.DefaultPluginUpgradeManager] Upgrade error: Unexpected exception caught during plugin upgrade: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, positionseq, GADGET_XML, COLOR FROM dbo.portletconfiguration WHERE (GADGET_XML = ? ) (The data types ntext and nvarchar are incompatible in the equal to operator.) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:499) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findListIteratorByCondition(WrappingOfBizDelegator.java:336) {code} *Workaround* No workaround needed. For the instances on which this upgrade task fails, it actually does nothing. So, if you are unable to launch a dashboard after your recent JIRA upgrade it must be due to an unrelated issue.

    Atlassian JIRA | 3 years ago | Taiwo Akindele [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, positionseq, GADGET_XML, COLOR FROM dbo.portletconfiguration WHERE (GADGET_XML = ? ) (The data types ntext and nvarchar are incompatible in the equal to operator.)
  2. 0

    *Steps to reproduce* * Setup a JIRA installation with SQL server as the database * Install the Wallboard plugin (current version is v.1.8.4) *Results* * The wallboard plugin is installed successfully as expected * The wallboard plugin appears to be functional as expected * The following errors are thrown in the logs on installing the plugin, and during subsequent JIRA restarts {code} 2014-05-29 23:41:23,246 localhost-startStop-1 ERROR [sal.core.upgrade.DefaultPluginUpgradeManager] Upgrade error: Unexpected exception caught during plugin upgrade: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, positionseq, GADGET_XML, COLOR FROM dbo.portletconfiguration WHERE (GADGET_XML = ? ) (The data types ntext and nvarchar are incompatible in the equal to operator.) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:499) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findListIteratorByCondition(WrappingOfBizDelegator.java:336) {code} *Workaround* No workaround needed. For the instances on which this upgrade task fails, it actually does nothing. So, if you are unable to launch a dashboard after your recent JIRA upgrade it must be due to an unrelated issue.

    Atlassian JIRA | 3 years ago | Taiwo Akindele [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, positionseq, GADGET_XML, COLOR FROM dbo.portletconfiguration WHERE (GADGET_XML = ? ) (The data types ntext and nvarchar are incompatible in the equal to operator.)
  3. 0

    {noformat} 2010-05-04 01:49:24,618 main INFO [jira.upgrade.tasks.UpgradeTask_Build552] Converting search requests to use the new labels system field is 100% complete. 2010-05-04 01:49:24,618 main INFO [jira.upgrade.tasks.UpgradeTask_Build552] Updating saved filters to use the new labels system field...DONE 2010-05-04 01:49:24,618 main INFO [jira.upgrade.tasks.UpgradeTask_Build552] Updating label gadgets use the new labels system field... 2010-05-04 01:49:24,717 main ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception whi le executing the following:SELECT ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have a n error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPRE FKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have an error in your SQL syntax; check the manual that corresponds to yo ur MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:188) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:175) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build552.updateGadgetConfigurations(UpgradeTask_Build552.java:190) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build552.doUpgrade(UpgradeTask_Build552.java:151) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:562) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:466) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:402) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:353) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:292) at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:100) at com.atlassian.jira.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE FROM gadgetuserpref erence WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right s yntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:596) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1076) at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:919) at org.ofbiz.core.entity.GenericHelperDAO.findByCondition(GenericHelperDAO.java:162) at org.ofbiz.core.entity.GenericDelegator.findByCondition(GenericDelegator.java:960) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:183) ... 25 more {noformat}

    Atlassian JIRA | 7 years ago | George Barnett
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPRE FKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have an error in your SQL syntax; check the manual that corresponds to yo ur MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When exporting the audit log, the export file is empty. The prompt will give you a number of entries that will be exported (truncated to the 100,000 newest events), yet when you open the export file, it is empty. I have attached the audit log zip file. *Edit with root cause:* In tomcat logs there are following exceptions: {code} SEVERE: Servlet.service() for servlet default threw exception com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, LOG_ID, OBJECT_TYPE, OBJECT_ID, OBJECT_NAME, OBJECT_PARENT_ID, OBJECT_PARENT_NAME FROM jiraschema.audit_item WHERE (LOG_ID IN [...] (Prepared or callable statement has more than 2000 parameter markers.) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:534) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findListIteratorByCondition(WrappingOfBizDelegator.java:349) at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.consumeWith(SelectQueryImpl.java:234) at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.visitWith(SelectQueryImpl.java:253) at com.atlassian.jira.auditing.AuditingStoreImpl.getItems(AuditingStoreImpl.java:293) at com.atlassian.jira.auditing.AuditingStoreImpl.getAuditRecords(AuditingStoreImpl.java:249) at com.atlassian.jira.auditing.AuditingStoreImpl.getRecords(AuditingStoreImpl.java:195) at com.atlassian.jira.auditing.AuditingManagerImpl.getRecords(AuditingManagerImpl.java:108) at com.atlassian.jira.auditing.AuditingManagerImpl.getRecords(AuditingManagerImpl.java:82) at sun.reflect.GeneratedMethodAccessor2802.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) at com.sun.proxy.$Proxy296.getRecords(Unknown Source) at sun.reflect.GeneratedMethodAccessor2802.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) [...] {code} This is reproducible only with MSSQL when exporting more than 2000 records, because MSSQL allows only for 2000 placeholder values in prepared statements. Also it affects Audit Log only in JIRA 6.3.5 and above since from that point there is an optimization introduced that results in prepare statements with long lists of place holders.

    Atlassian JIRA | 2 years ago | Chris Solgat
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, LOG_ID, OBJECT_TYPE, OBJECT_ID, OBJECT_NAME, OBJECT_PARENT_ID, OBJECT_PARENT_NAME FROM jiraschema.audit_item WHERE (LOG_ID IN [...] (Prepared or callable statement has more than 2000 parameter markers.)
  6. 0

    {noformat} 2010-05-04 01:49:24,618 main INFO [jira.upgrade.tasks.UpgradeTask_Build552] Converting search requests to use the new labels system field is 100% complete. 2010-05-04 01:49:24,618 main INFO [jira.upgrade.tasks.UpgradeTask_Build552] Updating saved filters to use the new labels system field...DONE 2010-05-04 01:49:24,618 main INFO [jira.upgrade.tasks.UpgradeTask_Build552] Updating label gadgets use the new labels system field... 2010-05-04 01:49:24,717 main ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception whi le executing the following:SELECT ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have a n error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPRE FKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have an error in your SQL syntax; check the manual that corresponds to yo ur MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:188) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:175) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build552.updateGadgetConfigurations(UpgradeTask_Build552.java:190) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build552.doUpgrade(UpgradeTask_Build552.java:151) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:562) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:466) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:402) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:353) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:292) at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:100) at com.atlassian.jira.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE FROM gadgetuserpref erence WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right s yntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:596) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1076) at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:919) at org.ofbiz.core.entity.GenericHelperDAO.findByCondition(GenericHelperDAO.java:162) at org.ofbiz.core.entity.GenericDelegator.findByCondition(GenericDelegator.java:960) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:183) ... 25 more {noformat}

    Atlassian JIRA | 7 years ago | George Barnett
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPRE FKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY = ? ) (You have an error in your SQL syntax; check the manual that corresponds to yo ur MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY = 'fieldId' )' at line 1)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.atlassian.jira.exception.DataAccessException

      org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, positionseq, GADGET_XML, COLOR FROM dbo.portletconfiguration WHERE (GADGET_XML = ? ) (The data types ntext and nvarchar are incompatible in the equal to operator.)

      at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition()
    2. com.atlassian.jira
      WrappingOfBizDelegator.findListIteratorByCondition
      1. com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:499)
      2. com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findListIteratorByCondition(WrappingOfBizDelegator.java:336)
      2 frames