Hi,
Adding a SqlPersistanceService to my workflow host causes the workfow to abort when it tries to persist. Unfortunatly the WorkflowAbort events arguments don't realy tell me anything usefull.
The database is SQl Server 2000 sp3a and the persistance setup scripts have been executed creating the required tables and sp's.
Initialising the SqlPersistanceService instance with a valid connections string causes no errors (indicating the the connection is fine).
Remove the persistance service and everything works as expected.
Any ideas as to how I might resolve this problem would be appreciated.
Thanks in advance,
Michael
Ps I had SQL persistance working against a SQL Server 2005 dB previously.
SqlStatePersistenceService troubles
Devin
Traced errors (in order of occurance):
1-
Exception thrown while persisting instance: MSDTC on server 'INSPIRON-9100' is unavailable.
2-
stacktrace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.GetDTCAddress(Int32 timeout, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.GetDTCAddress()
at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
at System.Data.SqlClient.SqlInternalConnection.Enlist(Transaction tx)
at System.Data.SqlClient.SqlInternalConnection.EnlistTransaction(Transaction transaction)
at System.Data.SqlClient.SqlConnection.EnlistTransaction(Transaction transaction)
at System.Workflow.Runtime.Hosting.DbResourceAllocator.GetEnlistedConnection(WorkflowTransactionService txSvc, Transaction transaction, Boolean& isNewConnection)
at System.Workflow.Runtime.Hosting.PersistenceDBAccessor..ctor(DbResourceAllocator dbResourceAllocator, Transaction transaction, WorkflowTransactionService transactionService)
at System.Workflow.Runtime.Hosting.SqlStatePersistenceService.System.Workflow.Runtime.IPendingWork.Commit(Transaction transaction, ICollection items)
3-
Workflow Runtime: WorkflowExecutor: Persist attempt on instance '9d4582ec-4e29-4e99-87c1-b86ea4b0fda3' threw an exception 'Error occurred while persisting workflow instance into the store.' at at System.Workflow.Runtime.Hosting.SqlStatePersistenceService.System.Workflow.Runtime.IPendingWork.Commit(Transaction transaction, ICollection items)
at System.Workflow.Runtime.WorkBatch.PendingWorkCollection.Commit(Transaction transaction)
at System.Workflow.Runtime.WorkBatch.Commit(Transaction transaction)
at System.Workflow.Runtime.VolatileResourceManager.Commit(WorkflowTransactionService txService, Transaction transaction)
at System.Workflow.Runtime.VolatileResourceManager.Commit(WorkflowTransactionService txService)
at System.Workflow.Runtime.WorkflowExecutor.CommitTransaction(Activity activityContext)
at System.Workflow.Runtime.WorkflowExecutor.Persist(Activity dynamicActivity, Boolean unlock, Boolean needsCompensation)
4-
Workflow Runtime: WorkflowExecutor: Persistence attempt at instance '9d4582ec-4e29-4e99-87c1-b86ea4b0fda3' termination threw an exception. Aborting the instance. The termination event would be fired. The instance would execute from the last persisted point whenever started by the host explicitly. Exception:Error occurred while persisting workflow instance into the store.
at System.Workflow.Runtime.Hosting.SqlStatePersistenceService.System.Workflow.Runtime.IPendingWork.Commit(Transaction transaction, ICollection items)
at System.Workflow.Runtime.WorkBatch.PendingWorkCollection.Commit(Transaction transaction)
at System.Workflow.Runtime.WorkBatch.Commit(Transaction transaction)
at System.Workflow.Runtime.VolatileResourceManager.Commit(WorkflowTransactionService txService, Transaction transaction)
at System.Workflow.Runtime.VolatileResourceManager.Commit(WorkflowTransactionService txService)
at System.Workflow.Runtime.WorkflowExecutor.CommitTransaction(Activity activityContext)
at System.Workflow.Runtime.WorkflowExecutor.Persist(Activity dynamicActivity, Boolean unlock, Boolean needsCompensation)
at System.Workflow.Runtime.WorkflowExecutor.TerminateOnIdle(String info)
Hope this makes some sense....
Michael
Ajit_C#
Yes, DTC must be up and running.
When I installed SP4 for SQL Server 2000, all problems with SqlStatePersistenceService gone away.
Here are the short descriptions of problems thad I had:
1.) Workflow started successfully.
2.) I move state machine to next state.
3.) When I tried to get current state, error ocurred.
4.) I realised that SqlStatePersistenceService doesn't working - table InstanceState was empty.
5.) Event Log was full with messages like 'EXCEPTION_ACCESS_VIOLATION'
6.) Using SQL Trace I found that SQL Server throws an exception when executing following statement:
"exec InsertInstanceState @uidInstanceID = '5215257E-2831-44FE-AF42-C9EE335E93D9', @state = 0x1F8B0800000000000400EDBD07601C499625262F6DCA7B7F4AF54AD7E074A10880601324D8904010ECC188CDE692EC1D69472329AB2A81CA6556655D661640CCED9DBCF7DE7BEFBDF7DE7BEFBDF7BA3B9D4E27F7DFFF3F5C6664016CF6CE4ADAC99E2180AAC81F3F7E7C1F3F227E8D5FF3D7F8357E8DFFFBFFFEBFFF6FFCC4FF7EA35FEBD7F8357E8DECF575D3E68BF177ABFAED79595D8D4FAAC5AA5AE6CBF68B6A9697A3F427F3BA29AAE567F7C63BF86F949EACCB765DE79F2DF3755B67D4E2E57A5216D3DF2BBF7E53BDCDA9E1EEE4FCDEC1FD4FB3D9BD4FF7F37BF77F5DF4F7667337E3D7795D6465F183ACA5BEC6C7D3B6B82CDAEBD7EBBAAE2EB236FFC47EA2EDF2D9ABFCFCD7FD357E8D5FE3D79E16B35FAB98FD3AEDF52AFF0D17F96292D72FB245DEFC86F2FBD3ACCD9A5FE3D7FCB57FBD5FF737F85D1485AF961E1CEEEFDB5539CB6B5003FFFBF57EED5FE3D7F8357EE3A779995D1B6C7FECD7F9357E8D5FE3C7D0DD8FFD7ABFC6AFF16BFC3AF8F377B9011CA0FC3AE8FEC7B8C337D7ABFC373A6E1AC2AABC0686BFE6AFF16BFE06BFDEAFFF6BFC1ABF46F64531ADABA63A6FC7AFB3C5AACC1B47A537F974BEACCAEAA2A04FBF5D356DB1BC187FD5D0BF2F312D349EE534A7B15C16536A30F405D0FDF57E835FE3D7F835BE1C6AF135A679B92ECBDF1C2401F45FEFC77E8D5FE3D7F875A73495BBBF5EF26BFC1ABFC6AF3703F9767FBDDFF0D7F8357E8D5F171FEFFD7ABFD1AFF16BFC1A779EE6AB7C39A39EAFBF9CFC743E6D3F99D90F5ED6D52AAFDBEB9FCCCA75DEFC66A03320FFD86FFC6BFC1ABFC68FFD26BFC6AFF16BFCD86FFA6BFC1ABFC68FFD66BFC6AFF16BFCBAF8ECCDCF0647A1C75F7B5ACC7EAD62F6EB80A312C745BFC6AFF96BFF3ABFC1EF72C3A4FFDEEF8594A3C6EBB6AA73C7ED9D2F5EE5E7604E3028FEF7EBFDE6BFC6AFF16BFCBA4CEC1FFB2D7E8D5FE3D7F8B1DFF2D7F8357E8D5F17247AF35EDDDF52CA40935F7B5ACC7EAD62F6EB802689A3C9AFF16BFEDABFCE6FF0BBDC4093DFFBBD907A0F9A801EA009FEF7EBFD56BFC6AFF16BFC7AC2753FF65BFF1ABFC6AFF163BFCDAFF16BFC1ABF2E58E6CD7BF57F4BA28028BFF6B498FD5AC5ECD701511247945FE3D7FCB57F9DDFE077B98128BFF77B21F51E4401414014FCEFD7FB6D7F8D5FE3D7F87559FC7E0C8CF263BFFDAFF16BFC1ABF2E24E8F7FED9EA1E5DFF3A6FF3EBE6D7BB6439FE757EDD7B3774E5C66634C0F7BE8F0160103FF63BFC1ABFC6AFF163BFE3AFF16BFC1ABF26F007D17FBDDFE9D7F8357E8DDFA50B53670D5AF2A49AE568F8EBFDCEBFC6AFF16B7C7FB8E1D750795DCBF66B42F040CE1FFB05BFC6AFF16BFCD8EFF26BFC1ABFC6AF09DE43F7BF5EFA6BFC1ABF46BA014F363068F96340F4D704BB02D48F7DF46BFC1ABFC68FFDF8AFF16BFC1ABF26660B1FFDD8EFF66BFC1ABFC68FFDEEBFC6AFF16BFCFAA0C7AF01FB0D72FC3ABBEF4D5A70C68FFDC25FE3D7F8357EECE35FE3D7F8357E6CEBD7F8357E8D1FBBF36BFC1ABFC68F7DEBD7F8357E8D1FFBE4D7F8357E8D1F1BFD1ABFC6AFF163DBBFC6AFF16BFCD8F8D7F8357E8D1FBBFB6BFC1ABFC68FEDFC1ABFC6AFF163BBBFC6AFF16BFCD8DEAFF16BFC1A3F76EFD7F8357E8D1FDBFF357E8D5FE3C7EEFF1ABFC6AFF1639FFE1ABFC6AFF1630F7E8D5FE3D7F8CD3053C0ECC70E7E8D5FE3D7F8B187BFC6AFF16BFC06BF0130FEB147BFC6AFF16BFCD8E1AFF16BFC1A3FF6F8D7F8357E8D1FFBECD7F8357E8D1F3BFA357E8D5FE3C77E8F5FE3D7F8357EECF7FC357E8D5FE3C78E7F8D5FE3D7F8B127BFC6AFF16BFCD8C9AFF16BFC1A3FF6F4D7F8357E8DDFE03780ABF263A7BFC6AFF16BFC06BFE6AFF963CF7E8D5FE3D7F8F541E95F031E0CBC985F67F7BD2900D9F8B1CF7F8D5FE3D7F8CD305D70857EECDBBFC6AFF16BFCFA20FBAF01CF0853F2EBECBE375CC8DC8F9DFD1ABFC6AFF163DFF9357E8D5FE3C77EAF5FE3D7F8357EECF9AFF16BFC1ABF19A612307F83DFE80FFA9FFE7796CC1FFBE2D7F8357E8DDFE0D7FC357EECC5AFF16BFC1ABF3E26F7D7804B06B7ECD7D97DEF8E21EC3F8601FD66E010F8763FF6F2D7F8357E8D5F17B3FCC57B43F34C8FF9E8557E9ED77016A0567E1DF831BF0EFC975FFBD7FC5D6ED07150433FF613BFC6AFF16BFC7AAF7E8D5FE3D7485E6635BDD6E675F36B82F980DF8FBDFE357E8D5FE3D77BF36BFC1ABFC66F084FE975B5AEA779F36B6EFD1ABFC6AF81AF7FECAB5FE3D7F8357EBD9FFC357E8D5FE3C74EAA659BBF6BCF66BF26D8155FFE18BEFCF57EEF5FE3D7F8357EAB3775367D4B8ECD495696F4E3759BB5F9AF098E46BB1F43BB5FEFA77E8D5FE3D7F88D7F629DAF73D3E0D704B7A3C18F7DEFD7F8357E8D5FEFF7FD357E8D5FE3B730743A5B366D46233E9BFD9A1007B4FA31B4FAF57EBF5FE3D7F8357E13D30AFDAC9B5F13B282163FF6FBFF1ABFC6AFF1EBFD01BFC6AFF16BFC4EC6889CBECBA76B687083FEF2BCFA35215668FF6368FFEB4D7E8D5FE3D7F84DACD101E6CDAF0999438B1F9BFE1ABFC6AFF1EBCD7E8D5FE3D7F8CD993CEB4933AD8B150036BFE6CEAFF16BFC1A68F46318DFAF77FE6BFC1ABFC66FFC7A3ACF67EB326730BF26E4150D7E0C0D7EBDF9AFF16BFC1ABF2D797EE755BDC0D04EAA35A15473D35F13528DA63F06947EBD9FFE357E8D5FE3173CAFA66FB9CD974B19E7C93C5B5EE4F2EFECD7840AC01B3F86377EBDF2D7F8357E8DDFD26F36C3EBF9ECD7849240B31F43B35F6FF96BFC1ABFC66F3B00F8D7842A41D31FAB7E8D5FE3D7F8F556BFC6AFF16BFC56687A3CFD45EBA2CE6798DB49367DFB6B42DBA0DD8F61427EBDFAD7F8357E8D1F3B6B9E94DCDFAF092D842F7F0CFDFD7AEDAFF16BFC1ABFD98B9C4460E614EFAF7BF06BFC1ABFC667370886E5D5A7F9B4A4DF650ECB925CD6A25AFE7ABFC6AFF16BFCC6D5D532AFCDC4FD0E64230847DBE20FD8FB644A10B33AAF7F9BFE57B362DAFE0EFD8FC96C32C57FC7FE57EDBCCE9B7955CE7E0BEFE3DD4F0A1A43F3EBFCDABFF6AFF16BFC3A6FDECBA2DFD2CB8123F1A7FC9A0AD9F5DC8C3FCF69F0C5D4FC3CFD456B82DD5EA34F8CF90FD8FDDEF7F4ADD76D4D12374A17CDB4AACB62E2CCEEDE6DCDEEE4C183ECFEF4FEA7BB0FEFEDE73B070FBFFFFDBFE0D7DA80D3D3823FC8EAEB3F60EF7BDF7B7D7B346E8F86A0313263DCC0453D2E1AA5032FDD3EE0BEC92DF9FEF77F83DFE0C97BB1C3730A075DF481BF5EE5E7F02261AF7E0CF9821FBBFC357E8D5F23A15F7E0DFCEFC7AE7E8D5FE3D7F87561DFEFDD6461AC5A7753F51BFC1ABFC6AFF1EBB2F8FC46E88A3546B1BCF80DED1FF9EC771896A7DF262E4FBFC3B03CFD8E1BE4E9B7E8CBD3AFF36BFFDABFF6AFFD6BFC1ABFCE9BF722E12D250A0EC0470A983CC01C048FE4223EBAB9C99FF26BFEBF4F2EFFB45FEBF672797BB9BCBD5CDE522E9F66AD32E52DA4F1F641C29034FE06BFC193F762A5A834C27384F7F863C8DEFDD8F5AFF16BFC1A3FF6835FE3D7F8357E0C7299402EF1BF1FFB995FE3D7F8357EA35FF26BFC1ABFC64F757B7C45A6BC58E4DF40D4F3EBC2991F0DC01FC77C3164897EDB29197067305F66ED9C1CCC77D7BF997CEE3CAEDF583E508FE9B794BFC81E13B1F4B3DFA4E4EC555E3FA949FFD5BFF6AFFD6BFC1ABFCE1FF46B6EE0BC3350F467DB26FD868AC0E7EB62F61BFC06E39BE8F33C1803A60CFF4F7E9D3FE4FFFEBFFFEFDFD0038588E1D74386E1ECE9AF3329DAE6D7F9F5BFFD5ECCF4BA404A115E7BE334FC1B868760E4D7FA75FFE0FFFBFFFEBFBFFD4D81446AF9D7E7C8FFF7FFFD7F8D5F0BD1CEAFF9637FD0AFF16BFC1A6050FCEFC7FEE05FE3D7F8357E5D0482F78608643E80B30E5F5D3294ECA72271FDEBFD2238F1CDAFF3E2BD50763E819764B39FBDCACF119861027EEC0FF9357E8D5FE3D744908A89F8357FC9FFFD7FFFDF20D0AFF9637FD8AFF16BFC1ABF2EE2D65F7813E2E20723C9FEEB2B257E8DDF00A0F1BF5F1741EFE10DA86F8A1E204ABF217B5BE7453E3B7BFA63531318FD86FA1BF8EF375DF9F27236FBCDE08C96E489CCBEAC67246CB35FF3D7F8B57F8D5FE337F80D3D3EFB0D7E03C4A63F86AC35FEF76BFEE0FFFEBFFF6F90E0D7BCFEBFFFEFFF1B24F8357FEC8FFA357E8D5F03EB07F8DFAF8BC0FDC5373B0788927F1DE48E7E3DC91DFDFAF43B38F5C7F84FFCF6EBFEBABFF6AFFDBBDC1075FE2E377C8F10FCC7FEE85FE3D7F8357EEC8FF9357E8D5FE3C7FED85FE3D7F8357EEC8FFB357E8D5FE3D7FC3D7F8D5FE3D7C0A87EEC8FFF357E8D5FE3C7FE845FE3D7F8357EEC4FFC357E8D5FE3C7FEA45FE3D7F8357E5D64277EE1D0CC9BB84BA229C4F8BFD64FECFC5A3FB1FBEBFC3A3B375148DECC26657E46EDBEF77D240876DEF7256415C0613FF627FF1ABFC6AFF1637FCAAFF16BFC1ABFEE935FE3D7F835EE0EE13B100682657F7D65D95FE33700CB6279E2D7413AE6778A68D7E3BACEAEA1C6C033BFDEEFCFB1C8AFFBFB37C50FF2DFE0F7BF14ABF9EBFE1ABFC66FF01BFCD89FFA6BFC1ABF0660E3FFBF26F23A80F8637FDAAFF16BFC1AF804FFFF7591E2F90B7ECDF7928BAA36FE13A26A4FBB9F5ED21BC7F545F30D071D60CFDF32531C7EC289E06F3C533C78E5E2C7AC40FE2657D992227E52F8CB269BB6BFE6AFFD6BFC1A1FDDECD6FD06BF2672443F0639FCB13FE3D7F8357E0DC8E3AFF1EB3EFB357E8D5FE3C97B495BD48900E85F9727EA37C0BF10A95FF7D7FE5D6E1018BCF4637FE6AFF16BFC1A3F86A0FAD744AA0921F68FFD16BFC6AFF16BFC7A7FCEAFF16BFC1ABFA14C488ECCEBAFF9ED5FE3D7F83530BF3FF6E7FE1ABFC6AF81B9C5FF7F4D24C6F0D28F213DFAEBFDF9BFC6AFF16BFCA66F8813AB75FB742D71D1AFF99D5FE3D7F835D0E4C7D0CBAFF717FE1ABFC6AFF1EB9D945593CF7E4DE4D2F0CD8FE1E55FEF2FFE357E8D5FE3B73E6BCE9632CF3A1F20C1AF897C1B1AFE181AFE7A7FE9AFF16BFC1ABF899F33397BFA6B22F306EC7EEC2FFB357E8D5F0398E1FFBFE68B5FE3D7F835A0EB7ECDEFFDDFFFF7FF0D5DF76BFED85FF16BFC1ABFC6AFF9F2D7F8357E0DB4FEB1BFF2D7F8357E0DB4C4FF7F4D64B4C00BBFDE5FF56BFC1ABFC667374CCAE64402C0FC7A7FF5AFF16BFC1AD96630DF80D7F66B22D586FE7EBDBFE6D7F8357E8DBD9B7869BD5A5575DB785939BCFB63C0F5D7443E097FFD7A7FDDAFF16BFC1A5B37994323AD78E3D7FBEB7F8D5FE3D7F8A99F3DD7F4D7444E081DFD7A7FC3AFF16BFC1A5B37A1669C4EBCF16340EDD704EFE1AF5FEF6FFA357E8D5FE3E35BEA23BCF063A0CCAF897C1DFEFAF5FE965FE3D7F835EE0C750FA24A9CABCE0D5EF931F4FF6B22F785BF7EBDBFEDD7F8357E8D4F6F3949AFAF97D3795D2D55F4F1FE8F019D5F07B1C19FF26B1AD5FDFF9EF40DA1F56BFC9A482140ADFDD8DFF16BFC1ABFC68FFD9DBFC6AFF16BFC3A886A3EBA59454237FE0646F9FFFA6D565FE4EDCEAF4F89967935DBF9B57F9D5F7BE766109F98EF4E976D7D7DEF0642C79218D08A77F53DCA90AB551C7F41EBFB8866CEAB48AF3FF677FD1ABFC6AFF163489BFCD8DFF36BFC1ABFC6AF89000E63FEB1BFF7D7F8357E8D1FC3E73FF6F7FF1ABFC6AFF16B228A03697EEC1FF8357E8D5FE3C7FEC15FE3D7F8357ED33FE8D7F8357E8DDFECD7F8357E8D5FEBD7E83CBF2E3CEAF110ABC5A30DE0FE1BFFFE39F4A7FA833FF6FB37E26737BFC6AFF31BBC782F4373A36B8DDEE0FFE27F3FF60FFD1ABFC6AFF16BC2C786A7F563FFF0AFF16BFC1A3FF68FFC1ABFC6AFF163FFE8AFF16BFC1A3FF68FFD1ABFC6AFF19BC2D1C6487FAD5FFABBFFD6AF76B7FEAFA77FE3937FFA7FB8F7FBFDA9FFF66FFA47FD1ABFC6AF816F7EADEE37BF19DC3970C58FE19F1FFBCD7F8D5FE3D7F8B1DFEAD7F8357E8DDF0C1E1E3EFAB17FEAD7F8357E8D1FFBA77F8D5FE3D7F8B17FE6D7F8357E8D5F134E1FC4E4D7FB677F8D5FE3D7F88D75B892A9C4C7BFDE3FF76BFC1ABFC6EFF50D662C7F4D389880FCEBFDF3BFC6AFF16B8C6EA957D89BC45B3F0669FECDE096E27FBF195C53FCEFD7847B0AAFE4D7FB177F8D5FE3D7F87893BAF1129078E1C7A06C7ECD3FE9D7F8357E0DFCF5EBFDCBBFC6AFF16BFCCBBFD6063DD109A06FC4DC7A68710F2D86A26A44CF791B3213B75FB71D4E9076A1DFDEE0DE7A71F8FBDF076D7F0CACF4EBC32FFF35E03CE07FBFCEF8FDFC7BC8CFAF0FA7FED70004FCEFD719BF1F0440F8CDE08503A31FFB577F8D5FE3D7F88D7FEDDFEC4FFB357E8D5F037FFFD8BFF66BFC1ABFC66FFC6BFF3A70363FBA597302D66F60B4E7AFAF4AF7D7FEB5776E7E33D4B977DF5377FED8BFFE6BFC1ABFC68FFD1BBFC6AFF16BFC66F04521D53FF61BFF1ABFC6AFF163BFC9AFF16BFC1A3FF69BFE1ABFC6AFF19BC1E3C4887EECDFF9357E8D5FE337FEB57FB3BFECD7F8357E0DFCFD63FFEEAFF16BFC1ABFF1AFFD9BC2A7FBCD7E8D5FE3D7F8B5FEDD6FEFFDFB7FE2A7BFD7177FECC5C5EE4FFC4317BFFB6F06FF0E2D7FECDFFB357E8D5FE337FEB57F339824FCEFD78459C217BFDEBFFF6BFC1ABFC6BDAFE1EBE1E51F83F8FE3A7FD7AFF16BFC1A3BEF4B250460BF0EB23FBF41D634645ACAEB5F4FECDD6F213FE0C11FEB37BF89FB08EBB389CC0D7EFD8D4D84C2D6EED7FC357FAD5FF3D7FC357FED9DF7C5E5D7FB0F7F8D5FE3D7F8677FCD1B888030D625F2599CBF9D2D6765B02874B3A1FDA108E88F61627EBDFFF8D7F8357E8D5F5FBD881FC327BFDE7FFA6BFC1ABFC6BD5BA3EA14E6AFF79FFD1ABFC6AFF19B7CB9F45735925F07A6FEEE7B723B56187F1D4CDD6F6466177FFCD849496C80DF7EEC7571B1CCB06A9688C78159FFCD545D93FA5C2F08D1E6D7FC357FCD5FF3D7F8B57F83DF583B479BEF7DFFC780E48F619C3F8671FE7AFFE5AFF16BFC1A7FE4AFF99355314B43CCB7F4B52F273F4DF6E0A609894D3CF438CDFAAD29F9FD3BBFC1AFF16BFC1AC9AF097708E2F263E0B81F03AABFDE7FF36BFC1ABFC6AFAF93F463F8E4C780FCAFF7DFFF1ABFC6AFF11B7B68E7B3E4D7840B059AFF18BEFC31B4FD31B4FDF5FEA75FE3D7F835FE885FB33BD07CF673314E8C33F9CDE0DEE17FBF265C3C688A5FEF7FFE357E8D5FE3CEADE985577E0C03FC35FFA15FE3D7F835E051FDD82FFB357E8D5FE3C77EF9AFF16BFC1A3FF62B7E8D5FE3D7F8B1FFF5D7F8357E8DDF0C5E164CC78FFDCA5FE3D7F8357E33B85BF8EBC7FEB75FE3D7F8357E4DF85D00F3EBFDAA5FE3D7F8357E0BEDF94CD6719195C2773F061BF66BFE63BFC6AFF16BE0AF5FEF57FF1ABFC6AFF1F19025E77947EA5632B678E1C7E06CFCBAFFD4AFF16BFC1AA3F7717CA0E17FBD8673A9BF3EE50928839927ABBA5AE5755BE4CDAFF3EBFCDABFFB4D4690DF85BDFA8537B4FC52C0A3E9EF14F182BE9D35F316C440835FF7D7FEBFFFEFFFFB77BF55D7A0F2AFAFF9B45FE3D7C2CBBFE6AFFB6BFDDFFFF7FFFD0B6F870E5EFFF5F5F55FE3D7C2EBBF46F26BC28705297FCD5FF3FFFEBFFF6FA0F26BFF9ABFC6FFFD7FFFDF00FB6B26BF269C5B7CFB6BFEDFFFD7FFFD7FE3DB5FF3D7FCBFFEAFFFFBFFC6B7BF46F2EBC2F0FF47BFE62DE7E0B62EDC06DF75DDDCE8D37DE3698EEF7F1F2CF75B46D274BF7190A6FB319BA6FB4DC234DDAFF96BFF1ABFC647379BC6DFE0D7C484FC1898F4C77E9D5FF3D7F835303BBFC6AF09570A54FE317CFE63BFDEAFF96BFC1AF8F8D7F835E1BBFC5DBFC6AFF16BFC7ABFFEAFF96BFC1A970A7DC036FE6CA52F7F0C529CFC18D4C5AF97FC9ABFC6AFF1E90D3369F296F94C97119E15659BD7BFDE6FF86BFE1ABFC66F4A0AB49ABE6D8EA7BF685DD4F92CF935E19841E9FE18BEFE3174F263E8E4D7FB4D7ECD5FE3D7B86F74AEFFCA80D6B5A3BFF31BFC1ABFC6AF91FC3A70E53EBA793A40EFDFC0B0EAAFAF76E2D757EFF4D7FE757EED9D9B4184EEE99B9B24FCEB2CFE4386EFBEA727F063BFE9AFF96BFC1A3F065DF063BFF9AFF96BFC1ABF267C59B0D88F61C83FF65BFE9ABFC6AF010EFB357E1D78AE1FDD3C4ABCF51B182AFCFA4AA85F5F09F56BFF3ABFF6CECD204242BDF9D920140875F73D09F563BFD5AFF96BFC1A3F0642FDD86FF36BFE1ABFC66F064B88FFFD66B086F8DFAF098B08EDF0EBFDB6BFE6AFF16BFC860A1ECB65F8F0C7201EBF26EC25FEFAF57EFB5FF3D7F8359E0D19B97856E513CDE6D1B2F67951E6909AAC58E635E0FD186CE0AF09FB8B3CF3AFF99FFF5FFFF7FF8D3CF3AFF963BFD3AFF96BFC1ABFEEFFF66BFC1ABFC6C7B7B4A85800FCCD89030B5A62C9675FE44D935DE4CD6FD5680EB05A3706ABE6B7CE629FFEFAF912B66CF61BB72AE058032D7FED5FE7D7F9357E8DDF2E62FCD896FF13BFE6107636CB0B65A6C97672473B0BEEBDD7182A3C465A44A291CC7E48613FD2507FEFAFF9B331961FD20030805FF3D7C4BF3FF63BFF9ABFC6AF91FCD82FF8357F8D5FE3D7FC357E1D98A08F6E165D48FF6F6044FBD757E9FFF555FA7FED5FE7D7DEB9194428FD3FF5B5A4DFF8166E2DBEFBCDABFC1C3AE0EE7BEA801FFB5D7ECD5FE3D7F8B1F4D7FC357E8D1FFB5D7FCD5FE3D7F87560813FBA794C20CB6F60C6FCEB2B597E7D25CBAFFDEBFCDA3B378308C9F2533F7B640159EEBE27597EECA35FF3D7F8357E0C64F93190E5D78449F9BB7E8D5FE3D7F8F57EF75FF3D7F8357ECB883BF2635086BFDEC7BFE6AFF16BFCFA4A8D1FFB0D7E8D5FE3D7F831A4237EBD6FFD9ABFC6AFF11B61AD6F579D97E4D7846582F5FF317CF76368FA6368FAEB6DFF9ABFC6AFB1C7D6DF6F7FA3E90780E4D7816DFBE866CA63F27E033333BFBEA2FBEBEBE4FDDABFCEAFBD73338870F27EEA676FF2307977DF73F27E6CFC6BFE1ABFC68FDDFD357F8D5FE3C7767ECD5FE3D7F83561E630793F86C9FB314CD4AF77EFD7FC357E8D5F5F47FE6320DE8F81FABFDEA7BFE6AFF16BFC4620FC9E123EF935611931513F86EF7E0C4D7F0C4D7FBD87BFE6AFF16BECD98932ED6F9C2800487E53D8B0DFECD7F8357E8D5FAB9B57FB75A0A37EBB21A3821CC7AFF7FB67759D5DFFBABFFF3CCF66BFEEEF4F06B3FC757FFFA6F841FE1BFEFE177575F58CCC5355FF06BFFFA58405BFEEAFF16BFC1ABFC6AFF11BFC06BFC16FF01BFCD8A35FF3D7F83508C0AF81FFE17FFFD4AFF16BFC1AF8F9EB4223FEBDBFE6FF87753C16327E63313A9FFCFEBC58FF1B99BF4099DFD4FCA144F9757E8D5FE31FFF356F60D9F70DEA7E2E4CDBF7BE8F10F737F80DB054F46387BFE6AFF16BC095C3FF7F4D287570FCAFF7F8D7FC357E8DBFEBD78CE8ABFF4F04A63F0659FDF58E7ECD5FE3D7F8F555567F0CC1D88F214EFAF58E7FCD5FE3D7F84DBE5CFA6173F2EB4263FFD4CF9E3602717FA35C5902C9C15FFB77D1CEBE5A2284EF2B4A24217EECC9AFF96BFC1ABF26EC0814C98F01F11FC3387E0CE3F8F59EFD9ABFC6AFF10768BCE70FE63D936C1BD30877A076925F13460D6CF163608B1F03717FBDB35FF3D7F8357E7D25EE8F01A91F03523F061C935F137A14ED7F0CED7F0CED7FBD2F7FCD5FE3D7F8F5B5FD8FFDCEBFC6AFF16BFC7A3FF16BFE1ABFC63FF96B76B153748ABC218FE617AD094D3221D65D540AC69870E38B7D2AB8E6DF8848FD7AAF7ECD5FE3D7F84DBE5C9ECC8B72765256CDBACE935F13A6049CF563AF7FCD5FE3D7F835615330913F86B63F061AFC1868F0EB7DF7D7FC357E8D3F4027D27FFF1B9D484C64F29B4195A7BFC6AFF16BFCC6E9AF0FB9FF35F07F044DBFCE3FFA6BDE924DFEDFACD720333FF67BFF9ABFC6AFF11BFFDABF26440723FB31B0257EF93130E9AF8989C05F3F06CAE3971FC33CFCBA78E91FFD35FF7F40020CE9B78CA4E47EE32025F7633625F79B8429B95FF3D7FE357E8D8F6EF6E27E835F1339D21FFBAD7E8D5FE3D7F8B1DFEFD7FC357E0DFAE3D7F8357E1DFCF6D1CD2FC3E8FE06C62CFEFAAA127E7DF5227FED5FE7D7DEB91944E845FED4CF9EDE462AF8EE7B7A913FF6FBFF9ABFC6AFF1637FC0AFF96BFC1A3F96FD9ABFC6AFF16BE24F28C35F6FF26BFE1ABFC69FFB6BDED2A6FE5CF8053F064DFDEBCD7ECD5FE3D7F8F5755A7E0CD2F1EB9DFF9ABFC6AFB1B541DFD24C655631FC7A17BFE6AFF16BFC565F2E5DDEE1925C4DE441925F1344813EFCB1F9AFF96BFC1ABF26A8037DF86378E3C7D0D38FA1A75FAFFC357F8D5FE3A5EAC33E949BB4629C7077A0FF925F13FD42447E0C1DE1971F43B7BFE1FF0392328A79B0450000, @status = 0, @activationComplete = 0, @blocked = 1, @info = N''
7.) After installing SP4 SQL statement executes without exception
8.) Check DTC - it must be up and running.
n.
DouglasR
Hi all,
I installed VS 2005 beta2 ...44, wwf beta1, sql server 2000 sp3 and run sql workflow script.
the workflow samples work well in memory.
if I add sqlstatepersistenceservice, sqltimerservice then it pend whenever workflow operates with sqlserver such as unload(), requestpersistence().
How can i solve it
Thanks,
wiz
Problem is to turn DTS on.
Thank you very much
rotninou
I recently had a similar problem - installing SP4 for SQL Server 2000, or using SQL Server 2005 for persistance database solved all of my problems.
n.
bbdobuddy
If we start the Distributed Transaction Coordinater service then the error trace starts with the following error:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
And then:
Exception thrown while persisting instance: SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Then its back to normal:
stacktrace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
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.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Workflow.Runtime.Hosting.PersistenceDBAccessor.InsertInstanceState(Guid instanceId, Stream stateStream, Int32 status, Int32 blocked, String info)
at System.Workflow.Runtime.Hosting.SqlStatePersistenceService.System.Workflow.Runtime.IPendingWork.Commit(Transaction transaction, ICollection items)
Any thoughts appreciated!
Michael
m a
Sorry for the length of the query... copy/paste... -:)
n.
amitvjti
Michael,
I would recommend making sure the latest SQL service pack (SP4) is installed:(http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx)
Let me know if this helps,
Arjun
Michael Kenney
You can also try subscribing to:
workflowRuntime.ServicesExceptionNotHandled += ...
To ensure that no unhandled exception was being raised from the persistence services.
Kai Steiner
Solution:
1 - Install SP4 for SQL Server 2000
2 - insure the SQL Server Distributed Transaction Coordinator is running
Ravindra Rajaram
Nope... no effect. But worth a try!
Michael
pyefleet
Michael,
Does the workflow terminate as well If so, is the exception message helpful
If not, could you add this to your application's app.config file:
<system.diagnostics>
<switches>
<add name="WorkflowTraceToDefault" value="1" />
<add name="Host" value="All" />
<add name="Runtime" value="All" />
<add name="Tracking" value="All" />
<add name="Activity" value="All" />
</switches>
</system.diagnostics>
And post any exception that is emitted immediately before the workflow aborts
Thanks!
Arjun
maimoy
hi nrasinec,
Thank you for your solution.
However, I had no improvement in both ways for updating sql server 2000 sp4 and install sqlserver 2005 express CTP April.
I dont know why.
Thanks.