Sender JDBC does not select date values from DB system

[former_member288713]

Hi Experts,

Good Day....

Actually I am working on a interface as direction is JDBC to JDBC, My issue is sender JDBC is not picking date values from DB.

for example.

Sender payload structure has10 fields and 2 fields are date fields in that structure.

when I test the scenario, Data from DB being picked up by PI(JDBC) but date values are not included on XML where DB has date values in it.

please let me know your thoughts if any one come across the same issue.

Note: this interface have been working fine at earlier testing and we encounter the issue after we have been updated PI 7.4 by support pack.

Thanks,

Srinivas.

[iaki_vila]

Hi Srnivas,

If in a previous version worked, the problem must be in the driver deployed. Check with your basis team that the driver is compatible with PI 7.4 jvm.

Regards.

[former_member288713]

Hi Vila,

Thanks for you response, I will check with my BASIS team.

Thanks,

Srinivas.

[former_member233209]

Hi Srinivas,

I faced same issue when I upgraded my SP to SP13.

After maintaining DATETIME datatype at database table issue was resolved.

Regards,

Ajinkya

[former_member288713]

Hi Ajinkya,

Thanks for your response, I will check with my DB team.

Thanks,

Srinivas

[former_member288713]

HI Ajinkya,

I have checked with DB team too, they have said that they maintained date format for the date fields and format is yyyy-MM-dd.

when I check with DB team, the also said that all records have the date values, but those information I could not seen on sender payload.

Thanks,

Srinivas

[former_member233209]

Hi Srinivas,

Ask DB Team to change data type from DATE to DATETIME for respective date fields.

Date format is not issue, data type is issue.

Please check, I hope it will work.

Regards,

Ajinkya

[former_member288713]

Hi Ajinkya,

Thanks for your response,

I will check with my team as per your suggestion.

Thanks,

Srinivas