|
Home > Archive > BizTalk Server Setup > January 2005 > 0x80040e14 and BTS Rollup Package 1
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 |
0x80040e14 and BTS Rollup Package 1
|
|
| norgie 2004-10-21, 7:47 am |
| Hi.
When trying to insert data into a db-table using BTS' Sql Adapter and an
updategram (for insert) I'm getting the following error:
The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14"
Description="Could not find stored procedure 'after'."
According to an MSDN article this may be due to some whitespace problem and
according to the same article was fixed in the BTS Rollup Package 1. So I
downloaded and installed the RP1, but encountered another error during the
installation:
[10/21/04 12:46:00] Custom Action: Patch BizTalk databases...
[10/21/04 12:46:00] <CustomActionData
xmlns="http://schemas.microsoft.com/2004/BizTalkCustomActionData"
Name="PatchDatabasesCA">
<Database Name="MGMTDB">
<Script Filename="update_Admin_server_logic.sql"/>
</Database>
<Database Name="MSGBOXDB">
<Script Filename="msgbox_security_logic.sql"/>
<Script Filename="msgbox_application_logic.sql"/>
</Database>
</CustomActionData>
[10/21/04 12:46:00] Resolved database: Alias=MGMTDB.
[10/21/04 12:46:00] Failed to resolve database: Alias=MSGBOXDB, Error:
HRESULT=0x80040e09 .
[10/21/04 12:46:01] Begin distributed transaction.
[10/21/04 12:46:01] Apply patch: Server="oslsqltest",
Database="BizTalkMgmtDb", Script="C:\Documents and Settings\All
Users\Application Data\Microsoft\E-Business Servers
Updates\BTS2004\Uninstall943\update_Admi
n_server_logic.sql".
[10/21/04 12:46:01] dataSource.Open HRESULT=0
[10/21/04 12:46:01] session.Open HRESULT=0
[10/21/04 12:46:01] file.Open HRESULT=0
[10/21/04 12:46:01] Processing... HRESULT=0
I don't know how to solve this and find myself in a situation where our
project is now being delayed due to BTS failing to update the DB. So if
anyone has a solution and/or suggestion for solving this, I'd be grateful to
hear from you.
TIA
-- norgie
| |
| norgie 2004-10-21, 7:47 am |
| Hi again,
I've solved the first part. The Sql adapter does not like multiple
<sync></sync> elements. Nor does it like one <sync></sync> containing
multiple <after></after>
elements. What it does like is a structure like this
<sync>
<after>
<footable (lots of attributes) />
:
:
<footable (lots of attributes) />
</after>
</sync>
-------------
What remains to be solved is the error from the RP1 istallation. Ideas anyone?
TIA
-- norgie
"norgie" wrote:
> Hi.
>
> When trying to insert data into a db-table using BTS' Sql Adapter and an
> updategram (for insert) I'm getting the following error:
>
> The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14"
> Description="Could not find stored procedure 'after'."
>
> According to an MSDN article this may be due to some whitespace problem and
> according to the same article was fixed in the BTS Rollup Package 1. So I
> downloaded and installed the RP1, but encountered another error during the
> installation:
>
> [10/21/04 12:46:00] Custom Action: Patch BizTalk databases...
> [10/21/04 12:46:00] <CustomActionData
> xmlns="http://schemas.microsoft.com/2004/BizTalkCustomActionData"
> Name="PatchDatabasesCA">
> <Database Name="MGMTDB">
> <Script Filename="update_Admin_server_logic.sql"/>
> </Database>
> <Database Name="MSGBOXDB">
> <Script Filename="msgbox_security_logic.sql"/>
> <Script Filename="msgbox_application_logic.sql"/>
> </Database>
> </CustomActionData>
> [10/21/04 12:46:00] Resolved database: Alias=MGMTDB.
>
> [10/21/04 12:46:00] Failed to resolve database: Alias=MSGBOXDB, Error:
> HRESULT=0x80040e09 .
>
> [10/21/04 12:46:01] Begin distributed transaction.
> [10/21/04 12:46:01] Apply patch: Server="oslsqltest",
> Database="BizTalkMgmtDb", Script="C:\Documents and Settings\All
> Users\Application Data\Microsoft\E-Business Servers
> Updates\BTS2004\Uninstall943\update_Admi
n_server_logic.sql".
> [10/21/04 12:46:01] dataSource.Open HRESULT=0
> [10/21/04 12:46:01] session.Open HRESULT=0
> [10/21/04 12:46:01] file.Open HRESULT=0
> [10/21/04 12:46:01] Processing... HRESULT=0
>
> I don't know how to solve this and find myself in a situation where our
> project is now being delayed due to BTS failing to update the DB. So if
> anyone has a solution and/or suggestion for solving this, I'd be grateful to
> hear from you.
>
> TIA
>
> -- norgie
>
>
>
>
| |
| Goutham[MSFT] 2005-01-18, 5:50 pm |
| Norgie,
regarding the rollup package installation,
the error message 0x80040e09 means "The provider indicates that the user
did not have the permission to perform the operation"
This means that the user who performed the rollup installation did not have
permissions on the BizTalk Management databases. Hope this helps resolve
that issue
thanks
-goutham
|
|
|
|
|