Issue with Export Data Store Entity to Excel

Question

Hi, 
 I have below process model where I am trying to use "Export Data Store Entity to Excel". 
 It was throwing an error when I try to use. I have not used any crazy setups related to this smart service, but still I am getting an error like " : An error occurred when attempting to write the document Excel Export 3_9_2023 7_10 PM GMT+00_00. Please contact your system administrator for additional details. (APNX-1-4505-056) ". 
 This error message is not giving any kind of clue to trace exact issue.

Arul · Answer

Hi swapna , 
 I can see here the "New Document Name" was text. But the value was text with datetime format. Pls add few more conditions to make that as text.

Mike Schmitt · Answer

Check tomcat-stdOut.log for the error (you might need to reproduce the error then load the log file afresh, and just scroll to the bottom, in order to find it). My first guess is that the query might be malfunctioning or timing out somehow, though this node is supposed to handle that. Hopefully if it's this or some other error, it might give slightly more detail there as to what the underlying issue is. 
 As a first order of troubleshooting, what happens if you replace the Data Store Entity with a different one, and try it again? At first I'd suggest using one that points to a small table (both in column width as well as data length), to rule out any size / timeout issues, and see if the error persists.