הערה
הגישה לדף זה מחייבת הרשאה. באפשרותך לנסות להיכנס או לשנות מדריכי כתובות.
הגישה לדף זה מחייבת הרשאה. באפשרותך לנסות לשנות מדריכי כתובות.
Question
Thursday, September 10, 2015 8:53 AM
I have check password of interactive user its correct still we are facing issue but some time its work.
we don't understand why this happen?
Actually we are using office automation for generating excel file and convert generated excel file to PDF.
From last one month it working fine but now we are facing issue regarding office automation.
system show below error
9/8/2015 9:58:28 AM
System.Runtime.InteropServices.COMException (0x8000401A): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.
In DCOM of excel application setting, we set the interactive user and set all permission to that user also that user continuously login to the server user never log off.
please help to resolve above issue.
Thanks
Sangram
All replies (5)
Thursday, September 24, 2015 6:28 AM ✅Answered
Hi Sangram Sapkal,
>>”The process cannot access the file because it is being used by another process”
Based on your exception message, I think the issue was clearly. You need to close the file stream after you have generated excel file. Then you could try to convert it into PDF.
You could refer to this similar thread for details: “File is being used by another process” after File.Create
Best Regards,
Xavier Eoro
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.
Thursday, September 10, 2015 8:58 AM
we are using office automation for generating excel file and convert generated excel file to PDF.
From last one month it working fine but now we are facing issue regarding office automation.
system show below error
9/8/2015 9:58:28 AM
System.Runtime.InteropServices.COMException (0x8000401A): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.
In DCOM of excel application setting, we set the interactive user and set all permission to that user also that user continuously login to the server user never log off.
please help to resolve above issue.
Thanks
Sangram
Thursday, September 10, 2015 9:00 AM
hii
Today I found that the interactive user is logged in on the application server but wherever the application server will going to locked then also that office automation for generating excel file and convert generated excel file to PDF. It shows the exception
9/8/2015 9:58:28 AM
System.Runtime.InteropServices.COMException (0x8000401A): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.
Please Give me the reason behind that and also solution for it.
Thanks in Advance
Sangram
Friday, September 11, 2015 5:42 AM
Hi Sangram Sapkal,
In my experience, It should be the permissions problem.
Please have a try using the following steps to Configure DCOM:
1. Go to the Start-Run menu to type in "dcomcnfg" and hit enter to load "Component Services" MMC.
2. Select the "Microsoft Excel Application" item through "Component Services" MMC->Component
Services->Computers->My Computer->DCOM Config->Microsoft Excel Application
3. Right click and select Properties->Select Identity Tab->Select This user and add the Administrator accout and password
4. Select Security Tab, Under "Launch and Activation Permissions", Choose "Customize", Click "Edit" button, Add the everyone account and add all the Permissions.
5. Do the same thing in "Access Permissions" and "Configuration Permissions"
Best Regards,
Xavier Eoro
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.
Friday, September 18, 2015 11:11 AM
hii Xavier Eoro,
i tried this setting but system give error during accessing the excel file.
the error is
The process cannot access the file because it is being used by another process
the excel file is generated but whenever it try to convert it into the PDF then it fails to access the excel file
Please Give me the reason behind that and also solution for it.
Thanks in Advance
Sangram