-
Type:
Bug
-
Resolution: Handled by Support
-
Priority:
Medium
-
None
-
Affects Version/s: 3.11
-
Component/s: None
-
Environment:
System Info
System Date Thursday, 22 Nov 2007
System Time 11:44:31
Current Working Directory C:\WINDOWS\system32
Java Version 1.6.0
Java Vendor Sun Microsystems Inc.
JVM Version 1.0
JVM Vendor Sun Microsystems Inc.
JVM Implementation Version 1.6.0-b105
Java Runtime Java(TM) SE Runtime Environment
Java VM Java HotSpot(TM) Client VM
User Name SYSTEM
User Timezone Europe/London
User Locale English (Ireland)
System Encoding Cp1252
Operating System Windows 2003 5.2
OS Architecture x86
Application Server Container Apache Tomcat/5.5.20
Database type mssql
Database JNDI address java:comp/env/jdbc/JiraDS
Database URL jdbc:jtds:sqlserver://harptwo.curamsoftware.com:1433/Jira4
Database version 08.00.2039
Database driver jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.2
External user management OFFJava VM Memory Statistics
Total Memory 155 MB
Free Memory 85 MB
Used Memory 70 MB
Memory Graph55 % Free (Force garbage collection)
JIRA Info
Uptime 18 hours, 14 minutes, 17 seconds
Edition Enterprise
Version 3.11
Build Number 288
Atlassian Partner
Installation Type Standalone
Server ID XXXXXXXXXXXXXXXX
Installed languages Chinese (China)
Chinese (Taiwan)
Czech (Czech Republic)
Danish (Denmark)
English (UK)
French (France)
German (Germany)
German (Switzerland)
Hungarian (Hungary)
Italian (Italy)
Norwegian (Norway)
Polish (Poland)
Portuguese (Brazil)
Russian (Russia)
Slovak (Slovakia)
Spanish (Spain)
Turkish (Turkey)
Default language English (Ireland) - System DefaultDatabase Statistics
Issues 1777
Projects 18
Custom Fields 41
Workflows 23
Users 414
Groups 22File Paths
Location of entityengine.xml file:/C:/Program%20Files/JIRA-Enterprise-3.11/atlassian-jira/WEB-INF/classes/entityengine.xml
Location of atlassian-jira.log C:\WINDOWS\system32\atlassian-jira.log
Location of indexes C:\Program Files\JIRA-Enterprise-3.11\JIRA INDEXES
Listeners
Issue Cache Listener
com.atlassian.jira.event.listeners.cache.IssueCacheListener
Issue Index Listener
com.atlassian.jira.event.listeners.search.IssueIndexListener
Mail Listener
com.atlassian.jira.event.listeners.mail.MailListener
ParamPrinter
com.atlassian.jira.event.listeners.DebugParamListenerServices
Mail Queue Service
com.atlassian.jira.service.services.mail.MailQueueService
Delay: 1 minutesPlugins
Admin Menu Sections - 1.0
Plugin by Atlassian Software Systems
Enabled
Browse Project Operations Sections - 1.0
Plugin by Atlassian Software Systems
Enabled
Custom Field Types & Searchers - 1.0
Plugin by Atlassian Software Systems
Enabled
Date Accepted Setter - 1.0
Plugin by Curam Software
Enabled
Issue Operations Plugin - 1.0
Plugin by Atlassian Software Systems
Enabled
Issue Tab Panels Plugin - 1.0
Plugin by Atlassian Software Systems
Enabled
Issue Views Plugin - 1.0
Plugin by Atlassian Software Systems
Enabled
Portlets Plugin - 1.0
Plugin by Atlassian Software Systems
Enabled
Preset Filters Sections - 1.0
Plugin by Atlassian Software Systems
Enabled
Project Panels Plugin - 1.0
Plugin by Atlassian Software Systems
Enabled
Project Role Actors Plugin - 1.0
Plugin by Atlassian Software Systems
Enabled
RPC JIRA Plugin - 3.11
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Renderer Plugin - 1.0
Plugin by Atlassian Software Systems
Enabled
Reports Plugin - 1.0
Plugin by Atlassian Software Systems
Enabled
Team Lead Assigner - 1.0
Plugin by Curam Software
Enabled
Test Lead Assigner - 1.0
Plugin by Curam Software
Enabled
Top Navigation Bar Sections - 1.0
Plugin by Atlassian Software Systems
Enabled
User Navigation Bar Sections - 1.0
Plugin by Atlassian Software Systems
Enabled
View Project Operations Sections - 1.0
Plugin by Atlassian Software Systems
Enabled
Web Resources Plugin - 1.0
Plugin by Atlassian Software Systems Pty Ltd
Enabled
Webwork Plugin - 1.0
Plugin by Atlassian Software Systems
Enabled
Wiki Renderer Macros Plugin - 1.0
Plugin by Atlassian Software Systems
Enabled
Workflow Plugin - 1.0
Plugin by Atlassian Software Systems
EnabledSystem Properties
shared.loader ${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar
java.vm.vendor Sun Microsystems Inc.
java.vendor.url http://java.sun.com/
path.separator ;
tomcat.util.buf.StringCache.byte.enabled true
file.encoding.pkg sun.io
user.country IE
sun.os.patch.level Service Pack 2
java.vm.specification.name Java Virtual Machine Specification
atlassian.profile.activate false
java.runtime.version 1.6.0-b105
java.awt.graphicsenv sun.awt.Win32GraphicsEnvironment
java.endorsed.dirs C:\Program Files\JIRA-Enterprise-3.11\common\endorsed
java.io.tmpdir C:\Program Files\JIRA-Enterprise-3.11\temp
line.separator
user.variant
java.naming.factory.url.pkgs org.apache.naming
sun.jnu.encoding Cp1252
java.specification.name Java Platform API Specification
java.class.version 50.0
sun.management.compiler HotSpot Client Compiler
user.home C:\Documents and Settings\Default User
catalina.useNaming true
java.awt.printerjob sun.awt.windows.WPrinterJob
java.specification.version 1.6
catalina.home C:\Program Files\JIRA-Enterprise-3.11
java.naming.factory.initial org.apache.naming.java.javaURLContextFactory
package.definition sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.
sun.arch.data.model 32
java.home C:\Program Files\JIRA-Enterprise-3.11\jre
java.specification.vendor Sun Microsystems Inc.
user.language en
awt.toolkit sun.awt.windows.WToolkit
java.vm.info mixed mode
java.ext.dirs C:\Program Files\JIRA-Enterprise-3.11\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext
server.loader ${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar
catalina.base C:\Program Files\JIRA-Enterprise-3.11
file.separator \
java.vendor.url.bug http://java.sun.com/cgi-bin/bugreport.cgi
common.loader ${catalina.home}/common/classes,${catalina.home}/common/i18n/.jar,${catalina.home}/common/endorsed/.jar,${catalina.home}/common/lib/*.jar
sun.cpu.endian little
sun.io.unicode.encoding UnicodeLittle
package.access sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.,sun.beans.
sun.desktop windows
sun.cpu.isalist
sun.boot.library.path C:\Program Files\JIRA-Enterprise-3.11\jre\bin
java.library.path C:\Program Files\JIRA-Enterprise-3.11\bin;
.;
C:\WINDOWS\Sun\Java\bin;
C:\WINDOWS\system32;
C:\WINDOWS;
C:\Borland\CaliberRMServer\Bin;
C:\Borland\CaliberRMServer\Versant\6_0_5\NT\Bin;
C:\Borland\CaliberRMServer\Lib;
C:\WINDOWS\system32;
C:\WINDOWS;
C:\WINDOWS\System32\Wbem;
C:\Program Files\Rational\common;
C:\Program Files\Dell\SysMgt\oma\bin
java.class.path C:\Program Files\JIRA-Enterprise-3.11\bin\bootstrap.jar
sun.boot.class.path C:\Program Files\JIRA-Enterprise-3.11\common\endorsed\xercesImpl.jar;
C:\Program Files\JIRA-Enterprise-3.11\common\endorsed\xml-apis.jar;
C:\Program Files\JIRA-Enterprise-3.11\jre\lib\resources.jar;
C:\Program Files\JIRA-Enterprise-3.11\jre\lib\rt.jar;
C:\Program Files\JIRA-Enterprise-3.11\jre\lib\sunrsasign.jar;
C:\Program Files\JIRA-Enterprise-3.11\jre\lib\jsse.jar;
C:\Program Files\JIRA-Enterprise-3.11\jre\lib\jce.jar;
C:\Program Files\JIRA-Enterprise-3.11\jre\lib\charsets.jar;
C:\Program Files\JIRA-Enterprise-3.11\jre\classesSystem Info System Date Thursday, 22 Nov 2007 System Time 11:44:31 Current Working Directory C:\WINDOWS\system32 Java Version 1.6.0 Java Vendor Sun Microsystems Inc. JVM Version 1.0 JVM Vendor Sun Microsystems Inc. JVM Implementation Version 1.6.0-b105 Java Runtime Java(TM) SE Runtime Environment Java VM Java HotSpot(TM) Client VM User Name SYSTEM User Timezone Europe/London User Locale English (Ireland) System Encoding Cp1252 Operating System Windows 2003 5.2 OS Architecture x86 Application Server Container Apache Tomcat/5.5.20 Database type mssql Database JNDI address java:comp/env/jdbc/JiraDS Database URL jdbc:jtds:sqlserver://harptwo.curamsoftware.com:1433/Jira4 Database version 08.00.2039 Database driver jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.2 External user management OFF Java VM Memory Statistics Total Memory 155 MB Free Memory 85 MB Used Memory 70 MB Memory Graph 55 % Free (Force garbage collection) JIRA Info Uptime 18 hours, 14 minutes, 17 seconds Edition Enterprise Version 3.11 Build Number 288 Atlassian Partner Installation Type Standalone Server ID XXXXXXXXXXXXXXXX Installed languages Chinese (China) Chinese (Taiwan) Czech (Czech Republic) Danish (Denmark) English (UK) French (France) German (Germany) German (Switzerland) Hungarian (Hungary) Italian (Italy) Norwegian (Norway) Polish (Poland) Portuguese (Brazil) Russian (Russia) Slovak (Slovakia) Spanish (Spain) Turkish (Turkey) Default language English (Ireland) - System Default Database Statistics Issues 1777 Projects 18 Custom Fields 41 Workflows 23 Users 414 Groups 22 File Paths Location of entityengine.xml file:/C:/Program%20Files/JIRA-Enterprise-3.11/atlassian-jira/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log C:\WINDOWS\system32\atlassian-jira.log Location of indexes C:\Program Files\JIRA-Enterprise-3.11\JIRA INDEXES Listeners Issue Cache Listener com.atlassian.jira.event.listeners.cache.IssueCacheListener Issue Index Listener com.atlassian.jira.event.listeners.search.IssueIndexListener Mail Listener com.atlassian.jira.event.listeners.mail.MailListener ParamPrinter com.atlassian.jira.event.listeners.DebugParamListener Services Mail Queue Service com.atlassian.jira.service.services.mail.MailQueueService Delay: 1 minutes Plugins Admin Menu Sections - 1.0 Plugin by Atlassian Software Systems Enabled Browse Project Operations Sections - 1.0 Plugin by Atlassian Software Systems Enabled Custom Field Types & Searchers - 1.0 Plugin by Atlassian Software Systems Enabled Date Accepted Setter - 1.0 Plugin by Curam Software Enabled Issue Operations Plugin - 1.0 Plugin by Atlassian Software Systems Enabled Issue Tab Panels Plugin - 1.0 Plugin by Atlassian Software Systems Enabled Issue Views Plugin - 1.0 Plugin by Atlassian Software Systems Enabled Portlets Plugin - 1.0 Plugin by Atlassian Software Systems Enabled Preset Filters Sections - 1.0 Plugin by Atlassian Software Systems Enabled Project Panels Plugin - 1.0 Plugin by Atlassian Software Systems Enabled Project Role Actors Plugin - 1.0 Plugin by Atlassian Software Systems Enabled RPC JIRA Plugin - 3.11 Plugin by Atlassian Software Systems Pty Ltd Enabled Renderer Plugin - 1.0 Plugin by Atlassian Software Systems Enabled Reports Plugin - 1.0 Plugin by Atlassian Software Systems Enabled Team Lead Assigner - 1.0 Plugin by Curam Software Enabled Test Lead Assigner - 1.0 Plugin by Curam Software Enabled Top Navigation Bar Sections - 1.0 Plugin by Atlassian Software Systems Enabled User Navigation Bar Sections - 1.0 Plugin by Atlassian Software Systems Enabled View Project Operations Sections - 1.0 Plugin by Atlassian Software Systems Enabled Web Resources Plugin - 1.0 Plugin by Atlassian Software Systems Pty Ltd Enabled Webwork Plugin - 1.0 Plugin by Atlassian Software Systems Enabled Wiki Renderer Macros Plugin - 1.0 Plugin by Atlassian Software Systems Enabled Workflow Plugin - 1.0 Plugin by Atlassian Software Systems Enabled System Properties shared.loader ${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar java.vm.vendor Sun Microsystems Inc. java.vendor.url http://java.sun.com/ path.separator ; tomcat.util.buf.StringCache.byte.enabled true file.encoding.pkg sun.io user.country IE sun.os.patch.level Service Pack 2 java.vm.specification.name Java Virtual Machine Specification atlassian.profile.activate false java.runtime.version 1.6.0-b105 java.awt.graphicsenv sun.awt.Win32GraphicsEnvironment java.endorsed.dirs C:\Program Files\JIRA-Enterprise-3.11\common\endorsed java.io.tmpdir C:\Program Files\JIRA-Enterprise-3.11\temp line.separator user.variant java.naming.factory.url.pkgs org.apache.naming sun.jnu.encoding Cp1252 java.specification.name Java Platform API Specification java.class.version 50.0 sun.management.compiler HotSpot Client Compiler user.home C:\Documents and Settings\Default User catalina.useNaming true java.awt.printerjob sun.awt.windows.WPrinterJob java.specification.version 1.6 catalina.home C:\Program Files\JIRA-Enterprise-3.11 java.naming.factory.initial org.apache.naming.java.javaURLContextFactory package.definition sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper. sun.arch.data.model 32 java.home C:\Program Files\JIRA-Enterprise-3.11\jre java.specification.vendor Sun Microsystems Inc. user.language en awt.toolkit sun.awt.windows.WToolkit java.vm.info mixed mode java.ext.dirs C:\Program Files\JIRA-Enterprise-3.11\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext server.loader ${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar catalina.base C:\Program Files\JIRA-Enterprise-3.11 file.separator \ java.vendor.url.bug http://java.sun.com/cgi-bin/bugreport.cgi common.loader ${catalina.home}/common/classes,${catalina.home}/common/i18n/ .jar,${catalina.home}/common/endorsed/ .jar,${catalina.home}/common/lib/*.jar sun.cpu.endian little sun.io.unicode.encoding UnicodeLittle package.access sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.,sun.beans. sun.desktop windows sun.cpu.isalist sun.boot.library.path C:\Program Files\JIRA-Enterprise-3.11\jre\bin java.library.path C:\Program Files\JIRA-Enterprise-3.11\bin; .; C:\WINDOWS\Sun\Java\bin; C:\WINDOWS\system32; C:\WINDOWS; C:\Borland\CaliberRMServer\Bin; C:\Borland\CaliberRMServer\Versant\6_0_5\NT\Bin; C:\Borland\CaliberRMServer\Lib; C:\WINDOWS\system32; C:\WINDOWS; C:\WINDOWS\System32\Wbem; C:\Program Files\Rational\common; C:\Program Files\Dell\SysMgt\oma\bin java.class.path C:\Program Files\JIRA-Enterprise-3.11\bin\bootstrap.jar sun.boot.class.path C:\Program Files\JIRA-Enterprise-3.11\common\endorsed\xercesImpl.jar; C:\Program Files\JIRA-Enterprise-3.11\common\endorsed\xml-apis.jar; C:\Program Files\JIRA-Enterprise-3.11\jre\lib\resources.jar; C:\Program Files\JIRA-Enterprise-3.11\jre\lib\rt.jar; C:\Program Files\JIRA-Enterprise-3.11\jre\lib\sunrsasign.jar; C:\Program Files\JIRA-Enterprise-3.11\jre\lib\jsse.jar; C:\Program Files\JIRA-Enterprise-3.11\jre\lib\jce.jar; C:\Program Files\JIRA-Enterprise-3.11\jre\lib\charsets.jar; C:\Program Files\JIRA-Enterprise-3.11\jre\classes
-
3.11
Hi,
I have recently upgraded from Jira 3.6.2 to 3.11 Enterprise edition (Standalone).
A new DB was created with appropriate user permissions etc.
I backed up the the issues (XML).
I backed up Custom plugins and JTDS.
Edited server.xml and entityengine.xml.
I have the instance of JIRA working fine except when a user tries to create an issue in one particular project, and enters data in one custom field we get:
Errors
- org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][id,16668][datevalue,2007-11-14 00:00:00.0][issue,12298][parentkey,null][customfield,10002] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Violation of PRIMARY KEY constraint 'PK_customfieldvalue'. Cannot insert duplicate key in object 'customfieldvalue'.))
Attached is my log file.
Thanks,
Seán
