Hello Team,
I am facing issue in fetching the values from Oracle database.
Values are getting round off while integrating oracle database to ignition.
Value in Oracle database of sample column: 1.0008
Value in Ignition database of sample Column: 1.001
kindly help us to rectify this issue and please elaborate the root cause and related settings/configuration required.
Thanks and Regards,
Mohan Raikwar
9340723404
How do you integrate Oracle Database to Ignition, through a named query? the round off happens before or after you put the data on a component?
Hi,
Thanks for response, oracle database is connected in gateway. In database connections through required drivers.
who’s URL description is like:
The format of the Oracle connect URL is:jdbc:oracle:thin:@host:port:SID
With the three parameters (in bold)
And it is rounding off after decimal value. the main data in database is up to 4 digit after decimal but in ignition when i am checking through database management tool. It is showing up to three decimal values only.
You can connect me also on whatsapp or direct call on my number.
Thanks and Regards,
Mohan Raikwar
+91 9340723404
Please see "Don't sign your posts" in the "Keep it tidy" section of FAQ - Inductive Automation Forum. Your name is automatically shown in every post. Put contact information in your user profile - if it's appropriate.
Please also keep discussion on the forum so that everyone benefits.
This happen to me also and is fine on my case , but I´m not sure how could you fix it.
a workaround would be pass the values 1,2437 to 12,437 on a new oracle table, call that table from Ignition and then restore the value to 1,2437. I can´t think of other solution now.
The default number format is to three digits. Add column data to your table and adjust the number format.
