KNOWLEDGE BASE

Error "Failure getting record lock on a record from table <table name>" With Progress OpenEdge Viewing Dashboard on Server


Published: 25 Feb 2017
Last Modified Date: 08 May 2017

Issue

When viewing a dashboard on Tableau Server, the following error occurs: 
An unexpected error occurred. If you continue to receive this error please contact your Tableau Server administrator. 
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Failure getting a record lock on a record from table <table name>
Would you like to reset the view?

 

Environment

  • Tableau Server
  • Progress OpenEdge

Resolution

Use a .tdc file. See Customizing Tableau for Progress DataDirect OpenAccess ODBC Driver at the Progress community for more information. 
The .tdc file will need to be placed in the bin folder for all computers running Tableau Server, as well as in the vizqlserver Datasources folder, located by default at: 
C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Datasources

 

And on any computer where the workbook will be used in Tableau Desktop: 

Windows

  • \My Documents\My Tableau Repository\Datasources 
Mac OS
  •  Documents > My Tableau Repository >Datasources

Important: Tableau does not test or support TDC files. These files should be used as a tool to explore or occasionally address issues with your data connection. Creating and maintaining TDC files requires careful manual editing, and there is no support for sharing these files.

Cause

This issue occurs because Tableau sends read-committed requests. Progress databases then lock up and the database cannot be accessed again. The .tdc file changes all read-committed requests to read-uncommitted, which will not lock the Progress database.
Did this article resolve the issue?