Is it possible to execute a Dataport from the Job Queue ?

Tarek_Demiati · 2008-10-09

I've got a customer for which I've developped a bunch of dataports for
importing and exporting data.

I've tried to automatized the import/export by setting up the Job Queue
module, however I ran into a silly problem, the job queue is returning me
the following error :

"You cannot use C/AL variables of type DATAPORT when running the Microsoft
Dynamics NAV Application Server."
From the job queue I did setup Codeunit X to be scheduled, and it's within
Codeunit X that Dataport Y is executed ...

My main constraints are that the dataports import quite complicated file
structure and it took me 3 months to develop and test, so I can't really
tell my customer that we must through away all this work ...

How come the Job Queue(Version 5) is not able to perform what the Job
Scheduler(Version 4) was able to do which is scheduling a dataport ? Sure being able to run as a service is an upgrade compared to V4 ...

Does anyone know if there's a work around to this problem ?

matttrax · 2008-10-09

Have you tried calling a codeunit that calls the dataport in OnRun?

Alex_Chow · 2008-10-09

You can move the code to a process only report so the Job Queue can be used.

Tarek_Demiati · 2008-10-09

matttrax wrote:

Have you tried calling a codeunit that calls the dataport in OnRun?

Yes it does not work either

Tarek_Demiati · 2008-10-09

Yes I could, but since there are a dozen of dataports and considering the time constraints I have, I won't be able to convert everything.

For now on I will just install the the Job Scheduler.

I think I will no longer use dataport and develop my own mapping tool, so I've got a good generic tool that will simulate what the dataport was good for (setting the delimiter, fixe/variable lengh ...)

Many of my customers are asking me about using the Job Queue, unfortunatly many of them have got zillions of middle aged dataports ...

Alex Chow wrote:

You can move the code to a process only report so the Job Queue can be used.

David_Singleton · 2008-10-09

Why not use XML ports. You should be able ot find software that converts CSV to XML easy enough.

garak · 2008-10-10

Sorry, but the NAS can't run Dataports. A Client which run the job sheduler can rund dataports (because the GUID)
so, if you need to import / export Datas use a report / Codeunit or XMLPort.

Regards

Alex_Chow · 2008-10-10

Yep, the job scheduler will be able to run dataports. However, job scheduler is not available in version 5.x so I'm assuming you need to do some code merging to get the granule in there.

If so, you're probably better off just migrating the dataports into reports that WRITE into a file. I highly doubt that MSFT will add dataports to be able to run in Job Queue anytime soon.

abufalihah · 2009-03-11

Have you tried to run the Job Queue Dispacher codeunit instead of using NAS? The drawback is you have to keep one active session for this method.

Is it possible to execute a Dataport from the Job Queue ?

Comments

Categories