Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Archive > 2017December14 - Deletes > 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