Create & Update case -Error

[Dan-BSR]

I have managed to get everything up and running apart from this one
last problem.
During the Diagnostics while cheking Create & Update case i get this
error.

"Problems while trying to establish a connection with the workflow's
engine backend. Please contact your system administrator. Inner
Exception: Could not connect to http://localhost:8089/Sinergia/CaseServices.
TCP error code 10061: No connection could be made because the target
machine actively refused it."

I have check things like firewalls and permission and it all seems to
be ok. No firewall on at all and currently added full permissions for
testing purposes.

I changed the port within SQL manager and then i recieved a different
error.

"Problems while trying to establish a connection with the workflow's
engine backend. Please contact your system administrator. Inner
Exception: The underlying connection was closed: The connection was
closed unexpectedly."

Right now im quite stumped on what the problem could be.
So if anyone could shed any light on the situation that would be
perfect.

Thank You
Dan

[gabouy]

Hi Dan,

What OS are you running? Is is Vista?

Do you have the Sinergia Workflow Windows Service up and running. It is the one listening on port 8089.

The 8089 port is the one used by Windows Communication Foundation's configuration to establish client and server endpoints. If you want to change it you should also change web.config file, and workflow's host config file.

regards,
gabo

[Dan-BSR]

Thanks that looks to be what the problem is.
The only issue now is theat when im actually trying to start the
service if Fails.
had a look in the event logs
It tells me it could not be started; being unable to create a
connection to the Database.

The databases look to have been create and are sitting in the
sqlexpress folder.
At the moment i am trying to work on finding out where it is looking
for the database

Im running server 2003
Thanks

[gabouy]

Dan,

Make sure the credentials used by the Sinergia Workflow process have permissions to connect to the database. By default they should be Local System, and this should be enough in most cases, but check it all the same.

You could try creating a  new account, domain or local user and a SQL Login for it, with read write permissions over the WorkflowPersistence database, and the Sinergia database, and then configuring the Sinergia Workflow service to run with it.

regards,
gabo

[Dan-BSR]

Gabouy,
I have given the Sinergia Service admin rights to login. But same
issue. The problem does seem to be from lack of privliges when trying
to access the database as when i check the Event Logs i got 3 msgs.

1.
Login failed for user 'BSLTSTHD\HDWebsrv'. [CLIENT: <local machine>]

