Error Running Workflow

[latimo1]

Workflow took forever to Output, then

[gautiergodard]

Hi @latimo1 

Is this error taking place in the output tool? What type of output are you trying to write? 

Typically, when I have seen this error, I need to restart Alteryx, and replace the tool that was causing the error.

[latimo1]

Yes, in an Output Tool to SQL Server. I closed Designer, reloaded the workflow, deleted the Output Tool and recreated it. Saved and run. I tried caching the data.

Info: Cache (1): 114671 records were read from odbc:DSN=SAP_S4_HANA_600;UID=SACUSER;PWD=__EncPwd1__ (select SAPHANADB.VBAP.VBELN as SalesOrder,
SAPHANADB.VBAP.POSNR as Item,
SAPHANADB.VBAP.ERDAT as Createdon,
SAPHANADB.VBAP.AEDAT as ChangedOn,
SAPHANADB.VBAP.KWMENG as OrderQuantity,
SAPHANADB.VBAP.LSMENG as ShippedQuantity,
SAPHANADB.VBAP.KBMENG as SalesQuantity,
SAPHANADB.VBAP.ABLFZ as DeliveryQuantity,
SAPHANADB.VBAP.LPRIO as DeliveryPriority,
SAPHANADB.VBAP.SESSION_CREATION_DATE,
SAPHANADB.VBAP.SESSION_CREATION_TIME,
SAPHANADB.VBEP.WMENG,
SAPHANADB.VBEP.LMENG,
SAPHANADB.VBEP.CMENG,
SAPHANADB.VBAP.KLMENG,
SAPHANADB.VBAP.SMENG,
SAPHANADB.VBAP.WERKS,
SAPHANADB.VBAP.ZMENG,
SAPHANADB.VBEP.BMENG
from SAPHANADB.VBAP
inner join SAPHANADB.VBEP on SAPHANADB.VBAP.VBELN = SAPHANADB.VBEP.VBELN
where SAPHANADB.VBAP.SESSION_CREATION_DATE >= '20221010'
-- 20221006 175001
-- 20221007 175327
-- 20221008 142331
-- 20221009 160828
-- 20221009 114436
-- 20221010 120551
-- 20221010 103847
and
SAPHANADB.VBAP.SESSION_CREATION_TIME >= '103847')

File_Output: Cache (1): C:\Users\jxl0924\AppData\Local\Temp\Engine_11656_34550f2c26894b3d8aba0ae5dd6b8d70_\Cache_11656_b789188b53ef49728752ce59170ebdef.yxdb|Tool #4: 114671 records were written to "C:\Users\jxl0924\AppData\Local\Temp\Engine_11656_34550f2c26894b3d8aba0ae5dd6b8d70_\Cache_11656_b789188b53ef49728752ce59170ebdef.yxdb"

Then it just spins.

[gautiergodard]

Hi @latimo1 ,

It looks like you are outputting the results to a .yxdb file in a temp folder - can you try to output to your desktop or some non-temp folder instead?