Focal Point
[Solved] Stop flow in Datamigrator

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/7177056876

September 30, 2015, 11:16 AM
ray_In_Vancouver
[Solved] Stop flow in Datamigrator
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
September 30, 2015, 03:50 PM
Clif
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';
September 30, 2015, 04:07 PM
ray_In_Vancouver
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
October 02, 2015, 10:21 AM
ray_In_Vancouver
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