2.
On start exception. Error: Message: Unable to open database connection
Parameter name: connectionString StackTrace: at
System.Workflow.Runtime.Hosting.DbResourceAllocator.Init(String
connectionStr)
at
System.Workflow.Runtime.Hosting.DbResourceAllocator..ctor(WorkflowRuntime
runtime, NameValueCollection parameters, String connectionString)
at
System.Workflow.Runtime.Hosting.SharedConnectionWorkflowCommitWorkBatchService.Start()
at System.Workflow.Runtime.WorkflowRuntime.StartRuntime()
at
Sinergia.WWF.Host.WFIndigoExtension.System.ServiceModel.IExtension<System.ServiceModel.ServiceHostBase>.Attach(ServiceHostBase
owner)
at System.ServiceModel.ExtensionCollection`1.InsertItem(Int32
index, IExtension`1 item)
at System.Collections.Generic.SynchronizedCollection`1.Add(T item)
at Sinergia.WWF.Host.SinergiaWWFHost.OnStart(String[] args)

For more information, see Help and Support Center at On start
exception. Error: Message: Unable to open database connection
Parameter name: connectionString StackTrace: at
System.Workflow.Runtime.Hosting.DbResourceAllocator.Init(String
connectionStr)
at
System.Workflow.Runtime.Hosting.DbResourceAllocator..ctor(WorkflowRuntime
runtime, NameValueCollection parameters, String connectionString)
at
System.Workflow.Runtime.Hosting.SharedConnectionWorkflowCommitWorkBatchService.Start()
at System.Workflow.Runtime.WorkflowRuntime.StartRuntime()
at
Sinergia.WWF.Host.WFIndigoExtension.System.ServiceModel.IExtension<System.ServiceModel.ServiceHostBase>.Attach(ServiceHostBase
owner)
at System.ServiceModel.ExtensionCollection`1.InsertItem(Int32
index, IExtension`1 item)
at System.Collections.Generic.SynchronizedCollection`1.Add(T item)
at Sinergia.WWF.Host.SinergiaWWFHost.OnStart(String[] args)

For more information, see Help and Support Center at

3.
Service cannot be started. System.ArgumentException: Unable to open
database connection
Parameter name: connectionString --->
System.Data.SqlClient.SqlException: A connection was successfully
established with the server, but then an error occurred during the
login process. (provider: Shared Memory Provider, error: 0 - No
process is on the other end of the pipe.)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject
stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBeh...

For more information, see Help and Support Center at

How is it exactly that i change the admin login for sql. and once iv
done that is it within the sinergia.worklow config file that i change
the details aswell

thanks

[gabouy]

Hi Dan,

In this case I would find the connection string used, and try it manually with the SQL Server Management Studio, with the same authentication type and credentials to verify.

The connection string you seem to be having problems with is located in the app.config of the Sinergia.Workflow service, in particular the one specified by the worklfow persistence configuration.

The workflow configuration in the app.config has two lines, like this:

      <add type=" System.Workflow.Runtime.Hosting.SqlWorkflowPersistenceService, System.Workflow.Runtime, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" ConnectionString="Initial Catalog=WorkflowPersistence;Data Source=.\sqlexpress;Integrated Security=SSPI;" UnloadOnIdle="true"/>
      <add type="System.Workflow.Runtime.Tracking.SqlTrackingService, System.Workflow.Runtime, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" ConnectionString="Initial Catalog=WorkflowPersistence;Data Source=.\sqlexpress;Integrated Security=SSPI;" IsTransactional="false" UseDefaultProfile="true" TrackXomlDocument="True"/>

If the autentication type is windows authentication (aka integrated) make sure you can login and read write to the db with BSLTSTHD\HDWebsrv credentials.

regards,
gabo

On 9/18/07, Dan-BSR <daniel...@gmail.com> wrote:

Gabouy,
I have given the Sinergia Service admin rights to login. But same
issue. The problem does seem to be from lack of privliges when trying
to access the database as when i check the Event Logs i got 3 msgs.

1.
Login failed for user 'BSLTSTHD\HDWebsrv'. [CLIENT: <local machine>]


2.
On start exception. Error: Message: Unable to open database connection
Parameter name: connectionString StackTrace:    at
System.Workflow.Runtime.Hosting.DbResourceAllocator.Init(String
connectionStr)
   at
System.Workflow.Runtime.Hosting.DbResourceAllocator..ctor(WorkflowRuntime
runtime, NameValueCollection parameters, String connectionString)
   at
System.Workflow.Runtime.Hosting.SharedConnectionWorkflowCommitWorkBatchService.Start()
   at System.Workflow.Runtime.WorkflowRuntime.StartRuntime()
   at
Sinergia.WWF.Host.WFIndigoExtension.System.ServiceModel.IExtension <System.ServiceModel.ServiceHostBase>.Attach(ServiceHostBase
owner)
   at System.ServiceModel.ExtensionCollection`1.InsertItem(Int32
index, IExtension`1 item)

   at System.Collections.Generic.SynchronizedCollection`1.Add (T item)

   at Sinergia.WWF.Host.SinergiaWWFHost.OnStart(String[] args)

For more information, see Help and Support Center at On start
exception. Error: Message: Unable to open database connection
Parameter name: connectionString StackTrace:    at
System.Workflow.Runtime.Hosting.DbResourceAllocator.Init(String
connectionStr)
   at
System.Workflow.Runtime.Hosting.DbResourceAllocator..ctor(WorkflowRuntime
runtime, NameValueCollection parameters, String connectionString)
   at
System.Workflow.Runtime.Hosting.SharedConnectionWorkflowCommitWorkBatchService.Start()
   at System.Workflow.Runtime.WorkflowRuntime.StartRuntime()
   at
Sinergia.WWF.Host.WFIndigoExtension.System.ServiceModel.IExtension <System.ServiceModel.ServiceHostBase>.Attach(ServiceHostBase
owner)
   at System.ServiceModel.ExtensionCollection`1.InsertItem(Int32
index, IExtension`1 item)

   at System.Collections.Generic.SynchronizedCollection`1.Add (T item)

[Dan-BSR]

For testing purposes i went into the SQL Server management made all
current users db_owner's for both sinergia and sinergia_aspnet
databases tried to start the service again with same errors.
I have also gone in and created a new user on the system given it
db_owner privliages and then set the windows service to login with the
new credentials. this time the errors were only different in the palce
where it had the old username.
the only erro i get when trying to create the case from the client
side is;
Event Type: Information
Event Source: Sinergia
Event Category: None
Event ID: 0
Date: 9/20/2007
Time: 8:33:39 AM
User: N/A
Computer: BSLTSTHD
Description:
Exception Message: Problems while trying to establish a connection

with the workflow's engine backend. Please contact your system
administrator. Inner Exception: Could not connect to
http://localhost:8089/Sinergia/CaseServices. TCP error code 10061: No
connection could be made because the target machine actively refused

it. StackTrace: at Sinergia.Logic.CaseManager.OpenNewCase(CaseData
newCase, Boolean returnTicketGuid) in D:\Develop\net\Tiger\Sinergia\src
\Projects\Logic\CaseManager.cs:line 31
at setup.btnWF_Click(Object sender, EventArgs e) in c:\Inetpub
\wwwroot\Sinergia\Web\setup.aspx.cs:line 133

[gabouy]

Dan,

What happens if you use the Sinergia.Test.Host console app project as the workflow host?

I've been googling the error, it never happened to me, but looks like other people get it. Unfortunately I've haven't found a fix yet. I will try to reproduce it.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1001196&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2065555&SiteID=1

regards,
gabo

On 9/19/07, Dan-BSR < daniel...@gmail.com> wrote:

For testing purposes i went into the SQL Server management made all
current users db_owner's for both sinergia and sinergia_aspnet
databases tried to start the service again with same errors.
I have also gone in and created a new user on the system given it
db_owner privliages and then set the windows service to login with the
new credentials. this time the errors were only different in the palce
where it had the old username.
the only erro i get when trying to create the case from the client
side is;
Event Type:     Information
Event Source:   Sinergia
Event Category: None
Event ID:       0
Date:           9/20/2007
Time:           8:33:39 AM
User:           N/A
Computer:       BSLTSTHD
Description:
Exception Message: Problems while trying to establish a connection
with the workflow's engine backend. Please contact your system
administrator. Inner Exception: Could not connect to

http://localhost:8089/Sinergia/CaseServices . TCP error code 10061: No

[Dan-BSR]

gabo,
I would susspect it is an issue with credentials.
As when the service is started manaully it crashes and gives me those
errors such as;

1.
Login failed for user 'BSLTSTHD\HDWebsrv'. [CLIENT: <local machine>]

2.
On start exception. Error: Message: Unable to open database
connection

As i am quite new to playing with web servers and SQL, and there not
really being any documentation, im not too sure on what the issue is.
Not sure if it a setup issue within Server 2003. I would tdoubt that
as i have really only installed what was need like service pack dot
net 2 and then built on top of that with sqlexpress and then ran your
setup. I have enev removed all of that and tried again.

Is there a way to remove the need to login into the database and just
use it without any credentials.
Saying that i am a little confused on that matter aswell as under ther
setup.aspx it manages to read and write from the database but only
fails on creating a case. which i find odd because it can find the
data base write data too it but not be able to create a case.

Thanks for your help with this matter

On Sep 20, 12:16 pm, gabouy <g...@gabouy.com> wrote:
> Dan,
>
> What happens if you use the Sinergia.Test.Host console app project as the
> workflow host?
>
> I've been googling the error, it never happened to me, but looks like other
> people get it. Unfortunately I've haven't found a fix yet. I will try to
> reproduce it.
>

> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1001196&SiteID=1http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2065555&SiteID=1
>
> regards,
> gabo

>
> On 9/19/07, Dan-BSR <daniel.ray...@gmail.com> wrote:
>
>
>
>
>
> > For testing purposes i went into the SQL Server management made all
> > current users db_owner's for both sinergia and sinergia_aspnet
> > databases tried to start the service again with same errors.
> > I have also gone in and created a new user on the system given it
> > db_owner privliages and then set the windows service to login with the
> > new credentials. this time the errors were only different in the palce
> > where it had the old username.
> > the only erro i get when trying to create the case from the client
> > side is;
> > Event Type: Information
> > Event Source: Sinergia
> > Event Category: None
> > Event ID: 0
> > Date: 9/20/2007
> > Time: 8:33:39 AM
> > User: N/A
> > Computer: BSLTSTHD
> > Description:
> > Exception Message: Problems while trying to establish a connection
> > with the workflow's engine backend. Please contact your system
> > administrator. Inner Exception: Could not connect to

> >http://localhost:8089/Sinergia/CaseServices. TCP error code 10061: No

> > connection could be made because the target machine actively refused
> > it. StackTrace: at Sinergia.Logic.CaseManager.OpenNewCase(CaseData
> > newCase, Boolean returnTicketGuid) in D:\Develop\net\Tiger\Sinergia\src
> > \Projects\Logic\CaseManager.cs:line 31
> > at setup.btnWF_Click(Object sender, EventArgs e) in c:\Inetpub

> > \wwwroot\Sinergia\Web\setup.aspx.cs:line 133- Hide quoted text -
>
> - Show quoted text -

[gabouy]

Hi Dan,

Sinergia runs on two different process, with different credentials, it's natural that you may experience problems with one but not with the other.

One process runs within IIS, with credentials defined by the identity of the Application Pool running the web site. The second the Windows Service that acts as Workflow runtime host, and the credentials used by it are configured in the Services Manager, in the Service properties. In your scenario you are having problems connecting to the database with the Windows Service process.

The following is a summary of the dependencies in the Sinergia architecture:

Sinergia Web --> Sinergia Workflow
Sinergia Web --> Sinergia Membership Database
Sinergia Web --> Sinergia Business Database

Sinergia Workflow --> Workflow Persistence Database
Sinergia Workflow --> Sinergia Business Database

You seem to be having authentication problems in any of the two last dependencies.

Try running Sinergia using the Sinergia.Test.Host console app, which will run with the credentials of the authenticated user in Windows, and will make the debugging easier. You can achieve this by running the Sinergia.Test.Host.exe executable in the Sinergia.Test.Host /bin/Debug folder.

regards,
gabo

[Dan Rayner]

Gabo,

I dont seem to seem to anything named sinergia.test. at all.

i have checked in the GLR directory and in thw wwwroot directory. Did find the Bin folder but no debug folder in there at all

 

> >http://localhost:8089/Sinergia/CaseServices . TCP error code 10061: No

[gabouy]

Download the sources rar from here...

https://sourceforge.net/project/showfiles.php?group_id=168325&package_id=191538&release_id=499522

There you will find in the src/Projects/Sinergia.Test.Host folder.

regards,
gabo

[Dan Rayner]

gabo,

Try running Sinergia using the Sinergia.Test.Host console app, which will run with the credentials of the authenticated user in Windows, and will make the debugging easier. You can achieve this by running the Sinergia.Test.Host.exe executable in the Sinergia.Test.Host /bin/Debug folder

the console app, is that the Sinergia.Test.Host.exe. If so that file cannot be run because it needs to be installed as a service first. also there is no /bin/debug folder within the source files. Has something been changed in the most recent versoin?
 

--
Denying the inevitable is a lot like mowing the lawn with a bucket of fish, it may seem fun at first but it just makes no sense.

[gabouy]

The src/Projects/Sinergia.WWF.Host folder contains the windows service installer.

The src/Projects/Sinergia.Test.Host is a Console Application. Once compiled it creates the bin/Debug/Sinergia.Test.Host.exe executable, which is not a service, and does not need to be installed, just run.

The sources distribution package only has source files, but not executables, or .pdf files, that's why it's not present. You have to compile the solution first.

cheers,

[Dan Rayner]

the only problem with that is i have nothing to complie it with

I am trying to run this program as an end user not as a developer

 

[gabouy]

Dan,

At this stage of Sinergia's development some development skills are required to customize and maintain the solution. It's not an out of the box ready to use solution, at least not yet.

[Dan Rayner]

I have had another look and where the config file is looking .\sqlexpress;database=sinergia

it can find that ok and all current users have been applied as db owners.

is there a way within the config file to stop it from needing to login. or ir it possible to get a hold of the config for the actual database and make sure mine are ok

 

[gabouy]

you can always change the connection string to use SQL Authentication,provided you had previously enabled it in the SQL Server instance. In this way you wouldnt rely on windows authentication, but you´d be forced to put username and password in the config files.

question is the sql in the same box as the IIS, and the windows service?

[Dan Rayner]

both on the same machine.

I was just wondering along with that is it possible that i am missingsomething to do with the workflow runtime. As i have not complied it myself, is it possible that i am missing that component or something similar?

 

[gabouy]

Dan,

Regarding your missing something question you should have:

One Website in the IIS
One Windows Service Sinergia.Workflow
Three databases in the SQL Server

Do you have all that, up and running?

[Dan Rayner]

Gabo,

I have the website in IIS

I have the sinergia..workflow service ( that i cant start)

and i have three db's called Sinerga, Sinergia_aspnetdb and system databases

 

i was more referring to a component that i might have missing becuase i didnt compile it myself.

something related to the workflow runtime files.