Thursday, March 14, 2013

SAS Add-In 4.3 Microsoft Office unexpected exception error

Error:
 System.ArgumentException: Input string is not in valid format for decryption
   at SAS.Shared.SASCrypt.Decrypt(String inString)
   at SAS.OfficeAddin.Options.OptionsCore.LoadSmtpPassword()
   at SAS.OfficeAddin.Options.OptionsCore.Read(String fileName)
   at SAS.OfficeAddin.Options.OptionsCore.Load()
   at SAS.OfficeAddin.Options.OptionsGeneral..ctor()
   at SAS.OfficeAddin.OfficeAddinBase..ctor(Object application)
   at SAS.OfficeAddin.ExcelAddin..ctor(Object application)
   at SAS.OfficeAddin.OfficeAddinBase.Create(Object application, ScriptInterface scriptInterface)
   at SAS.OfficeAddin.Connect.CreateAddIn()
   at SAS.ExcelAddIn.VstoExcelAddIn.CreateAddIn()

To correct the problem, rename or remove the Smtpspa file. It will be re-created the next time that the add-in is loaded into Microsoft Office. In the Windows XP operating environment, the Smtpspa file is located in the following location:
C:\Documents and Settings\userid\Application Data\Add-InForMicrosoftOffice\4.3

In the Windows 7 operating environment, the Smtpspa file is located in the following location:
C:\Users\userid\AppData\Roaming\SAS\Add-InForMicrosoftOffice\4.3

SAS had this possible fix documented at:  http://support.sas.com/kb/41/948.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 

No comments:

Post a Comment