mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 12:05 pm

All times are UTC + 1 hour [ DST ]




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

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8700
Location: 3rd rock from sun
Country: United States (us)
Add it to MMC right click on Application Server for Microsoft Dyanmics NAV manager and select New and add the service.

_________________
Rashed.

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


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

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
Getting same error message from MMC. :(


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

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8700
Location: 3rd rock from sun
Country: United States (us)
I suggest to contact your partner and let them test your license and make it works with two NASes.

_________________
Rashed.

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


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

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
2 NAS working simultaneoulsy if I define 2 two different companies manully. With Multicompnay and Job queue its not working.

2 NAS installed under the name HHJ-SQL1 and HHJ-SQL2

What I did:
1) Assign all the info manually for one company(Master Company) thru MMC with following parameters in HHJ-SQL1:
Database Server Name:
Company Name: MASTER
Start-UP Parameter := JOBQUEUE|MASTER|{2BFEC4EE-D6FF-4BC0-8A8F-FBE51C21C41D}
Net Tpe:TCP
Cache: 8000

2) Master company - Jobqueue Entry Card
Object Type to run : Codeunit
Object ID to run: 50062(Custom define codeunit - allow to add some data in table)
Parameter String : JOBQUEUE
Company Name : Atlanta

3) Master company - Jobqueue Entry Card
Object Type to run : Codeunit
Object ID to run: 50062(Custom define codeunit - allow to add some data in table)
Parameter String : JOBQUEUE
Company Name : Orlendo

Now when I run HHJ-SQL1, its run codeunit 50062 for Master Company and the stooped. Never run for Atlanta and Orlendo company.

What I am expecting that Master company will runs First NAS(HHJ-SQL1) and thru code written in 50001(RunNASforMultiple Comp) will run second NAS(HHJ-SQL2) for Atlanta and Orlendo and will execute codeunit 50062.

But it not wroking like that.

Please let me know if my understanding is wrong. Or I am doing something wrong stepwise.


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Fri Aug 27, 2010 5:00 pm 
Offline

Joined: Thu Sep 22, 2005 8:45 am
Posts: 125
Location: Göteborg + Skövde
Country: Sweden (se)
minicanada wrote:
2 NAS working simultaneoulsy if I define 2 two different companies manully. With Multicompnay and Job queue its not working.

2 NAS installed under the name HHJ-SQL1 and HHJ-SQL2

What I did:
1) Assign all the info manually for one company(Master Company) thru MMC with following parameters in HHJ-SQL1:
Database Server Name:
Company Name: MASTER
Start-UP Parameter := JOBQUEUE|MASTER|{2BFEC4EE-D6FF-4BC0-8A8F-FBE51C21C41D}
Net Tpe:TCP
Cache: 8000

2) Master company - Jobqueue Entry Card
Object Type to run : Codeunit
Object ID to run: 50062(Custom define codeunit - allow to add some data in table)
Parameter String : JOBQUEUE
Company Name : Atlanta

3) Master company - Jobqueue Entry Card
Object Type to run : Codeunit
Object ID to run: 50062(Custom define codeunit - allow to add some data in table)
Parameter String : JOBQUEUE
Company Name : Orlendo

Now when I run HHJ-SQL1, its run codeunit 50062 for Master Company and the stooped. Never run for Atlanta and Orlendo company.

What I am expecting that Master company will runs First NAS(HHJ-SQL1) and thru code written in 50001(RunNASforMultiple Comp) will run second NAS(HHJ-SQL2) for Atlanta and Orlendo and will execute codeunit 50062.

But it not wroking like that.

Please let me know if my understanding is wrong. Or I am doing something wrong stepwise.


Try to remove the bold+underline entries
1. |MASTER|{2BFEC4EE-D6FF-4BC0-8A8F-FBE51C21C41D}
2+3. JOBQUEUE

_________________
Regards
Dan Lindström
NCSD Navision 2.00 since 1999 (Navision Certified Solution Developer)
MBSP Developer for Microsoft Dynamics NAV 2009


Top
 Profile E-mail WWW  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Fri Aug 27, 2010 5:23 pm 
Offline

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
If I removed |MASTER|{2BFEC4EE-D6FF-4BC0-8A8F-FBE51C21C41D} I am getting the below error message:

Event Type: Warning
Event Source: GGHAPP01-SQL-2
Event Category: None
Event ID: 20010
Date: 8/27/2010
Time: 11:14:06 AM
User: N/A
Computer: GGHAPP01
Description:
The value of COPYSTR parameter 2 is outside of the permitted range.

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

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


This error comes due the code written in 50001

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


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Fri Aug 27, 2010 6:51 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8700
Location: 3rd rock from sun
Country: United States (us)
My code only gets called if startup parameter is JOBQUEUE2 not JOBQUEUE.

Check your code.

_________________
Rashed.

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


Top
 Profile  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Fri Aug 27, 2010 7:09 pm 
Offline

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
Getting the same error message eve if I change from JOBQUEUE to JOBQUEUE2

Event Type: Warning
Event Source: GGHAPP01-SQL-2
Event Category: None
Event ID: 20010
Date: 8/27/2010
Time: 12:56:20 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.


And reson I am gettin this if you see in the code:


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

since strParamemter in NAS1 = JOBQUEUE2, there is no value wheich will filter for STRPOS(strParamemter,'|').
and that is the reason COPYSTR in txtFromCompany is failed.

Any idea?


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Fri Aug 27, 2010 7:45 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8700
Location: 3rd rock from sun
Country: United States (us)
As I mentioned the startup parameter is used by 1st nas to start the second nas and pass parameter/company/record to process the job.

You shouldn't use it to start NAS.

_________________
Rashed.

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


Top
 Profile  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Fri Aug 27, 2010 7:56 pm 
Offline

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
I think I confused here.

I have 2 NAS - HHG-SQL1 and HHG-SQL2.

In application server under console I define all the values in HHG-SQL1(Like Server, Database name, company and Startup parameter=JOBQUEUE2)

In Codeunit 1 I called CU50001. In 50001 under function I dfined second NAS configuration(Like server, Database, Company Name(From Job Queue Entry Card - "Company Name" field) and Startup Parameter=JOBQUEUE2|MASTER|JobqueueID.

Now When I am tryning to run First NAS from Application Srever, getting the error message CopySTR out of range.

What I am doing wrong here please advice. I am really confused.
Regards


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Fri Aug 27, 2010 8:17 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8700
Location: 3rd rock from sun
Country: United States (us)
It looks like you did not follow the directions.

Do you have more than 2 companies? If you have just two companies then you don't need this modification.



Add the following to CU 1

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


You also do not need to install two NAS Service just one.

_________________
Rashed.

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


Top
 Profile  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Fri Aug 27, 2010 8:23 pm 
Offline

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
Yes I already written code in CU 1. I modifed all the objects downloaded from the link you specified.


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Fri Aug 27, 2010 8:24 pm 
Offline

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
I disabled the second NAS but same error getting

Event Type: Warning
Event Source: GGHAPP01-SQL-2
Event Category: None
Event ID: 20010
Date: 8/27/2010
Time: 2:22:24 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.


Top
 Profile E-mail  
 
 Post subject: Re: Job Queue for Unlimited Company
PostPosted: Fri Aug 27, 2010 8:46 pm 
Offline

Joined: Thu Aug 12, 2010 4:13 pm
Posts: 26
Country: Canada (ca)
I didnot understand yet what I am doing wrong :(. Run the first NAS from command prompt but same error getting :(


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

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8700
Location: 3rd rock from sun
Country: United States (us)
Check your PM.

_________________
Rashed.

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


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

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 3 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: