Computer Foul-up Breaks Canadian Tax Filing System 129
CokeJunky writes "During a weekend maintenance window, the Canada Revenue Agency (Fills the same role as the IRS south of the border) experienced data corruption issues in the tax databases. As a precaution, they have disabled all electronic filling services, and paper based returns will be stacking up in the mail room, as returns cannot be filed at all until the problem is fixed. Apparently on Monday they discovered tax fillings submitted electronically where the social insurance number, and the date of birth were swapped."
They need a thorough audit of their systems. (Score:5, Funny)
Re: (Score:2, Interesting)
It was a change?
Who approved it?
Was it tested?
What was the prepared back-out plan?
Why does the master recovery procedure not work like clockwork?
Qualification: Most databases are already corrupt/have issues, but not showstoppers
I'll make a guess.
1) ETL in there.(Note recovery using ETL is mostly unworkable)
2) There was no production mirror test environment - test environment and data is a sorry joke.
3) Contractors doing the data conversion
4) Database design, edit checks missing
5) Foreign compos
Data Types (Score:5, Insightful)
Sounds like a serious upfront data validation issue.
However, those two fields should be of a different types and the insert should fail.
Re: (Score:2)
It might be coincidence, but seems like data va
Re: (Score:2)
Re: (Score:2)
Re: (Score:3, Informative)
Re: (Score:2)
Re: (Score:2)
System.Threading.Thread.CurrentThread.CurrentCult
Of course, in
DateTime.Now.ToUniversalTime().ToString("s")
Of course, you likely know this already
Re: (Score:2)
Re: (Score:1)
Re: (Score:3, Funny)
Re:Data Types (Score:5, Funny)
We had to convert it to hex in our heads and enter it on paper tape.
Re: (Score:2)
We had to convert it to hex in our heads and enter it on paper tape.
Offtopic, but it reminds me of one of my first coding jobs. Most young'un's today don't believe it, but it was programming Z-80 *machine* language by hand, on an APL interpreter that was about 32K in size. Using an assembler was way too much overhead, and slowed us down too much. If we wanted to compare the 'A' register against the value 128, well that was "FE 80" (it's sad that these codes are still in my head, 20 years l
Re: (Score:2)
Re: (Score:3, Interesting)
I totally agree. If any kind of robust data validation was going on, this should have failed on insert.
Social insurance numbers are always 9 digits, and can be validated by the Luhn Algorithm [wikipedia.org].
A date of birth wouldn't be 9 digits by any scheme I can think of, especially formatted as 3 groups of 3 digits, and only a very, very few of them wouldn pass a check of this algorithm.
Re: (Score:3, Interesting)
Validation means nothing (Score:3, Insightful)
I just hope they get it sorted out before I'm ready to file. I don't wan
Re: (Score:1)
Jesus fucking christ. Are you that dependent on internet access that you can't think for yourself? Go to the Post Office and get a paper form. Or go to a tax office and get a paper form.
But they aren't processing paper forms at the moment.
Where To Get The Paper Form (Score:3, Interesting)
If you don't want to download it from here [cra-arc.gc.ca], then pick up a package at any post office. They've been there every year for at least twenty one years (and probably much longer). You must be very young, new to Canada, or both.
Re: (Score:2)
Neither, actually. Revenue Canada always mailed the form to me until I started efiling about 5 or 6 years ago. Ever since then they've only been sending me mailing labels. The only address I know is Sudbury, Ontario, which is close to 400km away.
In retrospect, the post office makes perfect sense. I presume that those kiosks in the malls may have the forms as well.
Re: (Score:2)
While I was doing some research...(I could have sworn that some SS #'s had been issued that were more than 9 digits to foreign nationals on loan to the US military branches)..I came across something interesting.
Apparently you can get out of paying (and collecting) SS and medicare benefits as a US citizen by filling out this form [irs.gov] .
Now...all I gotta do is find some of these religions...maybe start my own congregation!! At least you'd know all the members h
Re: (Score:2)
Canada does not use Social Security Numbers. It uses Social Insurance Numbers, which are always 9 digits.
Re: (Score:1)
Sounds like a serious upfront data validation issue.
However, those two fields should be of a different types and the insert should fail.
This belongs on http://www.thedailywtf.com/ [thedailywtf.com] (Now worsethanfailure.com). Its depressing how much stuff on there originates from govenment contracts.
Re: (Score:2)
Re: (Score:3, Funny)
Re: (Score:3, Funny)
Re: (Score:1)
Re: (Score:2)
Sounds like a serious upfront data validation issue.
However, those two fields should be of a different types and the insert should fail.
You would think so. But it is likely a mainframe DB, not SQL and government after all. They probably like enterprise IT figured it worked because it seemed to work.
But scary that our data is so poorly validated. Proves the mess they are really in.
Re: (Score:1)
We have no idea where in the process this field-swap observation was made. It could very well have been in a middleware service, perhaps doing some transformations on some XML, and might have been discovered because the validation was failing.
Some shit when awry with a giant system, and some spokesperson gave some general answer that's probably percolated up, in a completel
sweet (Score:2)
In other words, feel free to write off whatever the hell you want this year, because you officially have plasible deniability.
Plausible deniability (Score:2)
In other words, feel free to write off whatever the hell you want this year, because you officially have plausible deniability.
Not quite, according to their update [cra-arc.gc.ca]:
(I know, the post was supposed to be funny)
Party... (Score:1)
PS. I'm going to write everything off as a business expense.
What was the setup (Score:2)
e
Re: (Score:3, Insightful)
Re: (Score:3, Informative)
Re: (Score:2)
Re: (Score:2)
Actually, CRA is an all-IBM shop off the desktop; websphere, db2, da woiks. This is likely not the last little inconvenience they'll suffer; their development staff are a combination of highly experienced Cobol programmers and highly self-esteemed java "software engineers" with the ink still wet on their CS diplomas. Definitely more news at eleven...
filings, fillings (Score:1)
CCRA (Score:5, Funny)
Re: (Score:2, Informative)
Re: (Score:1)
Re: (Score:3, Funny)
Canadian Revenue Agency Problem.
Re: (Score:2)
Re: (Score:2)
What terrible disaster? Let's just fix the current mix-up for the incoming data, keep track of which data was tainted, and keep the data input going.
In the meantime, the DBAs will figure out ways in which they can reconstruct the lost data. They may not be able to reconstruct all of it, but with some creative thinking and some careful supervision -- they should be able to reconstruct 99% of it. Just to give one example, they should hav
Re: (Score:3, Insightful)
Re: (Score:3, Funny)
Pfft, you're very optimistic this morning.
Re: (Score:2)
No, actually Revenue Canada was renamed the CCRA, then in 2003 it was split into the CRA and Border Services, after the Americans kept running stories insisting we were letting in terrorists by the boatload.
A joke about strikes in Canada: Air Canada (our national subsidized air-carrier) goes on stike? Who cares, we'll walk. The Canadian postal workers goe on strike? (usually before Christmas). Great! It means Visa
What a joke! (Score:1, Funny)
NEO: So you're Trinity, the one that f!@#ed up the CRA database?
TRINITY: Would you like poutine with your back-bacon sandwich?
Poutine? (Score:3, Funny)
Being a US'ian, I am sure that is some kind of Canadian sexual reference.
Re: (Score:2, Informative)
Dammit (Score:2, Insightful)
I'm sure I'll get a nasty call a couple years from now, with a few thousand dollars in fines attached. They will attempt to convince me it was my fault taht they screwed up my information. How do I know this because I've spent the last 4 years trying to
Re: (Score:2)
For the inefficient Govt., its interest-free money.
Re: (Score:1)
Queue targeted phishing... (Score:3, Funny)
Re: (Score:2)
s/SSN/SIN/
Bad computer! BAD! (Score:3, Insightful)
How long must we put up with these computers fouling up our systems? We've been taxing people for hundreds of years with no problems worth mentioning [wikipedia.org].
Bring back trustworthy, reliable humans and we will have no more of these computer foul-ups.
Do they use MySQL? (Score:2)
I ask because MySQL is notorious for silently accepting data that shouldn't otherwise "fit" into a column. In the case of an SSN being inserted into a date field, it would probably just set the date to "0000-00-00" without the slightest complaint.
Re: (Score:2)
Re: (Score:2)
In the future, (Score:2)
Forward thinking, I think.
DST patch broke CRA? (Score:4, Interesting)
Yesterday afternoon, the VP of IT at my company called a 2.5 hour emergency meeting to review our entire DST patch process across all systems to ensure all issues are on track & resolvable - the reason for the emergency meeting? Somebody told him that that CRA glitch was triggered by problematic Microsoft DST (daylight savings time) patches. Our internal MS IT techs confirm, the patches are not exactly simple, or easy to apply and at the last minute some patches have been re-patched or "upgraded" to newer versions, requiring one to uninstall earlier 1.0 patches.
Can anybody site a source that confirms the CRA's glitch was indeed related to DST?
Adeptus
Re: (Score:3, Informative)
http://www.theglobeandmail.com/servlet/story/RTGA
Adeptus
election year (Score:1)
An 'Old government of Canada' used to defer processing returns until after budget delivery [ especially in election years ] to make its performance look better. A few months later, when the budget had to be restated, nobody was noticing. In 1992 [ Wilsons last kick at the can ] it was billions.
Same tactic, new scapegoat.
Re: (Score:1, Informative)
Re: (Score:2)
So they are using Windows - yikes!
Re: (Score:1)
Re:DST patch broke CRA? (Score:4, Informative)
Re: (Score:2)
When I saw that CRA had a "glitch" on the same weekend as the IT guys here applied the DST patch, I thought, "Well now, that's either an amazing coincidence or I'll be reading about it on
It is unlikely that CRA will say the problem was the patch, even if it was.
The question is, "Will we save more energy switching the DST than we consume by switching the DST?"
Re: (Score:2)
Re: (Score:2)
Ah, we've isolated the problem.
Whoever thought of... (Score:1)
Unit Trusts (Score:1)
Should be easy enough to fix... (Score:2)
Re: (Score:1)
Re: (Score:2)
What if I filed on 020070127 and have a SIN of 020070308?
Both of those will fit (with truncation) into either field, and bot of those will also logically resolve to usable data no matter which field they get encoded into.
Re: (Score:2)
A Big Return This Year? (Score:1)
Re: (Score:2)
DST Patches? (Score:3, Interesting)
Does it seem reasonable that I.T. at Revenue Canada would apply code changes at this time unless they were forced to? Generally, the system is only used for a few months of the year. What they are saying doesn't make much sense from the I.T. Operations point of view.
We have change freezes during any busy periods.
Of course, this statement could be influenced by my large refund that was already filed being put on hold and my distaste for tying H.A. systems into Windows boxes. _grin_
Re: (Score:2)
I didn't see the previous comments on DST pathes due to having my threshold turned up. Kudos to the earlier poster and whoever modded them up
Re: (Score:2)
I love you Unknown CCRA IT Guy! smmmooochie woooochie!
Apologies to the Beach Boys:
We'll have fun, fun, fun 'cause I got my tax refund today. Aaaawooooo Awooohoohoohoohoo
The CRA's IT Department (Score:3, Interesting)
A recent story is about the problems they're having with the change in the DST date.
Essentially, because the CRA is still on Windows 2000 systems they have to patch it themselves. So they write the fix, and then they instruct the accountants to leave their computers on and unsecured at the end of the day so that the IT guys can update their computers. Which means that anyone walking by could potentially have very easy access to any of the information about anyone in the Canadian Tax system, and it would be blamed on the individual whose computer they were using.
On top of that, the IT guys got about a third of the way through these updates before they realized that their patch was flawed and now they've decided to fix the problem with the following three measures:
1) Have people set their appointments an hour off, so as to counteract the time change.
2) When emails are sent they are now requited to post times as EST or EDT. My mother had a woman comment to her, "Like I know what time zone I'm in."
3) Upgrade to XP when they can get a deal from M$ for a cheap enough price.
The DOT is worrying over Vista, and the CRA can't set the clocks on 2000. Sometimes I get worried about things up here.
Re: (Score:2, Informative)
Yes, we still run Windows 2000 and indeed Office 2000. The reason CRA has not moved to XP is because CRA is waiting for Vista to stabilise and for Longhorn to be released (for common patches, "stability(for what that is worth)" etc) EVEN THOUGH CRA/CBSA has an enterprise licensing structure and XP is the same cost as 2000 per license, we are not ready for it yet. We run *hundreds* of applications for both CRA and CB
CCRA Messing with their systems at tax time (Score:4, Insightful)
Returns from across the country are going to be coming in. hundreds of thousands of returns will come through the online submission systems. Those machines should've been frozen at Christmas. The Bank that I used to work at had a freeze on their, c machines right near (or after) Christmas in preparation for the onslaught of transactions related to RRSP (US-401K) season).ulminating the lat week of February.
I'm not sure when the DST patches came out for the affected machines, but it seems that they would've been more intellegent about when they were applied.
Plus, no fail-over plan? No back up services? (or were they patched at the same time?) no roll-back? Uhm, naw, we'll just shut 'em down. Yes that works. I mean, who would mind?
Re: (Score:2)
I can certainly understand why the systems administrators want to keep the CCRA machines in the best state. However, messing with them at this particular time is rather ... well, let's go with skull-crushingly stupid.
From what I have seen within the Government of Canada in general is that because the employee numbers tend be largest under the Desktop Support / Helpdesk sections of the IT departments, the managers from Desktop support tend to become the bosses within a governemnt department's IT branch.
It sounds like normal Desktop support managers approach to server maintenance.
The computer did not "foul up" ANYTHING (Score:2)
It did precisely what the analysts and coders told it to do.
But a headline like "Programmer Foul-up Breaks Canadian Tax Filing System" wouldn't be very newsworthy.
A headline like "Programmer Gets Canadian Tax Filing System Just Right" would be newsworthy. And astonishing.
Re: (Score:2)
What I want to know is, how does this affect me if I haven't filed my taxes yet?
Should I do it now, or wait a few weeks?
Sure am glad... (Score:2)
Re: (Score:2)
I'm wondering - does this foul-up mean that there will be an extension on the filing deadline?
Re: (Score:2)
Seems to me that when netfiling, it quite clearly indicates that if you want to add direct deposit, or change an existing direct deposit, you need to mail in a printed return.
Daily WTF (Score:1)
Not A Computer Foul Up (Score:1)
South of the border? (Score:2)
Re: (Score:2)
How can they tell? (Score:2)
Botched software release (Score:2)
Their web site says that they traced the source of the problem to software maintenance conducted on March 4, 2007 [cra-arc.gc.ca].
So I'm impressed (Score:1)
I woul
H&R queue (Score:3, Funny)
When CRA is back up H&R will send the backlog. So CRA will get days of traffic in a minute.
What could possibly go wrong with that?
Re: (Score:2, Funny)