MS SQL XML - XML errors - 80004005 and 80040e14

Author

XML errors - 80004005 and 80040e14

H. Kalomiris

2005-10-27, 9:25 am

A third party app based in ASP, running on an IIS6 server, is generating the
following error messages when running the various reports provided against an
SQL 2000 server on a separate machine:

Error1:
msxml3.dll error '80004005'

The stylesheet does not contain a document element. The stylesheet may be
empty, or it may not be a well-formed XML document.

/apps/hrd/Utilities.asp, line 1249

Error 2:
Microsoft OLE DB Provider for SQL
Server->HRDPlus.CData2. RunSPReturnRS@DORADO
[version
7.95.9]->HRDPlus.CReportReader.runReportSP@DORADO[version 7.95.9] error
'80040e14'

The column prefix 'P_EM_Employees' does not match with a table name or alias
name used in the query.

/apps/hrd/reports/report.asp, line 99

The Vendor solved their problem by flattening their server, reinstalling
windows, applying all the latest service packs, patches, updates, etc.
We *cannot* do this because of the other applications running on these
servers.

I need to know what piece of windows needs to change; what specific patch,
service pack, software update or security patch to apply.

IIS Server:
IIS6
windows 2003 EE service pack 0,
c:\windows\system32\
msxml3.dll 8.50.2162.0
c:\program files\Common files\Microsoft shared\SFPCA Cache\msxml3.dll
8.40.9419.0
C:\WINDOWS\Registere
dPackages\{C53A407B-397A-4EEC-812F- E951673CDE7F}\msxml3
.dll 8.40.9419.0
C:\WINDOWS\$hf_mig$\
KB824151\RTMQFE\msxm
l3.dll 8.50.2162.0

SQl Server:
SQL 2000 sp3
windows 2003 EE service pack 0 (upgrade in place from Win2k AE)
C:\WINDOWS\system32\
msxml3.dll 8.40.9419.0
C:\WINNT\system32\ms
xml3.dll 8.40.9419.0
C:\WINNT\RegisteredP
ackages\{C53A407B-397A-4EEC-812F- E951673CDE7F}\MSXMLX
.CAB\msxml3.dll 8.30.9926.0

Thank-you.
H. Kalomiris

Michael Rys [MSFT]

2005-10-27, 9:25 am

Error 1 looks like your app could not find a correct XSLT stylesheet. Do you
know what stylesheet it is looking for and where to find it? Maybe it got
corrupted.

Error 2 looks like a problem with a query that is being sent. Is your
database running with a case sensitive collation? If that is not the issue,
can you contact your third party app provider?

Best regards
Michael

"H. Kalomiris" < HKalomiris@discussio
ns.microsoft.com> wrote in message
news:F997CDB3-DED1-45BB-BB93- 824A8CBF64E9@microso
ft.com...
>A third party app based in ASP, running on an IIS6 server, is generating
>the
> following error messages when running the various reports provided against
> an
> SQL 2000 server on a separate machine:
>
> Error1:
> msxml3.dll error '80004005'
>
> The stylesheet does not contain a document element. The stylesheet may be
> empty, or it may not be a well-formed XML document.
>
> /apps/hrd/Utilities.asp, line 1249
>
>
> Error 2:
> Microsoft OLE DB Provider for SQL
> Server->HRDPlus.CData2. RunSPReturnRS@DORADO
[version
> 7.95.9]->HRDPlus.CReportReader.runReportSP@DORADO[version 7.95.9] error
> '80040e14'
>
> The column prefix 'P_EM_Employees' does not match with a table name or
> alias
> name used in the query.
>
> /apps/hrd/reports/report.asp, line 99
>
> The Vendor solved their problem by flattening their server, reinstalling
> windows, applying all the latest service packs, patches, updates, etc.
> We *cannot* do this because of the other applications running on these
> servers.
>
> I need to know what piece of windows needs to change; what specific patch,
> service pack, software update or security patch to apply.
>
>
> IIS Server:
> IIS6
> windows 2003 EE service pack 0,
> c:\windows\system32\
msxml3.dll 8.50.2162.0
> c:\program files\Common files\Microsoft shared\SFPCA Cache\msxml3.dll
> 8.40.9419.0
> C:\WINDOWS\Registere
dPackages\{C53A407B-397A-4EEC-812F- E951673CDE7F}\msxml3
.dll
> 8.40.9419.0
> C:\WINDOWS\$hf_mig$\
KB824151\RTMQFE\msxm
l3.dll 8.50.2162.0
>
> SQl Server:
> SQL 2000 sp3
> windows 2003 EE service pack 0 (upgrade in place from Win2k AE)
> C:\WINDOWS\system32\
msxml3.dll 8.40.9419.0
> C:\WINNT\system32\ms
xml3.dll 8.40.9419.0
> C:\WINNT\RegisteredP
ackages\{C53A407B-397A-4EEC-812F- E951673CDE7F}\MSXMLX
.CAB\msxml3.dll
> 8.30.9926.0
>
> Thank-you.
> H. Kalomiris
>
>
>

Sponsored Links