Win OS – Error – “Replication of license information failed because the License Logging Service on server could not be contacted”

Background

Reviewing MS Windows Event Viewer and noticed a recurring error “Replication of license information failed because the License Logging Service on server [server-name] could not be contacted“.

Error

Event Viewer

Event Properties

Here is the error message…

Image

eventProperties_20180904_0119AM.png

Textual

  1. Source :- LicenseService
  2. Event ID :- 213

 

Events

Image

eventViewer_20180904_0119AM.png

Troubleshooting

Logging Service

Googled on the error message and directed to check the “Logging Service” on the remote computer.

Computer Manager

Launched “Computer Manager” and connected to remote computer.

Services

Service – License Logging

Outline
  1. Changed Service Mode from disabled to Automatic
  2. Start Service
Original – Service – Disabled
Image

licenseLogging_Disabled_20180904_0121AM.png

 

Service – Startup Type – Changed to Automatic
Image

licenseLogging_Automatic_20180904_0122AM.png

Service – Service Started
Image

licenseLogging_Automatic_Started_20180904_0123AM.png

Win OS – Run Application has an Administrator

Background

In a previous post, “Data Studio – Error – ‘configuration\org.eclipse.osgi.manager.fileTableLock (Access is denied.)’ ”, spoke of the need to run an application as an Administrator.

That post is here.

Always “Run As An Administrator

Let us see what it will take to always run an Application as an Administrator.

Guide

Googled on our title and found a very worthy post.

It is by “Sarah Jacobsson Purewal” and it is titled “Always run a program in administrator mode in Windows 10” as our guide.

That post is here.

Steps

Outline

  1. Identify Application Launcher
  2. Review Application Launcher
    • Review Application’s folder and binary name
  3. Change Application’s compatibility mode
    • Change “Run as an Administrator” mode for all users

Identify Application Launcher

Search for Application

In Windows Desktop, please search for the Application.

In our case “IBM Data Studio“.

desktop_datastudio_properties_20180830_0848AM.PNG

Open file Location

Please right click on the app and the drop-down menu appears.

From the drop-down menu, please choose “Open File Location“.

desktop_datastudio_openfilelocation_20180830_0853AM

Review Application Launcher

Start Menu \ Programs \ [Application]

Here is what the start menu for our application looks like.

startmenu_programs_ibmdatastudio_20180830_0903AM.PNG

Start Menu \ Programs \ [Application] \ [shortcut]

Let us access the short cut that we want to dig into.

Data Studio 4.1.3.3 Client
Properties

We selected the shortcut and right clicked on it.

Here is what our drop-down looks like.

startmenu_programs_ibmdatastudio_properties_dropdown_20180830_0910AM

Shortcut – Image

startmenu_datastudio_properties_shortcut_20180830_0914AM.PNG

Shortcut -Textual
  1. Target :- “E:\Program Files\IBM\DS4.1.3\eclipse.exe” -product com.ibm.datastudio.consolidated.product.ide
  2. Start In :- “E:\Program Files\IBM\DS4.1.3”

 

Application’s compatibility mode

Our application’s full name is “E:\Program Files\IBM\DS4.1.3\eclipse.exe”.

Let us go set its compatibility mode.

Windows Explorer

Using Windows Explorer, we accessed our application’s folder, E:\Program Files\IBM\DS4.1.3\.

windowsExplorer_IBMDataStudio_20180830_0926AM

 

Windows Explorer – Application

We selected our application and right clicked on it.

windowsExplorer_IBMDataStudio_properties_20180830_0928AM

Properties

Properties – Tab – General

Here is the initial tab when the Properties for an Application is accessed.

Properties_eclipse.exe_tab_general_20180830.0934AM

Properties – Tab – Compatibility

Please access the Compatibility tab.

Properties_eclipse.exe_tab_compatibility_01_20180830.0937AM

Please click on the “Change Setting for all users” button.

Properties – Tab – Compatibility – Change Settings for all users

