Help Me.. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Help Me..

Author

Topic

ganeshkumar08
Posting Yak Master

187 Posts

Posted - 2008-09-30 : 08:16:28

Hi All,

I got the below error message

Warning: A domain error occurred.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.

why this is coming i was not able to figure it. can any one you please advise me on this.

In many articles i read that for this error we need to install SP2.

Please suggest me..

Thanks
Ganesh

Solutions are easy. Understanding the problem, now, that's the hard part

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-30 : 08:22:58

what was the query which caused this error?

ganeshkumar08
Posting Yak Master

187 Posts

Posted - 2008-09-30 : 08:36:58

Hi
This is my SP
ALTER PROCEDURE [dbo].[sp_InsertTrendEvents_Distribution]
(
@InputMatchID Int
)
as
BEGIN

Declare @ImmediateEventID Int
Declare @PassReceiverID Int
Declare @PassReceiverClubID Int
Declare @XPosoriginRec Numeric(10,3)
Declare @YPosoriginRec Numeric(10,3)
Declare @FirstTime Bit
Declare @OwnHalf Bit
If Not Exists(Select 'T' From TrendEvents_Distribution Where MatchID = @InputMatchID)
Begin
Declare PassInfo Cursor for
select TE.MatchID,TE.SegmentID,TE.Time,TE.Event,TE.Player1,TE.Player1ClubID,
TE.XPosOrigin,TE.YPosOrigin,TE.XPosDest,TE.YPosDest,TE.Outcome
From TrendEvents TE
Inner Join TrendMatches TM ON TE.MatchID=TM.MatchID
Where TE.MatchID = @InputMatchID And TE.Event=48

Declare @MatchID Int,@ClubID Int,@SegmentID tinyint,@EventTime numeric(10,2),@Event Int
Declare @Player Int,@XPosOrigin Numeric(10,3),@YPosOrigin Numeric(10,3)
Declare @XPosDest Numeric(10,3),@YPosDest Numeric(10,3),@Outcome Smallint

open PassInfo
Fetch PassInfo into @MatchID,@SegmentID,@EventTime,@Event,@Player,@ClubID,
@XPosOrigin,@YPosOrigin,@XPosDest,@YPosDest,@Outcome
While @@fetch_Status = 0
BEGIN
Select @ImmediateEventID = ImmediateEventID,
@PassReceiverID = PassReceiverID,
@PassReceiverClubID = PassReceiverClubID,
@XPosoriginRec = XPosorigin,
@YPosoriginRec = YPosorigin,
@FirstTime = FirstTime,
@OwnHalf = OwnHalf
From
[dbo].[fn_GetImmediateEventInfo](@MatchID,@ClubID,@SegmentID,@EventTime)
Insert Into TrendEvents_Distribution Values
(
@MatchID,
@SegmentID,
@EventTime,
@Event,
@Player,
@ClubID,
@XPosOrigin,
@YPosOrigin,
@ImmediateEventID,
@PassReceiverID,
@PassReceiverClubID,
@XPosoriginRec,
@YPosoriginRec,
@FirstTime,
@OwnHalf,
dbo.fn_ResolveEventDirection(
@MatchID,@ClubID, @SegmentID, @XPosOrigin, @YPosOrigin, @XPosDest,@YPosDest),
dbo.fn_ResolveEventDistance(
@XPosOrigin, @YPosOrigin, @XPosDest, @YPosDest),
dbo.fn_IsFinalThirdEntry(
@XPosOrigin, @YPosOrigin, @XPosDest, @YPosDest,@MatchID,@SegmentID,@ClubID,@EventTime),
dbo.fn_IsPenaltyAreaEntry(
@XPosOrigin, @YPosOrigin, @XPosDest, @YPosDest,@MatchID,@SegmentID,@ClubID,@EventTime),
@Outcome
)
FETCH Next from PassInfo into @MatchID,@SegmentID,@EventTime,@Event,@Player,@ClubID,
@XPosOrigin,@YPosOrigin,@XPosDest,@YPosDest,@Outcome

END
Deallocate PassInfo
End
Else
Return

END

Solutions are easy. Understanding the problem, now, that's the hard part

lepeniotis
Yak Posting Veteran

75 Posts

Posted - 2008-09-30 : 08:47:54

I read in an other post that the problem might be the numeric! If you try to use float instead of numeric?? I'm not sure I just suggest.

Regards

MSc Advanced Computing Science
MSc Database Professional
Sheffield Hallam University
MCP (70-229, 70-228)
Industrial IT Engineer

ganeshkumar08
Posting Yak Master

187 Posts

Posted - 2008-09-30 : 09:02:26

Ok i will try to modify with Float

Solutions are easy. Understanding the problem, now, that's the hard part

lepeniotis
Yak Posting Veteran

75 Posts

Posted - 2008-09-30 : 09:04:48

Or maybe that the outcome range needs a larger type than smallint try it with int. Again, I'm not sure. I saw a similar problem somewhere else and the solution was this.

MSc Advanced Computing Science
MSc Database Professional
Sheffield Hallam University
MCP (70-229, 70-228)
Industrial IT Engineer

ganeshkumar08
Posting Yak Master

187 Posts

Posted - 2008-10-01 : 04:38:56

Thank you very much problem was solved by replacing Numeric instead of Float data type.

Solutions are easy. Understanding the problem, now, that's the hard part

lepeniotis
Yak Posting Veteran

75 Posts

Posted - 2008-10-01 : 05:14:02

I'm happy for this mate!

MSc Advanced Computing Science
MSc Database Professional
Sheffield Hallam University
MCP (70-229, 70-228)
Industrial IT Engineer

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources