Workflow and ServiceDesk Community

 View Only
  • 1.  Custom SQL generator doesn't load when I publish workflow

    Posted May 07, 2013 02:06 PM

    "Error starting/continuing dialog model execution LogicBase.Framework.ObjectDeserializationError: could not deserialize: LogicBase.Core.IOrchestrationComponent[] ---> System.Exception: could not find type UpdateUser.SqlQuery.UpdateUser"

    The application crashes immediately with this error. It works fine in debug mode.

    I have a lot of different SQL generators in my workflow and I've never had this problem. I just added a few more today and now this is happening.

    Anyone know what's going on?



  • 2.  RE: Custom SQL generator doesn't load when I publish workflow

    Posted May 07, 2013 02:22 PM

    It's already checked :(



  • 3.  RE: Custom SQL generator doesn't load when I publish workflow

    Posted May 07, 2013 02:26 PM

    I would try manually moving it then, just as a sanity check.



  • 4.  RE: Custom SQL generator doesn't load when I publish workflow

    Posted May 07, 2013 02:28 PM

    Manually move the Dll file to IIS?

    I can't even find the current file in IIS.



  • 5.  RE: Custom SQL generator doesn't load when I publish workflow

    Posted May 07, 2013 02:31 PM

    Make sure your updated component also resides on the server you deployed to, not just the one you're debugging on. Checking Publish in the Project Properties should make it do this.



  • 6.  RE: Custom SQL generator doesn't load when I publish workflow

    Posted May 07, 2013 02:33 PM

    I mean manually move the generated library from your server to the server you're publishing to.

    I sometimes get confused as to the difference between Publish/Copy Local myself (I have to look at the code sometimes just to make sure). usually I find it quicker just to update the library on my deployment machine manually though... and just to really make sure the versions are exactly the same.



  • 7.  RE: Custom SQL generator doesn't load when I publish workflow

    Posted May 07, 2013 02:43 PM

    I have been publishing locally.



  • 8.  RE: Custom SQL generator doesn't load when I publish workflow
    Best Answer

    Posted May 07, 2013 02:49 PM

    You probably have multiple copies of the generated lib on your local machine. And Workflow is loading the "wrong" one when you publish.

    If you've been publishing locally, I'd uncheck Publish from your project properties. Then I'd hunt for the bad copy (probably in the \bin folder of the deployed project). I like to keep the "latest and greatest" copies of my generated DLLs in the standard place: <install>/Shared/customlib.



  • 9.  RE: Custom SQL generator doesn't load when I publish workflow

    Posted May 07, 2013 03:20 PM

    Wow, thank you =)