Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-933

java.sql.SQLException: Incorrect syntax near '-'. When adding an existent user as agent.

XMLWordPrintable

      Environment:

      JIRA 6.2.7
      Service desk 2.0.2
      MS SQL Server 2008 R2/2012 with the database collation type = SQL_Latin1_General_CP1_CI_AS or SQL_Latin1_General_CP437_CI_AI

      When trying to add an existent user as an agent, JIRA throws the following error:

      Error
There was a SQL exception thrown by the Active Objects library: 
Database: 
- name:Microsoft SQL Server 
- version:10.50.2500 
- minor version:50 
- major version:10 
Driver: 
- name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 
- version:1.2.4 

java.sql.SQLException: Incorrect syntax near '-'.
Please contact the system administrator.

      Although if the page is refreshed the user was successfully added as an agent.

      Tested this on PostgreSQL and that does not occurs.

      Workaround:

        1. Screen Shot 2014-10-09 at 4.43.54 PM.png
          39 kB
          Diego Zarpelon
        2. misleading.PNG
          34 kB
          Julian
        3. collation.PNG
          10 kB
          Julian

            [JSDSERVER-933] java.sql.SQLException: Incorrect syntax near '-'. When adding an existent user as agent.

            Conny Postma made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 128757 ]
            Owen made changes -
            Workflow Original: JSD Bug Workflow v5 - TEMP [ 2304707 ] New: JAC Bug Workflow v3 [ 3125088 ]
            Status Original: Done [ 10044 ] New: Closed [ 6 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 [ 2058632 ] New: JSD Bug Workflow v5 - TEMP [ 2304707 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 - TEMP [ 2056298 ] New: JSD Bug Workflow v5 [ 2058632 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 [ 1955811 ] New: JSD Bug Workflow v5 - TEMP [ 2056298 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v4 [ 1615795 ] New: JSD Bug Workflow v5 [ 1955811 ]
            Confluence Escalation Bot (Inactive) made changes -
            Labels New: affects-server
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v2 [ 1602965 ] New: JSD Bug Workflow v4 [ 1615795 ]
            Marty (Inactive) made changes -
            Component/s New: Atlassian Account [ 35992 ]
            Component/s Original: User Management [ 32692 ]
            Owen made changes -
            Workflow Original: JSD Bug Workflow [ 1398852 ] New: JSD Bug Workflow v2 [ 1602965 ]

              tbuiquang Thong Bui Quang (Inactive)
              dzarpelon Diego Zarpelon (Inactive)
              Affected customers:
              7 This affects my team
              Watchers:
              14 Start watching this issue

                Created:
                Updated:
                Resolved: