Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Database Performance Analyzer (DPA) > Data truncation error on Storage IO view

Data truncation error on Storage IO view

Overview

This article describes the issue when you select the Storage I/O view within an instance in DPA and you receive the following error:

Unable to generate the chart: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into #CONDATA1_TEMP…Data truncation; nested exception is java.sql.DataTruncation: Data truncation

 

Environment

All versions of DPA

Resolution

Run the following script to generate SQL to run against the repository schema within SQL Server.  This adjusts the column type to be BIGINT for the tables used to aggregate latencies in our temp table for chart generation.

Note: This will be permanently fixed in a later release.
 

Replace ignite. with the appropriate mapping for your repo schema.

DECLARE

 @DBNAME VARCHAR(100)

, @DBID VARCHAR(3)

, @SQL NVARCHAR(MAX)

 

--SET @DBNAME = 'JWALTERS-LT'

 

DECLARE cCursor CURSOR

FOR SELECT ID from ignite.COND

OPEN cCursor

       FETCH NEXT FROM cCursor INTO @DBID

 

WHILE @@FETCH_STATUS = 0

BEGIN

 

SELECT @DBID = ID FROM ignite.COND WHERE NAME = @DBNAME

 

 

SET @SQL = '

ALTER TABLE CON_IO_DAY_' + @DBID + ' ALTER COLUMN READ_LATENCY_SCORE BIGINT NOT NULL

ALTER TABLE CON_IO_DAY_' + @DBID + ' ALTER COLUMN WRITE_LATENCY_SCORE BIGINT NOT NULL

'

print @SQL

 

FETCH NEXT FROM cCursor INTO @DBID

END

 

CLOSE cCURSOR

DEALLOCATE cCURSOR

 

Last modified

Tags

Classifications

Public