Case of the SAP ‘Do you want to open or save tx.sapssd?’ on IE9

Having in the past week passed all my usual tests for web browsing IE9 was sent off to users for UAT (my confidence was pretty strong as that group included my management and general managers Winking smile ). Yet I wasn’t surprised to find something in SAP was broken, because advanced SAP users always break something. Until the day my dream of eliminating SAP GUI becomes a reality I had to fix the issue. The component that was broken was advanced reporting functions that hook into the SAP GUI. Although this worked fine in IE8 on IE9 users were receiving a message “Do you want to open or save tx.sapssd from sap url?

image

A quick search of this prompt found many people experiencing this same issue on earlier versions of IE when file registration was configured for the extension .sapssd. There was no file registration information for this extension, and re-installing SAP GUI didn’t make the error go away. So I wondered what is the IE8 and IE9 version doing differently?

To do this i went to my all time favourite tool ProcMon (http://live.sysinternals.com/ProcMon.exe) and set a filter where “Path” Contains “.sapssd”

image

I just refreshed the page and did not click Open Save or Cancel and looked at the ProcMon log. What I notice

1) The file gets created in the temporary cache area

2) HKCR\.sapssd and HKCU\.sapssd are both checked to see if file extension is registered, but it is not

3) The registry entry HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.sapssd is created (not shown in below screenshot)

4) After that pretty much nothing exciting happens, even if you click Open you just get prompted what app to open it with

 

 

image

I then launched a ThinApp’ed (http://www.vmware.com/products/thinapp/overview.html)  instance of IE8  on the same machine to compare the difference:

The launch was almost exactly the same, except this time the key HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.sapssd did not get recreated

image

Importantly we got to a point where SAP GUI was launched:

image

With the first instance of saplogon.exe selected I then reset my ProcMon filter using Ctrl+R so I could work back to find out how IE new to load saplogon.exe:

Actually I had a lot of events to go through, I just wanted to get to start of saplogon.exe so I hit Ctrl+T to bring up Process Tree, then found saplogon.exe and clicked ‘Go To Event’ This took me to the Process Start even for the process.

image 

At this point I just wanted to find the Internet Explorer events again so I right clicked Internet Explorer and chose include

image

I scrolled up through a few pages of events until I saw what I was looking for. A CLSID entry – this can trigger the app to launch. Right clicking the Registry Value I used the “Jump To” option to take me straight there…

image

An export of this key demonstrated this was what I wanted to launch. The key is included below for the benefit of anyone who ever has SAP nightmares again. But in this case the value I looked at here was the default value for CLSID\{83658045-6571-3232-7082-797884697869}\ProgID which gave me SAPFront.App I then also found and exported HKCR\SAPFront.App

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}]
“SapCreateKey”=dword:00000000
@=”SAP Logon Application”

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\AuxUserType]
“SapCreateKey”=dword:00000000

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\AuxUserType\2]
“SapCreateKey”=dword:00000000
@=”SAP Logon”

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\AuxUserType\3]
“SapCreateKey”=dword:00000000
@=”saplogon”

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\DefaultExtension]
“SapCreateKey”=dword:00000000
@=”.gui, Filetype (*.gui)”

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\DefaultIcon]
“SapCreateKey”=dword:00000000
@=”\”C:\\Program Files\\SAP\\FrontEnd\\Sapgui\\saplogon.exe\”,0″

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\DocObject]
“SapCreateKey”=dword:00000000
@=”0″

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\InprocHandler32]
“SapCreateKey”=dword:00000000
@=”ole32.dll”

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\Insertable]
“SapCreateKey”=dword:00000000
@=””

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\LocalServer32]
“SapCreateKey”=dword:00000000
@=”\”C:\\Program Files\\SAP\\FrontEnd\\Sapgui\\saplogon.exe\” /Inplace”

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\MiscStatus]
“SapCreateKey”=dword:00000000
@=”32″

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\Printable]
“SapCreateKey”=dword:00000000
@=””

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\ProgID]
“SapCreateKey”=dword:00000000
@=”SAPFront.App”

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\Verb]
“SapCreateKey”=dword:00000000

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\Verb]
“SapCreateKey”=dword:00000000
@=”&Edit,0,2″

[HKEY_CLASSES_ROOT\CLSID\{83658045-6571-3232-7082-797884697869}\Verb\1]
“SapCreateKey”=dword:00000000
@=”&Open,0,2″

; SapFront.App

[HKEY_CLASSES_ROOT\SapFront.App]
“SapCreateKey”=dword:00000000
@=”SAP Logon Application”
“EditFlags”=hex:00,00,01,00

[HKEY_CLASSES_ROOT\SapFront.App\CLSID]
“SapCreateKey”=dword:00000000
@=”{83658045-6571-3232-7082-797884697869}”

[HKEY_CLASSES_ROOT\SapFront.App\DocObject]
“SapCreateKey”=dword:00000000
@=”0″

[HKEY_CLASSES_ROOT\SapFront.App\Insertable]
“SapCreateKey”=dword:00000000
@=””

[HKEY_CLASSES_ROOT\SapFront.App\protocol]
“SapCreateKey”=dword:00000000

[HKEY_CLASSES_ROOT\SapFront.App\protocol\StdFileEditing]
“SapCreateKey”=dword:00000000

[HKEY_CLASSES_ROOT\SapFront.App\protocol\StdFileEditing\server]
“SapCreateKey”=dword:00000000
@=”\”C:\\Program Files\\SAP\\FrontEnd\\Sapgui\\saplogon.exe\””

[HKEY_CLASSES_ROOT\SapFront.App\protocol\StdFileEditing\verb]
“SapCreateKey”=dword:00000000

[HKEY_CLASSES_ROOT\SapFront.App\protocol\StdFileEditing\verb]
“SapCreateKey”=dword:00000000
@=”&Edit”

 

~

OK but the strange part is – these keys exist on the machine with IE9? Why aren’t the working? This time I went back to Ie9 and hit F12 to bring up the most wonderful developer toolbar I’ve ever found in a browser. On the Network tab I hit Start

What do we find here…HOW AWESOME IS THIS INFORMATION? I don’t have to go and download & install Fiddler for some basic analysis. Great. This file it’s trying to download has a fancy MIME type application/vnd.sap-gui

image

I then went back to ProcMon and hit Ctrl+F to search on application/vnd.sap-gui

Sure enough Internet Explorer 9 had looked for it but come up short:

image

I created the following registry key to register the MIME type to the CLSID I had found earlier:

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\MIME\Database\Content Type\application/vnd.sap-gui]
“CLSID”=”{83658045-6571-3232-7082-797884697869}”

After adding this key I immediately refreshed IE9 without restarting:

and instantly SAP menu is back alive & kicking

image

The best part, all done without reverting my UAT user back to IE8. Despite the “end of financial year pressure” (We operate on Japanese financial new year, so  the end is two days away) Smile I hate to go backwards…

About chentiangemalc

specializes in end-user computing technologies. disclaimer 1) use at your own risk. test any solution in your environment. if you do not understand the impact/consequences of what you're doing please stop, and ask advice from somebody who does. 2) views are my own at the time of posting and do not necessarily represent my current view or the view of my employer and family members/relatives. 3) over the years Microsoft/Citrix/VMWare have given me a few free shirts, pens, paper notebooks/etc. despite these gifts i will try to remain unbiased.
This entry was posted in Internet Explorer, ProcMon and tagged . Bookmark the permalink.

