Red Gate forums :: View topic - Specified cast is not valid
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Log Rescue
SQL Log Rescue forum

Specified cast is not valid

Search in SQL Log Rescue forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
csco1550



Joined: 20 Oct 2005
Posts: 6

PostPosted: Thu Oct 20, 2005 11:52 pm    Post subject: Specified cast is not valid Reply with quote

Shocked
When I test the log rescue, got this error message on one table / update
"Specified cast is not valid"

Please help.

Here is the table :

CREATE TABLE [WeeklySalesReport] (
[WeeklySalesReportGUID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_WeeklySalesReport_WeeklySalesReportGUID] DEFAULT (convert(uniqueidentifier,(convert(binary(10),newid()) + convert(binary(6),getdate())))),
[dtCreated] [datetime] NOT NULL CONSTRAINT [DF_WeeklySalesReport_dtCreated] DEFAULT (getdate()),
[dtLastEdit] [datetime] NOT NULL CONSTRAINT [DF_WeeklySalesReport_dtLastEdit] DEFAULT (getdate()),
[SalesRepID] [int] NOT NULL ,
[LocationID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SubmittedByID] [int] NOT NULL ,
[WeekEndingGUID] [uniqueidentifier] NOT NULL ,
[DollarsSold] [money] NOT NULL CONSTRAINT [DF_WeeklySalesReport_DollarsSold] DEFAULT (0),
[AccountsSold] [money] NOT NULL CONSTRAINT [DF_WeeklySalesReport_AccountsSold] DEFAULT (0),
[OnSiteVisits] [int] NOT NULL CONSTRAINT [DF_WeeklySalesReport_OnSiteVisits] DEFAULT (0),
[Appointments] [int] NOT NULL CONSTRAINT [DF_WeeklySalesReport_Appointments] DEFAULT (0),
[CallBacks] [int] NOT NULL CONSTRAINT [DF_WeeklySalesReport_CallBacks] DEFAULT (0),
[TrialsPlaced] [int] NOT NULL CONSTRAINT [DF_WeeklySalesReport_TrialsPlaced] DEFAULT (0),
[NewPresentations] [int] NOT NULL CONSTRAINT [DF_WeeklySalesReport_NewPresentations] DEFAULT (0),
[PhoneHours] [float] NOT NULL CONSTRAINT [DF_WeeklySalesReport_PhoneHours] DEFAULT (0),
[Dialings] [int] NOT NULL CONSTRAINT [DF_WeeklySalesReport_Dialings] DEFAULT (0),
[DecisionMakerContacts] [int] NOT NULL CONSTRAINT [DF_WeeklySalesReport_DecisionMakerContacts] DEFAULT (0),
[AppointmentsScheduled] [int] NOT NULL CONSTRAINT [DF_WeeklySalesReport_AppointmentsScheduled] DEFAULT (0),
[TargetContacts] [int] NOT NULL CONSTRAINT [DF_WeeklySalesReport_TargetContacts] DEFAULT (0),
[TargetAppointments] [int] NOT NULL CONSTRAINT [DF_WeeklySalesReport_TargetAppointments] DEFAULT (0),
[UninstalledBusiness] [money] NOT NULL CONSTRAINT [DF_WeeklySalesReport_UninstalledBusiness] DEFAULT (0),
[ActualDollarsSold] [money] NOT NULL CONSTRAINT [DF_WeeklySalesReport_ActualDollarsSold] DEFAULT (0),
[DaysWorked] [int] NOT NULL CONSTRAINT [DF_WeeklySalesReport_DaysWorked] DEFAULT (5),
[NoActivity] [bit] NOT NULL CONSTRAINT [DF_WeeklySalesReport_NoActivity] DEFAULT (0),
[ISRReport] [bit] NOT NULL CONSTRAINT [DF_WeeklySalesReport_ISRReport] DEFAULT (0),
[wsr_dtWeekEnding] [datetime] NULL ,
[sum_UninstalledBusiness] [money] NOT NULL CONSTRAINT [DF_sum_UninstalledBusiness] DEFAULT (0),
[sum_amr_RouteRideDollarsSold_beforeStart] [money] NOT NULL CONSTRAINT [DF_sum_amr_RouteRideDollarsSold_beforeStart] DEFAULT (0),
[sum_amr_RouteRideDollarsSold_afterStart] [money] NOT NULL CONSTRAINT [DF_sum_amr_RouteRideDollarsSold_afterStart] DEFAULT (0),
[sum_amr_RouteRideAccountsSold_beforeStart] [money] NOT NULL CONSTRAINT [DF_amr_RouteRideAccountsSold_beforeStart] DEFAULT (0),
[sum_amr_RouteRideAccountsSold_afterStart] [money] NOT NULL CONSTRAINT [DF_sum_amr_RouteRideAccountsSold_afterStart] DEFAULT (0),
[sum_amr_InstalledBusiness_beforeStart] [money] NOT NULL CONSTRAINT [DF_sum_amr_InstalledBusiness_beforeStart] DEFAULT (0),
[sum_amr_InstalledBusiness_afterStart] [money] NOT NULL CONSTRAINT [DF_sum_amr_InstalledBusiness_afterStart] DEFAULT (0),
[sum_src_ActualDollarsSold_beforeStart] [money] NOT NULL CONSTRAINT [DF_sum_src_ActualDollarsSold_beforeStart] DEFAULT (0),
[sum_src_ActualDollarsSold_afterStart] [money] NOT NULL CONSTRAINT [DF_sum_src_ActualDollarsSold_afterStart] DEFAULT (0),
[sum_amr_Adjustments_beforeStart] [money] NOT NULL CONSTRAINT [DF_sum_amr_Adjustments_beforeStart] DEFAULT (0),
[sum_amr_Adjustments_afterStart] [money] NOT NULL CONSTRAINT [DF_sum_amr_Adjustments_afterStart] DEFAULT (0),
[sum_amr_MaySanis] [money] NOT NULL CONSTRAINT [DF_sum_amr_MaySanis] DEFAULT (0),
[sum_amr_MaySanisAdjustments] [money] NOT NULL CONSTRAINT [DF_sum_amr_MaySanisAdjustments] DEFAULT (0),
[flag_userSubmit] [bit] NOT NULL CONSTRAINT [DF_WeeklySalesReport_flag_userSubmit] DEFAULT (1),
CONSTRAINT [PK_WeeklySalesReport] PRIMARY KEY NONCLUSTERED
(
[WeeklySalesReportGUID]
) WITH FILLFACTOR = 90 ON [PRIMARY] ,
CONSTRAINT [FK_WeeklySalesReport_FiscalWeek] FOREIGN KEY
(
[WeekEndingGUID]
) REFERENCES [FiscalWeek] (
[FiscalWeekGUID]
),
CONSTRAINT [FK_WeeklySalesReport_users] FOREIGN KEY
(
[SalesRepID]
) REFERENCES [users] (
[userID]
),
CONSTRAINT [FK_WeeklySalesReport_users1] FOREIGN KEY
(
[SubmittedByID]
) REFERENCES [users] (
[userID]
)
) ON [PRIMARY]
GO
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6643

PostPosted: Fri Oct 21, 2005 10:22 am    Post subject: Reply with quote

Sorry --

What is the query that Log Rescue is trying to run?
Back to top
View user's profile Send private message
csco1550



Joined: 20 Oct 2005
Posts: 6

PostPosted: Fri Oct 21, 2005 6:55 pm    Post subject: Reply with quote

after log rescure finish processing backup files, it pop-ups the error dialog, it points the first row on the main screen , that's an update event.

When I click it, I got the same error pop-up.
There are many updates on this table, all result same error when you click them.

BTW, those updates are generated by a nightly scheduled job.

I also noticed some of them are identified as user : DBO, some are identified as user: Unrecorded(-1).

I am pretty sure they are all updated by the job at 11:20PM.

Is there any way I can send you a screen shot?

Thanks.
Back to top
View user's profile Send private message
csco1550



Joined: 20 Oct 2005
Posts: 6

PostPosted: Mon Oct 31, 2005 8:41 pm    Post subject: I am so disappointed Reply with quote

Sad I am so disappointed that no one answer my questions, the trial version is expiring, Does anyonehere know similar product which I can try? I heard logviewer or something...
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6643

PostPosted: Tue Nov 01, 2005 3:19 pm    Post subject: Reply with quote

Can you please send the screenshot to support@red-gate.com?

Thanks.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group