tag:blogger.com,1999:blog-47901027308183648562024-02-19T12:50:12.873+01:0012DMy life as an IT professionalLars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.comBlogger329125tag:blogger.com,1999:blog-4790102730818364856.post-84632908922479297832024-01-01T16:23:00.003+01:002024-01-02T08:07:26.090+01:00New year new currency ratesLast year, actually last Friday we had an incident in the Data Warehouse. The currency rates for next month must be loaded otherwise the Data Warehouse stops. It litterary stops, you cannot do any updating at all, so updating the currency rates it a pretty important task. Now I have not been involved in this since 2013 and the task was handed over to a new guy on the job, he is located in India Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-31520962318797566072023-12-31T08:45:00.002+01:002023-12-31T08:45:54.779+01:00Yet another YearThis year was an eventful year for my Data Warehouse. A new guy
Hans Mattson stepped in to
help me running the Data Warehouse. In no time Hans became proficient in running
the Data Warehouse, with his extreme analytical skills he solved some very
complex problem we faced. 'You know I'm curious, I want to know how things
works' he used to say. Unfortunatly his previous employeer realized how much
Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-27680976976530140412023-10-11T08:42:00.000+02:002023-10-11T08:42:12.242+02:00 Import SAP data into MySQL with little effort This morning I stumbled upon a SAP import script written in my Integration Tag Language. The script is a little gem, it is probably written about 2008.The script includes all code needed exporting data from a SAP rfc function into Mysql (including defining an import table in Mysql. I have removed parts not necessary for showing the complete export process from beginning to end.The script Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-26338834861505060262023-01-13T07:51:00.002+01:002023-01-13T07:51:26.048+01:00Sevetieth birthdaySomethings you cannot avoid like haveing your sevetieth birthday. I just had mine, I just pretend it never happened.Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-9905758345991582052022-08-19T10:57:00.002+02:002022-08-19T13:37:50.382+02:00A snapshot monitor for MySQLI recently created a snapshop monitor for Mysql.It gives nice snapshots every 15 minutes of Mysql (server) activities.It is a useful tool for finding problems especially from night run as you can go back in time. The output consists of:1 Memory stats of the server2 Number of SQL queries since last snap3 Processes running when snap is takenA snapshot of the snapshop monitor output:Fri Aug 19 Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-37960404797949682172022-07-20T12:53:00.001+02:002022-07-20T12:57:10.277+02:00Transpose away about 92 percentIt has been a long time since I wrote here about The Data Warehouse. I have spend time upgrading PHP from 5.6to 7.4 and Mysql latin1 to utf8. None of this is in production yet. I also spent time on the long overdue Mysql from5.6 to 5.7, which makes me go bonkers. In the old days when I had full control of the environment I just downloadedand installed the MySQL version I wanted. Now I try to Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-42896504650411769882022-01-16T16:22:00.000+01:002022-01-16T16:22:11.553+01:00Finally DW runs on PHP 7.4After quite some work I have upgraded my Data Warehouse to PHP7 (4.29). I
started by switching from Mageia 4 to first openSUSE where I developed the PHP7
version, and finally to Azure Ubuntu. I still use KDE as desktop though. In the
beginning of DW 2001 I used Mandrake Linux and PHP4. Since 2014 the DW was
upgraded to PHP5.6. I thought that was the last upgrade of the Data Warehouse
PHP code. Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-63271691505626869072021-12-31T16:00:00.000+01:002021-12-31T16:00:05.941+01:00Another Year Has PassedIt's been a while since I wrote a post now, this year is not so much to write home to mum about. Not much €work, not much work at all really. Since the Covid struck business have been bad.
But more work than Yesteryear, actually a little more work than I want. I'm finishing an upgrade of my Data Warehouse to PHP 7 (and 8.1 soon). The big problem was the SAP connector, it was much more work Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-9152844209106746002021-09-19T15:08:00.000+02:002021-09-19T15:08:09.587+02:00Summer's goneThe Data warehouse lives for another winter. Last month I tried to move the database to the Azure cloud. We knew it would probably not work out well, the latency turned out to be a bit over three times longer with the database in the cloud, a bit better than expected, but still to much.The company is very eager to move the Data Warehouse to the cloud, and I agreed to help them out. It is a Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-22460182087882643042021-08-08T13:23:00.003+02:002021-08-08T13:27:02.782+02:00PCHART and PHP 7.4I have for some time now struggled with PHP 7.4.9 and PCHART, finally this morning I made the combo work. First I started out with PCHART 2.4, I missed the little note saying "This version is not compatible with old PCHART scripts". I probably spent a calendar week trying to make my old scripts work before I started from scratch again, this time I both saw and read the little note. I downgraded Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-47464108453925409112021-07-16T16:27:00.002+02:002021-07-16T16:27:33.863+02:00IDRAC to the rescue Yesterday was abit hectic, while I was working on some Data Warehouse virtual servers, the database server went bananas, I had lots of server terminals up on my laptop and I shutdown one virtual server to change it's configuration, or so I thought I shutdown the physical host server, all console frames went black and I could not connect to the physical host. I then to launch the Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-41981574053886407382021-07-16T16:02:00.001+02:002021-07-16T16:02:24.317+02:00Database server running wild Yesterday the hottest day so far this summer 32C, the Data Warehouse MySQL server went haywire. Conections where dropped and database tables where partially unavailable this is a very heavy used server no time for deep debugging, so I restarted MySQL and all was normal again, for a few hours, then it really went crazy, now the entire server was affected not only MySQL was uncontactable but Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-89527554678781029782021-05-27T09:07:00.000+02:002021-05-27T09:07:49.749+02:00Second jab At last, I had my second covid jab the day before Yesterday😁 After the first shot I didn't feel any side effects at all. Yesterday I was really sick but today I'm ok again. And I'm still working on my old Data warehouse. After all this years. I several times thought I left it behind, but no it is still there hauting me on it's 21 year of operation. I recently found two broken disks inLars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-39736087571297745822021-02-19T08:16:00.002+01:002021-02-21T09:02:36.512+01:00Mars dust buster? I have not seen the most obvious question about the Mars helicopter Ingenuity. Will it be used for blowing dust off Perseverance?That would really be cool, once every now and then Ingenuity takes to the air over Perseverance and blow off the dust. At home I start my Neato each week to clean my apartment, but for Perseverance once or twice a year would probably be sufficient. Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-60995699409090550412021-02-08T08:43:00.000+01:002021-02-08T08:43:36.543+01:00Data Warehouse and winter Last week I had a call from the company they have performance problems with the Data Warehouse. It seems they want me to help them to fix the problems. While they make up their mind I’m enjoying outdoor winter activities.After a dreadful November, December and January, no sun, slush and rain, came beautiful February. Lots of snow and proper winter temperature down to -10C. Even though Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-46067924616717997332020-12-30T09:01:00.000+01:002020-12-30T09:01:44.481+01:00Another year It's been a while since I wrote a post now, this year is not so much to write home to mum about. Actually it's been a bad year for 11Dim. Not much €work, not much work at all really. Since the Covid struck business have been bad. I have helped the DW guys with odds and ends, and also given them a little hand replacing the DW (which seems to take some time). We also spotted a bug in theLars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-66133470631659514382020-09-08T09:36:00.004+02:002020-09-08T09:40:00.973+02:00Google home and power outageTuesday morning at 04:20 (AM) - "Hey Google Good Morning". Nothing happens, no lights no nothing. WTF, after some fumbling around I realized there is no power in my flat. I found a message in my phone from the electric power supplier there is an outage since 04:08 2836 households affected. and they expect the power to be back 06:00. Power outage in Stockholm is extremely rare it just do not Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-81863179321738413202020-08-15T20:14:00.004+02:002020-08-16T16:11:30.223+02:00VNC remote session hellToday I was about to start up TigerVNC server in a SUSE LEAP 15,02 server. I decided to try the SUSE way, start vnc with SUSE VNC manager. Now starting up a VNC server is always a thriller sometimes I manage to set it up in just a few hours of trial and errors, sometimes it is like banging my head bloody against a brick wall for days and sometimes the VNC server just refuses to startup. But the Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-7109674826092635252020-07-23T09:00:00.002+02:002020-07-24T13:26:56.855+02:00SharePoint - unbelieving badIn a blog post Microsoft? announces a plan for 'stop using SharePoint for application development'. This is not one day too early. I have from the very first day I came in contact with SharePoint development criticized SharePoint as a platform for IT applications, it is appallingly bad and buggy, and I have said so, (not always popular among colleagues and managers in the company I Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-43667837862623050972020-07-16T09:30:00.003+02:002020-07-16T09:38:28.412+02:00Are you alive?I have not checked the status or jobs of my data warehouse, not even checked if someone is fixing broken jobs since almost a month now. This is the longest period I have totally neglected my data warehouse since the start 2001. This morning I checked the twitter account and it seems the data warehouse runs along fine. If someone attending the failed jobs I do not know. I'm told there are Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-19365187709722006652020-06-27T09:10:00.000+02:002020-06-27T11:22:32.240+02:00The Swan Song of my Data WarehouseIt is not the end, but the beginning of the end. Finally the finale is approaching for my Data Warehouse. I have for some months participated in a project migrate my Data warehouse to the cloud. For reasons I do not understand the decision has been taken, the first step to decommission or rather replace the Data warehouse is to move it to the cloud. My Data Warehouse must live for yet some years Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com1tag:blogger.com,1999:blog-4790102730818364856.post-25752836899230685792020-05-10T13:06:00.001+02:002020-06-09T17:10:47.118+02:00Sunshine and eating cakeYesterday the first day this spring I had the opportunity to sit in the sunshine on my balcony. With a cup of coffee and my Samsung Tab S6 I had planned to read from the book "D Web Development". I could barely see there were letters on the page, no chance to read anything on the tab screen. Luckily I could switch to my Kindle Paper White, it is better than a paper book in the sunshine, a pity Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-83414386328798366392020-02-19T09:50:00.001+01:002020-02-19T09:59:33.181+01:00Bex Bax Dax PaxRecently I have participated in some BI meetings where the participants were discussing how to create new applications. Nowadays this seems to be very complicated, they use BEX DAX and all kinds of esoteric cryptic query languages. All tasks very complex, offloading data from one multi-dimensional data warehouse to data lakes into tabular data cubes stores.'You have to move the data to a data Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-64097581601092142412020-02-14T09:52:00.001+01:002020-02-14T10:00:19.241+01:00Lost in the cloud
I'm sitting here and thinking how sharp I am
I'm the under assistant blob store contrib man
Lasse Phelge & Lars Nanker
Recently I have been promoted to an Azure Blob Storage Contributor. We are trying to move my old Data Warehouse to the cloud. So far we have moved zero bits, we are fighting the network. You see these YouTube promos how easy it is to work with the cloud, you just Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0tag:blogger.com,1999:blog-4790102730818364856.post-26103894573374013362019-12-17T15:57:00.000+01:002019-12-17T16:18:54.829+01:00Strategy and a Tribute concertLast weekend we had a company future strategy meeting at 11Dim. The board was represented by me, Erik and Axel. We had some special invited experts Adela Juras, Victor Hjelm and Andreas Röine Larsson. We are especially grateful for Adela's insights in Human interfaces and Project management, Victor's hard work at the meeting and Andreas presentation on the Lars Johanssonhttp://www.blogger.com/profile/08450832809628203536noreply@blogger.com0