My boyfriend is going through a huge impossible request right now.
He works for Company X, which is mostly contracted to work for Company Y. The current problem that they're having is that Company Y maintains a spreadsheet/database of information called QRS (making up all the acronyms, but they really are just three letter acronyms). His job at Company X is to take the information from QRS and put it into ZYX database so another department at Company Y can read it.
There's a massive issue right now where the data from QRS isn't coming over properly. It's propigating the wrong sets of data, adding duplicate data that can't validate because of errors, and isn't including several pieces of information that they absolutely need. This is a known issue from when QRS was created, but the developers refuse to acknowledge this in any documentable form. Executives at Company Y and Company X are nearly screaming mad because nothing is being done, but boyfriend can't prove what data he's missing because he doesn't have access to QRS to compare what he has and doesn't have. He can't get anyone to allow him access to QRS because it's not part of his job to need all that information. It's likely to take at least another week for him to write the scripts to query the database to see what exactly is going on, plus taking things offline to test them in a stable setting, thus not letting any of the rest of QRS users access it or letting any of the data update live.
The best part? ZYX is going to be gone by the end of the month. This has been planned for a very long time. It's halfway through June and they're JUST NOW opening up tickets (and the average shelf life for a ticket with the development team is two to three weeks before anything can be done). There was literally no way in the timeframe the executives wanted that the issues between ZYX and QRS to be fixed, and barely enough time for them to be diagnosed properly, but unless there's visible progress RIGHT NOW, people are going to be getting in trouble.
Boyfriend has been pulling 14 hour days trying to fix this. Half of the people who can fix this are here in the USA, half of them are in India, making finding time for them to all be online together working on this more difficult than normal. But his bosses can't explain this to the execs from either company, they want it done and they want it done before the system phases out.
Um, yeah. Sorry. No.