String or binary data would be truncated

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 2000 Forums

Transact-SQL (2000)

String or binary data would be truncated

Author

Topic

sqlnovice123
Constraint Violating Yak Guru

262 Posts

Posted - 2008-08-18 : 16:27:06

Hello,

I am using SQL 12.x and wanted to confirm the cause of the above error.

When I run the same exact query against the production server with the same exact table structure and the same exact calling proc it works perfectly fine.

But when I run the query in TEST it pops up the below error.

Could it be that some otther developer might have changed the underlying data on TEST and this is causing a large field to be inserted in the VARCHAR or CHAR type field?

Below is the original table structure. The command works fine against the production server.

(
Portfolio varchar(8) NULL
, APM varchar(5) NULL
, HedgeCurrency varchar(12) NULL
, BeginningValueBase float(53) NULL
, CashBucketAmount float(53) NULL
, CashBucketCurrency varchar(12) NULL
, EndingValueBase float(53) NULL
, BeginningValueUSD float(53) NULL
, EndingValueUSD float(53) NULL
, AccountNumberADP_DOM varchar(20) NULL
, EndingValueDom float(53) NULL
, BeginningValueDom float(53) NULL
, USLongShort float(53) NULL
, UScashBucket float(53) NULL
, UScash float(53) NULL
, CashBucketBase float(53) NULL
, USCashBucketBase float(53) NULL
, BucketPercent float(53) NULL
, USBucketPercent float(53) NULL
, ExistsInPMSCashFlowsRpt CHAR(1) NULL
, ReportTitle VARCHAR(500) NULL

)

INSERT INTO #final EXEC QCRSAccountsWithCashBuckets_Global @APM = 'ALL'

I tried changing the table stucture for the VARCHAR fields by increasing the length but this made the command run for ever. I am told by the admin that there are some 1000 process running and he was going to kill them. Could it be the server itself that is causing this?

CREATE TABLE #final
(
Portfolio varchar(50) NULL
, APM varchar(5) NULL
, HedgeCurrency varchar(50) NULL
, BeginningValueBase float(53) NULL
, CashBucketAmount float(53) NULL
, CashBucketCurrency varchar(50) NULL
, EndingValueBase float(53) NULL
, BeginningValueUSD float(53) NULL
, EndingValueUSD float(53) NULL
, AccountNumberADP_DOM varchar(50) NULL
, EndingValueDom float(53) NULL
, BeginningValueDom float(53) NULL
, USLongShort float(53) NULL
, UScashBucket float(53) NULL
, UScash float(53) NULL
, CashBucketBase float(53) NULL
, USCashBucketBase float(53) NULL
, BucketPercent float(53) NULL
, USBucketPercent float(53) NULL
, ExistsInPMSCashFlowsRpt CHAR(1) NULL
, ReportTitle VARCHAR(1000) NULL

)

INSERT INTO #final EXEC QCRSAccountsWithCashBuckets_Global @APM = 'ALL'

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-18 : 16:32:51

SQL Server does not have version 12, so what platform are you using?

Is there a trigger on this table?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-18 : 16:41:46

quote:
Originally posted by tkizer

SQL Server does not have version 12, so what platform are you using?

Is there a trigger on this table?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

He is talking about SQL Server 2016

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2008-08-18 : 16:46:13

SQL Server 2016 allows keyboard-triggers, which fire every time you make a keystroke. But these will become obsolete when seat-based triggers are implemented in SQL Server 2018, which will fire every time you sit your ass down in the chair. Finally, we will be able to implement fully derriere-compliant database applications!

Boycott Beijing Olympics 2008

sqlnovice123
Constraint Violating Yak Guru

262 Posts

Posted - 2008-08-19 : 09:28:21

quote:
Originally posted by tkizer

SQL Server does not have version 12, so what platform are you using?

Is there a trigger on this table?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sqlnovice123
Constraint Violating Yak Guru

262 Posts

Posted - 2008-08-19 : 09:39:03

quote:
Originally posted by tkizer

SQL Server does not have version 12, so what platform are you using?

oops sorry version 8.x

Is there a trigger on this table? no trigger

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-19 : 09:49:43

Without knowing what QCRSAccountsWithCashBuckets_Global does its quite difficult to understand the reason. ANyways, your diagnosis is correct. its certainly because of some field being assigned a value that it cant hold.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources