Linux

SQL Server – Analysis Services – Cannot Connect ( Microsoft.AnalysisServices.AdomdClient )

Daniel Adeniji Connectivity ( Analysis Services ), Microsoft, MS SQL Server, Network Tracing, Networking, SQL Server Analysis Services (SSAS), Technical , , , ,

Background

Users are having problems connecting to the Analysis Services Server.

 

Error Message

Image

Text


TITLE: Connect to Server
------------------------------

Cannot connect to ....sql01.

------------------------------
ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

------------------------------

A connection attempt failed because the connected party did not properly respond after a period of time, 
or established connection failed because connected host has failed to respond z.y.76.188:2383 (System)

Text


===================================

Cannot connect to d-isql01.

===================================

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

------------------------------
Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond xx.xx.xx.xx:2383 (System)

------------------------------
Program Location:

at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)

TroubleShooting

Server

Resource Monitor

If the server has Microsoft’s Resource Monitor built-in let us use to it to review Network Ports.

Image

Explanation

  1. Listening Ports
    • Image :-
      • msmdsrv.exe
    • Address :-
      • IPV4 unspecified
      • IPV6 unspecified
    • Port :-
      • 2383
    • Protocol
      • TCP
    • Firewall Status
      • Allowed, not restricted

 

Client

netstat

Script


netstat -an | find "SYN_SENT"

Sample Output

Explanation

  1. Request was sent to port 2383
  2. Status is SYN_SENT
    • SYN_SENT means waiting on a reply

Remediation

Open up TCP Port 2383.

 

Review

Once the Network Port, 2383, is opened up retry access with SSMS.

 

Network Flow

Also, it makes sense to review the Network Traffic to get a full list of ports to be opened.

WireShark

Output

 

Explanation

Seems Analysis Services exclusively relies on port 2383.

Linux – Finding Text in Log Files – Day 1

Daniel Adeniji grep, Linux, Linux Commands, Microsoft, Technical

Background

Don’t really spend much time in the Linux World.

But, there are many Application Servers that sit on Linux Servers and rely on SQL Server on Windows.

 

Log Files

When error occurs a good Application Server write these errors in Log Files.

After a while needs develop to trend the type of DB Connectivity and more serious hard errors.

 

Sample Log Files

As we discussed in a recent post, we copied over SQL Server Error Log files over to Linux.

 

Text Search

grep

Let us use grep to perform simple Text Searches.

Scenario

Look for Text Matching Manufacturer

Script

grep -w -i -l -n  "Manufacturer" ERRORLOG
Output

Explanation
  1. No matches

 

Remediation

Attempted Workarounds

We tried the following workarounds

  1. Worked
    • Created a much simple text file and was able to grep against it
  2. Did Not Help
    • Modified copy over mode to binary and back to text
    • Command Issued
      • cat ERRORLOG | grep -i “manufacturer”

 

Worked

Code


cat ERRORLOG | tr -d '\000' | grep -i "manufacturer"

Output

Why does it work

  1. Cat
    • Outputs a file’s content
  2. tr – stands for translate
    • tr -d ‘\000’
      • -d means delete
      • \000 means null character

Crediting

What makes grep consider a file to be binary?
Link

When you are top 13% on stackexchange, you are one of the Big Boys and Girls.

 

Linux & Windows – Simple File Transfer Using FileZilla

Daniel Adeniji FileZilla, Linux, Microsoft, Technical

Background

There is a little insight that I need to reach for.

It has to do with LogFiles on a couple of Application Servers that run on Linux.

 

Preparation

I tried creating some sample text files on the Linux host, but I could only type in three lines or so.

I know that I generate a lot of errors on my SQL Server boxes, so opted to avail those on the Linux boxes and play with those instead.

 

Tools

FileZilla

FileZilla is free, Open Source, and there is a Portable Version.

Download

Download it from here.

 

Avail

Availed it by launching the *.paf.exe file

 

Launch

Configure Host through Site Manager

Let us explicitly configure our remote Host.

Access Site Manager through menu items “File” \ “Site Manager …”

Image

Explanation
  1. Enter Host Name
  2. Protocol :- SFTP – SSH File Transfer Protocol
  3. Logon Type :- interactive
  4. User :- Enter your user name
    • In our case dadeniji
  5. Password :- Enter your password
    • As we chose Interactive for Logon Type, the password text box is disabled
  6. Click the Connect to connect to the remote host

 

