Workflow Soluiton

 View Only
  • 1.  The Size property has an invalid size of 0

    Posted Aug 07, 2012 03:32 PM

     

    Has anyone ever seen this error message before: String[27]: the Size property has an invalid size of 0. I'm executing an insert stored procedure to write to the database table and this error pops up when called from the Workflow. However, if I execute the proc passing in the same parameters in SQL Studio Management it works just fine. 

    Arya



  • 2.  RE: The Size property has an invalid size of 0

    Posted Aug 07, 2012 03:46 PM

    Any chance I could get the whole stack trace?

    My initial guess is that when running through the generator wizard, the size of a certain parameter isn't populating correctly on the 1st page.



  • 3.  RE: The Size property has an invalid size of 0

    Posted Aug 07, 2012 03:49 PM

     

    Error Stack Trace: 
    System.InvalidOperationException: String[27]: the Size property has an invalid size of 0. at sp_webform_hr_new_hire_ins.SqlQuery.sp_webform_hr_new_hire_ins.Run(IData data) at LogicBase.Core.ExecutionEngine.SinglePathProcessComponentExecutionDelegate.Execute(IData data, IOrchestrationComponent comp, String& outputPath, IExecutionEngine engine, TLExecutionContext context) at LogicBase.Core.ExecutionEngine.AbstractExecutionEngine.RunComponent(TLExecutionContext context, IData data, IOrchestrationComponent comp)
     


  • 4.  RE: The Size property has an invalid size of 0
    Best Answer

    Posted Aug 07, 2012 03:53 PM

    When you run through the generator wizard, try manualy setting the size of the problem parameter in the "Parameters grid". I'm pretty sure this column can be marked up.



  • 5.  RE: The Size property has an invalid size of 0

    Posted Aug 07, 2012 04:29 PM
      |   view attached

    It seems to be the correct parameters as the 27th one is the revision_date. It's really strange seeing this one for the this as my other procs that have similar variables seem to work fine.



  • 6.  RE: The Size property has an invalid size of 0

    Posted Aug 07, 2012 07:42 PM

    I set a manual size of 15 for the @revision_user parameter (it was the 27th one since I forgot the count starts at 0) and it executed the proc correctly. Do you know why I would have to manually set this as I mentioned before I have the exact same parameter in other procs and I did not have the set a size for it. It seems really odd that it would work for others but not this particular one and the procs are basically the same.



  • 7.  RE: The Size property has an invalid size of 0

    Posted Aug 08, 2012 07:38 AM

    I'm unsure why you would need to mark up the size... it's the 1st time I've ever heard of someone actually having to do it. The size should be populated automatically when it finds the parameters.



  • 8.  RE: The Size property has an invalid size of 0

    Posted Aug 08, 2012 09:50 AM

    I agree and that's why I was surprised to see this error pop up when executing the proc from Workflow. Hopefully this was a one time thing and won't happen again. Thanks for the help reecardo.