34 Responses to Case of the SAP ‘Do you want to open or save tx.sapssd?’ on IE9

  1. Scott says:

    Thank you. Thank you. Thank you. This saved me hours of research and worked first time.

    Any idea what IE9 did that broke it in the first place? I can’t believe that IE9’s install would have mucked with those registry entries.

    • I don’t believe IE9 trashed the reg key, it was not required for previous versions of IE. I believe this is increased security in IE9 as it verifies MIME types downloaded against registered applications. I think in earlier versions of IE this was always recommended practice but wasn’t enforced.

  2. Robin Schmidt says:

    Awesome, thankyou for this!!! I searched SAP’s OSS site and sdn.sap.com and couldn’t find any solutions so I’m very happy to find this solution.

    I found that I have to have the sapgui running already in order for this to work though. If it’s not already running on the PC then I still get the prompt to save the file.

    Thanks again,
    Robin

    • You need SAP GUI installed but you shouldn’t need it running. What version of SAP GUI are you using?

      First step would be to make sure no file registrations exist by removing the following keys if the exist:

      HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.sapssd
      HKCR\.sapssd
      HKCU\.sapssd

      In particular the top one, which will get created automatically if you have tried opening these files without the MIME type fix.

      If you still get the problem after that let me know.

  3. Robin Schmidt says:

    Hey thanks for the reply.

    I’m running 7200.2.5.1057, build 1230744, patch level 5.

    If I don’t have saplogon running then I get the prompt that says ‘Do you want to save tx.sapssd from xxxx.xx.xx’ and it only has the option to Save or Cancel.

    If I have saplogon running already then it opens up the SAP session fine.

    I’ve now deleted the entries that you specified above and have verified that I no longer have any .sapssd related entries in the registry. Still the same issue, any other ideas?

    Thanks for your help.

    Regards,
    Robin

  4. mag says:

    Thank you so much. It all worked perfectly after following your very well layed out explanation. Top Marks to you. I picked up some additional info on using ProcMon more thoroughly, and the IE9 info on the developer toolbar.
    Regards,
    Mag.

  5. Marcel says:

    Wow. That is briljant! Very cool to read how you troubleshot the problem. And it works like a charm.

    Marcel

  6. Pingback: Case of the IE8 Download Opening with Wrong Application | chentiangemalc

  7. michael lee says:

    thanks!

    michael

  8. Robin Schmidt says:

    Just a quick FYI – SAP has released a note on this now:
    Note 1592282 – SAP EP / NWBC: starting SAP GUI via SSD iView on IE9 failed

    Thanks for your previous help!

    Regards,
    Robin

  9. Lee says:

    Thank you for your good information.
    In my case, it did not work. Is it because I am using 64bit windows 7 with IE9 ?

    When I searched in my registry, there is no information about the class-id: 83658045-6571-3232-7082-797884697869 under the key “HKCR\CLSID\”, but I could see the ID under “HKCR\SapFront.App\CLSID” & “HKCR\Wow6432Node\CLSID\” only.

    Do I have to register more information except what you taught ?
    [HKEY_CLASSES_ROOT\MIME\Database\Content Type\application/vnd.sap-gui]
    “CLSID”=”{83658045-6571-3232-7082-797884697869}”

  10. Ricardo Aponte says:

    Thank you for your research and fix! Great work

  11. Sonny Nguyen says:

    THANK YOU! you are the man ;)

  12. steve says:

    Hi, I am having a similar problem with tx.sap, through win 7 ie9. we are using the sap portal to login. using your excellent guidance, it looks to be using application/x-sapshortcut with the same clsid above. I put the entry in the registry which changed the behaviour a bit. i now get a popup window asking me to open, save or cancel, then after saying open, it continues with the do yo u want to open tx.sap bar at the bottom as before but without the open option. any thoughts on what i could try. cheers

    • 1) Make sure HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.sapssd does not exist already
      2) if you copy/pasted the reg file from my site i just realized web press has messed up my quotes, re-type those quotes as straight-down quotes.

      also what version of SAP are you using?

      If you run http://live.sysinternals.com/ProcMon.exe and filter on IExplore.exe you need to look for file extension registrations / or CLSID registry queries just before you get the do you want to open or save prompt? If those are missing…then you may have a problem.

      I would also try applying my fix on machine which nobody has yet launched SAP. If this works then it is likely some other key got created (like the HKU one mentioned above causing the problem)

  13. Moeketsi says:

    What a solution … You save me a lot of time.

  14. trsisko says:

    We get this save this file when users try to print from the internet portal for sap 7.20 on windows 7 and i think it asks to launch excel viewer to print what the users are working on in sap via the portal.

  15. Mike Powell says:

    Thanks for the great post — I actually got here looking for something else but read the whole article once the ProcMon tips started flowing! Great info on using that tool more effectively.

  16. Thanx , you saved my time…

  17. Kyle says:

    chentiangemalc –

    I want to preface this message with, I am not a developer, but an IT professional trying to deploy SAP 7.20 on Windows 2008 Server R2 (64 bit), Office 2010 (32 bit), via Citrix XenApp. Here’s my issue. The company uses the Enterprise Portal to launch SAP and all of its components. If you launch any of the SAP components devoid of the portal, everything works as expected. If you launch them via the Enterprise Portal, nothing works as expected. Some components may launch, but do not operate properly. If you launch SAP GUI from the portal link, and do a Help, about, system information, it shows Windows 2000. From the same server, if you launch the SAPLOGON.EXE by itself, help, about, system info, it shows Windows 2008. I dont understand where its pulling this. One component in question is BEx Analyzer/Reporter. If you launch it by itself, works fine. If you launch it via the portal, comes up with an error stating “The Operating System is not configured to run this application”. This is a very generic error, and since I am not a SAP developer, its like finding a needle in a haystack. All the issues seem to be the SAP Enterprise Portal and I am out of ideas. I appreciate any assistance you can provide.

    Thanks,

    Kyle

    • If you have SAP support account you should refer to this article for known issues on SAP & Citrix deployment https://service.sap.com/sap/support/notes/0000138869?nlang=E

      as well as these Citrix Knowledge bases

      http://support.citrix.com/article/CTX127399
      http://support.citrix.com/article/CTX126941

      When running under SAP GUI under Portal or from the server directly are you using the same user account in both cases? Typically an application would report an older version OS if it was running in compatibility mode.

      If none of these help…If you are able to run ProcMon on the server (but should be careful as it may impact performance while running) you can capture the ProcMon of when it works & when it doesn’t work. From that you may get clues as to why it’s not working. If you get the logs and can’t see anything obvious drop me a msg here and I’ll give you a location to upload the logs and I’ll take a look

      regs

      malcolm.

  18. Rose says:

    Wow, you ROCK!

  19. Khan says:

    Hi,

    I am working as support engineer for a large enterprise, we are in a test phase of IE9. some of the users testing ie9 has encountered ‘Do you want to open or save tx.sapssd’… i checked for the file association but i didn’t find the file type ‘.sapssd’ in the default programs. SAP Version – final Release 7.10 | Version 7100.4.16.3151. I am quite confused whether to do the registry changes you have recommended since your version 7.20. If possible please cut me the required keys i should add again.

    thanks
    khan

    • I don’t know the reg keys for 7.10 – but you can use Process Monitor as described in this article to identify what MIME key it is looking for /etc. As I describe “How” I found the solution you could apply the same process to other versions or other applications. However version 7.10 was not designed for Windows 7 and you will probably find even more issues down the track. Windows 7 & Microsoft Office 2010 support was added in 7.20. Also as of April 2011 SAP GUI version 7.10 went out of support, SAP’s advice is to upgrade as soon as possible. Refer to http://www.sdn.sap.com/irj/sdn/sap-gui

      • Khan says:

        Thanks for the quick response, we are in a process of upgrading to 7.20, however it takes some time due to large no. of users (55000). We are still on Vista and might directly move to win 8 (after service pack 1 releases) I have gone through your procmon procedure and the keys are the same.

        Many thanks
        Khan

  20. Newzi says:

    you save my life,thank you very much,so i can use windows 7 sp1 with ie9;

    thanks again from Jiangsu China

  21. sapbasisnwadmin says:

    Hi, I have no issue with “tx.sapssd” file autodownload with IE9, “tx.sapssd” is being used if you want to have SAPGUI opened inside the SAP Portal iView, whereas “tx.sap” file will trigger the BW Report (BEX) from SAP Portal and still have the IE9 message “Save/Save as / Cancel” download message.

  22. Alex says:

    This is great ! ! ! thanks for doing all the work, saving us tons of time. I’ve noticed this solution works for Windows 7 32bit but not for 64bit operating systems… any ideas if there is another registry key I have to change for the 64bit OS?

    Thank you,

    Alex

  23. dd says:

    Works 100% Win7x64 IE9

  24. Ed says:

    once i changed the quotes… IT WORKS!!!! thank you so much

  25. Giuseppe says:

    Great! it worked for me as well! I created the KEY

    [HKEY_CLASSES_ROOT\MIME\Database\Content Type\application/vnd.sap-gui]
    “CLSID”=”{83658045-6571-3232-7082-797884697869}”

  26. SolarFox says:

    Worked for me too. Win7 x32 IE 11
    Thanx!! :)

Leave a reply to Mike Powell Cancel reply