SAS Add-in - Connection to server error

Problem-Connection to server (port Combridge)

Software:

AMO BisPro Reports

Problem: 

A Connection problem that was a one time problem.

Error:

From: Ginger
Sent: Wednesday, March 07, 2012 8:47 AM
To: Alejandro
Subject: Exception this morning Got this error message this morning when opening my last saved report that I did yesterday …. SAS.BI.AuthenticationService.ClientUserContext.UserContextException: Could not establish a connection to the SAS server on the requested machine.  Verify that the SAS server has been started with the -objectserver option or that the SAS spawner has been started.  Verify that the port Combridge is attempting to connect to is the same as the port SAS (or the spawner) is listening on.   ---> System.Runtime.InteropServices.COMException (0x80042002): <connectionAttempts>       <connectionAttempt>              <description>Could not establish a connection to the SAS server on the requested machine.  Verify that the SAS server has been started with the -objectserver option or that the SAS spawner has been started.  Verify that the port Combridge is attempting to connect to is the same as the port SAS (or the spawner) is listening on.</description>              <status>0x8004274c</status>              <saslogin>tpwd\gmcgough</saslogin>              <sasmachinednsname>tpwd-aav-sas.tpwd.state.tx.us</sasmachinednsname>              <sasport>8561</sasport>              <sasclassid>0217E202-B560-11DB-AD91-001083FF6836</sasclassid>              <sasprogid>SASOMI.OMI.1.0</sasprogid>              <threadid>2828</threadid>       </connectionAttempt></connectionAttempts>   at SASObjectManager.ObjectFactoryMulti2Class.CreateOMRConnection(ServerDef ServerDef, String username, String Password)   at SAS.BI.AuthenticationService.ClientUserContext.UserContext.MakeOMRConnection(Boolean bUseDefaultConnection)   --- End of inner exception stack trace ---   at SAS.BI.AuthenticationService.ClientUserContext.UserContext.HandleCOMException(COMException e)   at SAS.BI.AuthenticationService.ClientUserContext.UserContext.MakeOMRConnection(Boolean bUseDefaultConnection)   at SAS.BI.AuthenticationService.ClientUserContext.UserContext.SetOmrUri(Uri uri, Login login)   at SAS.EG.SDS.Model.UserContextWrapper..ctor(Broker broker)   at SAS.EG.SDS.Model.Broker.get_UserContext()   at SAS.Shared.InformationMaps.Helpers.PromptValuesFromXml(String valuesXml)   at SAS.OfficeAddin.SasDataSource.ReadInformationMapXml(String infomapXml)   at SAS.OfficeAddin.SasDataSource..ctor(String xml)   at SAS.OfficeAddin.PivotTable.SetState(NameValueCollection state)   at SAS.OfficeAddin.OfficeAddinBase.TrySetJobStateWithDefaultHandlers(IRunnable job, NameValueCollection state)   at SAS.OfficeAddin.ExcelAddin.CreateAndInitializePivotTableRunnable(ContentInfo contentInfo, JobContext& context)   at SAS.OfficeAddin.ExcelAddin.PerformCalculatedItemOperation(ContentInfo contentInfo, CalculatedItemOperations operation)   at SAS.OfficeAddin.ExcelAddin.OnWorkbookOpen(Workbook book)   at SAS.ExcelAddIn.VstoExcelAddIn.OnWorkbookOpen(Workbook Wb)   GINGER MCGOUGHRegion 1 HQ.PO Box 1079Fort Davis, TX  79734432-426-3533, x-223432-426-3149 (fax) 

Discussion: 

Links below are some info.  Did not pursue further because it was a one time problem.

http://support.sas.com/kb/18/297.html

http://support.sas.com/kb/13/268.html

http://support.sas.com/techsup/technote/ts790.pdf

Fix:

DataFlux Result codes from matching

US Result Code - Indicates whether the address was successfully verified. In case the address was not successfully verified, a US Return Code indicates the cause of address verification failure, as shown in the following table:

Text Result Code	Numeric Result Code	Description
OK	0	Address was verified successfully.
PARSE	11	Error parsing address. Components of the address might be missing.
CITY	12	Could not locate city/state or zip in the USPS database. At least (city and state) or ZIP must be present in the input.
MULTI	13	Ambiguous address. There were two or more possible matches for this address with different data.
NOMATCH	14	No matching address found in the USPS data.
OVER	15	One or more input strings is too long (maximum 100 characters).

