mibuso.com

Microsoft Business Solutions online community
It is currently Thu Jun 20, 2013 12:24 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 109 posts ]  Go to page Previous  1 ... 3, 4, 5, 6, 7, 8  Next
Author Message
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Wed Apr 07, 2010 5:29 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8732
Location: 3rd rock from sun
Country: United States (us)
That is odd. Try to run it from cprompt as before do you get the same results?

Are you specifying some specific printer? Do you get the same result on on NASSQL as on native?

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Tue Apr 27, 2010 1:38 pm 
Offline

Joined: Mon Sep 18, 2006 3:40 pm
Posts: 31
Location: bangalore
Country: India (in)
Hi All,

I am getting confused..

1. I have installed NAS.
2. I have 12+1 [one dummy company] companies.. data for all 12+1 companies will be available in one table in NAV. I have to move them to the respective company's General Journal. I have few [based on Transaction Type] reports to do the same. Now i need to schedule the same on NAS.

3. I have imported the above customized objects. But getting confused with the setup.
a) In which company I have to do the Job Queue Setup.
b) In the Job Queue Entries, which object to run.. my customized reports or the CU 448??
c) What about the Job Queue in the other companies??

What i did..
1. After installing NAS, imported the customized Job Queue objects.
2. In the dummy company i created one Job Queue Entry to run a customized 50001 report and the company i selected was Company1.
3. In the Event Viewer i am getting an error

The value of COPYSTR parameter 3 is outside of the permitted range.

The current value is: -1.
The permitted range is: from 0 to 2147483647

I saw that in the Codeunit 50000 [Run NAS Accross Company], the
txtFromCompany := COPYSTR(strParamemter,1,STRPOS(strParamemter,'|')-1);
is returning this error..

So please let me know, whats the mistake i am doing.. ](*,)

Thanx in advance..

_________________
Sandeep B


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Wed Aug 11, 2010 2:13 am 
Offline

Joined: Tue Jun 30, 2009 9:16 pm
Posts: 121
We are using Native 5.0 SP1. I have downloaded and imported the objects into the database from the given link. I tried to compile the codeunit 50000. I am getting the error message “Table data 2000000047 doesn’t exist”. I think the virtual table number 2000000047 works for SQL server. Could you please tell me what should I use the table number for Server in Native?

Thank you for your help!



Administrator wrote:
Job Queue for Unlimited Company
The Job Scheduler 4.0 has been replaced in in 5.0 by Job Queue. You can use Job Queue to schedule to run reports, Codeunits, as adjust cost. Job Queue uses NAS to run the job. As you might know NAS can only run for one company. Thus if you have multiple companies, you need one instance of NAS per Company. The following modification allows you to run Job Queue in unlimited companies. Using two license instances of NAS. You only need to install one NAS. The code run NAS itself as second instance connecting to different companies. The only difference Setup wise is the new field "Company Name" in Job Queue Entry Code, where you can select other Companies.

You could run with one instance of NAS and a Navision client, by running CU 448 directly from a client where NAS is installed. NAS service should be stopped. NAS uses windows authentication so make sure have windows authentication.

Feedback is welcome.
Enjoy.

http://www.mibuso.com/dlinfo.asp?FileID=924

Discuss this download here.


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Wed Aug 11, 2010 10:35 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8732
Location: 3rd rock from sun
Country: United States (us)
that table is the server table. I just need to know what the server name is. You can have it as a setup or get it from wherever NAV classic gets it in file->datbase->information

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Thu Aug 12, 2010 4:23 pm 
Offline

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
Hi,

My requirements are something like that. Client has multiple companies with 2 NAS license. Now I want one NAS will call Master Company and thru Job scheduler and other NAS will call all other companies one by one. Like Job scheduler will call one company, process the code kill the session and call 2nd company and like that.

I gone thru the code design for multiple companies but I am not sure if this will solve my problem. I cannot see anywhere in the code where its looping all the company one by one. Please let me know if I understand wrong.

Your help and quick response will be highly appreciated.

Regards
Mini


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Fri Aug 13, 2010 4:24 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8732
Location: 3rd rock from sun
Country: United States (us)
There is a new field on Job Queue Entry table called Company Name and the job would run for that company.

