Welcome to the Alteryx Knowledge Base

Knowledge Base / Designer / GDC-2470: Designer crashes when running In-DB tools

GDC-2470: Designer crashes when running In-DB tools

user

Created/Edited - 12/6/2024 by Josh Pham | Alteryx

Summary

Designer crashes after closing the first workflow with a Connect In-DB tool and Browse In-DB tool and then creating a 2nd workflow with the same tools.

Environment

Issue

Designer crashes after closing the first workflow with a Connect In-DB tool and Browse In-DB tool and then creating a 2nd workflow with the same tools.

Environment Details

Alteryx Designer
- Version 2021.3.6 and below
Connect In-DB with Browser In-DB tools with any data sources

Cause

Diagnosis

The Windows Event Viewer > Windows Logs > Application list will have the following errors:

How to Retrieve System and Application Event Viewer Logs for Alteryx

Source - Application Error
Faulting application name: AlteryxGui.exe, version: 2021.4.2.2731, time stamp: 0x62316815
Faulting module name: KERNELBASE.dll, version: 10.0.19041.1645, time stamp: 0x630193b4
Exception code: 0xe0434352
Fault offset: 0x0000000000034f69
Faulting process id: 0x5e90
Faulting application start time: 0x01d86492b8b37f42
Faulting application path: C:\Users\<username>\AppData\Local\Alteryx\bin\AlteryxGui.exe
Faulting module path: C:\Windows\System32\KERNELBASE.dll
Report Id: b8763775-67a9-47c4-9818-811be74a4a6c
Faulting package full name:
Faulting package-relative application ID:

Source - .NET Runtime
Application:AlteryxGui.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.IO.IOException
at System.IO.__Error.WinIOError(Int32, System.String)
at System.IO.FileStream.Init(System.String, System.IO.FileMode, System.IO.FileAccess, Int32, Boolean, System.IO.FileShare, Int32, System.IO.FileOptions, SECURITY_ATTRIBUTES, System.String, Boolean, Boolean, Boolean)
at System.IO.FileStream..ctor(System.String, System.IO.FileMode, System.IO.FileAccess, System.IO.FileShare)
at AlteryxGuiToolkit.Utility.TempFolder..ctor(System.String)
at AlteryxGuiToolkit.Utility.TempFileManager.AddTempFolder(System.String)
at AlteryxGuiToolkit.Utility.TempFileManager.AddTempFile(System.String)
at AlteryxGuiToolkit.BrowseWrDb.DataProfileRunner.CallbackComplete(Int32, System.String, System.String)
at AlteryxGuiToolkit.Utility.InternalWorkflow.EngineRunner.RunWorkflow()
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
at System.Threading.ThreadHelper.ThreadStart()

Cause

Defect GDC-2470 is fixed in later versions of Alteryx Designer (see resolution C)

Resolution

Workaround A - Edit User Settings and disable data profiling

Go to User Settings > Edit User Settings, and uncheck Collect and display data profile information > Save.

NOTE: It is checked and enabled by default.

Workaround B - Save the workflow and open or create a new workflow without closing the original workflow tab

1. Open Designer.
2. Add a Connect IN-DB tool.
3. Select any saved connection.
4. Add a table from the Visual Query Builder (VQB).
5. Add a Browse IN-DB tool.
6. Run it and it runs successfully.
7. Save the workflow.
8. If needed, open the same workflow or a different workflow in a new tab without closing the original tab.

Resolution C - Upgrade Designer

This defect is fixed in the following Designer versions:

2022.3+
2022.1.1 Patch 2
2021.4.2 Patch 4
2021.3.7.05186

Additional Information

Additional Resources

Was this article helpful?