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

Question

Question

Move documents from one folder to another using a schedule rule in workflow

Laserfiche
Updated July 3, 2015
asked on July 2, 2015

Hi All,

I have a workflow which moves documents from a folder to another one. I have created a schedule rule which starts on 02/07/2015 at 16.00 and it should repeat daily.

But, the workflow is not being started automatically. I have gone through the Admin WF guide but there is nothing more to add as configuration. Is there a link that should be created in the LF Administration Console for the workflow to start automatically? How will I know if the workflow has been run correctly?

 

Thanks to advise.

Kind Regards,

Sheila

0 0

Replies

replied on July 3, 2015

Hi Sheila,

 

Check that your rule is enabled:-

(there should be a green tick under the enabled column like this)

 

If it is enabled, you might find some more clues as to why it didn't run in the application log in the event viewer. Also check the LFworkflow log in the event viewer for more information.

There are also some logs under C:\Program Files\Laserfiche\Laserfiche Workflow 9\Logs which may also yield some clues.

 

Good luck! smileyyes

0 0
replied on July 3, 2015

Hi Chris,

Yes, the schedule rule has already been enabled.

 

I'll check in the logs as you mention.

Thanks

Regards,

Sheila

0 0
replied on July 3, 2015

Hi all,

From the event viewer, I get the following error message under LF Workflow:

Log Name:      LFWorkflow
Source:        Laserfiche Workflow Service
Date:          03/07/2015 13:31:59
Event ID:      100
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      WIN-C4I9CJTF055
Description:
Timestamp: 2015-07-03 09:31:59.622

Local Time: 03/07/2015 13:31:59

Category: Errors

Machine: WIN-C4I9CJTF055

Severity: Error

Application Domain: Laserfiche.Workflow.Service.exe

Process Id: 1596

Process Name: C:\Program Files\Laserfiche\Laserfiche Workflow 9\Laserfiche.Workflow.Service.exe

Win32 Thread Id: 2556 - GC

Thread Name: GC

Message: <Exception handlingInstanceId="903a68d0-8fe3-4da4-a770-c15b5cdeb0f0">
  <Description>An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.</Description>
  <DateTime>2015-07-03 13:31:59Z</DateTime>
  <ExceptionType>System.Data.SqlClient.SqlException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
  <Message>Cannot open database "LF_Workflow" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\SYSTEM'.</Message>
  <Source>.Net SqlClient Data Provider</Source>
  <HelpLink />
  <Property name="Errors">System.Data.SqlClient.SqlErrorCollection</Property>
  <Property name="ClientConnectionId">b6089f4c-0988-40ed-8a57-404f4b350545</Property>
  <Property name="Class">11</Property>
  <Property name="LineNumber">65536</Property>
  <Property name="Number">4060</Property>
  <Property name="Procedure" />
  <Property name="Server">WIN-C4I9CJTF055\LASERFICHE</Property>
  <Property name="State">1</Property>
  <Property name="ErrorCode">-2146232060</Property>
  <Property name="HelpLink.ProdName">Microsoft SQL Server</Property>
  <Property name="HelpLink.EvtSrc">MSSQLServer</Property>
  <Property name="HelpLink.EvtID">4060</Property>
  <Property name="HelpLink.BaseHelpUrl">http://go.microsoft.com/fwlink</Property>
  <Property name="HelpLink.LinkId">20476</Property>
  <Property name="System Call">False</Property>
  <Property name="TargetSite">Boolean TryGetConnection(System.Data.Common.DbConnection, UInt32, Boolean, Boolean, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal ByRef)</Property>
  <Property name="HResult">-2146232060</Property>
  <StackTrace>   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&amp; connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Laserfiche.Workflow.Database.CommandExecutor.ExecuteCommand(DbCommand command, Delegate method, CallTypes type)</StackTrace>
  <additionalInfo>
    <info name="MachineName" value="WIN-C4I9CJTF055" />
    <info name="TimeStamp" value="03/07/2015 09:31:59" />
    <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="NT AUTHORITY\SYSTEM" />
  </additionalInfo>
</Exception>
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Laserfiche Workflow Service" />
    <EventID Qualifiers="0">100</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2015-07-03T09:31:59.000000000Z" />
    <EventRecordID>522</EventRecordID>
    <Channel>LFWorkflow</Channel>
    <Computer>WIN-C4I9CJTF055</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Timestamp: 2015-07-03 09:31:59.622

Local Time: 03/07/2015 13:31:59

Category: Errors

Machine: WIN-C4I9CJTF055

Severity: Error

Application Domain: Laserfiche.Workflow.Service.exe

Process Id: 1596

Process Name: C:\Program Files\Laserfiche\Laserfiche Workflow 9\Laserfiche.Workflow.Service.exe

Win32 Thread Id: 2556 - GC

Thread Name: GC

Message: &lt;Exception handlingInstanceId="903a68d0-8fe3-4da4-a770-c15b5cdeb0f0"&gt;
  &lt;Description&gt;An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.&lt;/Description&gt;
  &lt;DateTime&gt;2015-07-03 13:31:59Z&lt;/DateTime&gt;
  &lt;ExceptionType&gt;System.Data.SqlClient.SqlException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089&lt;/ExceptionType&gt;
  &lt;Message&gt;Cannot open database "LF_Workflow" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\SYSTEM'.&lt;/Message&gt;
  &lt;Source&gt;.Net SqlClient Data Provider&lt;/Source&gt;
  &lt;HelpLink /&gt;
  &lt;Property name="Errors"&gt;System.Data.SqlClient.SqlErrorCollection&lt;/Property&gt;
  &lt;Property name="ClientConnectionId"&gt;b6089f4c-0988-40ed-8a57-404f4b350545&lt;/Property&gt;
  &lt;Property name="Class"&gt;11&lt;/Property&gt;
  &lt;Property name="LineNumber"&gt;65536&lt;/Property&gt;
  &lt;Property name="Number"&gt;4060&lt;/Property&gt;
  &lt;Property name="Procedure" /&gt;
  &lt;Property name="Server"&gt;WIN-C4I9CJTF055\LASERFICHE&lt;/Property&gt;
  &lt;Property name="State"&gt;1&lt;/Property&gt;
  &lt;Property name="ErrorCode"&gt;-2146232060&lt;/Property&gt;
  &lt;Property name="HelpLink.ProdName"&gt;Microsoft SQL Server&lt;/Property&gt;
  &lt;Property name="HelpLink.EvtSrc"&gt;MSSQLServer&lt;/Property&gt;
  &lt;Property name="HelpLink.EvtID"&gt;4060&lt;/Property&gt;
  &lt;Property name="HelpLink.BaseHelpUrl"&gt;http://go.microsoft.com/fwlink&lt;/Property&gt;
  &lt;Property name="HelpLink.LinkId"&gt;20476&lt;/Property&gt;
  &lt;Property name="System Call"&gt;False&lt;/Property&gt;
  &lt;Property name="TargetSite"&gt;Boolean TryGetConnection(System.Data.Common.DbConnection, UInt32, Boolean, Boolean, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal ByRef)&lt;/Property&gt;
  &lt;Property name="HResult"&gt;-2146232060&lt;/Property&gt;
  &lt;StackTrace&gt;   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal&amp;amp; connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal&amp;amp; connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&amp;amp; connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Laserfiche.Workflow.Database.CommandExecutor.ExecuteCommand(DbCommand command, Delegate method, CallTypes type)&lt;/StackTrace&gt;
  &lt;additionalInfo&gt;
    &lt;info name="MachineName" value="WIN-C4I9CJTF055" /&gt;
    &lt;info name="TimeStamp" value="03/07/2015 09:31:59" /&gt;
    &lt;info name="FullName" value="Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /&gt;
    &lt;info name="AppDomainName" value="Laserfiche.Workflow.Service.exe" /&gt;
    &lt;info name="ThreadIdentity" value="" /&gt;
    &lt;info name="WindowsIdentity" value="NT AUTHORITY\SYSTEM" /&gt;
  &lt;/additionalInfo&gt;
&lt;/Exception&gt;</Data>
  </EventData>
</Event>

---

Also, the Laserfiche Workflow 9.2 service has been configured as Local System (the Log on type).

Thanks to advise.

Kind Regards,

Sheila

 

0 0
replied on July 3, 2015

Is your SQL server on the same machine? The error indicates that Workflow can't connect as the specified user.

0 0
replied on July 3, 2015

Yes, the SQL is on the same virtual machine. Both LF components and SQL reside on the same VM.

Thanks

Kind Regards,

Sheila 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...