Hello all!
I just built my first integration manger integration that I am using to import Journal Entries with Analytical information, and it works well with small files. With large files, 1000 entries and up, I get a the following error: "System.Data.SqlClient.SqlError: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." ( This is a bug that Microsoft is fixing at this time and is a side note to this posting in case someone is interested.)
What I am interested to find out is what happens with the failed import attempts? After trying this several times on my test environment, I eventually got a different error message indicating that the SQL database had run out of disk space. So I wonder, does the partial failed entry stay in some tables consuming disk space, or does integration manager roll back the partial entry? Do I need to include in the integration a clean up procedure of any sort on the SQL tables?
I welcome your input. Thank you in advance for your help.
*This post is locked for comments
I have the same question (0)
