KNOWLEDGE BASE

"An unexpected error occurred" Appears Intermittently When Editing Or Accessing A Published Workbook


Published: 20 Jul 2021
Last Modified Date: 21 Jul 2021

Issue

"An unexpected error occurred" appears intermittently when editing or accessing a published workbook on Tableau Server/Tableau Online using Tableau Desktop.

The error below is displayed on Tableau Desktop:

Internal Error - An unexpected error occurred and the operation could not be completed.
Error Code: 0E1EAFA4

User-added image


"LogicException" error is displayed on Tableau Server or Tableau Online. 

LogicException: Internal Error - An unexpected error occurred and the operation could not be completed.

User-added image

 

Environment

  • Tableau Desktop 2020.2  or newer
  • Tableau Server 2020.2  or newer
  • Tableau Online

Resolution

For Tableau Desktop
Workaround 1:

Open a command prompt as an administrator and execute the following command
  • cd "C:\Program Files\Tableau\Tableau < version>\bin"
  • tableau.exe -DExternalCacheDisable
Workaround 2:
Install an old maintenance release version such as v2020.3.8, v2020.2.13.


For Tableau Server
Workaround:

Open a command prompt as an administrator and execute the following command
  • tsm configuration set -k vizqlserver.native_api.external_cache_disable -v true
  • tsm pending-changes apply

 

Cause

This is a known issue that is under investigation and being addressed by the Tableau development team.

Additional Information

The log records "LogicException Details. Mismatching collation between column and tuple element".

Example(Tableau Desktop):

{"e":1.82e+05,"i":1.53e+06,"ne":1490,"ni":10624},"kcpu":{"e":0,"i":0},"ntid":2,"ucpu":{"e":0,"i":6}},"rk":"exception","root":"O9OjDIdvkx1LuOZiASz2Ii","rv":{"e-code":"e1eafa4","e-source":"System","msg":"\"Internal Error - An unexpected error occurred and the operation could not be completed.\n\nLogicException details: Mismatching collation between column and tuple element : LJA_RJP vs LJA\n\"","type":"LogicException"},"sponsor":"IFU1FtbaUACKGK2NuiMUBB","type":"end"},"v":{"query-category":"QuickFilter","rows":0},"ctx":{"wb":"<workbook name>"}}


Example(Tableau Server):

{"e":1,"i":4}},"rk":"exception","root":"MdDRSUNp0BwJ0AfSJaDRD2","rv":{"e-code":"e1eafa4","e-source":"System","msg":"\"\u5185\u90e8\u30a8\u30e9\u30fc - \u4e88\u671f\u3057\u306a\u3044\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3001\u64cd\u4f5c\u3092\u5b8c\u4e86\u3067\u304d\u307e\u305b\u3093\u3067\u3057\u305f\u3002\n\nLogicException details: Mismatching collation between column and tuple element : LJA vs LJA_RJP\n\"","type":"LogicException"},"sponsor":"GccjNvI8E7oKJO0ppUjVFm","type":"end"},"v":{},"ctx":{"vw":"<workbook name>"}}


Depending on the actual scenario, errors in the log may be displayed in differentnt languages.
Chineses:
LogicException in native code: Mismatching collation between column and tuple element : LZH_RTW_S2 vs LZH_RTW_S2_ZHANT
Japanese:
LogicException details: Mismatching collation between column and tuple element : LJA_RJP vs LJA
 
Did this article resolve the issue?