• QJo (unregistered)

    Another wee problem ...

  • (cs)

    ...because double manual entry without reconciliation fixes more problems than it creates?

  • (cs)

    Well hurry up in there for fuck's sake, I'm desperate ... to see my reports ...

  • (cs)

    Interestingly, our users only care about getting their reports. Yet they've never complained about all the broken data on which they're based.

  • George Fitch (unregistered)

    Let me guess... the real WTF is Microsoft Access?

  • (cs)
    Integration in the database layer often means trying to reconcile keys with no natural relationship

    Sounds better if you imagine this being spoken like a voice over from Burn Notice.

  • (cs)

    It's not often that you see a system/problem that is crying out for a buzzword solution, but this web of satan is rolling around in a sweaty fever, screaming "GIVE ME SOME SOA.... please, please, just a little bit of that ESB"

  • RuBen (unregistered)

    "So why did you use SQL2008?"

    "Well it was a tip from our auditor. He was helping out the president's sick daughter."

  • Sahir Siddiqui (unregistered)

    Oh yes the well known double entry technique to keep our new systems in sync, when the old systems they replaced never had any issues staying synced. Why am I not surprised.

  • CleanCode (unregistered)

    TRWTF is no mention of a database architect, or any technical people between a VP and the poor IT guy.

  • DogsBody (unregistered) in reply to snoofle
    snoofle:
    Interestingly, our users only care about getting their reports. Yet they've never complained about all the broken data on which they're based.

    I've had users complain when data was fixed as it broke their workarounds!

  • Mathias (unregistered)

    I would love to read a Confession article from Remy.

  • Tony (unregistered)

    I've fonud a problem!

  • Pock Suppet (unregistered) in reply to DogsBody
    DogsBody:
    snoofle:
    Interestingly, our users only care about getting their reports. Yet they've never complained about all the broken data on which they're based.

    I've had users complain when data was fixed as it broke their workarounds!

    This. Give me the friggin report now! No need for accuracy! No one actually looks at those numbers in the first place! It's all about relative numbers! Just make the change I told you to!

    Right until we get a client who is able to count past 20 and notices the report stupidity. Then it's time for a meeting where IT gets called on the carpet to explain why we "broke" things. Usually accompanied by the words "It never used to work like that!" And everyone thinks I'm crazy for never deleting emails...

  • RFoxmich (unregistered)

    SELECT * FROM PURCHASE_ORDER_STAGE_TAB WHERE VENDOR = 'frist';

  • I heard it on the modem like (unregistered)

    Sounds like a case of the FKIA report going way too far. http://www.centerpointforleaders.org/newsletters/FKIAReport.pdf

    CAPTCHA: nulla - When the moon hits the eye of a coder in the sky, that's a nulla.

  • (cs)

    The VP looks like he had some sense.

  • Confessor (unregistered)

    I've been party to a system like this. Some Pointy-haired-boss (or customer) gets a wild idea that they want feature XYZZY or whatever buzzword is in vouge right now. Sit down and lay out a plan for the development strategy, requirements, development effort to develop said feature. Get told that's too much time by 2 orders of magnitude. Get handed some half baked piece of software (along with half baked expamples) and get told to integrate the solution. Still takes over half the time to get a moderately working solution. Get told to ship what we have (even though it's not done) with promises that we'll come back to finish it in a few months, but never do.

    CAPTCHA: I vink therefore i ven i am

  • (cs)

    Lost in translation...

  • John (unregistered)

    "BizTalk doesn’t have a native connector for SQL2000 databases"

    Incorrect statement

  • (cs) in reply to Raedwald
    Raedwald:
    Integration in the database layer often means trying to reconcile keys with no natural relationship
    Sounds better if you imagine this being spoken like a voice over from Burn Notice.
    Whaddya think, Mikey? Send Fi and Jesse to take a closer look at Purchize while you and I get some answers from the Oracle admin? Easy Peasy! But let's make it snappy - I've got plans with my ladyfriend this evening.
  • emaNrouY-Here (unregistered) in reply to RFoxmich
    RFoxmich:
    SELECT * FROM PURCHASE_ORDER_STAGE_TAB WHERE VENDOR = 'frist';

    I found a bug... let me fix that for you!

    SELECT * FROM PURCHASE_ORDER_STAGE_TAB; WHERE VENDOR = 'frist';
  • Anonymous Coward (unregistered) in reply to Tony

    And I need remember to wear an athletic cup if I ever meet him.

  • Richard (unregistered)

    Sounds like a good fix to me, actually. If the new system is causing a double-entry situation then it should be fixed - but that's far FAR better than having a poorly written fix that causes production data to be deleted. Not so WTF. I mean the environment is, but the VP made exactly the right call.

  • Swedish tard (unregistered) in reply to emaNrouY-Here
    emaNrouY-Here:
    RFoxmich:
    SELECT * FROM PURCHASE_ORDER_STAGE_TAB WHERE VENDOR = 'frist';

    I found a bug... let me fix that for you!

    SELECT * FROM PURCHASE_ORDER_STAGE_TAB; WHERE VENDOR = 'frist';

    And I've got a fix too...

    STAB STAB STAB STAB_STAB_STAB_STAB STAB STAB 'stab';
  • golddog (unregistered) in reply to CleanCode
    CleanCode:
    TRWTF is no mention of a database architect, or any technical people between a VP and the poor IT guy.

    Let's not suggest that is necessarily the solution.

    I overheard our recently-hired DBA/Data Architect talking with someone, explaining how to generate a script out of a database on SQL Server.

    "When you save the script, make sure to save it as ANSI, not Unicode. When you save as Unicode and check it into a repository, that messes up the file."

    I remain unimpressed.

    While I don't like the Captcha repeating meme, I find it sadly ironic that it's "genitus" for this post. Which might describe our DBA: not quite a genius.

  • Rich L. (unregistered)

    Definitely one of my favourite WTF's of all time (up there with my friend the Shredder).

    Thanks for sharing.

  • (cs)

    [So, all of these other systems stopped merely dumping data into the Examiner, and started extracting data too.]

    An ad-hoc reporting system morphs into a "source of truth". There should have been about a hundred DBAs who choked on that idea; their role is the protection of the integrity of their data at all costs.

    Allowing data to flow back into one of their systems from an untrusted source should have raised red flags up the chain. And should have resulted in the firing of the people who allowed the data to get so screwed up.

  • Dave (unregistered)

    The whole time I was expecting the article to end with some moral about not having P.E.E. (Purchasing Enterprise Examiner) in your pool (of data solutions).

  • HowItWorks (unregistered) in reply to Dave
    Dave:
    The whole time I was expecting the article to end with some moral about not having P.E.E. (Purchasing Enterprise Examiner) in your pool (of data solutions).
    TRWTF appears to be refering to Examiner, rather than using the acronym.
  • Another Anon (unregistered)

    Any chance of trying to reorganize Payroll through this Oracle system? At least trial it out with the numb-nuts' own account information?

  • miker (unregistered) in reply to golddog

    [quote user="golddog"][quote user="CleanCode"] "When you save the script, make sure to save it as ANSI, not Unicode. When you save as Unicode and check it into a repository, that messes up the file."

    I remain unimpressed.[/quote]

    Really good advice, assuming he is not referring to UTF-8.

    A lot of tools will treat UTF-16, or UCS-2, files as binary. I can't remember which one SQL Server spits out by default, they are both bad UCS-2 is worse.

    I use an export tool that converts everything to UTF-8, but ASCII would be good enough for me.

  • (cs) in reply to golddog
    golddog:
    CleanCode:
    TRWTF is no mention of a database architect, or any technical people between a VP and the poor IT guy.

    Let's not suggest that is necessarily the solution.

    I overheard our recently-hired DBA/Data Architect talking with someone, explaining how to generate a script out of a database on SQL Server.

    "When you save the script, make sure to save it as ANSI, not Unicode. When you save as Unicode and check it into a repository, that messes up the file."

    I remain unimpressed.

    While I don't like the Captcha repeating meme, I find it sadly ironic that it's "genitus" for this post. Which might describe our DBA: not quite a genius.

    Windows not support unicode complete like unix and linux. I could find severe links to this statement, but I can't bother to google right now.

  • C-Derb (unregistered) in reply to Tony
    Tony:
    I've fonud a problem!
    was it this?
    remy:
    He traced the tendrils of data back to the other systems, and fonud nothing amiss
    this?
    remy:
    So we use SQL2008 to proxy your data and pump records too and from Purchize.
    or this?
    remy:
    ... told the users that they simply had to keep manually enter their changes in both Purchize and Oracle.
  • Foo (unregistered) in reply to snoofle
    snoofle:
    ...because double manual entry without reconciliation fixes more problems than it creates?

    without reconciliation, you'll never know what problems it creates, so yes.

  • (cs) in reply to Dave
    Dave:
    The whole time I was expecting the article to end with some moral about not having P.E.E. (Purchasing Enterprise Examiner) in your pool (of data solutions).
    A pool of PEE? This is becoming a theme!
  • (cs)

    <quote>Managing a long supply chain involves keeping thousands of moving parts in lock-step. From purchasing to order management, demand planning to operations, even the smallest hiccup in the chain can have massive impacts.</quote> There's the WTF in a nutshell. If your production system is not fault-tolerant, you're doomed no matter what.

  • (cs) in reply to Raedwald
    Raedwald:
    Integration in the database layer often means trying to reconcile keys with no natural relationship

    Sounds better if you imagine this being spoken like a voice over from Burn Notice.

    +1 for that. I'd give you more points, but apparently that's frowned upon in these Web2.x days.

  • UK Pete (unregistered) in reply to Pock Suppet
    Pock Suppet:
    DogsBody:
    snoofle:
    Interestingly, our users only care about getting their reports. Yet they've never complained about all the broken data on which they're based.

    I've had users complain when data was fixed as it broke their workarounds!

    This. Give me the friggin report now! No need for accuracy! No one actually looks at those numbers in the first place! It's all about relative numbers! Just make the change I told you to!

    Right until we get a client who is able to count past 20 and notices the report stupidity. Then it's time for a meeting where IT gets called on the carpet to explain why we "broke" things.

    This wasn't a UK bank by any chance?

  • Lerch98 (unregistered)

    The technical term for this is Cluster Fuck

  • (cs) in reply to Pock Suppet
    Pock Suppet:
    DogsBody:
    snoofle:
    Interestingly, our users only care about getting their reports. Yet they've never complained about all the broken data on which they're based.

    I've had users complain when data was fixed as it broke their workarounds!

    This. Give me the friggin report now! No need for accuracy! No one actually looks at those numbers in the first place! It's all about relative numbers! Just make the change I told you to!

    Right until we get a client who is able to count past 20 and notices the report stupidity. Then it's time for a meeting where IT gets called on the carpet to explain why we "broke" things. Usually accompanied by the words "It never used to work like that!" And everyone thinks I'm crazy for never deleting emails...

    Same. "How come you never delete emails?" "Leverage."

    A colleague of mine who wrote the reports was told one of his reports was "always wrong" based on the fact that two completely different numbers in the report were different.

  • (cs)

    Remy, time to update your schedule:

    1. caffeine
    2. author article
    3. more caffeine
    4. proofread article
    5. ?
    6. profit
  • James (unregistered)

    The True WTF is the usual bizTalk solutions I see deployed. I am amazed at the number of folks out there who really think a COTS middle-ware layer is going to solve their problems.

    I suppose its a nice short cut for some situations; but really message routing, and workflow is the easy part of most middle-ware efforts. If you don't have a decent bench of systems people and developers its gonna be FAIL.

    Add to the problem that for some reason almost everyone who has ever built an orchestration in BizTalk thinks this somehow makes them Gods gift to the field systems integration. Weird culture issue there. Especially when they all run around designing things like in today's article. Seriously using a SQL2008 instance as proxy server? Really? Someone decided to go to production with that?

    Honest on the best BizTalk project outcomes I have saw was an organization where after a year long attempt to get their Commerce Server based website to put orders into their GL and fulfillment systems successfully, wound up with this:

    BT ( using the same database engine the site was on incidentally ) would pickup XML orders written out by the site to a directory on a file system, it would format them as more human targeted text then e-mail them to a customer service rep. The customer service rep would then manually enter the order, into both the accounting/GL systems and various fulfillment suff; which includes some sort of technician scheduling application, and creating receiving and picking tickets for the warehouse staff. Then if everything was okay, credit card accepted (yes the numbers were mailed to the CSR, but TLS was used so its okay right? ) the CSR would reply to the Biztalk e-mail adding the PO number to the subject. Biztalk would then do a few database look-ups get the final shipping cost ( rather than the badly estimated on made on line at order time), and build a recipient/confirmation all as a giant XML blob and drop it off in a file folder for Commerce Server to read at some point and wait for it: format it as a more human target message and mail it as the order confirmation....

  • Evan (unregistered) in reply to Nagesh
    Nagesh:
    Windows not support unicode complete like unix and linux. I could find severe links to this statement, but I can't bother to google right now.
    Hahahahahahahahaha
  • Michael Bolton (unregistered)

    This has been my job for the last 7 years. Yee ha.

  • john (unregistered)

    Better than the solution I expected to hear from the VP: "just use a shared spreadsheet".

  • (cs) in reply to C-Derb

    I actually added fonud to my spellchecker, just to toy with you all.

  • iMortalitySX (unregistered)

    I think there is always a WTF if you draw a chicken and call it a data flow. Seriously though, am I the only one that sees a chicken in the drawing?

    CAPTCHA: vindico; Latin for avenge, punish, liberate, deliver, protect. I have seen chickens do none of these.

  • J (unregistered)
    ...and told the users that they simply had to keep manually enter their changes in both Purchize and Oracle.
    Wanted: Data Entry Clerk Requirements: PL/SQL programming experience
  • Michael (unregistered)

    This is simply the status-quo most places I have worked. I agree that it's broken and messed up, but hardly a WTF.

Leave a comment on “Purchasing Enterprise Examiner”

Log In or post as a guest

Replying to comment #400830:

« Return to Article