Can't show VIEW in Sql Server 2008 R2

matsg's profile image matsg posted 11 years ago in General Permalink
Hi,

I can't display views or stored procedured on SQL Server 2008 R2 with HeidiSQL - I just get an exception. It seems like there's a problem with some kind of parsing routine.

Not sure if this forum is where you place bug reports?


date/time : 2013-03-12, 08:42:33, 508ms
computer name : MIKE-THINKPAD
user name : Mike <admin>
registered owner : Mike
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : English
system up time : 1 day 13 hours
program up time : 2 minutes 13 seconds
processors : 4x Intel(R) Core(TM) i5-2410M CPU @ 2.30GHz
physical memory : 978/3983 MB (free/total)
free disk space : (C:) 200.16 GB
display mode : 1920x1080, 32 bit
process id : $15e8
allocated memory : 60.50 MB
executable : heidisql.exe
exec. date/time : 2013-03-12 08:40
version : 7.0.0.4362
compiled with : Delphi XE
madExcept version : 3.0m beta 1
callstack crc : $bbc5382c, $4ea5a3bc, $4ea5a3bc
exception number : 1
exception class : Exception
exception message : Regular expression did not match the VIEW code in ParseViewStructure(): CREATE VIEW [dbo].[vewCostCentreRights] AS SELECT DISTINCT uc.UserId, C.CostId, C.Description FROM tblCost C JOIN UserClaim uc ON uc.Claim = C.BusinessId WHERE uc.CategoryId = 100 UNION SELECT DISTINCT uc.UserId, C.CostId, C.Description FROM tblCost C JOIN tblCostCentreTree Ct ON C.CostId = Ct.CostCentreId, tblCostCentreTree AS Ct2 JOIN tblCost C2 ON Ct2.CostCentreId = C2.CostId JOIN UserClaim uc ON uc.Claim = C2.BusinessId WHERE Ct.lft BETWEEN Ct2.lft AND Ct2.rgt AND Ct.TreeId = Ct2.TreeId AND uc.CategoryId = 100 UNION SELECT DISTINCT ur.UserId, C.CostId, C.Description FROM tblCost C JOIN RoleClaim rc ON rc.Claim = C.BusinessId JOIN UserRole ur ON rc.RoleId = ur.RoleId WHERE rc.CategoryId = 100 Union SELECT DISTINCT ur.UserId, C.CostId, C.Description FROM tblCost C JOIN tblCostCentreTree Ct ON C.CostId = Ct.CostCentreId, tblCostCentreTree AS Ct2 JOIN tblCost C2 ON Ct2.CostCentreId = C2.CostId JOIN RoleClaim rc ON rc.Claim = C2.BusinessId JOIN UserRole ur ON rc.RoleId = ur.RoleId WHERE Ct.lft BETWEEN Ct2.lft AND Ct2.rgt AND Ct.TreeId = Ct2.TreeId AND rc.CategoryId = 100 UNION SELECT DISTINCT U.UserId, C.CostId, C.Description FROM tblCost C JOIN Users U ON C.OrgId = U.OrgId JOIN UserClaim UC ON UC.UserId = U.UserId WHERE UC.Claim = '7A9F94CD-38CC-4DD4-A79C-4D3360EBC23D' UNION SELECT DISTINCT U.UserId, C.CostId, C.Description FROM tblCost C JOIN Users U ON C.OrgId = U.OrgId JOIN UserRole UR ON U.UserId = UR.UserId JOIN RoleClaim RC ON RC.RoleId = UR.RoleId WHERE RC.Claim = '7A9F94CD-38CC-4DD4-A79C-4D3360EBC23D'.

main thread ($de0):
0072c59c heidisql.exe dbconnection 3435 +30 TDBConnection.ParseViewStructure
007fb03e heidisql.exe Main 7184 +60 TMainForm.DBtreeFocusChanged
00622aae heidisql.exe VirtualTrees TBaseVirtualTree.DoFocusChange
00626e4a heidisql.exe VirtualTrees TBaseVirtualTree.HandleMouseDown
004e97f4 heidisql.exe Controls TControl.DoMouseDown
0061ee4c heidisql.exe VirtualTrees TBaseVirtualTree.WMLButtonDown
0062b4ef heidisql.exe VirtualTrees TBaseVirtualTree.WndProc
004ed100 heidisql.exe Controls TWinControl.MainWndProc
004ab958 heidisql.exe Classes StdWndProc
75437885 USER32.dll DispatchMessageW
00575ffb heidisql.exe Forms TApplication.ProcessMessage
0057603e heidisql.exe Forms TApplication.HandleMessage
00576369 heidisql.exe Forms TApplication.Run
00817bf0 heidisql.exe heidisql 75 +23 initialization
753233a8 kernel32.dll BaseThreadInitThunk

Thanks,
Matt
ansgar's profile image ansgar posted 11 years ago Permalink
Please read issue #2496, be sure to have the latest HeidiSQL build, and report the above error with a comment there if it does not disappear after the update.

Please login to leave a reply, or register at first.