Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Proxy to JDBC synchronous interface issue.

Hi All,

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?

Thanks,

Shaibayan

Tags:
Former Member replied

Hi Shaibayan,

May be the field saved with some special characters in the database. Check with your DB.

Regards,

Praveen.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question