1 Reply Latest reply on Jun 14, 2012 1:17 PM by Robert Morton

    Tableau Locking Tables on SQL SERVER 2005 db

      It 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

        • 1. Re: Tableau Locking Tables on SQL SERVER 2005 db
          Robert Morton

          Hi Jared,

           

          We are aware of this problem, which is typically noticed in databases which have a mixture of read and write operations. Tableau works best with analytical databases which are updated in brief, efficient batches by nightly operations such as ETL. If you must perform analysis on a table which is updated with frequent write operations, you may wish to consider working with your DBA to create a second copy of the table which is updated less frequently using batches of updates from the transaction table.

           

          I'll make note of your concern, and I hope that we will be able to address this problem in a future release. However I cannot commit to a specific timeframe.

           

          -Robert

          1 of 2 people found this helpful