http://bugs.winehq.org/show_bug.cgi?id=20675
Summary: Excel 2007 Analysis Services -- no network activity at all Product: Wine Version: 1.1.32 Platform: PC OS/Version: Linux Status: UNCONFIRMED Severity: normal Priority: P2 Component: -unknown AssignedTo: wine-bugs@winehq.org ReportedBy: imirkin@alum.mit.edu
I'm running into an issue with the Analysis Services module (aka OLAP) in Excel 2007.
It presents me with a screen that asks for the server name (and asks for auth types), and then proceeds to fail-fast to a generic error:
""" Unable to connect to data source. Reason: Unable to locate database server. Verify that the database server name you entered is correct, or contact the database administrator for help. """
However doing a network trace, no packets ever go out the external interface.
Relevant bits from +relay,trace+reg (note that I added an extra TRACE to RegQueryValueW that prints out the data that it returns):
""" 0009:Call advapi32.RegQueryValueW(80000000,0032d3bc L"MSOLAP\Clsid",0032d3bc,00 32d3b8) ret=326c46e5 trace:reg:RegQueryValueW (0x80000000,L"MSOLAP\Clsid",0x32d3bc,512) trace:reg:NtOpenKey (0x13c,L"MSOLAP\Clsid",f003f,0x32d2f8) trace:reg:NtOpenKey <- 0x28c trace:reg:RegQueryValueExW (0x28c,(null),(nil),(nil),0x32d3bc,0x32d3b8=512) trace:reg:NtQueryValueKey (0x28c,(null),2,0x32d1a0,256) trace:reg:RegQueryValueW L"{176941F9-18E8-47D6-860D-006FF2655608}" 0009:Ret advapi32.RegQueryValueW() retval=00000000 ret=326c46e5 0009:Call KERNEL32.FindResourceA(01560000,00000006,000000d9) ret=326155f6 0009:Ret KERNEL32.FindResourceA() retval=0156dd80 ret=326155f6 0009:Call KERNEL32.LoadResource(01560000,0156dd80) ret=32615606 0009:Ret KERNEL32.LoadResource() retval=0158a6f8 ret=32615606 0009:Call KERNEL32.LockResource(0158a6f8) ret=32615615 0009:Ret KERNEL32.LockResource() retval=0158a6f8 ret=32615615 0009:Call KERNEL32.TlsGetValue(00000007) ret=3260568c 0009:Ret KERNEL32.TlsGetValue() retval=00620000 ret=3260568c 0009:Call KERNEL32.TlsGetValue(00000007) ret=3260568c 0009:Ret KERNEL32.TlsGetValue() retval=00620000 ret=3260568c 0009:Call advapi32.RegOpenKeyExW(80000001,00630024 L"Software\Policies\Microsoft\Office\12.0\Common\Alerts",00000000,0002001f,003240c0) ret=3260556d """
And then it goes on to generate the alert. So for some reason it totally fails and doesn't even try to do anything after looking up the registry key.
FWIW, here are a few entries from system.reg:
""" [Software\Classes\MSOLAP\Clsid] 1237579662 @="{176941F9-18E8-47D6-860D-006FF2655608}"
[Software\Classes\CLSID\{176941F9-18E8-47D6-860D-006FF2655608}] 1237579662 @="MSOLAP"
[Software\Classes\CLSID\{176941F9-18E8-47D6-860D-006FF2655608}\InprocServer32] 1237579662 @="C:\Program Files\Common Files\System\ole db\msolap90.dll" "ThreadingModel"="Both" """
I do not see the string "176941F9-18E8-47D6-860D-006FF2655608" anywhere in the trace logs, except as the return value to RegQueryValueW. (But I don't know a whole lot about Windows, perhaps that's to be expected.)
I'm happy to do more debugging here, so any ideas appreciated. I don't appear to have any DLL overrides.
http://bugs.winehq.org/show_bug.cgi?id=20675
--- Comment #1 from Austin English austinenglish@gmail.com 2011-10-02 11:45:39 CDT --- This is your friendly reminder that there has been no bug activity for 1 year. Is this still an issue in current (1.3.29 or newer) wine?
http://bugs.winehq.org/show_bug.cgi?id=20675
--- Comment #2 from imirkin@alum.mit.edu 2011-10-02 22:43:46 CDT --- The error persists, although it appears that now there is some amount of network activity to the analysis services machine. This is with wine-1.3.29. However I still get the same error dialog. I believe that I noticed that it started to do some amount of network activity after a lot of xml and/or inet changes went in at some point in the 1.3 series.
Let me know what would be helpful to provide in order to debug this further. I'm happy to do some heavy-lifting on this bug, since no one else appears interested, but I do need some help/direction since I'm mostly unfamiliar with how Windows works.
I suspect it could be some sort of issue in the auth logic now that the more basic problem of no communications has gone away, although that's just a complete guess. I'm using the direct username/password entry option rather than the Windows Authentication option.
As another data-point, while entering a host seems to generate traffic, if I enter in a URL (e.g. https://host/foo.dll) which is another valid way of accessing this in windows so that it's secure, there is no network traffic and I get the fixme
fixme:winhttp:WinHttpGetIEProxyConfigForCurrentUser returning no proxy used
which doesn't sound all bad, since I don't have a proxy set up.
http://bugs.winehq.org/show_bug.cgi?id=20675
imirkin@alum.mit.edu changed:
What |Removed |Added ---------------------------------------------------------------------------- Version|1.1.32 |1.3.29
http://bugs.winehq.org/show_bug.cgi?id=20675
imirkin@alum.mit.edu changed:
What |Removed |Added ---------------------------------------------------------------------------- Summary|Excel 2007 Analysis |Excel 2007 Analysis |Services -- no network |Services -- unable to |activity at all |connect
http://bugs.winehq.org/show_bug.cgi?id=20675
Dmitry Timoshkov dmitry@baikal.ru changed:
What |Removed |Added ---------------------------------------------------------------------------- Version|1.3.29 |1.1.32
http://bugs.winehq.org/show_bug.cgi?id=20675
--- Comment #3 from Austin English austinenglish@gmail.com 2013-11-13 16:52:32 CST --- This is your friendly reminder that there has been no bug activity for 2 years. Is this still an issue in current (1.7.6 or newer) wine? If so, please attach the terminal output in 1.7.6 (see http://wiki.winehq.org/FAQ#get_log).
http://bugs.winehq.org/show_bug.cgi?id=20675
--- Comment #4 from imirkin@alum.mit.edu 2013-11-14 00:14:20 CST --- Unfortunately I no longer have access to the environment in question, so I can't test the latest version. I believe that back when I did, I had tested many 1.5.x versions without success, although it's possible that the specific cause of the errors has changed.
Feel free to close this, although anyone with Excel and an Analysis Services OLAP cube should be able to test it out easily enough. (The latter bit is the trickier part.)
http://bugs.winehq.org/show_bug.cgi?id=20675
Austin English austinenglish@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution| |ABANDONED
--- Comment #5 from Austin English austinenglish@gmail.com 2013-11-19 03:40:31 CST --- (In reply to comment #4)
Unfortunately I no longer have access to the environment in question, so I can't test the latest version. I believe that back when I did, I had tested many 1.5.x versions without success, although it's possible that the specific cause of the errors has changed.
Feel free to close this, although anyone with Excel and an Analysis Services OLAP cube should be able to test it out easily enough. (The latter bit is the trickier part.)
Since no one else has commented, let's mark it as abandoned. If you get a chance to retest, feel free to reopen.
http://bugs.winehq.org/show_bug.cgi?id=20675
Austin English austinenglish@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED
--- Comment #6 from Austin English austinenglish@gmail.com 2013-11-26 14:56:37 CST --- Closing.
-
wine-bugs＠winehq.org