Tableau Locking Tables on SQL SERVER 2005 db
jared.thatcher Jun 14, 2012 9:45 AMIt seems that Tableau is locking tables on my database. It acts as a Sch-S or Schema Stability lock. I am able to pull data but if I try to modify the table is doesn't allow the alter. It references Tableau as the cause for the lock (says my DBA).
I looked through the forms and admin guides and nothing about table locking was referenced. It is possible our DBA doesn't fully know what he's talking about and something else is locking it.
Could someone help me out here?
Below is from the DBA showing what is locking the table.
spid | blocked | waitresource | open_tran | hostname | cmd | loginame | text | program_name | last_batch | duration(mi) |
53 | 0 |
| 0 | TBLEAU01 | SELECT | ScoreCard | SELECT [TableauSQL].[AABackup] AS [AABackup], [TableauSQL].[AAEndDate] AS [AAEndDate], [TableauSQL].[AAManager] AS [AAManager], [TableauSQL].[AAPosition] AS [AAPosition], [TableauSQL].[AARegion] AS [AARegion], [TableauSQL].[AASnrManager] AS [AASnrManager], [TableauSQL].[AAStartDate] AS [AAStartDate], [TableauSQL].[AAStatus] AS [AAStatus], [TableauSQL].[AccntName] AS [AccntName], [TableauSQL].[AdvisoryBoardMember] AS [AdvisoryBoardMember], [TableauSQL].[Advocate] AS [Advocate], [TableauSQL].[BAC] AS [BAC], [TableauSQL].[CaseNumber] AS [CaseNumber], [TableauSQL].[Case_Owner] AS [Case_Owner], [TableauSQL].[CreatedDate] AS [CreatedDate], [TableauSQL].[DAPUnits] AS [DAPUnits], [TableauSQL].[GMPrimaryMake] AS [GMPrimaryMake], [TableauSQL].[HasDAPEmail] AS [HasDAPEmail], [TableauSQL].[HasDAPProduct] AS [HasDAPProduct], [TableauSQL].[HasPowerSEO] AS [HasPowerSEO], [TableauSQL].[HasProCare] AS [HasProCare], [TableauSQL].[HasSearch] AS [HasSearch], [TableauSQL].[LDPFlag] AS [LDPFlag], [TableauSQL].[LinkToWebID] AS [LinkToWebID], [TableauSQL].[MakeMix] AS [MakeMix], [TableauSQL].[Name] AS [Name], [TableauSQL].[OEMFocus2] AS [OEMFocus2], [TableauSQL].[OEMFocus3] AS [OEMFocus3], [TableauSQL].[OEMFocus4] AS [OEMFocus4], [TableauSQL].[OEMFocus] AS [OEMFocus], [TableauSQL].[OEM] AS [OEM], [TableauSQL].[OMSOnbMMStatus] AS [OMSOnbMMStatus], [TableauSQL].[Period] AS [Period], [TableauSQL].[ProCareTeam] AS [ProCareTeam], [TableauSQL].[ProblemCode] AS [ProblemCode], [TableauSQL].[ProductCategory] AS [ProductCategory], [TableauSQL].[ProductMix] AS [ProductMix], [TableauSQL].[ReasonForTransfer] AS [ReasonForTransfer], [TableauSQL].[Region] AS [Region], [TableauSQL].[SEOOnbMMStatus] AS [SEOOnbMMStatus], [TableauSQL].[SEOOptOut] AS [SEOOptOut], [TableauSQL].[SalesRegion] AS [SalesRegion], [TableauSQL].[State] AS [State], [TableauSQL].[Status] AS [Status], [TableauSQL].[VIPFlag] AS [VIPFlag], [TableauSQL].[WebID] AS [WebID] FROM ( SELECT * FROM dbo.vRpt_Advocate_Cases ) [TableauSQL] | Tableau Protocol Server 7.0 | 01:38.9 | NULL |