You are viewing limited content. For full access, please sign in.

Question

Question

Value cannot be null. Parameter name: collection

asked on January 24, 2018

Any ideas as to what the above error means?  I have a simple workflow that searches for documents and for each passes their name to a query.  I can test the query and its fine.  I can also test it with a valid number and its fine.  I have also done a track tokens and see the number it finds....  But running the actual workflow fails.

Testing:

0 0

Replies

replied on January 24, 2018

Which activity throws that error? Could you look in the activity log (WF Admin Console\Monitoring\Error Logs) and post the full error message?

0 0
replied on January 24, 2018

It's the actual Query Data activity that is failing.

Full Error (after removing a username and servername just in case).  The query is to a SQL table that is on the same machine as workflow.

----------------------------------------
Timestamp: 2018-01-24 15:53:56.309
Local Time: 1/24/2018 9:53:56 AM
Category: Activity
Machine: 
Severity: Error
Application Domain: Laserfiche.Workflow.Service.exe
Process Id: 10712
Process Name: C:\Program Files\Laserfiche\Laserfiche Workflow 10.2\Laserfiche.Workflow.Service.exe
Win32 Thread Id: 16460 - 
Thread Name: 
Message: <Exception handlingInstanceId="34821648-6af3-4d76-bb27-8a8a54b7fcfb">
  <Description>An exception of type 'System.ArgumentNullException' occurred and was caught.</Description>
  <DateTime>2018-01-24 09:53:56Z</DateTime>
  <ExceptionType>System.ArgumentNullException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
  <Message>Value cannot be null.
Parameter name: collection</Message>
  <Source>Laserfiche.Workflow.Activities.83.External</Source>
  <HelpLink />
  <Property name="ParamName">collection</Property>
  <Property name="ActivityName">QueryData</Property>
  <Property name="ActivityType">Laserfiche.Workflow.Activities.Data.DataActivity</Property>
  <Property name="InstanceId">c0b49f54-5300-4d69-b694-f79cbcc57bad</Property>
  <Property name="TargetSite">Laserfiche.Project.Data.SourceInformation GetSourceInformation(System.Workflow.ComponentModel.ActivityExecutionContext)</Property>
  <Property name="HResult">-2147467261</Property>
  <StackTrace>   at Laserfiche.Workflow.Activities.Data.DataActivity.GetSourceInformation(ActivityExecutionContext executionContext)
   at Laserfiche.Workflow.Activities.Data.DataActivity.CreateTaskOptions(ActivityExecutionContext executionContext, ITokenService tokenService)
   at Laserfiche.Workflow.Activities.Data.DataActivity.ExecuteTask(ActivityExecutionContext executionContext)
   at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)
   at System.Workflow.Runtime.Scheduler.Run()</StackTrace>
  <additionalInfo>
    <info name="MachineName" value="" />
    <info name="TimeStamp" value="1/24/2018 3:53:56 PM" />
    <info name="FullName" value="Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    <info name="AppDomainName" value="Laserfiche.Workflow.Service.exe" />
    <info name="ThreadIdentity" value="" />
    <info name="WindowsIdentity" value="" />
  </additionalInfo>
</Exception>
----------------------------------------
 

0 0
replied on February 15, 2018

Since I have had this a few times since I just remembered that I posted about this.  The solution I have found is to delete the Query and re-create it.  Not sure why but I continue to see this error at random times in different versions at different clients when doing workflows.  If I encounter this error, I delete the step and re-create it exactly and that seems to work.  Just in case anyone else runs into this error.

2 0
replied on August 30, 2018

Thanks I was baffled. My query which worked fine in both SQL Studio and in the Workflow Designer (when using test) would not run in the actual workflow, throwing this error. I don't have any parameters specified in this case, so I don't know why it is pointing me to a parameter named collection.

Found this post, copied the query to the clipboard, deleted the query activity, added a new one in, pasted the query, and it worked!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.