Problem with Excel export with NAS

Emerik
Emerik Member Posts: 50
edited 2013-05-23 in NAV/Navision Classic Client
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

  • jannestig
    jannestig Member Posts: 1,000
    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
  • Emerik
    Emerik 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
  • danielecacchi
    danielecacchi 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.
  • greggalloway
    greggalloway 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.
  • darkmaster
    darkmaster 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
  • james_cs
    james_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.

Categories