ole/db provider 'openxml' irowset::restartposition returned 0x80004005

Error in SQL SERVER 200 :-ole db provider 'openxml' reported an error. the provider did not give any information about the error. ole db error trace [ole/db provider 'openxml' irowset::restartposition returned 0x80004005

This exception generates when you are using openxml and select record directly from xml input file or text .It comes only on SQL SERVER 2000 but not on SQL SERVER 2005.

for resolving such issue you have to first create a temp table in sql server with open xml and select record directly from there temp table instead of selecting direclty from openxml.
like this

Correct :- if(exists(select tblHHA160_HEADER.FED_ID from tblHHA160_HEADER inner join #TempDataHeader on tblHHA160_HEADER.FED_ID=#TempDataHeader.FED_ID))


InCorrect :---if(exists(SELECT FED_ID FROM OPENXML (@idoc, '/ROOT/tblHeader',1) WITH (FED_ID varchar(6)) where FED_ID in (Select FED_ID from tblHHA160_HEADER)))

Comments

Post a Comment

Popular posts from this blog

OutSystems – A Low-code Development Platform

Image
Introduction :- Low-code is a way for developers of all skill levels to design applications quickly and with minimum hand-coding by dragging and dropping visual blocks of existing code into a workflow to create applications.  It is model-driven or visual development paradigms supported by expression languages or scripting. Benefits of Low-Code Platform:- Faster Delivery Time and Reduce the cost of development by up to 60%.
Read more

What is difference between Azure Cognitive Search and Elastic Search

Image
  Cognitive search and Elastic search Azure Cognitive Search :-  The Azure Cognitive Search service enables search over different types of content by letting you create and manage search indexes. You can import data from a variety of sources, with AI-powered indexing that can infer and extract searchable content from non-text sources. You decide what data is imported into the index, and set up indexers to pull that data into it, or push JSON formatted documents manually. Azure Cognitive Search also lets you query search indexes. The results contain only your data, which can include text inferred or extracted from images, or new entities and key phrases detection through text analytics. It's a Platform as a Service (PaaS) so Microsoft manages the infrastructure and availability, allowing your organization to benefit without the need to purchase or manage additional hardware resources. Azure Cognitive Search exists to compliment existing technologies and provides a programmable searc
Read more

failed to access iis metabase asp.net

http://www.blogger.com/img/blank.gif set the userName to SYSTEM in the processModel of the machine.config file, the http://www.blogger.com/img/blank.gifappliaction works just fine. Omitting the userName attribute gives me the error. From reading other posts, this is indicative of a permissions problem. So, without specifying the userName, I tried the application while running filemon, but I don't see any file access getting denied like I expected to see based on the posts I have read. step1:- aspnet_regiis -i Step2:- aspnet_regiis -ga ASPNET http://www.getitshare.com http://www.shriashoka.com
Read more