US Numeric Result Code Contains the numeric result to the US Result Code field. See the Numeric Result Code column above for additional information.

_____________________________________________________________________

Dan Strickland - SAS Platform Adminstrator -512.666.4546_IF/Reg1__________
Texas Parks and Wildlife Department, 3407 S Chadbourne, San Angelo, TX 76903 danwstrickland@gmail.com 

How to FTP a file to SAS Help

How to Drop Off Data:

Planning to transfer a large file? If so, then please read this paragraph before you proceed. The length of time that it takes to transfer data depends on the amount of data and the robustness of your network connection to the FTP site. The larger the file and/or the slower the connection, the more likely an interruption can occur that will result in incomplete or corrupt data. If the amount of data that you would like to transfer exceeds 2GB, then you should consider placing it on media such as CD or tape and mailing it to the SAS employee. If that is not a viable option, then please notify the SAS employee so that other arrangements can be made with the SAS IT division to transfer the data. (The size of the data is not necessarily limited to 2GB; however, 2GB should be considered a general limit at which it becomes more likely that problems will occur during the transfer process.)

 

1.     Right-click the 'Start' button and select 'Open Windows Explorer' from the menu that appears.

A Windows Explorer window similar to the following screen capture will appear.

2.     Replace whatever appears in the 'Address' field with the following URL —

ftp://ftp.sas.com/incoming

— and then press the 'Enter' key.




The SAS FTP 'incoming' directory will appear to be completely empty, which is normal. (For security reasons, the contents are hidden.)

3.     Keep the 'incoming' directory window open, but set it aside for a moment.

4.     If the file that you would like to transfer to the SAS employee is located on the desktop of your PC, then you can proceed to step #5; otherwise, open a second Windows Explorer window and navigate to the location of the file that you would like to transfer to the SAS employee.

5.     Drag and drop (or copy and paste) the file from its current location (the desktop of your PC or the second Windows Explorer window) into the 'incoming' directory window.

That is all there is to it!

Please read the following important notes:

·         The file that you copied into the 'incoming' directory window will be visible only to you and only until you refresh the window. Once you refresh the window, the file will become invisible to you, as well.

·         The file will be available for the SAS employee to pick up within 30 minutes. The SAS employee should allow 30 minutes for the file to become available.

Age & Growth Test on Windows 7 (problem)

You may have problems getting your Age & Growth .mov files to work on your new Windows 7 machines.  To get the file to work you will need the Quicktime player installed on your machine.  The current reader version is 7.7.2(1680.56). I used IE 8 to download the software.  The Quicktime plug-in will not help you so don't install it.  The following link will get you to the website that has the correct player for you. If you are not on the wan please VPN before clicking this link.
https://gofish.tpwd.state.tx.us/FishNET/Apps/Age/Default.aspx



Click Download Quicktime

Uncheck the Keep me up to date box.  Click Download Now.

Click Run

Choose the defaults on the subsequent screens.  The only box I unchecked was dealing with automatically updating all my Apple software.  That box I left unchecked.

Once the install is successful to open a .mov file right click on the file in windows explorer and choose quicktime to open the file.  You may get a window asking you to associate .mov files with quicktime and choose yes.

It now works on my windows 7 machine.  As a note I did not have any versions of quicktime installed on my machine.  If these instructions don't work you may want to uninstall quicktime, reboot, and go thru these instructions again.  If you have any problems please call me.

Dan

Problem 1:

If you get the following error try below:

Install all quicktime, itunes, or any other apple software.

Download and install the software from the following link:

Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package ATL Security Update

http://www.microsoft.com/downloads/details.aspx?familyid=766a6af7-ec73-40ff-b072 -9112bab119c2&displaylang=en#filelist

Download for 32bit machines this file vcredist_x86.exe.

Reinstall Quicktime and other apple software.

Problem 2:

If during the install the installation hangs on "Publishing Product Information" then the following link may help to resolve this problem.

https://discussions.apple.com/thread/2361274?start=0&tstart=0

Problem 3:

There are times that reason you are having problems with the quicktime install is because you have had some Microsoft Windows updates failed to install properly.  If this has happened call the help desk for help on correcting these failed updates.  Some of these updates can cause additional problems which will cause you more problems with will cause you to have to reformat your computer.  Please back up all data before calling the help desk.

