SQL Server – v2017 – Install – “Oracle JRE 7 Update 51 (64-bit) is required for Polybase”

Background

Installing SQL Server v2017 and ran into an error that I have seen before.

Error

Error Image

OracleJRE7Update51_x64.2018109.1111AM.PNG

Error Textual

Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase

Tackled Before

History

Already tackled before here:

SQL Server (v2016) – Installation – Blocked – “Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase”
here

History

The fix applied was to install Java JRE downloaded from here:

https://www.oracle.com/technetwork/java/javase/downloads/index.html
Link

But, unfortunately even though install applied no help this time.

Trouble Shooting

Let us dig a bit deeper.

SysInternals

Process Monitor

Image

sysInternals.processMonitor.20181009.1010AM.PNG

Explanation

  1. Identified component used by SQL Server Setup
    • Component is ScenarioEngine
  2. ScenarioEngine
    • Log
      • C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20181009_092126\Detail.txt

Tail

Tail For Win32

Download

Downloaded Tail For Win32 from here:

Tail for Win32
Link

Usage

Launched “Tail For Win32” and loaded the identified SQL Server Log file ( Detail.txt )

Results
Image
TailforWin32_Usage_20181009_1151AM
Textual

13) 2018-10-09 10:13:06 Slp: Init rule target object: Microsoft.SqlServer.Configuration.Polybase.Polybase_IsMinJavaVersionInstalledFacet
(13) 2018-10-09 10:13:06 SQLPolyBase: Could not find registry setting HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Runtime Environment\CurrentVersion.
(13) 2018-10-09 10:13:06 SQLPolyBase: Minimum version expected: 1.7.51. Java not found.
(13) 2018-10-09 10:13:06 SQLPolyBase: Rule 'Polybase_IsMinJavaVersionInstalled' detection result: IsMinJavaVersionInstalled= False
(13) 2018-10-09 10:13:06 Slp: Evaluating rule        : Polybase_IsMinJavaVersionInstalled
(13) 2018-10-09 10:13:06 Slp: Rule running on machine:
(13) 2018-10-09 10:13:06 Slp: Rule evaluation done   : Failed
(13) 2018-10-09 10:13:06 Slp: Rule evaluation message: This computer does not have the Oracle Java SE Runtime Environment Version 7 Update 51 (64-bit) or higher installed. The Oracle Java SE Runtime Environment is software provided by a third party. Microsoft grants you no rights for such third-party software. You are responsible for and must separately locate, read and accept applicable third-party license terms. To continue, download the Oracle SE Java Runtime Environment from https://go.microsoft.com/fwlink/?LinkId=526030.
(13) 2018-10-09 10:13:06 Slp: Send result to channel : RulesEngineNotificationChannel

Textual
  1. QLPolyBase: Could not find registry setting HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Runtime Environment\CurrentVersion.
    (13) 2018-10-09 10:13:06 SQLPolyBase: Minimum version expected: 1.7.51. Java not found.

Registry

regedit

Images

Regedit – Image – Before
Image

registry_20181009_1038AM.PNG

Textual
  1. Computer\HKEY_LOCAL_MACHINE\Software\JavaSoft
    • Java Plug-in
    • Java Update
    • Java Web Start
    • Java Web Start Caps
    • JRE
Explanation
  1. HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Runtime Environment\CurrentVersion.
    • Java Runtime Environment
      • Missing

Remediation

Outline

Please download Java JRE 8 and install it.

Download

Please download artifacts from here :-

Java SE Runtime Environment 8 Downloads
https://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html
Link

Artifacts

Image

Java SE Runtime Environment 8u181

download_JavaSERuntimeEnvironment_20181009.1221PM.PNG

download_20181009.1026AM.PNG
Explanation
  1. Chose to download Windows X64

 

Install

Images

Destination Folder

download_DestinationFolder_20181009.1031AM.PNG

Installing
Installing -01

install_20181009.1032AM.PNG

java Setup – Complete

install_JavaSetupComplete_20181009.1033AM.PNG

Change in License Terms

download_JavaSERuntimeEnvironment_Roadmap_20181009.1030AM.PNG

Registry

Using regedit, please review the Java’s registry structure.

regedit

Images
Regedit – Image – After
Image

registry_java_jre_1Dot8_20181009_1243PM.PNG

Explanation
  1. HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Runtime Environment\CurrentVersion is now present

 

Summary

It appears that Oracle has changed the folder structure for Java in the Windows Registry.

Specifically what used to be

HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Runtime Environment\CurrentVersion.

is now

HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\JRE\CurrentVersion.

Please be sure to have Java JRE v1.8 ( Java 8) installed for SQL Server v2016\v2017 Polybase.

Nick Bryant – US election: Hillary’s humiliating low road to White House

Prologue

Sometimes it takes an outsider to offer a balanced and nuanced view of Politics and Elections.

Rather than scapegoating, Nick Bryant carefully lays out the case of interviewing for the nation’s highest Civil Servant position.

If she loses, she might get to rest.