Here is what the “Change Settings for all users” window look like.

Properties_eclipse.exe_tab_compatibility_changeSettigforallusers_01_20180830.0941AM

Please make the changes identified below:

  1. Run this program as an Administrator

Here is a screen that reflects our change.

eclipse.exe.compatibilityforallusers.20180830.0945AM

 

Dedication

Dedicated to Sarah Jacobsson Purewal.

On MS Windows, Profiling Java Apps Memory Utilization Using VMMap

Background

In our last post, we covered the usage of a few Oracle standard tools to profile Java Applications.

BTW the referenced post is available here.

 

SysInternals

VMMap

In this post, we will briefly cover using SysInternal’s VMMap GUI to track down memory utilization.

 

Artifact

VMMap is available from here.

The current version is v3.21 and it was released a couple of years ago; July 20, 2015 to be exact.

Download & Extract

Download and Extract it; no need for installation.

Usage

ElasticSearch

Select or Launch Process

 

Metrics

 

WebSphere

Select or Launch Process

 

Metric

WinOS – Restart Computer through Script

Background

Needing to restart a computer that is not accessible via Remote Desktop.

Script

DOS Batch

Here is a Dos Script that can help.

Outline

  1. Expects lone argument passed in to be computer name of host to restart
  2. Initiates shutdown.exe
    • /r :- Restart
    • /d p:0:0 :- Reason is a planned restart
    • /m :- Computer that is target of restart
    • /c :- Reason
      • User that initiated restart and host restarted from

Code


@echo on

setlocal

rem /r
rem restart computer

rem /d 
rem   p = planned restart

if [%1]==[] (
	echo Please pass along computer name as first parameter
	echo Exiting Script
	goto :endofScript
	)

set "_usernamefull=%USERDOMAIN%\%USERNAME%"

set "_computer=%1"

set "_reason=Planned restart by %_usernamefull% from host %COMPUTERNAME%"

shutdown.exe /r /d p:0:0 /m \\%_computer% /c "%_reason%"

:endofScript

endlocal

Output

Output #1

Image

Textual

LABDB: The entered computer name is not valid or remote shutdown is not supported on the target computer. Check the name and then try again or contact your system administrator.(53)

Output #2

Image

Textual

You're about to be signed out
Windows will shut down in less than a minute.

Bigfix – Error – “The specified target is unknown or unreachable”

Background

Trying to configure our BigFix Application Server, but running into the error pasted below.

Error

Image

