Dynamic data import / export

datenbank

simply more productive
Up to 100,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.
  • Page:
  • 1

TOPIC: Batch module - excel issue

Batch module - excel issue 5 years 3 weeks ago #2251

  • Gennaro
  • Gennaro's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 25
I wrote a simple script to run the batch module, I scheduled the script run via Windows scheduling task application, but I am encountering the following error (from the batch program debug):

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


While if I run the script manually, everything works fine.


any ideas?


thanks in advance

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

Re:Batch module - excel issue 5 years 3 weeks ago #2253

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 275
Hi Gennaro,

It could be three possible reasons:
  1. You try to run the scheduled task without user/password login information? For excel you need a windows user logon profile.
  2. Your (scheduled task) user hasn’t enough rights.
  3. If you have created a new user for the scheduled task you have first to logon with this user and start Excel manually one time.

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

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.

Re:Batch module - excel issue 5 years 3 weeks ago #2254

  • Gennaro
  • Gennaro's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 25
You are right.

After reviewing the event log, I found an error in COM Server for Microsoft Office Excel Application:

The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID
{00024500-0000-0000-C000-000000000046} to the user XXXXXXXXXXXXXXXXXX SID (S-1-5-21-818223188-3440559113-342323212-11453).
This security permission can be modified using the Component Services administrative tool.

For more information, see Help and Support Center at go.microsoft.com/fwlink/events.asp .


thanks!

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

Re:Batch module - excel issue 5 years 3 weeks ago #2257

  • Gennaro
  • Gennaro's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 25
It was a COM permissions problem.

I solved via:

Start > Run > dcomcnfg (or “mmc -32″ and then add the Component Services snap-in manually if you can’t find the app under step 3)

Navigate to Component Services > Computers > My Computer > DCOM Config

Locate the MS application giving you trouble (eg: “Microsoft Excel Application” for Excel or “Microsoft Word 97 – 2003 Document” for Word)

Right click > Properties

On the security tab: Select Customize under Launch and Activation Permissions and click Edit…

Add the account under which the site is running (eg: Network Service) and assign Local Launch & Local Activation permissions

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

  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.088 seconds