Proxy to JDBC synchronous interface issue.

[Former Member]

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

[RaghuVamseedhar · Accepted solution]

Shaibayan,

Please down the response XML on to desktop and open it with Notepad++. Let us know, if still spaces are missing.

FYI. Browsers (IE, Chrome...) and Moni hide spaces.

[Former Member · Accepted solution]

Yes Raghu.

There are some spaces at times but not in all the cases. However in the database for all the records no space is maintained in the begining.

Regards,

Shaibayan

[former_member182412 · Accepted solution]

Hi Shaibayan,

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

Regards,

Praveen.