Job Queue in Nav Three Tier

paramb · 2011-04-21

Hi All,

I have a Job Queue setup and is working good. I noticed that the Job Queue is executed using Nav 2 Tier and not 3 Tier. I have also found comments from various others posting that Job Queue can be executed in 3 Tier using webservice. I really appreciate if some one can help me to have the Job Queue executed in 3 tier. I have three tier installed and working with webservice.

Thanks in advance for any help.

Regards,
siyab

ara3n · 2011-04-21

Here are the how to using sql jobs and 3 tier.

http://mibuso.com/blogs/ara3n/2009/11/1 ... b-service/

Here is using NAS to run the job on NAS.

http://mibuso.com/blogs/ara3n/2009/01/2 ... companies/

paramb · 2011-04-21

Thanks Rashed for quick reply. I have seen your posting for Running Job Queue through NAV Web service for Unlimited Companies. I am new to the three tier architecture for Nav and the project I am working has 3 tier already installed and working succesfully. I also have Jobs working succesfully.

This is my case. I have a Job Queue which does the posting of Purchase Order receipt. The new requrement is generate a PDF copy of the Posted Invoice document and place it in a folder. I have created a new function and called it from the posting routin and is working good if Purchase Order is posted from the Nav RTC(3 Tier). When the Job Queue post the Purchase Orders the PDF Invoice generation doesnt work as SaveAsPDF command will only work in 3 tier.

All I need is a little bit more instructions on how to get this Job executed in three tier. Remember the Job Queue and Webservice is working now. Will some minor tweaking will get the Job executed in three tier or I will require to write any code to get this Job executed in three tier.

ara3n · 2011-04-21

It's minor change.

You need to import the new text file CU 50000. Change CU to some other number if you already have a CU 50000.

Then publish the CU on webservice.

Then schedule it on jobqueue based on screenshot.

Put in the parameter the Company and the other object you would like to run that will do all the stuff required such as save as PDF.

paramb · 2011-04-22

Hi,

I have received an error 'Unhandled Error. Please check the xml file' in the Job Queue Log Entry. I have seen another posting with the same issue but did not see a solution for that error. I have opened the response.xml file in note pad and it is a blank file.

ara3n · 2011-04-23

You'll need to pass the login and password. If you read the comments, I've posted info on this.
Also you need to setup delegation.

You could test it on one machine where you have nas,service tier and sql on same box.

alwaysguna · 2011-04-23

Hi Siyab,

You have verify these 3 things to make it work.

1 object to be called using the webservice
2 Company name if it is with spaces should be encoded with Percentage
3 Authentication details to be provided

paramb · 2011-04-25

Hi,

I have given userd id and password and got the following error message.

'This message is for C/AL programmers: The call to member send failed. msxml3.dll returned the following message: The login request was denied'

I am trying to get this executed in a Nav 3 tier environment where Nav Webservice and NAS installed on the same computer and SQL Server is on a different computer. The windows userid for the Nav Web Service, NAS and the Job Queue is the same.

Rashed have mentioned in the last posting that delegetion must be setup. Could some one please provide more info that. Is that causing the error message which I am getting. If not,k what could be causing the error.

ara3n · 2011-04-26

Here is the walk through,

http://msdn.microsoft.com/en-us/library/dd301254.aspx

ara3n · 2011-04-26

also see if you can change the NTLM settings in cusomsettings.config file in your service tier.

Change it to true and then restart the nav services.

paramb · 2011-04-26

Hi Rashed,

NTLM settings in cusomsettings.config file is already set to True. Working on getting the delegation setup per the Blog you have mentioned.

I have a different question at this point. Just to make sure I am giving the user credentials correct.

When I use - domain/windowslogin: I get the error ''This message is for C/AL programmers: The call to member send failed. msxml3.dll returned the following message: The login request was denied"

When I use - domain\windowslogin: I get the error "a:Microsoft.Dynamics.Nav.Service.WebServices.ServiceBrokerExceptionService "Codeunit/RunJob" was not found!Service "Codeunit/RunJob" was not found!"

ara3n · 2011-04-26

Did you enter a new record in table Web Service in correct CASE RunJob ?

If NAS and Webservice are running on same box, you don't need delegation.

paramb · 2011-04-26

It is working!!!.....

The problem was the wrong case.

Thank you very much.

ara3n · 2011-04-26

I saw one more person make that mistake.
I should have kept the function name all lowercase.

Howdy, Stranger!

Quick Links

Categories

Job Queue in Nav Three Tier

Answers