Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [Solved] Stop flow in Datamigrator
Go
New
Search
Notify
Tools
Reply
  
[Solved] Stop flow in Datamigrator
 Login/Join
 
Gold member
posted
trying to figure out a way that if a file does not exist, I want to just stop the flow with out causing error.


the flow runs on a schedule that looks for a file, if it is there run the flow, if not it is OK just stop.

the code below runs but the flow try's to Execute the next procedure, even if the file is not there.


state \\LCBOData\PurchaseOrderinTransitImport\PurchaseOrderinTransit.csv
-RUN
-IF &RETCODE NE 0 THEN GOTO NOT_THERE;

-TYPE files are all there
-TYPE &RETCODE
-EXIT
-NOT_THERE
-TYPE a file is missing
-TYPE ReCode &RETCODE
-TYPE CM__RETURN &&CM__RETURN
-EXIT



this is the error getting sent

09/29/2015 23:59:01 (ICM18122) Request - "lcbodata/lcbopurchaseorderintransitreportflow" (Owner: net\svcIway) submitted.
09/29/2015 23:59:01 (ICM18015) DEP_4: procedure checkforfilelcbopurchaseorderintransitreport started.
09/29/2015 23:59:01 File doesn't exist
09/29/2015 23:59:01 a file is missing
09/29/2015 23:59:01 ReCode -1
09/29/2015 23:59:01 CM__RETURN 001
09/29/2015 23:59:01 (ICM18039) DEP_4 checkforfilelcbopurchaseorderintransitreport Return Code = 001


with the Condition set to only run if the (Return code is 0) to not run the next procedure. where this error coming from?

This message has been edited. Last edited by: ray_In_Vancouver,


IWay SM 5.6, 6.01, 6.1, 6.9, 7.0
EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server
 
Posts: 85 | Registered: February 27, 2009Reply With QuoteReport This Post
Guru
posted Hide Post
Looking (or waiting) for files is what the File Listener is for.

But if you want to hand code this yourself add to your error processing
-SET &&KILL_RPC='Y';
 
Posts: 373 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
Thx Clif, Hope your doing good.

I put the code in but the email is still being sent

2015/09/30 13:03:01 (ICM18974) ------ Start of Log Record for canadacommisions/loadexceptiondatacc ------ canadacommisions loadexceptiondatacc 20150930130300_f17820a5
2015/09/30 13:03:01 (ICM18122) Request - "canadacommisions/loadexceptiondatacc" (Owner: net\svcIway) submitted. canadacommisions loadexceptiondatacc 20150930130300_f17820a5
2015/09/30 13:03:01 (ICM18015) DEP_0: procedure checkcommissionexceptionsfile started. canadacommisions loadexceptiondatacc 20150930130300_f17820a5
2015/09/30 13:03:01 File doesn't exist canadacommisions loadexceptiondatacc 20150930130300_f17820a5
2015/09/30 13:03:01 a file is missing canadacommisions loadexceptiondatacc 20150930130300_f17820a5
2015/09/30 13:03:01 ### Return Code: -1 canadacommisions loadexceptiondatacc 20150930130300_f17820a5
2015/09/30 13:03:01 (ICM18094) User termination via KILL_RPC flag canadacommisions loadexceptiondatacc 20150930130300_f17820a5
2015/09/30 13:03:01 (ICM18031) Finished canadacommisions loadexceptiondatacc 20150930130300_f17820a5
2015/09/30 13:03:01 (ICM18072) Elapsed run time 0:00:01 canadacommisions loadexceptiondatacc 20150930130300_f17820a5
2015/09/30 13:03:02 (ICM18771) Email sent to rcooper@xxxxxxxxxxxxxom canadacommisions loadexceptiondatacc 20150930130300_f17820a5
2015/09/30 13:03:02 (ICM18975) ------ End of Log Record for canadacommisions/loadexceptiondatacc ------ canadacommisions loadexceptiondatacc 20150930130300_f17820a5


wheres it coming from?


IWay SM 5.6, 6.01, 6.1, 6.9, 7.0
EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server
 
Posts: 85 | Registered: February 27, 2009Reply With QuoteReport This Post
Gold member
posted Hide Post
Found it with the Help of Darryl in Toronto Office.

Open up the Server console, go to Special Services And Listeners, right click scheduler, then to properties. Scroll to bottom of page, Under E-Mail Notification, uncheck 'On Failure'

Thx Clif and Darryl


IWay SM 5.6, 6.01, 6.1, 6.9, 7.0
EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server
 
Posts: 85 | Registered: February 27, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [Solved] Stop flow in Datamigrator

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.