Re: XMLtoCursor : Invalid class string Michael Hogan (Ideate Hosting)
Rick Strahl
Aug 4, 2014 @ 03:06pm
I have a program that sends XML data up to my web site on an hourly basis and at some point (a few days) in time it stops working and returns:
Processing Error - https://www.interlight.biz/OrderImport.int?Error: 1426
Message: OLE error code 0x800401f3: Invalid class string.
Code:
Program: orderimport
Line No: 111
Client: 173.150.244.198
... at this line of code: XMLTOCURSOR(lcOrdersXML,"ImportOrders")
If VFP uses MSXML3, is there some way to re-initialize it after each method call? Is there some other methodology I should be using? Perhaps EncodeDBF/DecodeDBF?
It appears that Rick's wwXML also uses MSXML3, so I'm guessing I would have the same problem.
XmlToCursor uses MS Xml 3.0 which should be on every machine you run. XmlAdapter requires MS XML 4.0 and you need to install this if you use it. MS XML 6 will not install 4 so that is separate - post MS XML 3 are all separate side by side versions so they all require specific installation. VFP doesn't use anything past 4 internally.
+++ Rick ---
Hi
We use the native VFP XMLtoCursor function to convert an XML string to a cursor. This is done on a (Win XP SP2) PC with the latest available MS XML installed (6.00.3883.0).
When the code executes - we get the following error message :
Error #1426
OLE error code 0x800401f3 : Invalid class string.
What do I do to correct?
Thanks!
Jan
Michael
www.WebConnectionHosting.com
Re: XMLtoCursor : Invalid class string Rick Strahl
Michael Hogan (Ideate Hosting)
Aug 4, 2014 @ 05:41pm
You might want to make sure you install the latest MsXml bits on the machine. I suspoect the error might be intermittent as certain features are accessed (formatters maybe?)...
Usually Invalid Class string seems to suggest that the COM class is not visible to the client - possibly because permissions have changed? Could it be related to impersonation in your Web application?
+++ Rick ---
I'm getting this same error with a webconnect application, but only after a period of successful operation.
I have a program that sends XML data up to my web site on an hourly basis and at some point (a few days) in time it stops working and returns:
Processing Error - https://www.interlight.biz/OrderImport.int?Error: 1426
Message: OLE error code 0x800401f3: Invalid class string.
Code:
Program: orderimport
Line No: 111
Client: 173.150.244.198
... at this line of code: XMLTOCURSOR(lcOrdersXML,"ImportOrders")
If VFP uses MSXML3, is there some way to re-initialize it after each method call? Is there some other methodology I should be using? Perhaps EncodeDBF/DecodeDBF?
It appears that Rick's wwXML also uses MSXML3, so I'm guessing I would have the same problem.
XmlToCursor uses MS Xml 3.0 which should be on every machine you run. XmlAdapter requires MS XML 4.0 and you need to install this if you use it. MS XML 6 will not install 4 so that is separate - post MS XML 3 are all separate side by side versions so they all require specific installation. VFP doesn't use anything past 4 internally.
+++ Rick ---
Hi
We use the native VFP XMLtoCursor function to convert an XML string to a cursor. This is done on a (Win XP SP2) PC with the latest available MS XML installed (6.00.3883.0).
When the code executes - we get the following error message :
Error #1426
OLE error code 0x800401f3 : Invalid class string.
What do I do to correct?
Thanks!
Jan
West Wind Technologies
Making waves on the Web
from Maui
Re: XMLtoCursor : Invalid class string Michael Hogan (Ideate Hosting)
Rick Strahl
Dec 18, 2014 @ 09:55am
All the msxml3 bits seem to be in their proper places. Checking further...
You might want to make sure you install the latest MsXml bits on the machine. I suspoect the error might be intermittent as certain features are accessed (formatters maybe?)...
Usually Invalid Class string seems to suggest that the COM class is not visible to the client - possibly because permissions have changed? Could it be related to impersonation in your Web application?
+++ Rick ---
I'm getting this same error with a webconnect application, but only after a period of successful operation.
I have a program that sends XML data up to my web site on an hourly basis and at some point (a few days) in time it stops working and returns:
Processing Error - https://www.interlight.biz/OrderImport.int?Error: 1426
Message: OLE error code 0x800401f3: Invalid class string.
Code:
Program: orderimport
Line No: 111
Client: 173.150.244.198
... at this line of code: XMLTOCURSOR(lcOrdersXML,"ImportOrders")
If VFP uses MSXML3, is there some way to re-initialize it after each method call? Is there some other methodology I should be using? Perhaps EncodeDBF/DecodeDBF?
It appears that Rick's wwXML also uses MSXML3, so I'm guessing I would have the same problem.
XmlToCursor uses MS Xml 3.0 which should be on every machine you run. XmlAdapter requires MS XML 4.0 and you need to install this if you use it. MS XML 6 will not install 4 so that is separate - post MS XML 3 are all separate side by side versions so they all require specific installation. VFP doesn't use anything past 4 internally.
+++ Rick ---
Hi
We use the native VFP XMLtoCursor function to convert an XML string to a cursor. This is done on a (Win XP SP2) PC with the latest available MS XML installed (6.00.3883.0).
When the code executes - we get the following error message :
Error #1426
OLE error code 0x800401f3 : Invalid class string.
What do I do to correct?
Thanks!
Jan
Michael
www.WebConnectionHosting.com
Re: XMLtoCursor : Invalid class string Rick Strahl
Michael Hogan (Ideate Hosting)
Dec 18, 2014 @ 12:38pm
I would log user access, and native account information in your app (ie. SYS(0)) on every hit and see if that somehow changes. It sure sounds to me like the impersonation is changing back and forth when people are logged on, and when it does you may not have rights to MSXML anymore.
If that's not the case then you may have some MSXML corruption which is going to be a much bigger and more problematic issue to deal with.
+++ Rick ---
No, it's intermittent. If I reload the COM instances, it will work again for some period of time - even on the xml that failed just moments before (which seems to rule out the formatters idea).
All the msxml3 bits seem to be in their proper places. Checking further...
You might want to make sure you install the latest MsXml bits on the machine. I suspoect the error might be intermittent as certain features are accessed (formatters maybe?)...
Usually Invalid Class string seems to suggest that the COM class is not visible to the client - possibly because permissions have changed? Could it be related to impersonation in your Web application?
+++ Rick ---
I'm getting this same error with a webconnect application, but only after a period of successful operation.
I have a program that sends XML data up to my web site on an hourly basis and at some point (a few days) in time it stops working and returns:
Processing Error - https://www.interlight.biz/OrderImport.int?Error: 1426
Message: OLE error code 0x800401f3: Invalid class string.
Code:
Program: orderimport
Line No: 111
Client: 173.150.244.198
... at this line of code: XMLTOCURSOR(lcOrdersXML,"ImportOrders")
If VFP uses MSXML3, is there some way to re-initialize it after each method call? Is there some other methodology I should be using? Perhaps EncodeDBF/DecodeDBF?
It appears that Rick's wwXML also uses MSXML3, so I'm guessing I would have the same problem.
XmlToCursor uses MS Xml 3.0 which should be on every machine you run. XmlAdapter requires MS XML 4.0 and you need to install this if you use it. MS XML 6 will not install 4 so that is separate - post MS XML 3 are all separate side by side versions so they all require specific installation. VFP doesn't use anything past 4 internally.
+++ Rick ---
Hi
We use the native VFP XMLtoCursor function to convert an XML string to a cursor. This is done on a (Win XP SP2) PC with the latest available MS XML installed (6.00.3883.0).
When the code executes - we get the following error message :
Error #1426
OLE error code 0x800401f3 : Invalid class string.
What do I do to correct?
Thanks!
Jan
West Wind Technologies
Making waves on the Web
from Maui
Re: XMLtoCursor : Invalid class string Michael Hogan (Ideate Hosting)
Rick Strahl
Dec 19, 2014 @ 07:39am
Thanks for the tip!
I would log user access, and native account information in your app (ie. SYS(0)) on every hit and see if that somehow changes. It sure sounds to me like the impersonation is changing back and forth when people are logged on, and when it does you may not have rights to MSXML anymore.
If that's not the case then you may have some MSXML corruption which is going to be a much bigger and more problematic issue to deal with.
+++ Rick ---
No, it's intermittent. If I reload the COM instances, it will work again for some period of time - even on the xml that failed just moments before (which seems to rule out the formatters idea).
All the msxml3 bits seem to be in their proper places. Checking further...
You might want to make sure you install the latest MsXml bits on the machine. I suspoect the error might be intermittent as certain features are accessed (formatters maybe?)...
Usually Invalid Class string seems to suggest that the COM class is not visible to the client - possibly because permissions have changed? Could it be related to impersonation in your Web application?
+++ Rick ---
I'm getting this same error with a webconnect application, but only after a period of successful operation.
I have a program that sends XML data up to my web site on an hourly basis and at some point (a few days) in time it stops working and returns:
Processing Error - https://www.interlight.biz/OrderImport.int?Error: 1426
Message: OLE error code 0x800401f3: Invalid class string.
Code:
Program: orderimport
Line No: 111
Client: 173.150.244.198
... at this line of code: XMLTOCURSOR(lcOrdersXML,"ImportOrders")
If VFP uses MSXML3, is there some way to re-initialize it after each method call? Is there some other methodology I should be using? Perhaps EncodeDBF/DecodeDBF?
It appears that Rick's wwXML also uses MSXML3, so I'm guessing I would have the same problem.
XmlToCursor uses MS Xml 3.0 which should be on every machine you run. XmlAdapter requires MS XML 4.0 and you need to install this if you use it. MS XML 6 will not install 4 so that is separate - post MS XML 3 are all separate side by side versions so they all require specific installation. VFP doesn't use anything past 4 internally.
+++ Rick ---
Hi
We use the native VFP XMLtoCursor function to convert an XML string to a cursor. This is done on a (Win XP SP2) PC with the latest available MS XML installed (6.00.3883.0).
When the code executes - we get the following error message :
Error #1426
OLE error code 0x800401f3 : Invalid class string.
What do I do to correct?
Thanks!
Jan
Michael
www.WebConnectionHosting.com
Re: XMLtoCursor : Invalid class string Rick Strahl
Michael Hogan (Ideate Hosting)
Dec 19, 2014 @ 09:16pm
There are special MSXML components that have to be installed on the server, but those are part of the regular patches on Windows, so if the server is patched that should be there.
FWIW, I use XmlToCursor() myself for a lot of things and I don't see any problems so this seems like an odd configuration/install issue perhaps?
+++ Rick ---
I've switched to using a cursoradapter, which uses msxml4. If that does not solve the issue, I will begin recording sys(0) when it fails in a try-catch.
Thanks for the tip!
I would log user access, and native account information in your app (ie. SYS(0)) on every hit and see if that somehow changes. It sure sounds to me like the impersonation is changing back and forth when people are logged on, and when it does you may not have rights to MSXML anymore.
If that's not the case then you may have some MSXML corruption which is going to be a much bigger and more problematic issue to deal with.
+++ Rick ---
No, it's intermittent. If I reload the COM instances, it will work again for some period of time - even on the xml that failed just moments before (which seems to rule out the formatters idea).
All the msxml3 bits seem to be in their proper places. Checking further...
You might want to make sure you install the latest MsXml bits on the machine. I suspoect the error might be intermittent as certain features are accessed (formatters maybe?)...
Usually Invalid Class string seems to suggest that the COM class is not visible to the client - possibly because permissions have changed? Could it be related to impersonation in your Web application?
+++ Rick ---
I'm getting this same error with a webconnect application, but only after a period of successful operation.
I have a program that sends XML data up to my web site on an hourly basis and at some point (a few days) in time it stops working and returns:
Processing Error - https://www.interlight.biz/OrderImport.int?Error: 1426
Message: OLE error code 0x800401f3: Invalid class string.
Code:
Program: orderimport
Line No: 111
Client: 173.150.244.198
... at this line of code: XMLTOCURSOR(lcOrdersXML,"ImportOrders")
If VFP uses MSXML3, is there some way to re-initialize it after each method call? Is there some other methodology I should be using? Perhaps EncodeDBF/DecodeDBF?
It appears that Rick's wwXML also uses MSXML3, so I'm guessing I would have the same problem.
XmlToCursor uses MS Xml 3.0 which should be on every machine you run. XmlAdapter requires MS XML 4.0 and you need to install this if you use it. MS XML 6 will not install 4 so that is separate - post MS XML 3 are all separate side by side versions so they all require specific installation. VFP doesn't use anything past 4 internally.
+++ Rick ---
Hi
We use the native VFP XMLtoCursor function to convert an XML string to a cursor. This is done on a (Win XP SP2) PC with the latest available MS XML installed (6.00.3883.0).
When the code executes - we get the following error message :
Error #1426
OLE error code 0x800401f3 : Invalid class string.
What do I do to correct?
Thanks!
Jan
West Wind Technologies
Making waves on the Web
from Maui
Re: XMLtoCursor : Invalid class string Michael Hogan (Ideate Hosting)
Rick Strahl
Mar 2, 2015 @ 12:56pm
I have the code trying to use MSXML3, then trying MSXML4 in the CATCH - so both are failing occasionally.
I'm planning to switch to your old EncodeDBF / DecodeDBF to transfer the data. Here's hoping that's not using MSXML in the background...
I cannot think if a way to track down the problem at the os/dll level. I found no info in the event logs but I may not know exactly what to look for.
Michael
I would log user access, and native account information in your app (ie. SYS(0)) on every hit and see if that somehow changes. It sure sounds to me like the impersonation is changing back and forth when people are logged on, and when it does you may not have rights to MSXML anymore.
If that's not the case then you may have some MSXML corruption which is going to be a much bigger and more problematic issue to deal with.
+++ Rick ---
No, it's intermittent. If I reload the COM instances, it will work again for some period of time - even on the xml that failed just moments before (which seems to rule out the formatters idea).
All the msxml3 bits seem to be in their proper places. Checking further...
You might want to make sure you install the latest MsXml bits on the machine. I suspoect the error might be intermittent as certain features are accessed (formatters maybe?)...
Usually Invalid Class string seems to suggest that the COM class is not visible to the client - possibly because permissions have changed? Could it be related to impersonation in your Web application?
+++ Rick ---
I'm getting this same error with a webconnect application, but only after a period of successful operation.
I have a program that sends XML data up to my web site on an hourly basis and at some point (a few days) in time it stops working and returns:
Processing Error - https://www.interlight.biz/OrderImport.int?Error: 1426
Message: OLE error code 0x800401f3: Invalid class string.
Code:
Program: orderimport
Line No: 111
Client: 173.150.244.198
... at this line of code: XMLTOCURSOR(lcOrdersXML,"ImportOrders")
If VFP uses MSXML3, is there some way to re-initialize it after each method call? Is there some other methodology I should be using? Perhaps EncodeDBF/DecodeDBF?
It appears that Rick's wwXML also uses MSXML3, so I'm guessing I would have the same problem.
XmlToCursor uses MS Xml 3.0 which should be on every machine you run. XmlAdapter requires MS XML 4.0 and you need to install this if you use it. MS XML 6 will not install 4 so that is separate - post MS XML 3 are all separate side by side versions so they all require specific installation. VFP doesn't use anything past 4 internally.
+++ Rick ---
Hi
We use the native VFP XMLtoCursor function to convert an XML string to a cursor. This is done on a (Win XP SP2) PC with the latest available MS XML installed (6.00.3883.0).
When the code executes - we get the following error message :
Error #1426
OLE error code 0x800401f3 : Invalid class string.
What do I do to correct?
Thanks!
Jan
Michael
www.WebConnectionHosting.com
Re: XMLtoCursor : Invalid class string Rick Strahl
Michael Hogan (Ideate Hosting)
Mar 2, 2015 @ 01:02pm
EncodeDbf and DecodeDbf do not use MSXML since they're just picking up the raw files and putting them into strings.
But... given all that, I run MSXML based data in a number of apps on my server without any issues. There must be some problem with the VFP runtime install or MSXML install? You should consider re-installing the VFP runtimes perhaps and maybe looking for the explicit MSXML installers from Microsoft.
+++ Rick ---
This is still occurring erratically. SYS(0) is reporting local administrator in all instances.
I have the code trying to use MSXML3, then trying MSXML4 in the CATCH - so both are failing occasionally.
I'm planning to switch to your old EncodeDBF / DecodeDBF to transfer the data. Here's hoping that's not using MSXML in the background...
I cannot think if a way to track down the problem at the os/dll level. I found no info in the event logs but I may not know exactly what to look for.
Michael
I would log user access, and native account information in your app (ie. SYS(0)) on every hit and see if that somehow changes. It sure sounds to me like the impersonation is changing back and forth when people are logged on, and when it does you may not have rights to MSXML anymore.
If that's not the case then you may have some MSXML corruption which is going to be a much bigger and more problematic issue to deal with.
+++ Rick ---
No, it's intermittent. If I reload the COM instances, it will work again for some period of time - even on the xml that failed just moments before (which seems to rule out the formatters idea).
All the msxml3 bits seem to be in their proper places. Checking further...
You might want to make sure you install the latest MsXml bits on the machine. I suspoect the error might be intermittent as certain features are accessed (formatters maybe?)...
Usually Invalid Class string seems to suggest that the COM class is not visible to the client - possibly because permissions have changed? Could it be related to impersonation in your Web application?
+++ Rick ---
I'm getting this same error with a webconnect application, but only after a period of successful operation.
I have a program that sends XML data up to my web site on an hourly basis and at some point (a few days) in time it stops working and returns:
Processing Error - https://www.interlight.biz/OrderImport.int?Error: 1426
Message: OLE error code 0x800401f3: Invalid class string.
Code:
Program: orderimport
Line No: 111
Client: 173.150.244.198
... at this line of code: XMLTOCURSOR(lcOrdersXML,"ImportOrders")
If VFP uses MSXML3, is there some way to re-initialize it after each method call? Is there some other methodology I should be using? Perhaps EncodeDBF/DecodeDBF?
It appears that Rick's wwXML also uses MSXML3, so I'm guessing I would have the same problem.
XmlToCursor uses MS Xml 3.0 which should be on every machine you run. XmlAdapter requires MS XML 4.0 and you need to install this if you use it. MS XML 6 will not install 4 so that is separate - post MS XML 3 are all separate side by side versions so they all require specific installation. VFP doesn't use anything past 4 internally.
+++ Rick ---
Hi
We use the native VFP XMLtoCursor function to convert an XML string to a cursor. This is done on a (Win XP SP2) PC with the latest available MS XML installed (6.00.3883.0).
When the code executes - we get the following error message :
Error #1426
OLE error code 0x800401f3 : Invalid class string.
What do I do to correct?
Thanks!
Jan
West Wind Technologies
Making waves on the Web
from Maui