#58 Year 2005 issue?

[John Carpenter]

Submitting new issues:

java.lang.Exception: Issue.java : insertion
impossible:java.sql.SQLException: [Microsoft][SQLServer
2000 Driver for JDBC][SQLServer]The conversion of char
data type to smalldatetime data type resulted in an out-
of-range smalldatetime value.

INSERT INTO issue (priority, sender, emissionDate,
modifiedOn, domain,subSystem, label, patch, status,
standByState, filledBy, filledDate, reproductibility,
subType, nature, type, severity, projectId, versionPf,
versionApp, assignedTo, description,
reproduction,extraInfo, processedAction, attachedFile1,
attachedFile2, attachedFile3,attachedFile4,
attachedFile5, history, verboseHistory,
actors,plannedVersion, domainChangeRemark,
deliveryRemark, storingRemark,
environment,effectiveTime, estimatedTime,
senderProfile, senderDepartment, origin,
assignmentHistory, refusedRemark,wishedDate,
plannedBeginDate,realBeginDate,plannedEndDate,realEnd
Date,deliveryDate,storingDate,dialog, msgAuthor,
republicationRemark, senderTeamId, standByQualifier,
modifier, plumLink,template, modint) VALUES (-1,'JC','14-
01-2005','14-01-2005',-1,-1,'',3900,406,-1,'JC','14-01-
2005',-1,-1,-1,601,-1,7,'','','','','','','','','','','','','-
Submission (14/01/2005, JCarpenter)','- Submission
(14/01/2005, JCarpenter)','#JC#','','','','',-
1,'','',2,'5',1,'','',null,null,null,null,null,null,null,'','','',1,'','','',n
ull,1)

[Nobody/Anonymous]

Logged In: NO

Can you provide more information about how the bug occured?
regards
Xavier

[John Carpenter]

Logged In: YES
user_id=418059

Web Server: Elips 1.5.6 served through Tomcat 5.0 running
on Win 2000 Pro.

DB Server: SQL Server 2000 running on Win 2000 Adv. Server.

Sequence: Log in then Submit new Bug / Task / Evolution.

If you need more info, please be specific.

[Nobody/Anonymous]

Logged In: NO

qqqqqqqqqqqqqqqqqqqqqqqqqqqqqq

[Mike Tillberg]

Logged In: YES
user_id=662138

I saw this same issue as well the first time I went through
(using PostgreSQL. The problem is the date formatting.
dd-MM-yyyy causes problems with the default date parser.
The fix is to keep the date in yyyy-MM-dd mode.

[John Carpenter]

Logged In: YES
user_id=418059

I cannot provide any more information. It has been many
months, and now we have moved on with a different issue
tracking package.

I think there is enough information here to reproduce the
error, though. Install into the same environment I listed on
1005-01-16 and then attempt to submit a new
Bug/Task/Evolution.