File Listing

Image
Before

 

After

Please navigate your directory structure, select the files you want to copy over, and drag and drop them onto the Target Folder.

Linux – Listing Files Based on Date

Daniel Adeniji Linux, Scripting - Bash, Technical ,

 

Background

I have a need to list files on a Linux Host sorted by date.

 

ls Command

Earliest First

Command


ls -ltr -G -g | grep -v '^total' | head -5

 

Output

 

Latest First

Command


ls -lt -G -g | grep -v '^total' | head -5

Output

 

ls Command In a ditch

Unfortunately, when there are numerous files in the target folder the ls command and other file utilities can get in a ditch.

Argument List Too Long

Command


ls *.LOG

Output

Image

Text

bash: /bin/ls: Argument list too long

 

Find Command

Earliest First

Command


find . -name '*.LOG' | sort | head -n 5

Output

Command


find . -name '*.LOG' | sort | tail -n 5

Output

 

Script

Let us get a bit more complicated.

And, we will do do by picking up individual files, process them, and exit after N Number of files have been processed.


# get current folder
echo "Current working folder is $PWD"


#echo list all files in current log
#find . -name "*.LOG" | xargs -i echo " {} "


declare -i iFileID
declare -i iFileIDMax
declare FORMAT_FILE_PROCESSING

iFileID=1
iFileIDMax=1000
iFileIDMax=50
FORMAT_FILE_PROCESSING="%d  file %s \n"

#echo $FORMAT_FILE_PROCESSING

#list earliest top N LOG files
find . -name "*.LOG" 2> /dev/null  | sort | head -n $iFileIDMax  | while  IFS="" read name;
do



     printf "$FORMAT_FILE_PROCESSING" $iFileID  $name

     iFileID=$((iFileID+1));

     if [ $iFileID  -gt  $iFileIDMax ]
      then


        break;

     fi


done

 

 

Dedicated

Dedicated to ….

The Electronic Toolbox
Argument list too long when copying/deleting/moving files on Linux
Link

Summary

When needing to list files by date, one can use the ls command,

In cases where there are numerous files, the type of filtering one can do is hampered by the fact that the ls command tries to accept all the files as a batch.

A good workaround is the find command.

 

Next Up

The error that I really need to fix was the one from running “gzip S066*”

Image

Textual

bash: /usr/bin/gzip: Argument list too long

 

I know it has something to do with 666

 

Reference

  1. Error – Argument list too long …
    • The Electronic Toolbox
      • Argument list too long
        Link
  2. ls command
    • TheGeekStuff.com
      • Linux ls command examples
        Linux
    •  linuxcommand.org
  3. Find Command
    • Unix.com
      • While loop, input from find command
        Link
    • StackOverflow.com
      • Display modified datetime with Find Command
        Link
    • unix.stackexchange.com
      • Only find first few matched files using find
        Link
    • Superuser.com
      • How can I find the oldest file in a directory tree
        Link
  4. Loop Control
    • The Linux Documentation Project ( tldp.org )
    • LinuxCommand.org
      • Flow Control – Part 3
        Link
  5. If Command
    • TheGeekStuff.com
      • Bash If Statement Examples ( If then fi, If then else fi, If elif else fi, Nested if )
        Link
  6. Math
    • K-State Polythecnic
      • Math in Shell Script
        Link
  7.  printf
    • Linuxconfig.org
      • Bash printf basic commands
        Link
    • Bash Hackers wiki
      • The printf command
        Link
    • Unix.StackExchange.org
      • Printf formatting with variable format – what does this var reference?
        Link
  8. variables
    • Ryan

 

Change Prompt in Bash

Daniel Adeniji Linux, Prompt ( Bash ), Scripting, Scripting - Bash

Background

For us that like to journal and keep notes of every command we issue and capture screens, having long prompts get in the way a bit.

Especially, when you get an incident and pick up that phone and  it says one of the DB/2 hosts is running out of Log space again.

And, the best you can do is say that if it is only at 90% it can likely suffer till the morning.

 

Current Prompt

To get the current prompt issue “echo $PS1”

Image

Text

\u@\h:\w>

Revised Prompt

