March 7, 2020 at 5:55 pm
When we were about to go live, we had 2 people run supply demand on the same item at the same time. Locked up the whole environment. Some of the code developed on our site made it into later versions.
We used triggers on the production instance to capture daily changes we were interested in. The coolest part was we never had any issue with new releases. And I can remember one odd instance where finance had a processing option set wrong and released work orders moved back in status. The production crew was mystified for weeks. I had our programmer do a slight modification to our trigger, and we captured the issue the same day.
JDE got me my start into IT after working on the shop floor. As an SME, with limited access to some things, I often got directed to figure out set up bugs. It was rather an interesting cat and mouse game when they restricted security. We worked with Born, and one time when some of the people were leaving, Craig Thielen was back. He mentioned he was back to secure the environment, and I chuckled. He was well aware of my creative flair. So he asked the question what’s so funny? I replied a shop floor user can access the source code in production. He goes no way. Then I describe the function key path to do so. I had a valid reason to be there - comments in the code (and browsing the code itself) expedited bug fixes. I knew who to talk to, and a pretty good understanding of what was helpful. Although RPG is nothing I had actual training in, it was similar enough to the VB / VBA I used.
I remember the pains as they tested One World. The green screen wasn’t so bad. Users complained, but the alternative, although it looked better, had lots of issues.
Once I was asked to do an update world writer in production, as JDE production support was swamped. Simply a field was mixed case and needed to be all upper. Was unable to run it. Security officer said I wasn’t locked out. I figured out how to grant myself access, then told him what he needed to lock down.
Part of what many never had a handle on was few shops ran JDE out of the box, but enhanced code for their needs. Which led to challenges when you upgraded.
WW and Showcase were my launch into report writing. 2 days of WW training and we went live with no reports. The users will tell you what they need. And I was a busy bee. But a tremendous learning experience. Showcase was pretty neat - especially embedded in Excel and tying in macros.
March 10, 2020 at 4:43 pm
on floor laughing... steal that plaque and post it to me.
I can just imagine that as the front bit of a box that contains an instant database that is fully indexed and well written - forget dynamoDB, mongoDB,cosmoDB - we now have "GILADB"
MVDBA
March 10, 2020 at 5:15 pm
Ignoring the politics, this is interesting: https://www.cnn.com/2020/03/09/politics/coronavirus-airlines-white-house-tensions/index.html
US govt: we want this data
CEO: We don't have that
US govt: You're lying.
CEO: We can collect it with paper, or build an app in a few months.
That's a simple view, and there are lots of issues, but interesting that this data is the center of a controversy here. I get both sides, but I also get this is something we want to contain and control quickly.
March 10, 2020 at 5:31 pm
Ignoring the politics, this is interesting: https://www.cnn.com/2020/03/09/politics/coronavirus-airlines-white-house-tensions/index.html
US govt: we want this data
CEO: We don't have that
US govt: You're lying.
CEO: We can collect it with paper, or build an app in a few months.
That's a simple view, and there are lots of issues, but interesting that this data is the center of a controversy here. I get both sides, but I also get this is something we want to contain and control quickly.
you won't get the data until people are dead... in the UK we have been advised to NOT go to a GP or a hospital or a pharmacy. so how do they collect the data??
if airlines are required to vet passengers and report on that data then it will mean longer checkin times, more delays and frankly since it takes a few days to start showing signs - then it is impossible. - can you imagine climbing onto a plane and getting a temperature test, a breath test and a blood sample??
I coughed today (just man flu - kids on the bus all sneezing) and I was asked if I wanted to work from home (cool boss) , but putting us in isolation won't make us better. - collect the data
end of rant 🙂
MVDBA
March 10, 2020 at 5:47 pm
Steve Jones - SSC Editor wrote:Ignoring the politics, this is interesting: https://www.cnn.com/2020/03/09/politics/coronavirus-airlines-white-house-tensions/index.html
US govt: we want this data
CEO: We don't have that
US govt: You're lying.
CEO: We can collect it with paper, or build an app in a few months.
That's a simple view, and there are lots of issues, but interesting that this data is the center of a controversy here. I get both sides, but I also get this is something we want to contain and control quickly.
you won't get the data until people are dead... in the UK we have been advised to NOT go to a GP or a hospital or a pharmacy. so how do they collect the data??
if airlines are required to vet passengers and report on that data then it will mean longer checkin times, more delays and frankly since it takes a few days to start showing signs - then it is impossible. - can you imagine climbing onto a plane and getting a temperature test, a breath test and a blood sample??
I coughed today (just man flu - kids on the bus all sneezing) and I was asked if I wanted to work from home (cool boss) , but putting us in isolation won't make us better. - collect the data
end of rant 🙂
They may already are collecting the data, but know how it goes when a company defies a government request for data. Just think back to late 2015 and a terrorist's encrypted iPhone. The risk was high and the legal cost could not have been light. Companies collect tons of data all the time - some right, some wrong, but they collect it.
I think the potential irony of the whole mess is that fewer people are flying, so the airlines aren't making as much money. After the fighting in both directions is over, how long before they want a bailout?
March 10, 2020 at 6:27 pm
...I think the potential irony of the whole mess is that fewer people are flying, so the airlines aren't making as much money. After the fighting in both directions is over, how long before they want a bailout?
It may be sooner than people think if they keep flying empty planes:
March 11, 2020 at 8:57 am
Ed Wagner wrote:...I think the potential irony of the whole mess is that fewer people are flying, so the airlines aren't making as much money. After the fighting in both directions is over, how long before they want a bailout?
It may be sooner than people think if they keep flying empty planes:
Flybe have already gone bust, but that was already on the cards
but empty aircraft - that's a lot of fuel dumped into the atmosphere - maybe regulators might look at that idea and pay operators to not fly unnecessary flights
I have a microlight licesnse and I fly for fun (npplm(r) license) I use a couple of gallons of fuel per flight (£10) , but I know my little Foxbat is still poluting
MVDBA
March 11, 2020 at 9:29 am
but empty aircraft - that's a lot of fuel dumped into the atmosphere - maybe regulators might look at that idea and pay operators to not fly unnecessary flights
Last I read the EU has reached out to the Airports about this. The reason they're flying the planes is because of the "use it or lose it" attitude in regards to favourable departure times. If the Flight Company doesn't use the slot, they lose the slot, so to avoid losing it they send the plane out regardless if many (or anyone) are on the plane. Really stupid if you ask me; at least with things that are going on.
Next flight I have (booked) isn't till September though, so hoping things will be calmer by then. If not, and the Home Office advise against flying to Japan at least I get a refund so I'm not worrying about it; not like anything I can do will change things.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 11, 2020 at 9:29 am
Awww, SQLBits has been postponed until September. I was really looking forward to it as well, but not surprised at all.
March 11, 2020 at 9:33 am
I have a flight to Poland in a few weeks.. fingers crossed Ryanair can get me there and back before work on monday
MVDBA
March 11, 2020 at 9:43 am
I have a flight to Poland in a few weeks.. fingers crossed Ryanair can get me there and back before work on monday
Your real problem there is RyanAir, not COVID-19. 😉
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 11, 2020 at 9:50 am
MVDBA (Mike Vessey) wrote:I have a flight to Poland in a few weeks.. fingers crossed Ryanair can get me there and back before work on monday
Your real problem there is RyanAir, not Corvid-19. 😉
lol - I use them about 5 or 6 times a year and there are crying babies, no first class, no legroom, service attendants that smash the trolley into your arm, 5$ for a small pack of pringles
an old colleague of mine told me that they shaved 30% of the weight of the safety notices (which we don't read) just to cut fuel costs as the weight saving was a few KG
gotta say, as much as this is not in the spirit of customer luxury.. it is in the spirit of DBA... make it as light as possible and keep your query costs down
MVDBA
March 11, 2020 at 11:04 am
Last I read the EU has reached out to the Airports about this. The reason they're flying the planes is because of the "use it or lose it" attitude in regards to favourable departure times. If the Flight Company doesn't use the slot, they lose the slot, so to avoid losing it they send the plane out regardless if many (or anyone) are on the plane. Really stupid if you ask me; at least with things that are going on.
Next flight I have (booked) isn't till September though, so hoping things will be calmer by then. If not, and the Home Office advise against flying to Japan at least I get a refund so I'm not worrying about it; not like anything I can do will change things.
I'm going to be cancelling and rearranging flights & hotels all over the place. Phew, what a pain in the bottom this is all going to be.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2020 at 11:12 am
MVDBA (Mike Vessey) wrote:but empty aircraft - that's a lot of fuel dumped into the atmosphere - maybe regulators might look at that idea and pay operators to not fly unnecessary flights
Last I read the EU has reached out to the Airports about this. The reason they're flying the planes is because of the "use it or lose it" attitude in regards to favourable departure times. If the Flight Company doesn't use the slot, they lose the slot, so to avoid losing it they send the plane out regardless if many (or anyone) are on the plane. Really stupid if you ask me; at least with things that are going on.
Next flight I have (booked) isn't till September though, so hoping things will be calmer by then. If not, and the Home Office advise against flying to Japan at least I get a refund so I'm not worrying about it; not like anything I can do will change things.
a terrible system at best - hopefully they can use those slots to put trainee crew through a couple of drills
MVDBA
Viewing 15 posts - 64,591 through 64,605 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply