Re: After DBXL database was moved/reconfigured getting SubmitToDbxl error with qRules

DC Forms — Thu, 25 Oct 2012 20:03:29 GMT

Thanks for confirming.

Re: After DBXL database was moved/reconfigured getting SubmitToDbxl error with qRules

Jim Cantwell — Thu, 25 Oct 2012 19:34:29 GMT

With DBXL v2.6, the CLR is required to be enabled on the SQL Server instance.

Open SQL management studio and connect to the SQL Server where the databases reside using an account with sysadmin permissions and execute the following:

sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO

After DBXL database was moved/reconfigured getting SubmitToDbxl error with qRules

DC Forms — Thu, 25 Oct 2012 19:17:45 GMT

Post database changes that impacted DBXL I am getting the following error:

Action: SubmitToDbxl. Arguments: submit: SubmitDocumentToDBXL doctype: fundingForm name: 2012-10-25T14-57-17[XXXX_XXXX] author: dglover . Details: I9999An unhandled exception was thrown: Executing Sql 'insert into "dbo"."Document"("Size","VersionNo","Name","Author","Type","Description","Data","DataExtractedPlaintext","RefID","IsLocked","LockedBy","LockExpires","LockComments","DateCreated","DateModified","CreatedBy","ModifiedBy","OptimisticLockField")values(@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,null,@p11,@p12,@p13,@p14,@p15,@p16) set @p17=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p18,@p19,@p20,@p21) set @p22=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p23,@p24,@p25,@p26) set @p27=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p28,@p29,@p30,@p31) set @p32=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p33,@p34,@p35,@p36) set @p37=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p38,@p39,@p40,@p41) set @p42=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p43,@p44,@p45,@p46) set @p47=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p48,@p49,@p50,@p51) set @p52=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p53,@p54,@p55,@p56) set @p57=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p58,@p59,@p60,@p61) set @p62=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p63,@p64,@p65,@p66) set @p67=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p68,@p69,@p70,@p71) set @p72=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p73,@p74,@p75,@p76) set @p77=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p78,@p79,@p80,@p81) set @p82=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p83,@p84,@p85,@p86) set @p87=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p88,@p89,@p90,@p91) set @p92=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p93,@p94,@p95,@p96) set @p97=SCOPE_IDENTITY() insert into "dbo"."DocumentProperty"("Document","ColumnName","DocumentTypeProperty","Value","OptimisticLockField")values(@p17,@p98,@p99,@p100,@p101) set @p102=SCOPE_IDENTITY() insert into "dbo"."DocumentStats"("DocId","AccessType","DateAccessed","AccessedBy","OptimisticLockField")values(@p103,@p104,@p105,@p106,@p107) set @p108=SCOPE_IDENTITY() update "dbo"."Document" set "Size"=@p109,"VersionNo"=@p110,"Name"=@p111,"Author"=@p112,"Type"=@p113,"Description"=@p114,"Data"=@p115,"DataExtractedPlaintext"=@p116,"RefID"=@p117,"IsLocked"=@p118,"LockedBy"=@p119,"LockExpires"=null,"LockComments"=@p120,"DateCreated"=@p121,"DateModified"=@p122,"CreatedBy"=@p123,"ModifiedBy"=@p124,"OptimisticLockField"=@p125 where (("DocID" = @p126) and ("OptimisticLockField" = @p127)) IF @@ROWCOUNT <> 1 begin set @r=0 RETURN end set @r=1' with parameters '{3199},{1},{2012-10-25T14-57-17[XXXX_XXXX]},{dglover},{213},{},{System.Byte[]},{ en-US 2012-10-19 2012-10-12 1000000.0 5 9 27 25 25 true 1 true ...},{20216},{False},{},{},{10/25/2012 1:57:39 PM},{10/25/2012 1:57:39 PM},{XXXX\XXXX},{XXXX\XXXX},{0},{Null},{{F806610E-5E55-4482-BBF2-61DB2810716D}},{0},{5},{0},{Null},{{9291A3FE-8C24-415E-B961-4B080180EAE9}},{0},{},{0},{Null},{{781A89B4-C34F-43AB-AF13-85D76C5A97BB}},{0},{},{0},{Null},{{FEA6F4F3-E0D1-44B2-88A7-6666E6ECF26C}},{0},{2012-10-25T14-57-17[XXXX_XXXX]},{0},{Null},{{B8E23F00-E3BF-4789-8C24-8054408D93F9}},{0},{9},{0},{Null},{{FB5D6631-6819-4188-AEFE-CC3B7F290F83}},{0},{},{0},{Null},{{EDE67C04-BE9D-4431-A327-976C730512A4}},{0},{25},{0},{Null},{{BC15E069-4A5B-4BCD-8970-0CDD72ED3418}},{0},{1},{0},{Null},{{C8F0C3B4-3C18-41F3-913A-D2E6B39366D0}},{0},{2012-10-19},{0},{Null},{{905F246F-AF76-42DE-BE72-3E02A2EE4136}},{0},{},{0},{Null},{{FEEC285B-8FD8-4A14-846E-870A81EBCC38}},{0},{1000000.0},{0},{Null},{{76D274D7-8FA7-45FE-81B2-54A089401F33}},{0},{},{0},{Null},{{F319C53A-ECD1-4395-ACE1-1FE60C5B9899}},{0},{},{0},{Null},{{FE873330-B651-46CE-9A3D-828169013C31}},{0},{2012-10-12},{0},{Null},{{92B8C583-5FF7-43B1-BA34-00A1E4163350}},{0},{27},{0},{Null},{{8DFFACFE-3732-4560-ADFD-316481D1D7AE}},{0},{25},{0},{Null},{{C8364C2C-4AEF-464D-B438-22F690BDE7D1}},{0},{},{0},{Null},{206},{2},{10/25/2012 1:57:39 PM},{XXXX\XXXX},{0},{Null},{304},{73},{},{System DocType Handler},{2},{},{System.Byte[]},{ 20216},{3},{False},{},{},{9/25/2012 9:19:42 AM},{10/25/2012 1:57:39 PM},{XXXX\XXXX},{XXXX\XXXX},{72},{206},{71},{Null}' exception 'System.Data.SqlClient.SqlException: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option. The statement has been terminated. at System.Data.SqlClient.SqlConnection.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 DevExpress.Xpo.DB.MSSqlConnectionProvider.Exec()'. Stack: at Qdabra.Utilities.SubmitDocument(String docType, String name, String author, String description, SubmitDocument submitDocument, XPathNavigator xml, String& docId, String& refId) at Qdabra.Tools.RulesLibrary.Commands.SubmitToDbxl() at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()

A key point may be "Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option."

Before I begin blindly following the guidance at http://mitchfincher.blogspot.com/2012/04/execution-of-user-code-in-net-framework.html, has anyone seen something like this before?

Qdabra Database Accelerator

Re: After DBXL database was moved/reconfigured getting SubmitToDbxl error with qRules

Re: After DBXL database was moved/reconfigured getting SubmitToDbxl error with qRules

After DBXL database was moved/reconfigured getting SubmitToDbxl error with qRules