SIMS.Net CommandReporter scheduled doesn't work

[u8dmtm]

I am using CommandReporter to export reports to XML files from SIMS.Net and have put a number of these command lines into a batch file.

 

When I run the batch file logged in as an admin on our SIMS.Net server it works fine.

 

When I schedule the same batch file, the batch file runs (because it makes entries in the Event Logs) but the CommandReporter aspects are not running.

 

Does anyone have any idea why not? Below is a representation of the batch file:

 

eventcreate /L Application /T INFORMATION /SO WDX /ID 0001 /D "WDX XML Data Export Process Began"

C:

CD C:\Program Files\SIMS\SIMS .net\

commandreporter.exe /USER:SimsUsername /PASSWORD:SimsPassword /REPORT:SimsReportName /OUTPUT:"S:/Users/Username/My Documents/WDX/Students-StudentData.xml" /QUIET

eventcreate /L Application /T INFORMATION /SO WDX /ID 0002 /D "WDX XML Data Export Process Completed"

Edited January 8, 2009 by u8dmtm

[dhicks]

When I schedule the same batch file, the batch file runs (because it makes entries in the Event Logs) but the CommandReporter aspects are not running.

 

Is S drive mounted when your batch file is run as a scheduled job? You might have to add a "net use ..." line in to tell the computer to mount the SIMS area first before you run CommandReporter.

 

--

David Hicks

[u8dmtm]

Is S drive mounted when your batch file is run as a scheduled job? You might have to add a "net use ..." line in to tell the computer to mount the SIMS area first before you run CommandReporter.

Drive S is a drive letter on the server (not a mapped network drive) and is also where the batch file itself is run from. Just to be sure, I moved everything to C: and tried again, but the same issue persists.

[matt40k]

perhaps redirect the output to a file.

 

>>c:\output.txt

[dhicks]

perhaps redirect the output to a file.

 

Good idea - might want to catch stderr as well:

 

>>c:\output.txt 2>&1

 

--

David Hicks

[u8dmtm]

Thanks, that was useful. The output returned was:

 

Login failed for user username. Reason: Incorrect F:\Apps\Sims\Connect.ini file

 

It looks like I will need to log this issue with our LA (who provide SIMS support). Unless anyone knows of a quick fix?

[webman]

What is the contents of that connect.ini file?

[bossman]

Login failed for user username. Reason: Incorrect F:\Apps\Sims\Connect.ini file

 

There is your answer incorrect ini file at F: not S:

[matt40k]

check your sims.ini

[u8dmtm]

Excellent, thanks to all.

 

Drive F: is a mapping so needed to use NET USE to map it for SIMS and it then worked without a problem.