Workflow Soluiton

 View Only

  • 1.  INTEGRATION component

    Posted Nov 17, 2011 12:54 AM

    Hi guys,

     

    I am trying to take backup of a database in sqlserver 2005 via ALTRIS DESIGNER.

    I have created a stored procedure and calling that procedure from my altris designer through my integration component.

    The procedure works fine in my sqlserver 2005.

    Also, when i test the query, the altris designer says "1 row is affected". but when i use the actual component in the WF Project i get the following error.

    when i call the procedure through my ALtris designer, i get the following error in my execution log.

    Component Executed: Start (LogicBase.Components.Default.Process.StartComponent), exit path is ''

    Data:

    Log Error:

    Component Executed: Start (LogicBase.Components.Default.Process.StartComponent), exit path is ''

    Data:

    ErrorMessage = "Cannot perform a backup or restore operation within a transaction.

    BACKUP DATABASE is terminating abnormally."

    LastComponent = "sql"

    ModelID = "8a69de77-cf29-424f-8938-6bccf5dd36ff"

     

    please help me to fix this problem.

     

    Regards,

    manjoobentur



  • 2.  RE: INTEGRATION component

    Posted Nov 25, 2011 12:52 AM

    Hi,

    Could you please share the package of the workflow project you are using? So that we can look into it further.

    Thank you.