sql - "String or binary data would be truncated" error -


I am having an interesting problem, which was created a couple of weeks ago, with my SQL server. I use Crystal Reports to perform routine questions for my DB, and one of my reports has recently started failing and once again has started to succeed. Let me start by saying that I am not a true DBA, I am just taking this DB and Crystal Reports from someone else. I had not written a question in question.

I did some excavation, and I think the syntax that is causing the problem has been found. This is a long pending inquiry, so long as the request is not made, I will not be involved. This query pulls data based on today's day. For a few days, the query succeeds, and for some days it fails. When this fails, the error code is: 

  string or binary data will be deducted

Here the syntax is causing the problem is: 

  @LastWeekDay declared as DATETIME set @LastWeekDay = (select case DatePart (weekdays, GETDATE ()) = 2 then cast (DATEADD (day - 3, GETDATE ()) date as) when DatePart (weekday, GETDATE ()) = 1, then cast (, -2 DATEADD (day, GETDATE ()) date as) ELSE Cast (DATEADD (day , -1, GETDATE () as the date)

If I start manipulating this query, instead of using GETDATE, by entering static dates) function. I get mixed results. Today, the report is working, so if I throw at today's date, then it works, and gives me the result which I am looking for: 

 < code> DECLARE @LastWeekDay aS DATETIME SET @LastWeekDay = (select case when DATEPART (weekday, "01/22/2015") = 2 then cast (DATEADD (day -3, "01/22/2015") Date of time (time of day, '1/22 ​​/ 2015') = 1 then cast (DATEADD (day, -2, '1/22/2015') DATE) ELSE CAST (DATEADD (day, -1, '1/22/2015' AS DATE) END)

However, if I change the date from 1/2/21/2015, so it fails in this error code: 

  (1 line affected) Message 8152, level 16, state 14, line 310 String or binary data will be deducted. The statement has been terminated.

I went to issue 310, to see what the problem is. And here is code at 310. 

  announced 308 @Queue table (LoanID varchar (8), LoanType varchar (12), CreditApproval DATE) 309 310 INSERT INTO @Queue (LoanID, LoanType, CreditApproval) select 311 312 "_364" LoanID , 313 "_1172" LoanType, 314 "_2300" CreditApproval

I've tried increasing the number of characters on my field announcements, but it does not seem to work. I do not understand why the results of some dates are generated, and errors occur in a few days.

Here is a sample of the past few weeks, and the date that works / generates errors: 

  1 / 22 Works 1/21 Error 1/20 Works 1/19 Works 1/16 Error 1/15 Error 1/14 Works 1/13 Works 1/12 Error 1/9 Works 1/8 Works 1/7 Error

All dated 1/6 and the last seems to work fine. Can this cause the error?

Well, I got the problem at some point in my farm at one of the lengths of VECCAR (12) ) VARCHAR (25) had changed. For a few days, the prices were less than 12 characters, so there was no problem. On the second day, the price got more than 12, and when you tried to put it in the "Loan Type" field there was an error. In my manifesto, I changed the length of my area to 25 letters. Now I have no other problem. This is my new announcement. 

  @Queue selected table (LoanID varchar (8), LoanType varchar (25), CreditApproval DATE) announced @Queue (LoanID, LoanType, CreditApproval) insert in "_364" loan ID " , "_1172" loan type, "_2300" credit acceptance FROM (((emdbuser.LOANXDB_S_02 s2 joined INNER. LOANXDB_S_06 s6 in SOLAFFID = s6.XrefId) Join INNER. LOANXDB_S_01 s1 ON s2.XrefId = s1.XrefId) insider Join emdbuser.LOANXDB_S_03 S3 on s2.XrefId = s3.XrefId) s2.XrefID Join insider emdbuser.LOANXDB_D_02 d2 = d2.XrefId

there is also a And the announcement, and below was my query, where I was in the field Length was changed to 25. Now everything is fine.


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more