10/6/2007 12:07:36 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: 00B51000
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/6/2007 12:07:24 PM
v1.3445 - Transaction (Process ID 62) 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: 00A61000
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/5/2007 2:01:04 PM
v1.3425 - Invalid column name 'Date_Start'
Continue or restart VDM - This error was queued for analysis, we apologize.
update Contacts set [Date_Start]='10/5/2007 4:36:18 PM' where [ID]=218
0001:0001E6C8       ComObj.DispCallError line 1795
0001:002418F8       axVDM.Finalization line 54 base: 00A61000
update Contacts set [Date_Start]='10/5/2007 4:36:18 PM' where [ID]=218

9/27/2007 9:40:44 AM
v1.3395 - ZIP (11036) This archive is not a valid Zip archive
Continue or restart VDM - This error was queued for analysis, we apologize.

0001:0022367C       axView.txView.DoOnZipMessage line 6988
0001:00240A40       axVDM.Finalization line 54 base: 00AB1000


9/27/2007 6:51:49 AM
v1.3395 - Invalid column name 'Date_Expiry'
Continue or restart VDM - This error was queued for analysis, we apologize.
select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' )
0001:0022E370       axView.txView.ExecuteRS line 7967
0001:0023CA9C       axView.txTabsEx.DoOnClick line 9524 base: 00AB1000
select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' ) ) as ID_Number,[Phone],[Name],[Main_Contact_Name],[Reference],Cast( Note as VarChar( 1000 ) ) as [Note],'$' + rTrim( Cast( Total as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Grand_Total as Decimal(18,2) ) ) as Total_Amts,[Grand_Total],[Total],[Taxable_Amount],[Tax_Profile],'$' + rTrim( Cast( Taxes1 as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Taxes2 as Decimal(18,2) ) ) as Tax_Amounts,[Taxes],[Taxes1],[Taxes2],[Locked_Deposits],[Change],[Balance],[Payment],[Payment1],[Payment2],[Payment3],[Payment4],[Payment5],[Payment6],[ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,rTrim( isNull( Date_Printed, '' ) ) + ' - ' + rTrim( isNull( Date_Locked, '' ) ) + ' - ' + rTrim( isNull( Date_Voided, '' ) ) as Printed_Locked,[Date_Required],[Type],[Group],[Repeat_Frequency],[Employee],[Referred_by],[Price_Level],[Currency],[Address],[City],[State_or_Province],[Postal_Code],[Country],[Fax],[eMail],[Credit_Card],[Card_Number],[Date_Expiry],[Card_Code],[Ship_Name],[Ship_Address],[Ship_City],[Ship_State_or_Province],[Ship_Postal_Code],[Ship_Country],[Ship_Fax],[Ship_eMail],[AR_Account],[Sales_Account],[Asset_Account],[COGS_Account],[Payment_Account],[Payment1_Account],[Payment2_Account],[Payment3_Account],[Payment4_Account],[Payment5_Account],[Payment6_Account],[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 Orders where [ID]=3755

9/27/2007 6:51:43 AM
v1.3395 - Invalid column name 'Date_Expiry'
Continue or restart VDM - This error was queued for analysis, we apologize.
select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' )
0001:0022E370       axView.txView.ExecuteRS line 7967
0001:0023CA9C       axView.txTabsEx.DoOnClick line 9524 base: 00AB1000
select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' ) ) as ID_Number,[Phone],[Name],[Main_Contact_Name],[Reference],Cast( Note as VarChar( 1000 ) ) as [Note],'$' + rTrim( Cast( Total as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Grand_Total as Decimal(18,2) ) ) as Total_Amts,[Grand_Total],[Total],[Taxable_Amount],[Tax_Profile],'$' + rTrim( Cast( Taxes1 as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Taxes2 as Decimal(18,2) ) ) as Tax_Amounts,[Taxes],[Taxes1],[Taxes2],[Locked_Deposits],[Change],[Balance],[Payment],[Payment1],[Payment2],[Payment3],[Payment4],[Payment5],[Payment6],[ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,rTrim( isNull( Date_Printed, '' ) ) + ' - ' + rTrim( isNull( Date_Locked, '' ) ) + ' - ' + rTrim( isNull( Date_Voided, '' ) ) as Printed_Locked,[Date_Required],[Type],[Group],[Repeat_Frequency],[Employee],[Referred_by],[Price_Level],[Currency],[Address],[City],[State_or_Province],[Postal_Code],[Country],[Fax],[eMail],[Credit_Card],[Card_Number],[Date_Expiry],[Card_Code],[Ship_Name],[Ship_Address],[Ship_City],[Ship_State_or_Province],[Ship_Postal_Code],[Ship_Country],[Ship_Fax],[Ship_eMail],[AR_Account],[Sales_Account],[Asset_Account],[COGS_Account],[Payment_Account],[Payment1_Account],[Payment2_Account],[Payment3_Account],[Payment4_Account],[Payment5_Account],[Payment6_Account],[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 Orders where [ID]=3755

9/27/2007 6:51:39 AM
v1.3395 - Invalid column name 'Date_Expiry'
Continue or restart VDM - This error was queued for analysis, we apologize.
select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' )
0001:0022E370       axView.txView.ExecuteRS line 7967
0001:0023CA9C       axView.txTabsEx.DoOnClick line 9524 base: 00AB1000
select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' ) ) as ID_Number,[Phone],[Name],[Main_Contact_Name],[Reference],Cast( Note as VarChar( 1000 ) ) as [Note],'$' + rTrim( Cast( Total as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Grand_Total as Decimal(18,2) ) ) as Total_Amts,[Grand_Total],[Total],[Taxable_Amount],[Tax_Profile],'$' + rTrim( Cast( Taxes1 as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Taxes2 as Decimal(18,2) ) ) as Tax_Amounts,[Taxes],[Taxes1],[Taxes2],[Locked_Deposits],[Change],[Balance],[Payment],[Payment1],[Payment2],[Payment3],[Payment4],[Payment5],[Payment6],[ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Locked],[Date_Voided],rTrim( isnull( Date_Created, '' ) ) + ' - ' + rTrim( isNull( Date_Modified, '' ) ) + ' by ' + rTrim( UserName ) + ' on ' + rTrim( WorkStation ) as Created_Modified,rTrim( isNull( Date_Printed, '' ) ) + ' - ' + rTrim( isNull( Date_Locked, '' ) ) + ' - ' + rTrim( isNull( Date_Voided, '' ) ) as Printed_Locked,[Date_Required],[Type],[Group],[Repeat_Frequency],[Employee],[Referred_by],[Price_Level],[Currency],[Address],[City],[State_or_Province],[Postal_Code],[Country],[Fax],[eMail],[Credit_Card],[Card_Number],[Date_Expiry],[Card_Code],[Ship_Name],[Ship_Address],[Ship_City],[Ship_State_or_Province],[Ship_Postal_Code],[Ship_Country],[Ship_Fax],[Ship_eMail],[AR_Account],[Sales_Account],[Asset_Account],[COGS_Account],[Payment_Account],[Payment1_Account],[Payment2_Account],[Payment3_Account],[Payment4_Account],[Payment5_Account],[Payment6_Account],[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 Orders where [ID]=3755

9/27/2007 6:51:37 AM
v1.3395 - Invalid column name 'Date_Expiry'
Continue or restart VDM - This error was queued for analysis, we apologize.
select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' )
0001:0022E370       axView.txView.ExecuteRS line 7967
0001:0023CA9C       axView.txTabsEx.DoOnClick line 9524 base: 00AB1000
select rTrim( ID ) + ' - ' + rTrim( isNull( Deposit_ID, '' ) ) + ' - ' + rTrim( isNull( Number, '' ) ) as ID_Number,[Phone],[Name],[Main_Contact_Name],[Reference],Cast( Note as VarChar( 1000 ) ) as [Note],'$' + rTrim( Cast( Total as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Grand_Total as Decimal(18,2) ) ) as Total_Amts,[Grand_Total],[Total],[Taxable_Amount],[Tax_Profile],'$' + rTrim( Cast( Taxes1 as Decimal(18,2) ) ) + ', $' + rTrim( Cast( Taxes2 as Decimal(18,2) ) ) as Tax_Amounts,[Taxes],[Taxes1],[Taxes2],[Locked_Deposits],[Change],[Balance],[Payment],[Payment1],[Payment2],[Payment3],[Payment4],[Payment5],[Payment6],[ID],[GUID],[Number],[Date_Created],[Date_Modified],[Date_Printed],[Date_Lock