mibuso.com

In that case just just run standard NAV Job queue for each company. And write record in the other company Job queue entry as in the above link and wait till it gets processed by NAS.

If posting errors then grab the error and you need to specify how you want to proceed.

Hope this makes sense.

One NAS for each company A and B (need to purchase One more NAS).

From Company A Write Order to Company B. Write entry into job queue entry of Company B. Wait for NAS to post in Company B. If successful then continue, else take appropriate action.

Oh I'd forgotten about this.
Okay, it's not difficult to make a NAS that hops between companies, and you only need one NAS and it works with 3.01B (this is when I tried it).

First you need the DLL that's used by the windows to configure the NAS.



Next you need the service name of the NAS.



Then you just set it:


The NAS will switch companies when the current trigger exits.

Use an NFTimer as normal to get control back.



If you want to log error messages use the error event trigger.



Seems to be reliable, if a little slow.

Might be useful as well.
Batch/CMD code to create NAS instanse "on-fly".



Note about "sc" syntax. "demand" means "Manual" service start-up.
It weird, but you HAVE TO put "space" before parameter's value. Otherwise it will not work.

Later you just need to use "net start <service name>"/"net stop <service name>".

Here is another solution using webservices.


viewtopic.php?f=32&t=31476

You don't need to purchase a second expensive NAS.

Hello, ara3n!
Thank you for your job. It really helped!
I have a problem, though. In case there are any quotation marks (") in company name, job fails. In fact, 2nd application server fails to start and Job Queue log contains an error with company name without quotation marks (see attached image). If company name is renamed (quotation marks are removed), everything works fine.
Of course, we can rename the company, if there is not the other solution. What would you suggest?

I would try and change the CU and add Double quotes to the Company parameter.

Change the code




to

'company="' + JobQueueEntry."Company Name" + '",'+

Hello. Adding additional quotes did not help. Anyway, we have already renamed companies, so the problem is not an issue anymore.

Yet we have another problem: everything works fine on Windows 2003 server, but on Windows 2008 server the 2nd application server hangs up - it never starts. I tried to test the functionality by starting codeunit 448 directly. In this case black command line window appears (which is run to start application server) and no further actions are performed. Job queue entries are not processed. What could be the reason?

I haven't tested in windows 2008.
if you run the CU manually.


Make sure that this is where you installed NAS, If not change the string in the red section to the correct directory.

WindowShell.CurrentDirectory('C:\Program Files\Microsoft Dynamics NAV\Application Server\')
ELSE
WindowShell.CurrentDirectory(APPLICATIONPATH);
txtCommand := 'NASSQL servername=' + Server."Server Name" + ','+
'database=' + Session."Database Name" + ','+
'company=' + JobQueueEntry."Company Name" + ','+
'nettype=TCP,startupparameter=' + 'JOBQUEUE2|'+COMPANYNAME+'|'+FORMAT(JobQueueEntry.ID);
WSHExec := WindowShell.Exec(txtCommand);

Also manually from from command prompt try to start the NAS. AND make sure txtCommand is well formatted based based on your results.
Also see what APPLICATIONPATH returns in NAV on 2008. It should return the same directory where NAS is installed.

Thank you, ara3n, for your reply.

I have further testing results.
But first more information about environments:
Windows 2003 server - is our testing environment. As I've said before - everything works fine here.
Windows 2008 server - client's production system. The problem is on this environment.

So, I've decided to do the following on the client's environment:
1. I've installed application server on another computer, running win.xp and tried to run the functionality -> same problem.
2. Next, I've installed 2 separate application servers (2 services) - one server for each company - and have set up jobs in each company -> everything works fine.

Something wrong is in whole environment, the server is not the one rising issue, I guess. 2nd application server cannot be started by the 1st NAS.


Yes, I have already changed it. We have different directory: 'C:\Program Files (x86)\Microsoft Dynamics NAV\Application Server\'

Yes, that's correct. C:\Program Files (x86)\Microsoft Dynamics NAV\Application Server\


I have copied txtCommand variable value from debugger and tried to start NAS manually. It started, although I had to add few quotation marks (") to startup parameter:
NASSQL servername=MYSERVERNAME,database=My Database Name,company=My Test Company,nettype=TCP,startupparameter="JOBQUEUE2|Master Database Name|{E0013D2F-B34B-48B6-8614-C761EB7F3041}"
The quotation marks I've added to code:


Any ideas?

Check your PM.
I would need to look at 2008 server.

I found where the problem was!
SQL server, DB settings: client had CS (case sensitive) database
The main company, Job Queue jobs were run from, had lower and upper case characters in its name. When the company name was passed through NAS it has been converted to upper case. Then in codeunit (Run NAS Accross Company) the company was supposed to be fetched from "Company" table and the action could not be completed. Here is the code:

This type of error was not handled in portion of code analyzing NAS command promt output.

I changed the code in Codeunit "Run NAS Accross Company" as follows:
Function OnRun()

Function RunNasForOtherCompany()


Of course, the company name has to be renamed in this case (or additional code has to be added to handle name conversion back to its original state).

Thank you very much, ara3n, for your help and the piece of functionality

Hello,

I read the first posts. I am in this situation:
- I only have 2 companies A and B
- I actually have only 1 standard NAS granule
- I need to run a report that import data in company A reading from a text file (and this should go right with the NASSQL installation a 1 standard granule)
- I also need to run another report on company B alway for import data reading from a text file.

I ask you:
- this solution is not for me because I only have 2 companies and need to buy however the second NAS granule. Is that correct? I don't need unlimited company but only two.
- is it possible to use only first NASSQL connected to company A to run also the second report loading data on company B using something like CHANGECOMPANY or this is not recommented if I use for example validate functions? The report insert and modify data on table Customer.

Thank you

On what version are you on?

If you are on 2009, I could offer a better solution.

Thanks.

you can also contact rdebath and look at his solution I haven't tried that one.

For this customer we have NAV 5.0 SP1

Thanks

You will need a second NAS.
As you mentioned you can use changecompany but validation does not run in the other company.