10/9/2007 7:43:56 AM v1.3445 - Invalid column name 'Total_Amts' Continue or restart VDM - This error was queued for analysis, we apologize. select [Total_Amts] from Orders where [ID]=4070 0001:0023031C axView.txView.ExecuteRS line 8060 0001:0023EA4C axView.txTabsEx.DoOnClick line 9565 base: 00A11000 select [Total_Amts] from Orders where [ID]=4070 10/8/2007 8:24:57 PM v1.3445 - Operation is not allowed when the object is closed Continue or restart VDM - This error was queued for analysis, we apologize. select [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modi 0001:001F48A4 axView.txTree.RefreshValues line 3223 0001:0021FF54 axView.txView.DoOnTimer line 6670 base: 00A01000 select [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modified],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,[Date_Locked],[Type],[Name],[Contact_Name],[Resource_Name],[Catalog_Name],[Minutes],[Hours],[Days],[Activities_Count],[Date_Start],[Date_Stop],Cast( Note as VarChar( 1000 ) ) as [Note],[Change_Notification_List],[Notification_Condition],[Late_Notification_List],[Notify_when_Late_by_Days],[Late_Reminder_every_Hours],[Follow-Up_Notification_List],[Follow-Up_every_Days],[Late_Follow-Up_Reminder_every_Hours],[Date_Last_Follow-Up_Done] from Activities where [ID]=47 10/6/2007 11:51:54 PM v1.3445 - Syntax error converting the varchar value '2006-12-31' to a column of data type int Continue or restart VDM - This error was queued for analysis, we apologize. update Activities set [Hours]=5 where [ID]=48 0001:0001E6C8 ComObj.DispCallError line 1795 0001:00242784 axVDM.Finalization line 54 base: 00A01000 update Activities set [Hours]=5 where [ID]=48 10/6/2007 12:02:02 PM v1.3445 - Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction Continue or restart VDM - This error was queued for analysis, we apologize. declare @I int, @ID int, @GUID varchar( 100 ), @S varchar( 100 ) if NOT exists( select ID from Reso 0001:0021AFB8 axView.txView.RunSQL line 6184 0001:0018F4B0 axPopup.txPopup.DoOnClick line 1028 base: 00A01000 declare @I int, @ID int, @GUID varchar( 100 ), @S varchar( 100 ) if NOT exists( select ID from Resources where [Name] like 'VDM_Test_Resource_%' ) begin set @I = 0 while @I < 10 begin set @S = 'VDM_Test_Contact_' + Cast( @I as varchar( 10 ) ) insert Contacts ( [Name] ) values( @S ) set @S = 'VDM_Test_Resource_' + Cast( @I as varchar( 10 ) ) insert Resources ( [Name], Price ) values( @S, @I + 1 + @I / 10 ) set @I = @I + 1 end end set @I = 0 while @I < 100 begin set @S = 'VDM_Test_Contact_' + Cast( @I % 10 as varchar( 10 ) ) insert Orders ( [Name], [Type] ) values( @S, 'Sale' ) set @ID = Scope_Identity() set @S = 'VDM_Test_Resource_' + Cast( @I % 10 as varchar( 10 ) ) insert OrderItems ( Order_ID, Resource_Name, Quantity, Price ) values( @ID, @S, @I + 1, @I + 1 + @I / 10 ) select @GUID = isNull( GUID, '' ) from Orders where ID = @ID AND Date_Locked is Null set @S = 'VDM_Test_' + Cast( @ID as varchar( 100 ) ) execute dbo.LockOrder @GUID, 'getdate()', @S set @I = @I + 1 end 10/4/2007 5:57:09 AM v1.3296 - Operation is not allowed when the object is closed Continue or restart VDM - This error was queued for analysis, we apologize. select top 101 [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[D 0001:001E52C0 axView.txTree.WhereClause line 2918 0001:00218148 axView.txView.ReversePhone line 6897 base: 00A11000 select top 101 [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modified],[Date_Locked],[Type],[Sequence],[Name],[Contact_Name],[Resource_Name],[Serial_or_Lot_Number],[Catalog_Name],[Minutes],[Hours],[Days],[Activities_Count],[Date_Start],[Date_Stop],[Tree_Path],[Note], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from Activities where ([Activity_ID]=0) order by [Sequence], [ID] 10/2/2007 5:23:16 AM v1.3296 - Operation is not allowed when the object is closed Continue or restart VDM - This error was queued for analysis, we apologize. select top 501 [ID],[Name], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from Activities where 0001:001E52C0 axView.txTree.WhereClause line 2918 0001:001DD1A8 axView.txTree.LoadDir line 2075 base: 00A11000 select top 501 [ID],[Name], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from Activities where ([Type]='Project') AND (Date_Locked is Null) order by [ID] 10/2/2007 5:23:12 AM v1.3296 - Operation is not allowed when the object is closed Continue or restart VDM - This error was queued for analysis, we apologize. select [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modi 0001:001E71E0 axView.txTree.LoadValues line 3102 0001:00218148 axView.txView.ReversePhone line 6897 base: 00A11000 select [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modified],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,[Date_Locked],[Type],[Name],[Contact_Name],[Resource_Name],[Catalog_Name],[Minutes],[Hours],[Days],[Activities_Count],[Date_Start],[Date_Stop],[Note],[Change_Notification_List],[Notification_Condition],[Late_Notification_List],[Notify_when_Late_by_Days],[Late_Reminder_every_Hours],[Follow-Up_Notification_List],[Follow-Up_every_Days],[Late_Follow-Up_Reminder_every_Hours],[Date_Last_Follow-Up_Done] from Activities where [ID]=557 10/2/2007 5:23:09 AM v1.3296 - Operation is not allowed when the object is closed Continue or restart VDM - This error was queued for analysis, we apologize. select [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modi 0001:001E71E0 axView.txTree.LoadValues line 3102 0001:002142E4 axView.txView.GetData line 6367 base: 00A11000 select [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modified],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,[Date_Locked],[Type],[Name],[Contact_Name],[Resource_Name],[Catalog_Name],[Minutes],[Hours],[Days],[Activities_Count],[Date_Start],[Date_Stop],[Note],[Change_Notification_List],[Notification_Condition],[Late_Notification_List],[Notify_when_Late_by_Days],[Late_Reminder_every_Hours],[Follow-Up_Notification_List],[Follow-Up_every_Days],[Late_Follow-Up_Reminder_every_Hours],[Date_Last_Follow-Up_Done] from Activities where [ID]=557 10/2/2007 5:23:05 AM v1.3296 - Operation is not allowed when the object is closed Continue or restart VDM - This error was queued for analysis, we apologize. select [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modi 0001:001E71E0 axView.txTree.LoadValues line 3102 0001:00218148 axView.txView.ReversePhone line 6897 base: 00A11000 select [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modified],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,[Date_Locked],[Type],[Name],[Contact_Name],[Resource_Name],[Catalog_Name],[Minutes],[Hours],[Days],[Activities_Count],[Date_Start],[Date_Stop],[Note],[Change_Notification_List],[Notification_Condition],[Late_Notification_List],[Notify_when_Late_by_Days],[Late_Reminder_every_Hours],[Follow-Up_Notification_List],[Follow-Up_every_Days],[Late_Follow-Up_Reminder_every_Hours],[Date_Last_Follow-Up_Done] from Activities where [ID]=557 10/2/2007 5:23:02 AM v1.3296 - Operation is not allowed when the object is closed Continue or restart VDM - This error was queued for analysis, we apologize. select [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modi 0001:001E71E0 axView.txTree.LoadValues line 3102 0001:00218148 axView.txView.ReversePhone line 6897 base: 00A11000 select [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modified],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,[Date_Locked],[Type],[Name],[Contact_Name],[Resource_Name],[Catalog_Name],[Minutes],[Hours],[Days],[Activities_Count],[Date_Start],[Date_Stop],[Note],[Change_Notification_List],[Notification_Condition],[Late_Notification_List],[Notify_when_Late_by_Days],[Late_Reminder_every_Hours],[Follow-Up_Notification_List],[Follow-Up_every_Days],[Late_Follow-Up_Reminder_every_Hours],[Date_Last_Follow-Up_Done] from Activities where [ID]=557 10/2/2007 5:22:59 AM v1.3296 - Operation is not allowed when the object is closed Continue or restart VDM - This error was queued for analysis, we apologize. select [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modi 0001:001E71E0 axView.txTree.LoadValues line 3102 0001:00218148 axView.txView.ReversePhone line 6897 base: 00A11000 select [ID],[GUID],[OrderItem_ID],[Contact_ID],[Resource_ID],[Activity_ID],[Date_Created],[Date_Modified],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,[Date_Locked],[Type],[Name],[Contact_Name],[Resource_Name],[Catalog_Name],[Minutes],[Hours],[Days],[Activities_Count],[Date_Start],[Date_Stop],[Note],[Change_Notification_List],[Notification_Condition],[Late_Notification_List],[Notify_when_Late_by_Days],[Late_Reminder_every_Hours],[Follow-Up_Notification_List],[Follow-Up_every_Days],[Late_Follow-Up_Reminder_every_Hours],[Date_Last_Follow-Up_Done] from Activities where [ID]=557 10/2/2007 5:22:55 AM v1.3296 - Operation is not allowed when t