[Bug 19223] New: null Object reference during Database object expansion (MS SQL SMSE)

http://bugs.winehq.org/show_bug.cgi?id=19223

Summary: null Object reference during Database object expansion
                    (MS SQL SMSE)
           Product: Wine
           Version: 1.1.25
          Platform: PC
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: P2
         Component: -unknown
        AssignedTo: [e-mail]
        ReportedBy: [e-mail]

Created an attachment (id=22225)
 --> (http://bugs.winehq.org/attachment.cgi?id=22225)
Wine log for SSMSEE

Immediately after launching Microsoft's SQL Server Management Studio Express,
an "Object Explorer" pane is visible on the left to explore the connected SQL
server.  Double-clicking on the "Databases" node to expand it produces the
following error message (see below)...

The databases can be acquired using the "Summary" window, and then the "Object
Explorer" pane can be synchronized to the "Summary" window.  Although a
workaround exists, it is clumsy.  Plus, a method so basic as expanding the
connected databases should not create such an error.

Incidentally, the error message is empty at first, and the message can only be
viewed by clicking on the "Show technical details" button in the error log...

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

Object reference not set to an instance of an object.
(Microsoft.SqlServer.Express.ObjectExplorer)

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

at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SystemObjectAccessHandler.get_HideSystemObjects()
   at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SystemObjectAccessHandler.Visible(INodeInformation
source)
   at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.IsNodeVisible(NavigableItem
item)
   at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildStaticItem(IList
nodes, INodeInformation source, INavigableItem sourceItem)
   at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
   at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
   at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()

[Bug 19223] null Object reference during Database object expansion (MS SQL SMSE)

http://bugs.winehq.org/show_bug.cgi?id=19223

--- Comment #1 from m27315   2009-07-06 15:50:22 ---
Created an attachment (id=22226)
 --> (http://bugs.winehq.org/attachment.cgi?id=22226)
screenshot of error message and empty error box

[Bug 19223] null Object reference during Database object expansion (MS SQL SMSE)

http://bugs.winehq.org/show_bug.cgi?id=19223

Nikolay Sivov  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #22225|application/octet-stream    |text/plain
          mime type|                            |

[Bug 19223] null Object reference during Database object expansion (MS SQL SMSE)

http://bugs.winehq.org/show_bug.cgi?id=19223

--- Comment #2 from Austin English   2010-06-04 15:44:08 ---
This is your friendly reminder that there has been no bug activity for 11
months. Is this still an issue in current (1.2-rc2 or newer) wine?

[Bug 19223] Microsoft SQL Server Management Studio Express (SSMSE): "Object Explorer" encounters error during "Databases" expansion

http://bugs.winehq.org/show_bug.cgi?id=19223

Anastasius Focht  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |download
                URL|                            |http://www.microsoft.com/do
                   |                            |wnload/en/details.aspx?id=8
                   |                            |961
                 CC|                            |[e-mail]
            Summary|null Object reference       |Microsoft SQL Server
                   |during Database object      |Management Studio Express
                   |expansion (MS SQL SMSE)     |(SSMSE): "Object Explorer"
                   |                            |encounters error during
                   |                            |"Databases" expansion

--- Comment #3 from Anastasius Focht  2012-03-04 03:51:48 CST ---
Hello,

prerequisites: winetricks -q dotnet20 msxml6

(installer explicitly checks for MSXML6 component)

$ wine msiexec -i SQLServer2005_SSMSEE.msi

The log from initial reporter is not really useful, it shows a crashing
"winemenubuilder" process.

Actually you need a running MS SQL server but no information is given which
version/installer or if the test was done on remote SQL server (running on
Windows?).

--- snip ---
$ pwd
/home/focht/.wine/drive_c/Program Files/Microsoft SQL
Server/90/Tools/Binn/VSShell/Common7/IDE
$ wine ssmsee.exe
...
--- snip ---

Setting up a local test server using "Microsoft SQL Server 2005 Express
Edition" (http://www.microsoft.com/download/en/details.aspx?id=21844) doesn't
work due to WMI insufficiencies.

Please retest on your own.

Regards

[Bug 19223] Microsoft SQL Server Management Studio Express (SSMSE): "Object Explorer" encounters error during "Databases" expansion

http://bugs.winehq.org/show_bug.cgi?id=19223

--- Comment #4 from Nikolay Sivov  2012-03-04 07:27:26 CST ---
(In reply to comment #3)
> prerequisites: winetricks -q dotnet20 msxml6
>
> (installer explicitly checks for MSXML6 component)

Does it mean it checks that with msi API? So we probably need to create
msxml6.msi package eventually.

[Bug 19223] Microsoft SQL Server Management Studio Express (SSMSE): "Object Explorer" encounters error during "Databases" expansion

http://bugs.winehq.org/show_bug.cgi?id=19223

--- Comment #5 from Anastasius Focht  2012-03-04 09:47:48 CST ---
Hello Nikolay,

--- quote ---
Does it mean it checks that with msi API? So we probably need to create
msxml6.msi package eventually.
--- quote ---

Sure, using RegLocator.
I created bug 30078 for this issue.

When installers don't carry msxml6 redistributable on their own, people always
use 'winetricks -q msxml6' to work around.

Regards

[Bug 19223] Microsoft SQL Server Management Studio Express (SSMSE): "Object Explorer" encounters error during "Databases" expansion

http://bugs.winehq.org/show_bug.cgi?id=19223

Daniel Jelinski  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]

--- Comment #6 from Daniel Jelinski  2012-03-08 14:58:44 CST ---
Hello Anastasius,
I managed to install SSMSEE without using any winetricks. I set windows version
to 2008 R2, which bypassed the check (Vista and newer come with preinstalled
msxml6).
I still need dotnet to run it though.

[Bug 19223] Microsoft SQL Server Management Studio Express (SSMSE): "Object Explorer" encounters error during "Databases" expansion

http://bugs.winehq.org/show_bug.cgi?id=19223

--- Comment #7 from Daniel Jelinski  2012-03-20 17:21:14 CDT ---
Hello,
Both issues are still present in wine 1.4:
-expanding Databases node fails
-error window is empty.
To reproduce this bug:
- install SQL Server 2000 (see appdb for details)
- install management studio as described in comment 3
- connect to the installed server
- expand Databases node by double-clicking or clicking (+) sign (note that if
you select this node first e.g. by single-clicking, everything will work fine)

[Bug 19223] Microsoft SQL Server Management Studio Express (SSMSE): "Object Explorer" encounters error during "Databases" expansion

http://bugs.winehq.org/show_bug.cgi?id=19223

--- Comment #8 from Daniel Jelinski  2013-03-10 10:56:49 CDT ---
Hello,
In wine-1.5.25 expanding databases still fails. The error message is now
visible.

[Bug 19223] Microsoft SQL Server Management Studio Express (SSMSE): "Object Explorer" encounters error during "Databases" expansion

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=19223

joaopa  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]

--- Comment #9 from joaopa  ---
Does the bug still occur with wine-6.21?

[Bug 19223] Microsoft SQL Server Management Studio Express (SSMSE): "Object Explorer" encounters error during "Databases" expansion

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=19223

Anastasius Focht  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                URL|http://www.microsoft.com/do |https://web.archive.org/web
                   |wnload/en/details.aspx?id=8 |/20130719021548/http://down
                   |961                         |load.microsoft.com/download
                   |                            |/a/6/c/a6c820bb-9043-4ef6-8
                   |                            |a7b-a0cd327cf8c5/SQLServer2
                   |                            |005_SSMSEE.msi
             Status|UNCONFIRMED                 |NEEDINFO
     Ever confirmed|0                           |1

--- Comment #10 from Anastasius Focht  ---
Hello folks,

adding stable download links via Internet Archive:

https://web.archive.org/web/20110620205250/http://www.microsoft.com/download...

https://web.archive.org/web/20130719021548/http://download.microsoft.com/dow...

https://web.archive.org/web/20130719021548/http://download.microsoft.com/dow...

$ sha1sum SQLServer2005_SSMSEE*
a609e482188cdb4bbfae786c4aa8149af9944d29  SQLServer2005_SSMSEE.msi
303860befbe8ad94efa7e011aabf3dc9c8090f65  SQLServer2005_SSMSEE_x64.msi

$ du -sh SQLServer2005_SSMSEE*
39M    SQLServer2005_SSMSEE.msi
40M    SQLServer2005_SSMSEE_x64.msi

Microsoft SQL Server 2005 Express Edition:

https://web.archive.org/web/20130318195510/http://download.microsoft.com/dow...

$ sha1sum SQLEXPR32.EXE 
edeb3fe40fd6f03087a55b3f4e08bac795f68436  SQLEXPR32.EXE

$ du -sh SQLEXPR32.EXE 
36M    SQLEXPR32.EXE

Alternatively: Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)

https://web.archive.org/web/20101225105840/http://download.microsoft.com/dow...

$ sha1sum MSDE2000A.exe 
84967a13671758c9e7cd2b19cdb60cce634cd869  MSDE2000A.exe

$ du -sh MSDE2000A.exe 
43M    MSDE2000A.exe

Regards