IBM Divestiture – 2019

Background

IBM recently completed its purchase of Raleigh’s North Carolina Linux Powerhouse, Red Hat.

As part of that corporate merger, it appears regulars whether here overseas are concerned of allowing too much vertical technology ( Application software, Operating System, and Integration Software ) to rest in a single entity.

 

Affected Product Lines

HCL Software

  1. Collaboration
    • Notes Domino
  2. Application Security
    • AppScan
  3. Application Delivery
    • Bigfix
  4. Marketing
    • Unica
  5. Digital Experience

 

Impact

The current customer base of the products will obviously be affected.

Impacts will include license renewals, support issue tracking, etc.

Customer facing support staff will also have to respond graciously concerns raised by customers.

Referenced Material

  1. HCL
    • HCL TECHNOLOGIES ANNOUNCES CLOSE OF ACQUISITION OF SELECT IBM PRODUCTS
      Link

 

SQL Server Data Tools ( SSDT ) – Error – “The Application is not installed”

Background

Wanted to quickly go over an error that is easy to self trigger when working with SQL Server Data Tools ( SSDT ).

 

Triggering Point

A few days ago I was working with SSDT, and I was informed that one of the plugins is running slow and prompted if I want to disable it.

Error

Error Message

Solution Explorer

Here is the visuals from Solution Explorer.

Text

The project is marked “incompatible“.

The project’s packages are not outlined.

Their usual placement is obstructed by a text that reads “The application is not installed“.

Image

solutionExplorer.01.20190704.0637PM.PNG

Textual

The application is not installed.

 

Remediation

Outline

  1. In SQL Server Data Tools ( SSDT )
    • Extensions and Updates
      • Access Menu Options Tools \ “Extensions and Updates”
      • The “Extensions and Updates” Window appears
        • Left Panel
          • From the left panel, access the Installed\All Tab
        • Middle Panel
          • Choose to sort by “Most Recent”
          • Select “Microsoft Integration Services”
          • Click on the “Enable” button
  2. Restart SSDT
  3. Load Project
  4. Access Solution Explorer window
    • Access Project
    • Right click on Project and choose to Reload it

 

Images

Extensions and Updates

Microsoft Integration Services Project

Pre Changes

extensionsAndUpdates.integrationServices.01.20190704.0645AM.PNG

Post Changes

extensionsAndUpdates.integrationServices.02.20190704.0646AM.PNG

Summary

Please keep good notes of changes you make.

And, be ready to go back and revert if need be.

Error :- “Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.ReportViewer.WinForms, Version=13.0.0.0, Culture=neutral”

Background

Running SQL Server Tools, but run into an exception.

Error

Error Image

unhandledException.01.20190626.0731PM

Error Text


Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Trouble Shooting

The cited assembly is Microsoft.ReportViewer.WinForm and the version is 13.0.0.0.

13.0.0.0 maps to SQL Server 2016.

Remediation

Outline

  1. Artifacts
  2. Download the following features
    • Actual :-
      • Report Viewer
        • ENU\x86\ReportViewer.msi
    • Pre-requisite
      • SQLSysClrTypes
        • NU\x64\SQLSysClrTypes.msi
  3. Install Modules
    • Pre-requisite
      • SQLSysClrTypes
        • SQLSysClrTypes.msi
      • Report Viewer
        • ReportViewer.msi
  4. Review Install Modules
    • Report Viewer
      • ReportViewer.msi

Tasks

Artifacts

The cited missing module is “Microsoft.ReportViewer.WinForms” version 13.

Please access SQL Server 2016 Features Pack. The latest service pack is SP2 and it is available here.

Image

featurePack.v2016.SP2.20190626.0710PM

Download Modules

Report Viewer ( x86 )

featurePack.v2016.SP2.download.reportviewer.x86

SQLSysClrTypes ( x64 )

featurePack.v2016.SP2.download.sqlclr.x64

Install Downloaded Modules

  1. Pre-requisites
    • SQLSysClrTypes_x64.msi
  2. Actual
    • ReportViewer.msi

Review Installed Modules

Report Viewer

Report Viewer modules are .Net and they are installed in GAC.

Review Installed Module in GAC
Syntax

gacutil.exe /l

Sample
"C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.6.1 Tools\gacutil.exe" /l | find "Microsoft.ReportViewer.Common" | find "Culture=neutral"

Output – Image

GAC.Folder.02.20190626.0725PM

Output – Text
  Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL

  Microsoft.ReportViewer.Common, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL

  Microsoft.ReportViewer.Common, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL

Review Installed Module in GAC
Syntax

gacutil.exe /l

Sample
dir c:\windows\assembly\GAC_MSIL\Microsoft.ReportViewer.Common
Output – Image

GAC.Folder.01.20190626.0550PM

Pastor Paul LeBoutillier :- Priscilla, Aquila, Apollo, and Paul

Background

Pastor Paul LeBoutillier delivers a power sermon on how the church needs worker such as Priscilla, Aquila, Apollo, and Paul.

Scripture

Acts 18:24-27

Link

Meanwhile a Jew named Apollos, a native of Alexandria, came to Ephesus. He was a learned man, with a thorough knowledge of the Scriptures.

He had been instructed in the way of the Lord, and he spoke with great fervor and taught about Jesus accurately, though he knew only the baptism of John.

He began to speak boldly in the synagogue. When Priscilla and Aquila heard him, they invited him to their home and explained to him the way of God more adequately.

When Apollos wanted to go to Achaia ( Corinth ), the brothers and sisters encouraged him and wrote to the disciples there to welcome him. When he arrived, he was a great help to those who by grace had believed.

Acts 19:1-7

Link

While Apollos was at Corinth, Paul took the road through the interior and arrived at Ephesus. There he found some disciples

and asked them, “Did you receive the Holy Spirit when you believed?” They answered, “No, we have not even heard that there is a Holy Spirit.”

So Paul asked, “Then what baptism did you receive?” “John’s baptism,” they replied

Paul said, “John’s baptism was a baptism of repentance. He told the people to believe in the one coming after him, that is, in Jesus.

On hearing this, they were baptized in the name of the Lord Jesus.

When Paul placed his hands on them, the Holy Spirit came on them, and they spoke in tongues and prophesied.

There were about twelve men in all.

Videos

  1. Calvary Chapel Ontario
    • Acts 18
      • Acts 18 – The Gifts of Apollos
        • Video #1
          Channel :- Calvary Chapel Ontario
          Published On :- 2015-March-1st
          Link
    • Acts 19
      • Acts 19 – Part 1 The Power of the Holy Spirit
      • Video #1
        Channel :- Calvary Chapel Ontario
        Published On :- 2015-March-8th
        Link

 

Additional Material

  1. Calvary Chapel Ontario
    • Acts 18 (Part 1) Concluding Paul’s 2nd Missionary Journey
      • Video #1
        Channel :- Calvary Chapel Ontario
        Published On :- 2015-March-1st
        Link

 

 

Sid Roth – 2019/Summer

 

Background

Each of us is in one ministry or another.

There is a timing to it.

Time to shut in, time to be released in to it.

God lets us go, and then he calls us in.

 

