|
Home > Archive > BizTalk Server General > February 2005 > Error deploying assembly at production
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 |
Error deploying assembly at production
|
|
| Christoffer 2005-01-31, 5:53 pm |
| Hi, I've develop a set of assemblies which are about to be deployed to
production. Three out of four deployed successfully (after some changes in
the binding xml files) but the last one a bit of a problem. The production
runs BizTalk on one machine and SQL Server on a different machine. When I
run the binding xml file I get the following error:
Failed updating binding information. BindingException: Could not store
transport type data for Primary Transport of Send Port 'name_Query_HTTP' to
config store. Primary SSO Server 'BIZTALK' failed. The property bag
contained a VT_NULL value to indicate that the existing property value
should be retained, but there is no existing value.
Having no clue what this means, I had a look in the Event Log and found this
entry:
The following stored procedure call failed: "{ call
adm_ApplicationInstace_get_details ( ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server
returned error string: "EXECUTE permission denied on object
'adm_ApplicationInstance_get_details', database 'BizTalkMgmtDb', owner
'dbo'.".
What are my servers doing?
Regards,
Chris
| |
| Neal Walters 2005-01-31, 8:49 pm |
| Might be a problem access SSO? HTTP and SQL credentials are saved in SSO
(Single-Sign-On server). Maybe the ports that worked were flat files and
there was not a credential problem?
But error seems to indicate security problem on BizTalkMgmtDb? Is the user
you are running under a Biztalk Admin?
Neal Walters
http://Biztalk-Training.com
"Christoffer" wrote:
> Hi, I've develop a set of assemblies which are about to be deployed to
> production. Three out of four deployed successfully (after some changes in
> the binding xml files) but the last one a bit of a problem. The production
> runs BizTalk on one machine and SQL Server on a different machine. When I
> run the binding xml file I get the following error:
>
> Failed updating binding information. BindingException: Could not store
> transport type data for Primary Transport of Send Port 'name_Query_HTTP' to
> config store. Primary SSO Server 'BIZTALK' failed. The property bag
> contained a VT_NULL value to indicate that the existing property value
> should be retained, but there is no existing value.
>
> Having no clue what this means, I had a look in the Event Log and found this
> entry:
>
> The following stored procedure call failed: "{ call
> adm_ApplicationInstace_get_details ( ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server
> returned error string: "EXECUTE permission denied on object
> 'adm_ApplicationInstance_get_details', database 'BizTalkMgmtDb', owner
> 'dbo'.".
>
> What are my servers doing?
>
> Regards,
> Chris
>
>
>
>
| |
| Matt Milner 2005-02-01, 2:47 am |
| When you exported yoru binding file, all passwords were masked. If you have
not updated the binding file with the correct password before trying to
apply it in production, you'll get this error.
matt
"Christoffer" <christoffer@nospam.com> wrote in message
news:O73HVx5BFHA.2076@TK2MSFTNGP15.phx.gbl...
> Hi, I've develop a set of assemblies which are about to be deployed to
> production. Three out of four deployed successfully (after some changes in
> the binding xml files) but the last one a bit of a problem. The production
> runs BizTalk on one machine and SQL Server on a different machine. When I
> run the binding xml file I get the following error:
>
> Failed updating binding information. BindingException: Could not store
> transport type data for Primary Transport of Send Port 'name_Query_HTTP'
> to config store. Primary SSO Server 'BIZTALK' failed. The property bag
> contained a VT_NULL value to indicate that the existing property value
> should be retained, but there is no existing value.
>
> Having no clue what this means, I had a look in the Event Log and found
> this entry:
>
> The following stored procedure call failed: "{ call
> adm_ApplicationInstace_get_details ( ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server
> returned error string: "EXECUTE permission denied on object
> 'adm_ApplicationInstance_get_details', database 'BizTalkMgmtDb', owner
> 'dbo'.".
>
> What are my servers doing?
>
> Regards,
> Chris
>
>
>
| |
| Christoffer 2005-02-01, 7:50 am |
| I reinstalled everything on the same server to get around any security
problems, and I updated all the passwords in the binding file. Still get
this error! I'm exporting a HTTP send port which uses Basic authentication.
Event Log says:
SSO AUDIT
Function: SetConfigInfo
Tracking ID: decbf8b4-7250-460b-b301-bbc5bf8a9c98
Client Computer: biztalk (BTSDeployWiz.exe:2092)
Client User: BIZTALK\Administrator
Application Name: {30671A35-1FEA-404D-BC61-2DAB10475440}
Error Code: 0xC0002A08, The property bag contained a VT_NULL value to
indicate that the existing property value should be retained, but there is
no existing value.
What I did in the bind file was to change:
Password vt="1" />
to:
Password vt="1">(passwd)</Password>
What the devil is wrong with my property bag?
Regards,
Chris
"Matt Milner" <matt.milner@m3technologypartners dot com> wrote in message
news:uhT2AtACFHA.2260@TK2MSFTNGP14.phx.gbl...
> When you exported yoru binding file, all passwords were masked. If you
> have not updated the binding file with the correct password before trying
> to apply it in production, you'll get this error.
>
> matt
>
>
> "Christoffer" <christoffer@nospam.com> wrote in message
> news:O73HVx5BFHA.2076@TK2MSFTNGP15.phx.gbl...
>
>
| |
| Matt Milner 2005-02-03, 2:47 am |
| It may be the permissions on SQL so definitely check that. But otherwise,
change the vt="1" to vt="8" and see if that works for you.
Matt
"Christoffer" <christoffer@nospam.com> wrote in message
news:OGFswmECFHA.3592@TK2MSFTNGP11.phx.gbl...
>I reinstalled everything on the same server to get around any security
>problems, and I updated all the passwords in the binding file. Still get
>this error! I'm exporting a HTTP send port which uses Basic authentication.
>Event Log says:
>
> SSO AUDIT
> Function: SetConfigInfo
> Tracking ID: decbf8b4-7250-460b-b301-bbc5bf8a9c98
> Client Computer: biztalk (BTSDeployWiz.exe:2092)
> Client User: BIZTALK\Administrator
> Application Name: {30671A35-1FEA-404D-BC61-2DAB10475440}
> Error Code: 0xC0002A08, The property bag contained a VT_NULL value to
> indicate that the existing property value should be retained, but there is
> no existing value.
>
> What I did in the bind file was to change:
> Password vt="1" />
> to:
> Password vt="1">(passwd)</Password>
>
> What the devil is wrong with my property bag?
>
> Regards,
> Chris
>
>
> "Matt Milner" <matt.milner@m3technologypartners dot com> wrote in message
> news:uhT2AtACFHA.2260@TK2MSFTNGP14.phx.gbl...
>
>
| |
| Matt Milner 2005-02-04, 2:47 am |
| I believe the VT means it is a variant, and the 8 indicates the underlying
type, in this case string. If you export a binding file, you'll be able to
see some of these other values in play. The 1 is a null which is why you
were getting the error.
Thanks,
matt
"Christoffer" <christoffer@nospam.com> wrote in message
news:uugghrcCFHA.2380@tk2msftngp13.phx.gbl...
> It works! Thanks a lot! Mind giving me a hint what the vt="8" means?
>
> Best regards,
> Chris
>
> "Matt Milner" <matt.milner@m3technologypartners dot com> wrote in message
> news:O9LPTyZCFHA.1396@tk2msftngp13.phx.gbl...
>
>
|
|
|
|
|