Bug 1506201 – Osisoft translator - Cannot cast String to Float if value is negative

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1506201 - Osisoft translator - Cannot cast String to Float if value is negative

Summary:	Osisoft translator - Cannot cast String to Float if value is negative

Status:	CLOSED WONTFIX

Aliases:	None

Product:	JBoss Data Virtualization 6
Classification:	JBoss
Component:	Teiid, Documentation (Show other bugs)
Sub Component:
Version:	6.4.0
Hardware:	Unspecified Unspecified

Priority	high Severity high
Target Milestone:	GA
Target Release:	6.4.0
Assigned To:	David Le Sage
QA Contact:	Jan Stastny
Docs Contact:

URL:
Whiteboard:
Keywords:	Documentation

Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2017-10-25 07:47 EDT by Andrej Smigala
Modified:	2018-02-01 03:22 EST (History)
CC List:	8 users (show)

See Also:
Fixed In Version:
Doc Type:	Known Issue
Doc Text:	If you are using the OsiSoft translator and you attempt to cast a string containing a negative or zero value (such as '-24' or '0') to Float/Single, you will encounter an exception.
Story Points:	---
Clone Of:
Environment:
Last Closed:	2018-02-01 03:22:45 EST
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
JBoss Issue Tracker	TEIID-5123	Major	Resolved	Osisoft translator - Cannot cast String to Float if value is negative	2018-02-07 06:14 EST

Groups: None (edit)

Description Andrej Smigala 2017-10-25 07:47:00 EDT

Casting a string containing a negative value (e.g. '-24') to float fails with

> com.osisoft.rdsa.RdsaException: [PIOLEDBENT] Cannot convert -24 from String to Single.

This seems to be a bug in Osisoft PI SQL DAS (server-side not the JDBC driver), as connecting to the PI server using Osisoft's SQL Commander and running

> select cast(N'-24' as single)

results in the same error.

I think the best course of action would be to document this behaviour of the PI server as known issue and NOT work around it.

Comment 4 David Le Sage 2017-12-03 17:08:38 EST

Added to release notes errata as a known issue.

Note You need to log in before you can comment on or make changes to this bug.