Integration Scheduled tasks

[Luvsql]

I am trying to schedule an integration to run. Everytime I put the syntax to run an integration group:

"C:\Program Files\Microsoft Business Solutions\Integration Manager\IMRun.exe /G DailySales"


xp and Windows 2003 keeps changing the syntax back to
IMRun.exe \G DailySales" and the task never runs.

This is the syntax that has to be run for it to work, but if the OS keeps changing it, how can it ever run? The syntax is on page 125 of the IM user guide.

Another note I'd like to add is that MBS's SQL Optimized adapters should not be advertised. I have never been able to use any of them due to their extreme limitations (can't use SOP, POP or inventory is have segmented sites, can't use SOP or POP if importing currency ID, can't use SOP if importing negative quantities onto invoice which is a new feature of GP 8) and on and on.

 

[klewis10367]

Type it like this:

C:\Program Files\Microsoft Business Solutions\Integration Manager\IMRun.exe /G "DailySales"

Put the quotes just around the Group Name. I believe by putting the qoutes around the whole path, Xp reads this and truncates it all the way up to the IMRun.exe since the path you are referring to is probably shared.

 

[Luvsql]

I have entered this identically but the scheduled task will not run (status shows could not start). I have the admin user associated with the task. Here is how it appears:

C:\Program Files\Microsoft Business Solutions\Integration Manager\IMRun.exe /G "SubrentalPOs" /S

 

[klewis10367]

If I am not mistaken you will need to use AutoDim because you need to have Great Plains running and logged into the company that you want to Integrate into. You can not just run IM as a stand alone unless you are using the SQL Optimizer. It needs to have Great Plains running so it can associate a company database. SQL Optimizer lets you do this on the Integration Setup therefore you do not need to open up Great Plains. Also, I believe you do not need the /S.

 

[Luvsql]

I am using a sql optimized integration, so Great Plains does not need to be running. As well, the /S puts the integration into silent mode, so that the progress screen does not open and remain open after the integration finishes.

 

[klewis10367]

Are you logged into the machine that is running the task or are you leaving it unattended. Also, does the integration run if you do it from the command line and not the scheduled task?

 

[Luvsql]

If I type in the exact same thing in a command prompt, it doesn't run, nor will it run via start > run. I am logged into the machine that I have setup the scheduled task on.

The error when running it via command prompt is 'cannot fine the file C:\Program Make sure the filename and path are correct."

It is the correct path.

 

[klewis10367]

When you open the command prompt what is the default drive and path set to. If it is not set to the C:\ then try changing it to that and then running it.

 

[Luvsql]

I was running it at C:\. It doesn't work under start > run either.

 

[klewis10367]

Can you run this at run, IMRun.exe /G SubrentalPOs /S (Do Not use quotes.)

 

[klewis10367]

Also, in your first post did you originally try it with quotes. I know I said to try it without but I did some looking, and it seems that since there is a space in Program Files, windows xp and 2000 sometimes does not recognize the path. Also you can try installing IM to the root of C:\ and name the Folder just C:\IM.

 

[Luvsql]

I can only get it to run with start > run if I use this:

C:\Program Files\Microsoft Business Solutions\Integration Manager\IMRun.exe

or

"C:\Program Files\Microsoft Business Solutions\Integration Manager\IMRun.exe"

Adding anything else to it causes it to fail.

This is right from the IM manual:

To start an integration or integration group from the command line, use IMRUN.EXE. The syntax is:

IMRun [/I Integration] [/G Integration Group] [/S]

/I Integration—Indicates the name of the integration to run. If the name contains spaces, enclose it in quotation marks.

/G Integration Group—Indicates the name of the integration group to run. If the name contains spaces, enclose it in quotation marks.

/S—Indicates that the integration or integration group are run silently, not displaying the progress dialog.
Note that you can run an integration or an integration group, but not both at the same time.

As an example, the following command runs the Vendor Information integration silently.

IMRun /I “Vendor Information” /S

 

[Luvsql]

I've also tried

C:\Program Files\Microsoft Business Solutions\Integration Manager\IMRun.exe /G SubrentalPOs /S

and

C:\Program Files\Microsoft Business Solutions\Integration Manager\IMRun.exe /G SubrentalPOs

It's failing at the /

 

[jazgeek]

did you try putting the commandline into a batch file and executing the batch? Sometimes that fools the OS.

-----------
and they wonder why they call it Great Pains!

jaz

 

[barksphl]

C:\"Program Files"\"Microsoft Business Solutions"\"Integration Manager"\IMRun.exe /G SubrentalPOs /S

Works for me. Command prompt didn't like the spaces in the folder names so I had to quote the names.

Brad