Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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
19:08, 22 Jun 2016

Tags

Classifications

Public