If you have multiple companies, you would create one job queue entry for each company.

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Fri Aug 13, 2010 4:36 pm 
Offline

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
Hi,

Thanks for prompt reply. But I am little confused. Did you meant that in each company, define a compnay name in new field "Company Name", in Job Queue entry card?

If yes then how the NAS will switch one compant from other since only 2nd instance of NAS will run per company. Do I need to schedule different time for diffrent company to run the Job queue or the system will smart enoghu if process one by one company.

Please advice.

Regards
Mini


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Sat Aug 14, 2010 5:21 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8732
Location: 3rd rock from sun
Country: United States (us)
you will setup the job queue in one company only. For each job queue entry record in that one company you can specify in which company that object will run I just looked at my blog and it looks like the company name is specified in

So one NAS will look only in one company. and will call the second NAS based on Job queue entry card new field company name.

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Tue Aug 24, 2010 9:55 pm 
Offline

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
I have the same issue as sandy_bsil have.
Event Type: Warning
Event Source: GGHAPP01-SQL
Event Category: None
Event ID: 20010
Date: 8/24/2010
Time: 3:24:28 PM
User: N/A
Computer: GGHAPP01
Description:
The value of COPYSTR parameter 3 is outside of the permitted range.

The current value is: -1.
The permitted range is: from 0 to 2147483647.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

This error message is comming due the code written in CU50000

txtFromCompany := COPYSTR(strParamemter,1,STRPOS(strParamemter,'|')-1);

strParameter = JOBQUEUE2

Please advice.


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Wed Aug 25, 2010 5:21 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8732
Location: 3rd rock from sun
Country: United States (us)
I guess there is a problem with how the Parameter is being passed to the CU when NAS starts. Put a breakpoint and solve it.

//MOD01 Start
IF (COPYSTR(Parameter,1,9) = 'JOBQUEUE2') THEN BEGIN
CU50000.SetParameter(Parameter);
CU50000.RUN;
CGNASStartedinLoop := TRUE;
END;
//MOD01 End

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Wed Aug 25, 2010 10:30 pm 
Offline

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
I have a qurey regarding NAS license. My company bought 1 more NAS license so total 2 new sessions. I amk geeting the error message :
Event Type: Warning
Event Source: GGHAPP01-SQL
Event Category: None
Event ID: 20010
Date: 8/25/2010
Time: 4:18:26 PM
User: N/A
Computer: GGHAPP01
Description:
Your program license does not permit more users to work simultaneously.

Wait until another user has stopped using the program.

Contact your system administrator if you want to allow more simultaneous users on your system.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Is that mean, somehow 2nd NAS session is not existing in license? If I can see the License granules it shows that:

1415 - Application Server Each 1

Is that mean License has 2nd NAS session or just one seesion come by default?
If this is 2nd NAS session license then why I ma getting the above error message?

Regards
Mini


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Thu Aug 26, 2010 3:26 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8732
Location: 3rd rock from sun
Country: United States (us)
Did you upload the license on sql server?

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Thu Aug 26, 2010 3:30 pm 
Offline

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
I uploaded the license under C:\Program Files\Microsoft Dynamics NAV\60\Classic(SQL Server) and C:\Program Files\Microsoft Dynamics NAV\60\Application Server (Application server). Do i need to upload the license any other place?


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Thu Aug 26, 2010 5:40 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8732
Location: 3rd rock from sun
Country: United States (us)
The license is stored in Master database.

To Upload.

Tools->License Information ->Upload button.

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Thu Aug 26, 2010 6:29 pm 
Offline

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
Yes license is already uploded in Master DB.

Now I am getting one more issue. I installed 2 NAS some weeks ago. Both are working fine at a time( not simultaneously for sure). I am not sure what happend today, I cannot see second NAS in NASMSnapIN under Appilcation Server for Microsoft Dynamics NAV Manager. However I can see both NAS in Services.( I can even start both the NAS).

Under Appilcation Server for Microsoft Dynamics NAV im getting the error message :
Unable to locate Application Server 'GGHAPP01-SQL' running on computer '10.243.105.176'.

I can see the first NAS though. How can I see second NAS?

Regards,
Madhavi


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 109 posts ]  Go to page Previous  1 ... 3, 4, 5, 6, 7, 8  Next

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: