Job Queue through NAV Webservice for mulitple Companies

ara3n · **Posted:** Wed Jan 28, 2009 5:33 pm

I had posted on mibuso a while back on how to use two NAS instances to run job queue for unlimited amount of companies. Here is the link

viewtopic.php?f=7&t=22633. You had to purchase an additional NAS user license in order to use it. Dynamics NAV 2009 comes with web service, and you can publish any Code unit or Page by default. You will need to purchase one user but for webservice, but it much cheaper. In this blog, I will show you how to setup JOB QUEUE to schedule to run jobs across companies. The advantages of using Web Services is that you can run multiple jobs at the same time for multiple companies. What I’ve experienced with NAV 2009 Web Service is that once you call a web service function, you can disconnect and Service Tier will finish the job and commit the transaction.

In addition you don’t have to modify any processing/posting jobs that have dialog windows displayed. The Service tier simply ignores them. For example you can run adjust cost report without modifying any objects from Job queue. In addition, the solution I’ve created does not modify any existing objects!!!

You can download the fob and read more about it on my blog.
http://mibuso.com/blogs/ara3n/2009/01/2 ... companies/

kine · **Posted:** Thu Jan 29, 2009 7:36 am

What to say... =D>

munib00 · **Posted:** Thu Jan 29, 2009 9:45 am

Top quality.

garak · **Posted:** Thu Jan 29, 2009 9:59 am

if i click on the link, the following message is displayed

Quote:

WordPress database error: [Table 'vadysoft_mibusoblogs.wp_38_ras_count' doesn't exist]
INSERT INTO wp_38_ras_count (id) VALUES (NULL)

WordPress database error: [Table 'vadysoft_mibusoblogs.wp_38_ras_image' doesn't exist]
INSERT INTO wp_38_ras_image (id, createtime, word) VALUES (0, 1233215879, 'w6x27rn')

WordPress database error: [Table 'vadysoft_mibusoblogs.wp_38_ras_count' doesn't exist]
DELETE FROM wp_38_ras_count WHERE id = 0

Waldo · **Posted:** Thu Jan 29, 2009 10:43 am

The idea is great! =D>

But I have to think it through though... because when scheduling codeunits through web services ... what about the lack of optimistic concurrency?

ara3n · **Posted:** Thu Jan 29, 2009 2:18 pm

garak wrote:

if i click on the link, the following message is displayed

Quote:

WordPress database error: [Table 'vadysoft_mibusoblogs.wp_38_ras_count' doesn't exist]
INSERT INTO wp_38_ras_count (id) VALUES (NULL)

WordPress database error: [Table 'vadysoft_mibusoblogs.wp_38_ras_image' doesn't exist]
INSERT INTO wp_38_ras_image (id, createtime, word) VALUES (0, 1233215879, 'w6x27rn')

WordPress database error: [Table 'vadysoft_mibusoblogs.wp_38_ras_count' doesn't exist]
DELETE FROM wp_38_ras_count WHERE id = 0

I've uploaded in here as well

http://sites.google.com/site/ara3nfiles ... edirects=0

Luc Van Dyck · **Posted:** Thu Jan 29, 2009 2:28 pm

Blog is working now. I fixed the missing tables.

ara3n · **Posted:** Fri Jan 30, 2009 4:46 pm

I also submitted it to the download section on mibuso.

ara3n · **Posted:** Fri Jan 30, 2009 7:09 pm

Waldo wrote:

The idea is great! =D>

But I have to think it through though... because when scheduling codeunits through web services ... what about the lack of optimistic concurrency?

could you clarify?

Waldo · **Posted:** Mon Feb 02, 2009 12:24 pm

Well, simple ... when two users are running the same webservice, and that web service is a codeunit in NAV ... there is no optimistic concurrency. You have to handle this manually.

kine · **Posted:** Mon Feb 02, 2009 1:33 pm

It will be handled in same way, as when you run these two codeunits in two different clients. There is nothing specific for WebServices in this... ot it is? :-k

Waldo · **Posted:** Mon Feb 02, 2009 1:36 pm

yes there is.
You won't get the message "the record has been changed since you last read it from the table...". No version control.

Or at least, this has been told to me...

ara3n · **Posted:** Mon Feb 02, 2009 3:41 pm

I just tested it and I do get the error.

Code: Select all

Another user has modified the record for this Item after you retrieved it from the database.  Enter your changes again in the updated window, or start the interrupted activity again.  Identification fields and values:  No.='1000'

From webservice.

My test codeunit looked like this.

Code: Select all

Item.GET('1000');
SLEEP(10000);

Item.VALIDATE(Description,'Bicycle WS');
Item.MODIFY;

So while the WS was waiting I modified the description on the item with another client.

Waldo · **Posted:** Mon Feb 02, 2009 4:59 pm

Sorry guys, I can't get into too much of detail .. it's just a warning I have been given a couple of times.
I wish a Microsoft dude (freddy? :wink:

) would stick his nose into this issue, because also I would like to know the details of it ... .

ara3n · **Posted:** Tue Feb 03, 2009 11:19 pm

So how do we get his attention?

mibuso.com

Job Queue through NAV Webservice for mulitple Companies

Who is online