Automation file gets corrupted on its own

I am using version 4.3 Base Edition of Toad Data Point and trying to create automation in it. I have used different versions of Toad Data point in the past and never had this issue before. I can create small automations here on this version but when it comes to creating complex automation, the automation file gets corrupted and can no longer open it in the toad. I open the .tas file in the notepad to see the issue and found that there is unexpected end to the XML file - The XML file is partial. Is this an issue with this particular version? or there is a setting that needs to be updated?

I have identified this issue followed by the error message - FilePath\filename.tas has been modified on disk. Do you want to reload the file?

After this message this automation file is no longer been recognized by Toad Data Point and when I open it in XML it is truncated.

Can you provide more information so that we can reproduce? What is your step? What activities are you using in your created automation?

The steps for automation are -

Creating 3 variables for Date > Copy the required file to the right location> Import Wizard - data from the excel file to Database> Execute Script (Data update into the table)> Another Execute Script > Export Wizard - From database into the text file with delimited ‘|’ format and Encoding

I cannot reproduce the issue. Can you provide the screenshot of each activity? We want to know the detail setting.

Or better yet, post sample automation script

This is what .tas file ends like when I opened XML into word -

<ta0:VariableIfElseBranchActivity x:Name=“If_Condition_2” Condition="#RES# = 1">
<ta0:LogActivity Message=“NO RES” Description=“Add a message to the script execution Log” OnError=“stopOnError” x:Name=“Log_1” />
</ta0:VariableIfElseBranchActivity>
</ta0:VariableIfElseActivi

When I run automation and save it and then reopen it, can no longer open it in toad - The automation file will end incorrectly like above script.

The xml file seems have some issue, please post sample automation script.

Hello There,

I also has same issue with TDP 4.3.0.718 (64 bit).

The automation file was working fine when run from within TDP environment takes less than 10min. to complete.

While the .tas file was open in TDP, I ran task from windows scheduler. The task was taking more than expected time so I thought of looking for a command line switch that may display the automation step/action being executed, -kind of similar to TDP GUI log.

I issued following commands
Toad.exe /? Toad.exe /help Toad.exe -? Toad.exe -help
All these commands started a new toad session with editor tab titled the passed argument. I closed the sessions. I think there was one file in the same session that I had my .tas file opened.

When the task run from the task scheduler didn't finished in over 30mins, I stopped the task from windows scheduler.

After that I went to close TDP, it prompted me if I want to save changes, I clicked yes, and since then when I open the file, I only see settings and no other activity.

There are 370 lines in the task file. The last line is:

</ta:ToadAutomationScript>]]>< /Source>< /Xoml>< /ToadAutomationScript>

Note: I have purposefully added a space before closing tags for Source, Xoml and ToadAutomationScript, as without the space, these were not being seen in the post.

Nodepad++ marks "ta" and "Xoml" with red wiggly line indicating an error. I have to learn some more about .xml files to be able fix it manually, if possible.

Thanks,

Aleem

Hi,
can you try turning on log verbose level by setting it here in Settings like so:


Could you send us your whole automation script?

Thank you Dan,

For security reasons, I have to change connection/user information, could you please let me know if this change hinders/impacts in finding the issue?

The upload seems to allow only picture files, how may I upload the .tas file?

Thanks,

Unfortunately not here. I guess the best way is to open a support case with us and you can send us anything.