Global Bank Demo Error

Topics: Web Client Software Factory
Jun 6, 2007 at 12:15 AM
Edited Jun 6, 2007 at 12:18 AM
Hello,
I got the sample application built successfully. I was also able to login with "admin" and "p@ssword". However, once I clicked on the button "Create Transfer". I got the following error message. Did anyone run into this problem and find the solution? Thank you.


Source Error:


Line 69: InitializeWorkflowRuntime();
Line 70:
Line 71: WorkflowInstance instance = _runtime.CreateWorkflow(pageFlowType);
Line 72: instance.Unload();
Line 73:




Stack Trace:


InvalidOperationException: Instance failure.
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +683983
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Workflow.Runtime.Hosting.DbResourceAllocator.OpenNewConnection(Boolean disallowEnlist) +94
System.Workflow.Runtime.Hosting.DbResourceAllocator.Init(String connectionStr) +40

[ArgumentException: Unable to open database connection
Parameter name: connectionString]
System.Workflow.Runtime.Hosting.DbResourceAllocator.Init(String connectionStr) +151
System.Workflow.Runtime.Hosting.DbResourceAllocator..ctor(WorkflowRuntime runtime, NameValueCollection parameters, String connectionString) +210
System.Workflow.Runtime.Hosting.SqlWorkflowPersistenceService.Start() +169
System.Workflow.Runtime.WorkflowRuntime.StartRuntime() +682


Jun 6, 2007 at 5:44 AM
Did u run all the scripts for the database? It looks like your workflow-database wasn't created.

Benny
Jun 6, 2007 at 6:40 PM
Yes, I ran SetUpDatabase.cmd and I have two databases WCSF_RI1 and PageFlowPersistenceStore added to my SQL Server Express. Is there an other database I need? Thank you Benny.

Regards,
Oakkar


BennyXNO wrote:
Did u run all the scripts for the database? It looks like your workflow-database wasn't created.

Benny

Jun 6, 2007 at 8:23 PM
And your web.config looks like this? (You run SqlExpress?)

<connectionStrings>
<add name="RISqlConnection" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=WCSFRI1;Data Source=.\SQLEXPRESS;" providerName="System.Data.SqlClient"/>
<add name="PageFlowPersistanceStore" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=PageFlowPersistenceStore;Data Source=.\SQLExpress" providerName="System.Data.SqlClient"/>
</connectionStrings>

<membership defaultProvider="SqlMembershipProvider" userIsOnlineTimeWindow="15">
<providers>
<add name="SqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="RISqlConnection" applicationName="WCSFRI_1" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="true" passwordFormat="Hashed"/>
</providers>
</membership>
<!-- Role manager default configuration -->
<roleManager enabled="true" defaultProvider="SqlRoleProvider">
<providers>
<add name="SqlRoleProvider" connectionStringName="RISqlConnection" applicationName="WCSFRI_1" type="Microsoft.Practices.CompositeWeb.Providers.RoleProvider, Microsoft.Practices.CompositeWeb"/>
</providers>
</roleManager>


<pageFlowInstanceStoreProvider providerType="Microsoft.Practices.PageFlow.Storage.EnterpriseLibrary.PageFlowInstanceCorrelationSqlProvider, Microsoft.Practices.PageFlow.Storage.EnterpriseLibrary" connectionString="PageFlowPersistanceStore"/>
Jun 6, 2007 at 10:41 PM
Hi Benny,
Yes, I'm using SQL Express and my web.config looks just like that. But I don't know why I still have that error. Thanks much.

Regards,
Oakkar