Toad World® Forums

Scheduled Tasks / Automation Scripts


#1

I created an Automation Script ‘Automation_Script_HH_Data.tas’ which runs several other Automation Scripts. This script runs well when I click Run Automation Script. However, if I add it to the Scheduled Tasks, only the first Export Automation Script runs.

Please let me know what I am doing wrong. Thank you for your assistance.
Rob

HH_Book.tsm (247 KB)

HH_Book_Company.tsm (105 KB)

HH_Code_Description.tsm (59 KB)

Server Error in ‘/’ Application.


Operation is not valid due to the current state of the object.

    Operation is not valid due to the current state of the object.

         **Description:**
        An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

         **Exception Details:** System.InvalidOperationException: Operation is not valid due to the current state of the object.

        **Source Error:**

`

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.`

        **Stack Trace:**
   [InvalidOperationException: Operation is not valid due to the current state of the object.] System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959 System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213 Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270

``


Version Information:
Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

">HH_Furniture.tsm

Server Error in ‘/’ Application.


Operation is not valid due to the current state of the object.

    Operation is not valid due to the current state of the object.

         **Description:**
        An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

         **Exception Details:** System.InvalidOperationException: Operation is not valid due to the current state of the object.

        **Source Error:**

`

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.`

        **Stack Trace:**
   [InvalidOperationException: Operation is not valid due to the current state of the object.] System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959 System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213 Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270

``


Version Information:
Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

">HH_Pattern.tsm

HH_Pattern_Alias.tsm (557 KB)

Server Error in ‘/’ Application.


Operation is not valid due to the current state of the object.

    Operation is not valid due to the current state of the object.

         **Description:**
        An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

         **Exception Details:** System.InvalidOperationException: Operation is not valid due to the current state of the object.

        **Source Error:**

`

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.`

        **Stack Trace:**
   [InvalidOperationException: Operation is not valid due to the current state of the object.] System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959 System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213 Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270

``


Version Information:
Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

">HH_Pattern_Color.tsm

Server Error in ‘/’ Application.


Operation is not valid due to the current state of the object.

    Operation is not valid due to the current state of the object.

         **Description:**
        An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

         **Exception Details:** System.InvalidOperationException: Operation is not valid due to the current state of the object.

        **Source Error:**

`

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.`

        **Stack Trace:**
   [InvalidOperationException: Operation is not valid due to the current state of the object.] System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959 System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213 Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270

``


Version Information:
Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

">HH_Pattern_Color_Book.tsm

Server Error in ‘/’ Application.


Operation is not valid due to the current state of the object.

    Operation is not valid due to the current state of the object.

         **Description:**
        An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

         **Exception Details:** System.InvalidOperationException: Operation is not valid due to the current state of the object.

        **Source Error:**

`

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.`

        **Stack Trace:**
   [InvalidOperationException: Operation is not valid due to the current state of the object.] System.Web.HttpValueCollection.FillFromString(String s, Boolean urlencoded, Encoding encoding) +4008959 System.Web.HttpUtility.ParseQueryString(String query, Encoding encoding) +213 Telligent.Evolution.Rest.Framework.Infrastructure.RestPluginHttpHandler.ProcessRequest(HttpContext context) +325 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +625 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270

``


Version Information:
Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

">HH_Pattern_Color_Stock.tsm

SQL.zip (32.4 KB)

TAS.zip (19 KB)

TXP.zip (7.73 KB)