Options

Problem with Excel export with NAS

EmerikEmerik Member Posts: 50
Hello,
I have written a report, that uses the Table 370 Excel buffer to export data to multiple Excel-files. It works fine, when I run the report manually (with same user as with NAS), but when I let the NAS run it, it fails during the first export with the following error:
This message is for C/AL programmers:

An exception was raised in method SaveAs. The OLE control or Automation server has returned error (HRESULT) -2147352567.
The component did not provide the exception description.

Runtime is NAV 5.0 SP1
Database is NAV 4.0 SP1
OS is Windows Server 2008 Standard SP1
Excel is MS Office Excel 2007 SP2
NAS is NAV 5.0 SP1

Can anyone figure out, what could be wrong?

P.S. I have just tried to run the NAS with the debug option. It seems to work ALSO. Weird... Why would it work in debug mode and not in normal mode?

Kind regards,
Emerik

Comments

  • Options
    jannestigjannestig Member Posts: 999
    You are not alone.

    viewtopic.php?f=23&t=38483

    This guy solved his issue though

    viewtopic.php?f=23&t=26971&hilit=excel+NAS&start=15
  • Options
    EmerikEmerik Member Posts: 50
    Hi Jannestig,
    Thank you for your reply. However, my problem is slightly different, and cannot be resolved by the thread mentioned.

    The errors are different. And I have noticed, that in debug mode, the export with NAS works just fine, whereas it doesn't work, when NAS is not in debug mode.

    NAS user is member of the servers Administrators group.

    So I would still like to get some help on this issue.

    Thx anyway.

    Emerik
  • Options
    danielecacchidanielecacchi Member Posts: 13
    If you find a solution , please post it.
    I've an analog problem in reading excel by NAS.
    I'm thinking there is something in excel 2007 running in background.
    I've tried to insert a XlApp.VISIBLE:=FALSE , but nothing changed.
  • Options
    greggallowaygreggalloway Member Posts: 1
    Hi Emerik,

    Were you ever able to resolve this issue? I am experiencing exactly the same problem and cannot find a resolution anywhere.

    Thanks,
    Greg.
  • Options
    darkmasterdarkmaster Member Posts: 4
    i had the same problem today i found the solution under http://social.msdn.microsoft.com/Forums/en/innovateonoffice/thread/b81a3c4e-62db-488b-af06-44421818ef91

    This solution is ...
    ・Windows 2008 Server x64
    Please make this folder.
    C:\Windows\SysWOW64\config\systemprofile\Desktop

    ・Windows 2008 Server x86
    Please make this folder.
    C:\Windows\System32\config\systemprofile\Desktop
    Grütter Pascal
    p.gruetter(at)darkmaster.ch
    4402 Frenkendorf
    www.pascal-gruetter.com
    www.darkmaster.ch
  • Options
    james_csjames_cs Member Posts: 39
    darkmaster - you da man!

    I love mibuso - it has got me out of so many holes. and darkmaster can chalk up another one!

    Thank you.
Sign In or Register to comment.