Or leave us a private message
I have a recordset with X rows.
I need to perform some validation for each one to decide whether to exclude this record at this point (carrying on would result in failure)
in my recordset is a return code. I then need to decide based on this code whether to proceed. lets assume of all 10 return codes 3 will allow the process to continue the other 7 are considered failure.
I create my service that takes in a code and then gets a list of statuscodes and the resulting action.
I then call this service for each entry in my recordset. If that services has to goto the DB each time its going to be a perfomant dog. If however it were to cache the results (as we do in code all the time - think lookup date bank names, branch codes, post codes etc) it would make performance much better
So what Im asking for is a services that is created but doesnt get collected once its been used. Singleton vs SingleCall
If this exists plz point me in the correct direction
You are correct, performance would be a dog. The best design to handle this is to create your validation workflow to accept recordsets Inputs and return recordset Outputs (rather than scalars and then putting it inside a for each).
In this way you can map the entire recordset with next to no overhead into the validation workflow, do one db call and then handle the iteration between records inside that workflow.
The service just vanishes in the background. Then in the designer I cant save my changes as there is no server. I dont loose much data but I have to then restart which is annoying. Its intermittent at the moment. If I get steps to reproduce ill post them here.
This has happened a couple times while playing with sproc related updated. I do hit ctrl-s a lot without thinking from just general coding so maybe the multiple saves are somehow causing badness when talking to the server?
Within designer view, are you able to abstract that process flow into a process object that could be used in higher level processes?
You just need to drag it from the explorer onto your new workflow to re-use it.
Be sure to map your inputs and outputs when re-using a workflow.
Once the User interaction (Webpages) piece is done, you will be able to interact with the workflow if its built into the process.
It is not a windows group, its internal to Warewolf.
1. Open Security Settings
2. Under the Windows Group heading, you will see a Public group.
3. Give this group Administrator rights.
4. Click Save
Any user can now do anything on that Warewolf.
I tried to click 'edit' on a service proc in my designer and the edit window opened but the progress wheel just remained spinning.
Wareworf server then crashed.
Details from the Application Log:
Faulting application name: Warewolf Server.exe, version: 0.3.1.1, time stamp: 0x51decfcb
Faulting module name: clr.dll, version: 4.0.30319.18052, time stamp: 0x5173c114
Exception code: 0xc0000005
Fault offset: 0x000000000005b074
Faulting process id: 0xcdc
Faulting application start time: 0x01ce8385673cd772
Faulting application path: C:\Program Files (x86)\Warewolf\Server\Warewolf Server.exe
Faulting module path: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll
Report Id: 030305a3-f431-11e2-ac0c-70f3951b032e
Application: Warewolf Server.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an internal error in the .NET Runtime at IP 000007FEF07AB074 (000007FEF0750000) with exit code 80131506.
Most API's these days allow a variety of return types. What types can I offer without having to build it into everything I do and still have it as XML
My windows password used to connect to this sql server needed to be changed today. I open up my source to enter the new password.
Once the connection test succeeds I am asked to select a db. It would be nice if I didn't have to re-select the db as I'm sure this could lead to the incorrect db being selected.
Good thinking. Thanks
Customer support service by UserEcho