Videos

  1. Ian and Rosemary Andrews
    • Profile
      • In this Sid Roth’s It’s Supernatural! Classic episode from 2002: When God told Ian Andrews what his calling was, Ian thought God was joking. He wasn’t. Now Ian sees thousands of people healed. Over 300 students were miraculously healed of learning disorders when Ian prayed.
    •  Videos
      • I Thought God Was Joking When He Told Me My Calling…
        • Channel :- Sid Roth’s It’s Supernatural!
          Published on 2019-June-14th
          Link
  2. Mike Schwartz
    • Videos
      • Supernatural Travel Through the Invisible World | Mike Schwartz
        • Profile
          • In this Sid Roth’s It’s Supernatural! Classic episode from 2001: Mike Schwartz travels supernaturally from one place to the other. It’s not by plane, or car, or even bicycle, but through the invisible world.
        • Videos
          • Video #1
            Channel :- Sid Roth’s It’s Supernatural!
            Published On :- 2018-Dec-5th
            Link
        • Quotes
          • Mike, I want you to give you my heart or today you will go to Hell
  3. Margy Palm
    • Videos
      • Margy Palm Was Abducted by a Serial Killer. Then God Intervened! | It’s Supernatural! Classics
        • Profile
          • In this It’s Supernatural! Classic episode from 1996, you’ll meet a woman who was abducted by a serial killer who was wanted by the FBI for raping and murdering 40 women. Hear her story of how God supernaturally protected her from this madman!
        • Videos
          • Video #1
            Channel :- Sid Roth’s It’s Supernatural!
            Published On :- 2017-January-18th
            Link
  4. Terry Mize
    • Videos
      • I Was Shot Repeatedly But a Force Stopped the Bullets! | Terry Mize
        • Profile
          • In this It’s Supernatural! Classic episode from 1996: Terry Mize picked up a hitchhiker who tried to rob him. The hitchhiker pointed his gun at Terry and shot five times at pointblank range. Find out about the supernatural force that protected Terry!
        • Videos
          • Video #1
            Channel :- Sid Roth’s It’s Supernatural!
            Published On :- 2017-April-19th
            Link
  5. Johnny Lee Clary
    • Videos
      • MUST WATCH! Ku Klux Klan Leader Radically Saved! | Johnny Lee Clary
        • Profile
          • In this It’s Supernatural! Classic episode from 1998: What supernatural power caused a former imperial wizard of the Ku Klux Klan to be repulsed by the Klan, and love the Jew and black?
        • Videos
          • Video #1
            Channel :- Sid Roth’s It’s Supernatural!
            Published On :- 2017-August-23rd
            Link
  6. Frank Sherry
    • Videos
      • I Murdered Two People, But I Couldn’t Escape God’s Love | Frank Sherry
        • Profile
          • In this It’s Supernatural! Classic episode from 1996: Meet Frank Sherry, who murdered two people with a hammer. When the widow of one of the men he killed confronted him, the last thing Frank expected occurred
        • Videos
          • Video #1
            Channel :- Sid Roth’s It’s Supernatural!
            Published On :- 2017-March-29th
            Link
        • keyword
          • August 4th, 1975
          • Ruth, my wife
            • This is a virtuous woman
            •  Derail me from the ministry
            • I rebuked it
            • Brand new creation in Christ
            • My name was written down in the book of LIFE
  7. David Demian
    • Videos
      • I Murdered Two People, But I Couldn’t Escape God’s Love | Frank Sherry
        • Profile
          • In this Sid Roth’s It’s Supernatural! Classic episode from 1999: David Demian is an Egyptian who proves supernatural curses on North America are connected with the Jewish people.
        • Videos
          • Video #1
            Channel :- Sid Roth’s It’s Supernatural!
            Published On :- 2018-June-6th
            Link
        • Keyword
          • Egyptian
          • Jews
          • Canadian
          • Auschwitz, Poland
  8. Bob Larson
    • Videos
      • Exorcist Comes Face to Face with Satanist. Then This Happens
        • Profile
          • Sid Roth with Bob Larson on It’s Supernatural!
        • Videos
          • Video #1
            Channel :- Sid Roth’s It’s Supernatural!
            Published On :- 2019-March-22nd
            Link
  9. Dave Duell
    • Videos
      • Palestinian Leaders Healed by Jesus! | Dave Duell
        • Profile
          • In this It’s Supernatural! Classic episode from 1998: Dave Duell prayed for Arafat and his leaders, and Arafat and 60 members of his cabinet were physically healed!
        • Videos
          • Video #1
            Channel :- Sid Roth’s It’s Supernatural!
            Published On :- 2017-Sept-20th
            Link
  10. Moshe Laurie
    • Videos
      • You Have to Hear What God Said to This Israeli Assassin! | Moshe Laurie
        • Profile
          • In this It’s Supernatural! Classic episode from 1998: This Orthodox Jewish man, a Mossad officer from Israel, was miraculously healed of eight major diseases! Find out what God said to Moshe Laurie that caused him to give his life to the Lord.
        • Videos
          • Video #1
            Channel :- Sid Roth’s It’s Supernatural!
            Published On :- 2017-Sept-13th
            Link
  11. Laurie Ditto
    • Videos
      • I Found Myself in Hell. The Reason Why Will Surprise You.
        • Videos
          • Video #1
            Channel :- Sid Roth’s It’s Supernatural!
            Published on 2019-April-7th
            Link
  12. Janie Duvall
    • Videos
      • Amazing Benefits of Speaking in Tongues! | Janie Duvall
        • Videos
          • Video #1
            Channel :- Sid Roth’s It’s Supernatural!
            Published on 2018-April-4th
            Link
    • Terminologies
      • Speaking in Tongue
  13. Live Streams
    • Videos
      • Video #1
        • Channel :- Sid Roth’s It’s Supernatural!
          Published on 2017-May-9th
          Link

 

Conclusion

There is a lot to say.

But, the Lord, God has his own timing.

There are so many stories wrapped up in intersection of time and spaces.

 

SQL Server Agent on AWS/RDS

Background

There is quite a bit of SQL Server management surface area that is not available when running on AWS/RDS.

 

Surface Area