Last Effort Fix:

Right click on the quicktime player that was emailed to you originally and choose properties.  Then choose the Compatibility tab.  Within that tab select the Compatibility mode "Run this program in compatibilitiy mode for:"  then select Windows XP.  Apply then OK.  Know test your mov file to see if it will work.

Thanks,

Dan

Creel Zipcode Error

Sometimes when you run a creel zipcode report from the SAS Portal you may get an error.  Here is something to check before you call me to look into your error.  On the main Creel tab there is a SAS program called "SP_CreelLakes".  Double click on that stored process.

Once you double click the link a report will open up in a new window that will show which lakes have been creeled along with their creeled dates and if the schedule has been verified. 

Make sure the zipcode report you are running contain the correct begin end date without any skip quarters. Also, you should be able to run a report on a unverified quarter.  This will allow you to check for data errors.

Please call me if this does not fix your error.

Thank you,

Dan 

How to register for a Free Skype Account

I wanted to take a few minutes to share a tool I use daily to get me job done at TPWD.  Some of you may be already using skype for you phone calls and if you are that is great.  If you are not then look below and I will take you through the registration process so you can get started in making Free calls with skype.

Skype free calls are only from one registered skype user to another registered skype user.  You can make as many calls as you like and talk as long as you want.  This works great for long distance calls and also out of country calls. It cost nothing to use this type of service.   If you want to call someone on a cell phone or land line then you will need a skype subscription.  I have the subscription to US and Canada which allows me to call anyone in the US or Canada for on $2.99 flat fee per month. You can also choose a "by the minute" type usage.  I use skype at work all the time with my headset (In fact I am using right now while I create this blog.)  Using monthly subscripton, Skype just deducts if from my credit card each month.  You can also create a phone book for ease of calling that contains not only registered skype users but non-registered users.  I have also downloaded the skype software to my android phone so I can make wifi calls from my cell phone using skype.  All this for only $2.99 a month.

If you would like to receive calls through skype, I caught a special of $30 (regularly $60) a year which gets you a telephone number where people can call you and it will ring your skype cell phone or your computer.  My current cell phone is a wifi only cell phone so for $66 a year I have a wifi only cell phone.  It has been a great way for me to cut my cell phone bill.

Once you have installed skype make sure that it is loaded as a service.  In the your task manager you should have an image of a green cloud with a white check box in it.  Also it is helpful if you allow skype to load as a add-on to your web browser.  This will allow phone numbers that are displayed on webpages to be clickable and dialed from skype.  Next month I will talk about my google voice number and how I use it with my skype phone.

Skype Registration

click on "join skype" in the top left corner.

Fill out the required fields.  In the question that asks "How do you intend to use Skype" select mostly personal conversations.  Click I agree - Continue when done.

Choose Not now, Thanks then hit continue.

A new window should open up with download informtion.  Follow the steps on the screen by choosing run to complete and log into skype.  

Once you have logged into skype click Tools - Options to modify options to fit your preferences.

If you have any questions please let me know.

Dan

SAS Software Depot

Wow.  Have I learned my lesson.  We had ordered a new SAS access to Oracle provide from SAS.  They  sent the software and I decided to load it on the SAS server from the SAS DVD's they sent me.  Sounds like the right way to go doesn't.  So that is what I did.  It was 5 DVD to be loaded onto our Virtual server and it was going to take some time to do it.  How Should I have loaded that software?

 Now I know I should have go into the SAS Deployment Wizard and Add to my current SAS Depot the new software.  That will update all the files correctly in the SAS Software Depot.  Then I can install the software from the Depot and everything works like it should.  How did I find out about this.  I tried to reload some SAS software from my Depot and the SAS system saw that the order number I was currently using was not in the SAS Depot.  Hence the problem. I also understand that I need to put the SID files for license renewals also in the SAS Depot.

On another note I tried installing some Webtier hotfixes and ran into the same problem.  Valuable lesson learned.  This SAS note helped me with that install.  http://support.sas.com/kb/40/396.html

_____________________________________________________________________

Dan Strickland - SAS Platform Adminstrator -512.666.4546_IF/Reg1__________
Texas Parks and Wildlife Department, 3407 S Chadbourne, San Angelo, TX 76903 danwstrickland@gmail.com