workflow runs a SQL query to Navision SQL db it's creating a connection and never releasing it, how do I fix this?
Are you talking about data sources in Query Data or Insert Data activities? What connection method are you using?
Hi Miruna, I'm talking about Query Data activity in Workflow. I have attached a screen shot.
These are the problems/questions:
2. We are noticing that every time a workflow runs (onchanged/oncreated events) it creates a xml file under the LFData folder on the D:/. This isn’t really an issue except that it appears that file never disappears, it’s holding onto it forever, why is this?
3. We also are noticing that every time a workflow runs that has a sql query out to our Navision SQL database it’s creating a connection and never releasing it? How do we fix this?
Thanks Wendi
Hi Miruna, just wanted to let you know that I am waiting on my client to reply to the above post. Thanks Wendi