For instance with SQL Server Agent :-

  1. SQL Server Agent
    • Category
      • Add new category
        • API
          • sp_add_category
        • Error
          • Msg 229, Level 14, State 5, Procedure msdb.dbo.sp_add_category
          • The EXECUTE permission was denied on the object ‘sp_add_category’, database ‘msdb’, schema ‘dbo’.
    • Job Step
      • Fetch Job Steps
        • API
          • SELECT * FROM msdb.dbo.sysjobsteps
        • Error
          • Msg 229, Level 14, State 5, Line 71
          • The SELECT permission was denied on the object ‘sysjobsteps’, database ‘msdb’, schema ‘dbo’.

 

Scripting

In terms of scripting, SQL Server Agent is not accessible in an AWS/RDS Environment.

Github – Warning – “… this is larger than GitHub’s recommended maximum file size of 50.00 MB”

Background

In our last post tried uploading Microsoft’s office Excel Viewer to github, but ran into a familiar error\warning.

Referenced Posts

Here are referenced posts :-

  1. Microsoft Office Files Viewer
    Link

 

Error

Error Image

gitLargeFilesDetected.20190317.1143AM.png

Error Text


>git push
Enumerating objects: 8, done.
Counting objects: 100% (8/8), done.
Delta compression using up to 4 threads
Compressing objects: 100% (3/3), done.
Writing objects: 100% (7/7), 73.84 MiB | 712.00 KiB/s, done.
Total 7 (delta 0), reused 0 (delta 0)
remote: warning: GH001: Large files detected. You may want to try Git Large File Storage - https://git-lfs.github.com.
remote: warning: See http://git.io/iEPt8g for more information.
remote: warning: File Excel/Excel2007/RTM/12.0.4518.1071/ExcelViewer.exe is 74.14 MB; this is larger than GitHub's recommended maximum file size of 50.00 MB
To https://github.com/DanielAdeniji/MicrosoftOfficeViewer.git
   c1abc53..5c0f86d  master -> master

Remediation

Git Large File Storage

Outline

Please peruse Git Large File Storage instruction on how to incorporate Git LFS:

Git Large File Storage
Link

  1. Git Command Line Extensions
    • Download Git Command Line Extensions
    • Install
  2. Launch Command Line Shell
    • Access your targeted repository root folder
    • Git Lfs Install
      • Enable lfs for current repository
    • Git lfs track
      • Register files\file types
    • Make sure .gitattributes is tracked
      • git add .gitattributes
    • Commit, as usual
    • Push, as usual

Actual

Download

Download Git LFS for Windows.

It is available here.

And, the current version is 2.71.

Install

Please install the downloaded file

Command Line Shell

I use Command Line Shell and so launched one.

git lfs install
Syntax
git lfs install
git lfs track
Syntax
git lfs track
Actual
git lfs track *.exe
Add .gitattributes
Syntax
git add .gitattributes
Actual
git add .gitattributes
Add Files
Syntax
git add
Actual
git add *.exe
Git Commit
Syntax
git commit
Actual
git commit
Git Push
Syntax
git push
Actual
git push
Output – Image

gitLFSPrep.push.03.20190317.1215PM.PNG

Output – Textual
>git push
Uploading LFS objects: 100% (1/1), 78 MB | 735 KB/s, done
Enumerating objects: 13, done.
Counting objects: 100% (13/13), done.
Delta compression using up to 4 threads
Compressing objects: 100% (5/5), done.
Writing objects: 100% (11/11), 1.18 KiB | 121.00 KiB/s, done.
Total 11 (delta 1), reused 0 (delta 0)
remote: Resolving deltas: 100% (1/1), completed with 1 local object.
To https://github.com/DanielAdeniji/MicrosoftOfficeViewer.git
   4144078..d08a9f8  master -> master

Explanation

 

  1. Indicate LFS Upload
    • Uploading LFS objects: 100% (1/1), 78 MB | 735 KB/s, done

 

Verification

Outline

  1. Review files marked as LFS
    • Locally
    • Uploaded

 

Tasks

Files marked as LFS

Locally

To review the list of files you have marked as LFS, please review your .gitattributes file

Syntax

type .gitattributes

Output
Output – Image

.gitattributes.20190318.0735AM

Output – Textual

*.exe filter=lfs diff=lfs merge=lfs -text

Explanation
  • *.exe
    • filter=lfs

Uploaded Files

To verify if a file is uploaded as an LFS file, please launch a browser and access the file’s URL.

LFS files will be noted as “Stored with Git LFS“.

git.lfs.wordviewer.20190318.0654AM

References

  1. GitHub
    • Git Large File Storage
      Link
    • Versioning Large Files
      Link