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
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid, Documentation
Version: 6.4.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: GA
: 6.4.0
Assignee: David Le Sage
QA Contact: Jan Stastny
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-10-25 11:47 UTC by Andrej Smigala
Modified: 2018-02-01 08:22 UTC (History)
8 users (show)

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.
Clone Of:
Environment:
Last Closed: 2018-02-01 08:22:45 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-5123 0 Major Resolved Osisoft translator - Cannot cast String to Float if value is negative 2018-02-07 11:14:26 UTC

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.
Note You need to log in before you can comment on or make changes to this bug.