Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1506201

Summary:	Osisoft translator - Cannot cast String to Float if value is negative
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Andrej Smigala <asmigala>
Component:	Teiid, Documentation	Assignee:	David Le Sage <dlesage>
Status:	CLOSED WONTFIX	QA Contact:	Jan Stastny <jstastny>
Severity:	high	Docs Contact:
Priority:	high
Version:	6.4.0	CC:	blafond, dlesage, drieden, gjospin, jolee, jschatte, thauser, vhalbert
Target Milestone:	GA	Keywords:	Documentation
Target Release:	6.4.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
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 08:22:45 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Andrej Smigala 2017-10-25 11:47:00 UTC

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 22:08:38 UTC

Added to release notes errata as a known issue.