0 Replies Latest reply: May 15, 2014 10:16 AM by roger_27 _ RSS

    Sequence contains no elements ??

    roger_27 _

      here is the exact error. I haven't used data pump since version 10.5. This web interface is nice but this is a cryptic error message:

       

      11-03-2013 02:12:17 Created.

       

       

      + 11-03-2013 02:12:17 Pump process failed: System.InvalidOperationException: Sequence contains no elements at System.Linq.Enumerable.First[TSource](IEnumerable`1 source) at Datawatch.Services.DataPump.Processing.Services.PumpLocationService.ExecuteTaskProcessing(PumpTask pumpTask, PumpJob mainPumpJob, PumpManifestSerialized manifestSerialized) at Datawatch.Services.DataPump.Processing.Services.PumpLocationService.RunPump(PumpTask pumpTask, IDictionary`2 statuses, PumpJob mainPumpJob, PumpManifestSerialized manifestSerialized).

       

       

      + 11-03-2013 02:12:17 Failed: System.InvalidOperationException: Sequence contains no elements at System.Linq.Enumerable.First[TSource](IEnumerable`1 source) at Datawatch.Services.DataPump.Processing.Services.PumpLocationService.ExecuteTaskProcessing(PumpTask pumpTask, PumpJob mainPumpJob, PumpManifestSerialized manifestSerialized) at Datawatch.Services.DataPump.Processing.Services.PumpLocationService.RunPump(PumpTask pumpTask, IDictionary`2 statuses, PumpJob mainPumpJob, PumpManifestSerialized manifestSerialized) 

       

      + 11-03-2013 02:12:17 Distribution started.

      + 11-03-2013 02:12:17 Distribution completed.

       

       

      OKAY I FIGURED THAT ONE OUT!!!

      I didn't have an input file I guess... so now I get

       

       

      Failed: Invalid Path: Provider=SQLOLEDB.1;Data Source=DBSAPP2;Persist Security Info=True;User ID=DBS_User;Initial Catalog=Statement_Data

       

      System.ArgumentException: Invalid Path: Provider=SQLOLEDB.1;Data Source=ABSAPP2;Persist Security Info=True;User ID=DBS_User;Initial Catalog=Statement_Data

       

      WHAT DOES THIS MEAN???

      When I test the DB connection in the project editor, it all works okay.  Why would I get an invalid path ?

       

      Any help or advice is really appreciated.  I wish Technical support was open on weekends!

       

      Thanks!