Let us rid ourselves of all the clutter by dropping all three; username, machine name and the current working directory are all out of here.

SESSION


export PS1='>'

 

Permanently

To make the change permanently, please edit ~/profile in your editor of choice and add same line.


					

		
		
	




			
				


	

		

					
SSH Connection to Linux Over Active Directory and Centrify

								

								 Daniel Adeniji
															Centrify, Identity Access management, Linux, Putty, SSH, Technical					
												

					


				

			
Background


Need to start providing On call support to  some of our DB Servers that are running on Linux Hosts.


Being able to ssh to the boxes is essential.


 


Downloading


Downloaded Putty from here.




Usage


Putty


Connection Attempt


Launched Putty.exe, thanks goodness no installation needed.


The Putty Screen is very minimal:


    

  1. Host Name or IP address

      

    • xxxx01
      • 

    

    2. 

  2. Port

      

    1. 22
      2. 

    

    3. 



 


session


 


Connection Attempt


Image


accessdenied


Textual



Using keyboard-interactive authentication.
Password :
Access denied





Active Directory


To do


Have your Active Directory support group add you to the impacted AD Group


 


Validate


DOS


Script


Syntax


net group [ADgroup] /domain



Sample


net group grpLinuxDBA /domain



 


Output


netgroup_20161208_0320pm


Centrify


Have Centrify Administrators do the following:


    

  1. Create an account for you
    2. 

  2. Add you to an existing group that has access to the Linux DB Hosts
    3. 

  3. Grant explicit sudo access  to created account or inherit from group membership
    4. 



BTW, the Centrify product that we use is listed here.


 


 


 

					

		
		
	




			
				


	

		

					
CentOS – Blank Screen – No Login

								

								 Daniel Adeniji
															CentOS, GRUB, Redhat					
												

					


				

			
Background


Yesterday, I installed CentOS v7 on a refurbished box.  I went the “Server with GUI” option, but upon starting up for the first time, the usual login screen is not coming up.


I have a dull blank screen, rather than one that lists my username.


Remediation


Idea


Took to the net and found a few people had similar problems.  The most widely promulgated option is to edit the /etc/default/grub configuration file and look for the “GRUB_CMDLINE_LINUX” entry.


And, go on to add “video=LVDS-1:d” to the end of the current contents of the entry.


Steps


Outline


    

  1. Access Terminal window via pressing the key combination CTRL-ALT-F2
    2. 

  2. Login from the terminal by entering the username and password
    3. 

  3. The configuration file /etc/default/grub is read only and so change the file to writable
    4. 

  4. Edit in vi or your choice editor as sudo

      

    • Look for the “GRUB_CMDLINE_LINUX” entry and add “video=LVDS-1:d” to the end of the current value.
      • 

    

    5. 

  5. Reconfigure using grub2-mkconfig
    6. 

  6. Reboot your computer
    7. 



 


Details


Here are the steps in detail.


CTRL-ALT-F2


Access Terminal mode by pressing the key combination CTRL-ALT-F2.  The Terminal Screen should appear.


 


Logging from the Terminal


Logging from the Terminal by entering your username and password.


 


Launch vi in sudo mode



sudo vi /etc/default/grub




 


Edit /etc/default/grub


Add ” video=LVDS-1:d“


Before


grub-20160813-1143PM ( Before )


Add


grub-20160813-1146PM ( Before)


Reconfig Grub



sudo grub2-mkconfig -o /boot/grub2/grub.cfg



Reboot


reboot



Credit


No original thoughts here!


Credits go out to the guys ( scubastevesama) who spoke about it on Reddit.


And, the ones ( Josef Holland ) who blogged about it.


References


CentOS Login Screen


    

  1. centos 7 installation issue, no login screen – scubastevesama
    
Link
    2. 

  2. Josef Holland – Disable Laptop LCD Completely on boot
    
Link
    3. 

  3. [RESOLVED] Atom D510 – 6.0 updated to 6.1 – became confused about monitor configuration
    
Link
    4. 

  4. Install on a laptop with external monitor only
    
Link
    5. 



 


Editing /etc/default/grub


    

  1. Amanda Folson – Modify File Permissions with chmod
    
Link
    2. 

  2. I need to change the Read Only in gedit to Read/Write
    
Link
    3.