Proxy to JDBC synchronous interface issue.
We have a synchronous interface. A proxy is triggered from ECC with a from date and to date and this is sent with a query to a DB.
Now according to the query which is a simple SELECT query SELECT field1,field2,field3 FROM View WHERE RECORD_LAST_ACTIVITY_PERFORMED > TO_DATE('20150219064710', 'YYYYMMDDHH24MISS')AND RECORD_LAST_ACTIVITY_PERFORMED <= TO_DATE('20150219111810', 'YYYYMMDDHH24MISS')
This fetches the 3 fields in the response. But one particular field behaves in a very peculiar manner. When t is added to the field in the DB i.e. say t12345 is added in the DB it comes to PI as 12345. Also at times an extra blank space is coming. The source code also has 2 extra blanks in it.
Does anyone have any clue on this?
Is there any XI setting which is causing this?
May be the field saved with some special characters in the database. Check with your DB.