On the other hand, if she wins it will likely take time for her to connect with a divided electorate.  And, even longer for the whole to connect with her.

Just a couple of days I heard one prophetic voice refer to what is his name as Hussein.

Here is Nick’s words:

Link

Hillary Clinton could be days away from earning the most powerful job in the land. But the road to victory has been a rough one.

Her journey in these final days has taken her across this vast continent, and travelling with Hillary Clinton, on her plane and in her motorcade, I have got to see the view from her window.

Of the snarling faces of pro-Trump protesters, some dressed in prison fatigues, some waving the Confederate flag, as she arrived for a rally in the Florida countryside.

Of a golden skyscraper emblazoned with the name of her rival, TRUMP, as we drove past The Strip in Las Vegas.

Of the floodlit faces of supporters at a night-time, open-air rally in Fort Lauderdale, where a Trump protester lurked in the crowd with a placard he had smuggled in: “Bill Clinton is a rapist.”

Her road to the White House has been lined with anger, hatred and mistrust. And surely it must sometimes be painful to peer through the tinted glass of her armoured SUV to see demonstrators who would rather see her in jail. From bullets those vehicles offer a protective shell, but not the brickbats.

Only two weeks ago, with Donald Trump reeling from the release of the Access Hollywood tape and mercilessly lampooned by Saturday Night Live for his self-satirising performances in the televised debates, these concluding miles looked like they were becoming a victory lap.

Though America is too polarised these days to produce 1964-style landslides, it looked like she was on course for a lop-sided victory in the Electoral College. Arizona, a red state that has only once gone Democrat since 1948, was thought to be leaning Democrat. Even Texas, one of the Republican’s most bankable states, was said to be in play.

Then came that October surprise on steroids, as Fox News described the FBI’s announcement that it was reviewing emails found on the laptop used by her closest aide Huma Abedin and Anthony Weiner, the disgraced former Congressman.

The aura of inevitability projected by her campaign was quickly replaced by a palpable sense of vulnerability.

The polls were tightening. Some showed Trump had pulled ahead. In early voting, African-Americans were not turning out in high enough numbers. Florida, the most important battleground state, was now a toss-up.

The conjecture inside the Hillary bubble about who would occupy senior posts in her administration ended abruptly. Abedin, her constant companion and so-called “second daughter”, was now absent from her side.

After a few days, we didn’t even bother craning our necks to look to see if she was boarding the campaign plane. It was now a given that she wouldn’t be there.

Rather than ending on high-minded appeals for national unity, the plan when she enjoyed double-digits leads in the polls, Hillary Clinton has been forced to re-litigate the case against Donald Trump.

Rather than outlining her vision for the nation, she has sounded like a prosecutor making a desperate closing argument in a scrappy and sordid trial that the jury can’t wait to end.

What’s been striking about her stump speeches in these final days is their tone of exasperation.

As she recites again her curriculum vitae – those years fighting for children as a lawyer, her tenure as First Lady, her time in the Senate co-sponsoring bipartisan legislation, those 112 countries she visited as Secretary of State, it is as if she cannot believe that the world’s most important job interview could end with someone so manifestly unqualified being appointed.

A man, she repeatedly reminds audiences, who was presenting Celebrity Apprentice on the night that she was hunkered in the Situation Room watching the mission that killed Osama Bin Laden.

Nor can she seem to fully process the idea that this polyglot nation, in which millions more women will vote than men, could seriously entertain the idea of electing a candidate whose name has become synonymous with xenophobia and misogyny.

The unspoken line of these final days speeches is: How did it ever come to this?

It is as if she has walked onto the set of the wrong movie. Or, more aptly, the set of the wrong daytime show: Jerry Springer or Judge Judy rather than Oprah or Ellen.

Surely, she could never have imagined that at a campaign stop in Florida, she would be introduced by a former Miss Universe, Alicia Machado – there to remind women voters that Donald Trump has called her Miss Piggy.

Nor would she have predicted that at a rally in North Carolina she would have to call on Bernie Sanders, a proud socialist and septuagenarian, who managed this year to enthuse young female voters in ways that she struggled to do so.

Surely it must be wounding to be so dependent on the star power of Michelle Obama. And also to rely so heavily on Barack Obama, not only to act as her campaigner-in-chief, but more importantly her character witness-in-chief.

As campaigns reach their climax, it is customary for presidential candidates to reflect on how seeking the highest office in the land has been a humbling experience.

But there must have been times when Hillary Clinton has also found it deeply humiliating.

To peer out of the window in these final days, with the country flashing by, is to have been reminded of what can be awe-inspiring about America. Flying into Las Vegas, we looked down on the Hoover Dam, that great monument to American ingenuity.

We have travelled to its university campuses, those academic powerhouses that have helped make America great.

From the palm-lined beaches of southern Florida to the copper-tinted mountains on the fringes of Phoenix, we have witnessed its epic beauty. But the end of this campaign, like so much that has gone before, has been unlovely and unedifying.

In these final days, it has felt like we have been travelling along a low road to the White House.