failedToConnectTheSpecificTargetIsUnknown_20180713_0400PM [BrushedUp

Textual


Failed to connect to https://bigfixsrv:52311:
Windows Error 0x80090303

Remediation

Network

netstat

Command


netstat -an | find "52311"

Explanation

Noticed network connections on our Application’s port ( 52311).

Active Directory

Service Principal Name ( SPN )

setspn

Overview

SPN is formatted as such :-

serviceclass/host:port servicename

Here is a quick breakdown of each element

  1. Serviceclass
    • For Bigfix, the service class registered is iem
  2. Host
    • The computer name
  3. Port
    • If other than the default port number for the application
  4. Service Name
    • It our case it will be the Active Domain Account that our service will be running under

 

Syntax
Syntax – List

REM List SPN entries for computer
setspn -L [computer]

Syntax – Add

REM Add iem account for computer
setspn -S iem/[computer] [user]

Sample

setlocal

set "_comp=BIGFIXSRV"
set "_compFQDN=BIGFIXSRV.LAB"
set "_user=LAB\servicebf"

REM Remove Previous iem account ( Computer )
setspn -D iem/%_comp% %_comp%

REM Remove Previous iem account ( FQDN )
setspn -D iem/%_compFQDN% %_comp%

REM Add iem account (Computer) 
setspn -S iem/%_comp%  %_user%

REM Add iem account  ( FQDN )
setspn -S iem/%_compFQDN% %_user%

REM List spn for computer
setspn -l %_comp%

REM List spn for user
setspn -l %_user%


endlocal

References

  1. IBM
    • Support
      • Pass-Through Authentication failing
        Link
    • IBM Knowledge Center \ SSPS Modeler  \ Configure Single Sign-On
      • The Service Principal Name
        Link
  2. Microsoft
    • Setspn
  3. Viruk67 – You Want It When!
    • Setting the NetworkService as an SPN account
      Link

SQL Server – BulkCopy ( BCP ) – Which data file?

Background

Using BCP, we are churning though quite a bit of files.

Unfortunately, the DOS batch file that I quickly stitched together missed an importantly functionality.

And, that functionality is to log the current file being processed.

Diagnostic

Microsoft

Resource Monitor

I am a big fan of Microsoft’s Resource Monitor.

Let us use it.

Preparation

We remote connect to the source computer and launched task Manager; from Task Manager accessed Resource Monitor.

Resource Monitor – Tab – Memory

Image

ResourceMonitor_Tab_CPU_ProcessesAndAssociatedHandles_20180706_0850AM.png

Explanation
  1. When we filter on the bcp.exe process, we see our data file as one of the files mentioned in the “Associated Handles” tab

 

Resource Monitor – Tab – Memory

Image

ResourceMonitor_Tab_Memory_20180706_0852AM.png

Explanation
  1. The BCP process is using about 14 MB

 

Resource Monitor – Tab – Disk

Image

ResourceMonitor_Tab_Disk_20180706_0907AM.png

Explanation
  1. sqlserver,exe is mentioned
  2. But, not our bcp.exe file

 

Summary

To get a reliable insight into which files are being accessed, please consider Microsoft’s own Resource Monitor; specifically the CPU tab.

 

 

Error: “The requested operation could not be completed due to a file system limitation (mscorlib”

Background

Experiencing an error when trying to run an embedded process.  Part of the functionality that is bundled in the process, is a file copying module.

Error Message

Here is the error message :-

*** Error: The requested operation could not be completed due to a file system limitation (mscorlib) ***

Trouble Shooting

Application Message

Thankfully the particular file that is copied is logged, as well.


Copying log backup file to temporary work file. Source: '\\LABDB\Backup\hrdb_20180703104507.trn', Destination: '\\LABMirror\backup\HRDB_20180703104507.wrk'

Fast Copy

Attempted same file copy in FastCopy.

And, again thankfully it reported an error message; along with an error number.

Image

FastCopy_20180705_0712PM_v2.png

Text


WriteFileWait(The requested operation could not be completed due to a file system limitation665) : \\LABMirror\backup\HRDB_20180703104507.wrk
TotalRead  = 40,414 MB
TotalWrite = 40,289 MB
TotalFiles = 0 (0)
TotalTime  = 26:50
TransRate  = 25.0 MB/s
FileRate   = 0.00 files/s 

Explanation

  1. Error
    • Error Operation :- WriteFileWait
    • Error Description :- The requested operation could not be completed due to a file system limitation
    • Error Number :- 665

 

Error Causation

There are a few probably causes for error number 665.

Compression?

File

Finally, we checked the compression setting on others files in the targeted folder.

File Property

Image

file_20180706020000_trn_brushedup.png

Textual
  1. Size :- 2.07 GB
  2. Size on Disk :- 760 MB
Explanation

We can see that our file is compressed.

Folder Settings

Reviewed the Folder’s Advanced Attributes.

Image

AdvancedSettings_20180705_0717PM.png

Explanation

  1. Compress Contents to save disk space ( is enabled )

 

Remediation

Compression

Setting

We turned off compression on the targeted folder.

Fast Copy

Retried Fast Copy and it worked successfully.

NoError__20180705_1014PM_v2.png

 

Summary

Wished the original application displayed the OS’s error number and not just a simple error text that read “Error: The requested operation could not be completed due to a file system limitation (mscorlib)“.

Thankfully, there was enough diagnostic data in regards to the original file and destination folder that allowed us to replay via a more illuminating tool.