Dublin Monitoring and PErsistance Databases

Question

All,

Is there a prescise listing of the database schema objects that should be installed with Monitoring and PErsistance Databases? I have installed Dubln on 3 identitcal machines with 3 different results in regards to the database schema.

StepsI used to create the Database Objects pre-Dublin installtion:

- New Database [ServerSpace]
- New user ServerSpaceAdmin  (equal rights of an sa)

Each time i install i get a different set of Tables and procedures.  Two of the boxes are geting exceptions in the Event viewer while trying to find procedures that do not exist:.Log Name:      System
Source:        WorkflowManagementService 4.0.0.0
Date:          11/23/2009 2:13:03 PM
Event ID:      3
Task Category: Workflow Management Service
Level:         Error
Keywords:      Classic
User:          BSPACE2\AppServer
Computer:      BSPACE2
Description:
Workflow Management Service encountered a non-fatal exception. Review the exception to determine the cause of the issue.
 Exception: System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'System.Activities.DurableInstancing.InstanceRecoveryJob'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(IAsyncResult asyncResult)
   at System.ServiceModel.Activities.DurableInstancing.Management.SqlWorkflowStoreCommandCollector.InstanceRecoveryJobComplete(IAsyncResult result)
 Process Name: WorkflowManagementService
 Process ID: 4612

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="WorkflowManagementService 4.0.0.0" />
    <EventID Qualifiers="49159">3</EventID>
    <Level>2</Level>
    <Task>15</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2009-11-23T22:13:03.000000000Z" />
    <EventRecordID>2278</EventRecordID>
    <Channel>System</Channel>
    <Computer>BSPACE2</Computer>
    <Security UserID="S-1-5-21-714372414-156846826-1418110977-1005" />
  </System>
  <EventData>
    <Data>System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'System.Activities.DurableInstancing.InstanceRecoveryJob'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(IAsyncResult asyncResult)
   at System.ServiceModel.Activities.DurableInstancing.Management.SqlWorkflowStoreCommandCollector.InstanceRecoveryJobComplete(IAsyncResult result)</Data>
    <Data>WorkflowManagementService</Data>
    <Data>4612</Data>
  </EventData>
</Event>



- I dont not believe that Dublins installation is installing these objects, and for whatever reason is bombing and simply not creating these objects.
- I would understand if the user i created did not have permission to access/create objects. However in all 3 instances OBjects where created, I however can not tell if it created all objects needed.

---

Rex Whitten

Answer 1

Hi Rex,

Firtsly, you shuold check WorkflowManagementService.exe.config to make sure it is pointing to the database(s) that you have created.

Also, you can use powershell to configure the databases - if there is a problem you might get a more informative error message.

You can do something like this from an elevated powershell prompt. Change the groups + DB name to match what you want.

--

Import-Module applicationserver

$admins = $env:ComputerName + "\AS_Administrators"
$writers = "BUILTIN\IIS_IUSRS"
$readers = $env:ComputerName + "\AS_Observers"
$DBName = "FooBar"

Write-Output "Creating monitoring database..."
Initialize-ASMonitoringDatabase -Server $env:ComputerName -Database $DBName -Admins $admins -Writers $writers -Readers $readers -Force

Write-Output "Creating persistence database..."
Initialize-ASPersistenceDatabase -Server $env:ComputerName -Database $DBName -Admins $admins -Users $writers -Readers $readers -Force

Answer 2

Stewart, thanks for the reply, WorkflowManagementService.exe / WorkflowManagementService.exe.config - is pointed to the correct database. As for the above powershell script, will this create missing database objects? Tables, Procedures, etc?

---

Rex Whitten

Answer 3

Hi Rex,

The "Initialize-ASPersistenceDatabase" powershell cmdlet used in the script above is the recomended way to setup a persistence db. It will create the db (if it doesn't already exist) and add all the tables/procedures/users.

If you point it to an existing persistence database it will overwrite anything already there.

Answer 4

Rex I just updated the script to the correct beta 1 names - sorry for the confusion.

Answer 5

David, 

Thanks for the Info

I am unable to find that module anywhere 'applicationserver' 

I have reinstalled Velocity, and the experience is the same. Its almost like the installer is bad. The DistributedCache libraries also cant be found this time after install. 

If that is the recommended way of creating the schema, then that should not only be documented somewhere, but should also be taken OUT of the install process then. In fact I dont have much faith in the installer for Velocity. Running a repair does not change anything but is successful, and installing this on mulitple boxes creates different footprints of the application, and database, all with similar exceptions. 

Please let me know if you need other info, again, my theory is that this is a problem with the installer, or instllation issues that arent being checked/reporting/logged

---

Rex Whitten

Answer 6

Rex,

Assuming you have succesfully installed Dublin, "applicationserver" powershell module should be residing under folder

%windows%\System32\WindowsPowerShell\v1.0\Modules\ApplicationServer\Microsoft.ApplicationServer.Management.dll

when you launch a powershell console, did you try importing the module with "import-module applicationserver" command? What is the output?

Answer 7

Output:

PS C:\Users\RWhitten> import-module applicationserver
Import-Module : The specified module 'applicationserver' was not loaded because no valid module file was found in any m
odule directory.
At line:1 char:14
+ import-module <<<<  applicationserver
    + CategoryInfo          : ResourceUnavailable: (applicationserver:String) [Import-Module], FileNotFoundException
    + FullyQualifiedErrorId : Modules_ModuleNotFound,Microsoft.PowerShell.Commands.ImportModuleCommand

this is immediately after rebooting after an install

---

Rex Whitten

Answer 8

Can you please check to see if C:\Windows\System32\WindowsPowerShell\v1.0\Modules\Applicationserver is present on your machine?

---

mayur

Answer 9

Rex,

Do you have the log of your Dublin installation? Because, after looking at your output, installation seems to be incomplete for some reason. we may go figure out why installation failed to put powershell modules in place

---

http://blogs.msdn.com/ibrahim/

Answer 10

I tried to do a uninstall, and that didnt work either. It removed some of th compents, now i get errors all over the place about things missing. MY Server manager is red from error notifications.

I tried a reinstall (assuming that i did not have a clean installation environment from a failed uninstall) 

Install Log:  (install failed on 'Apply Distributed Cache Configuration' )

Again, running the above suggested fixes in this forum have also returned the same results. 


**Can not post the log, this forum is giving me errors when i try to post it.  Guys, I wish you the best of luck with this, i look forward to testing this again in a year when you have it ready for release. I simply do not have time anymore to QA an install.

---

Rex Whitten

Answer 11

Hi Rex,

I am sorry you had difficulties posting the log. I would really appreciate if you could send it to my address directly (s a s h a n @ m i c r o s o f t . c o m). I want to make sure we understand what caused the errors.

Thank you very much,
Sasha Nosov

Answer 12

Hi Rex,

Based on your last input, the product has installed, but distributed cache configuration has failed. You can find the logs in user %temp% folders, which has times stamp in the name of the file. You can paste the log from these files (App Server * ) that will help indentifying the error.

Thanks