Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

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

Automated Batch job: problem if the user is not logged in 6 years 1 month ago #2058

  • Gennaro
  • Gennaro's Avatar
  • Offline
  • Junior Member
  • Posts: 25
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
The administrator has disabled public write access.

Re:Automated Batch job: problem if the user is not logged in 6 years 1 month ago #2059

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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.
The administrator has disabled public write access.

Re:Automated Batch job: problem if the user is not logged in 6 years 1 month ago #2061

  • Gennaro
  • Gennaro's Avatar
  • Offline
  • Junior Member
  • Posts: 25
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?"
The administrator has disabled public write access.

Re:Automated Batch job: problem if the user is not logged in 6 years 1 month ago #2062

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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 10 months ago by FlowHeater-Team.
The administrator has disabled public write access.

Re:Automated Batch job: problem if the user is not logged in 6 years 1 month ago #2064

  • Gennaro
  • Gennaro's Avatar
  • Offline
  • Junior Member
  • Posts: 25
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
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.076 seconds