|
Home > Archive > BizTalk Server Orchestration > October 2005 > SQL Adapter Error 0x80004005
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Adapter Error 0x80004005
|
|
| Jyoti Khetan 2005-10-24, 10:31 am |
| Hello All
I am facing a problem in my Orchestration that uses an SQL Adapter. This
Orch just takes an XML file and inserts values from this file into my SQL
2000 database. It was working fine yesterday. Today, suddenly i get this
error 0x80004005 in HAT.
Does anyone know why this is happening, or what is the way out? Please
respond
Regards
Jyoti
| |
| Hannes Morsten 2005-10-24, 10:32 am |
| Why are you using an orchestration for that? Try it with a simple Map from
your input schema to the SQL Adapter generated schema of your stored
procedure (plus a SQL SendPort and a File Receive Port).
"Jyoti Khetan" wrote:
> Hello All
>
> I am facing a problem in my Orchestration that uses an SQL Adapter. This
> Orch just takes an XML file and inserts values from this file into my SQL
> 2000 database. It was working fine yesterday. Today, suddenly i get this
> error 0x80004005 in HAT.
> Does anyone know why this is happening, or what is the way out? Please
> respond
>
> Regards
> Jyoti
>
>
>
| |
| MapleLeaf 2005-10-24, 10:32 am |
| Hi Jyoti,
I run into the same error too...Have you solved the problem yet? Would you
please share with me on what you have done to resolve the issue?
I have an orchestration that would use an stored procedure with 1 parameter
to
clean up holding tables in SQL 2000. That procedure went fine, I think, cause
I didn't see any suspended message of that message type in HAT. But it's
strange that I don't see anything about this message in HAT at all.
Then I have several SQL updategram to load those holding tables. They went
through. I can see them in SQL.
Then I call another stored procedure to perform updates to SQL 2000 based on
the data in the holding tables. That's when my messagae got suspended
according
to HAT.
Do you know what possibly would have gone wrong?
"Hannes Morsten" wrote:
[vbcol=seagreen]
> Why are you using an orchestration for that? Try it with a simple Map from
> your input schema to the SQL Adapter generated schema of your stored
> procedure (plus a SQL SendPort and a File Receive Port).
>
>
> "Jyoti Khetan" wrote:
>
|
|
|
|
|