LRCPAdmin

Data from a PI tag to DB2 using RDBMS

Discussion created by LRCPAdmin on Jan 23, 2013
Latest reply on Feb 5, 2013 by LRCPAdmin
I am trying to move some data from a PI tag to JDE (JD Edwards Enterprise 1).  I am running into an issue that the tag is refused.  Has anyone experienced this?


Here is the log.  I am not concerned with the truncation because the value length in the PI Point is the exact length of the field unless that is truly an error that PI can not deal with.


Wed Jan 23 13:30:54 2013 [DEB-1]: Point - TAPPI-ID-P2-SEND : SQL statement(s) : insert into F563730 (PI$TAP,PI$PIDTS) values(?,?);
Wed Jan 23 13:30:54 2013 [IFC-E]: SQLExecute> Point - TAPPI-ID-P2-SEND : doTrialExec() : [S][22001]: [IBM][System i Access ODBC Driver]Character data right truncation.
Wed Jan 23 13:30:54 2013 [IFC-E]: uni_dsol> Point - TAPPI-ID-P2-SEND : tag refused.

Outcomes