Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Chart

Automated Batch job: problem if the user is not logged in

More
14 years 1 month ago #2058 by Gennaro
I've scheduled a flowheater batch job managed by the Windows XP "Scheduled Tasks" application.

If the user is logged to the pc the procedure completes correctly, on the the contrary, if the PC is in the "logged off" status, the following error appears after launching the batch job:

MS Excel coud not be startet. One reason can be, Excel is not installed on this computer?


p.s. I get this error because a used an error text log (via the script "if %ERRORLEVEL% LSS 0 goto error" etc ...)

Regards

Please Log in or Create an account to join the conversation.

More
14 years 1 month ago #2059 by FlowHeater-Team
Replied by FlowHeater-Team on topic Automated Batch job: problem if the user is not logged in
One reason can be that the task logon user is different to the pc logged in user? If you just created a new (technical) user account for the scheduled task you have first to login with this user account. After login start Excel for the first time and fill out the MS Excel user information dialog like user name and initials ;)

Now try to execute the batch job manually. If this runs well you can logoff the scheduled task are working now.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

More
14 years 1 month ago #2061 by Gennaro
I've tried to re-set the user & password on the windows task manger, but the problem is still present.

the problem is that on a PC with no user logged in (log off status), the batch script (managed by the windows task manager program) is executed, but the flowheater batch program produces an error: "MS Excel coud not be startet. One reason can be, Excel is not installed on this computer?"

Please Log in or Create an account to join the conversation.

More
14 years 1 month ago - 1 year 1 week ago #2062 by FlowHeater-Team
Replied by FlowHeater-Team on topic Automated Batch job: problem if the user is not logged in
I’ve made today 3 tests with the FlowHeater Batch module and a scheduled windows task!
  1. Windows XP and Office/Excel 2007 (both German)
  2. Windows XP and Office /Excel 2007 (both English)
  3. Windows XP (Italian) and Office/Excel 2007 (English)
All 3 test scenarios run well from a scheduled windows task and no user is logged in on the PC. This time I don’t know what the problem can be :(

Please try the follows
  1. Verify the user account is really the user account you want (e.g. Domain user / local user)
  2. Grants the user admin rights
  3. Create the registry entry "ExcelLanguage" under HKEY_LOCAL_MACHINE instead of HKEY_CURRENT_USER. For more info’s have a look to the release notes for version 1.2.4 . After this check the FlowHeater Version, you need the Version 1.2.4 or higher.
  4. Be sure you have started Excel (for the first time) with the user account you want to run the task. For more info´s see my last reply to this thread .
  5. Try to run a simple FlowHeater Definition with the TestData Adapter on the READ and TextFile Adapter on the WRITE side.
  6. Copy all FlowHeater DLL and EXE files from the FlowHeater\BIN folder to the folder you have saved the Definition and also the batch CMD file and modify the paths in the CMD command script
If this doesn’t work please post your batch command script for more analysis and also the result for the steps above.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Last edit: 1 year 1 week ago by FlowHeater-Team.

Please Log in or Create an account to join the conversation.

More
14 years 4 weeks ago #2064 by Gennaro
The problem was due to rights of the user (proposed steps 1 and 2). Now, everything works correctly.

Thank you very much for your help!!!

best regards

Please Log in or Create an account to join the conversation.

Time to create page: 0.271 seconds
FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.