Skip to Content
0

PCo: using timestamps in an ODBC destination

Apr 24, 2017 at 07:15 AM

66

avatar image

Hi there

I've defined an ODBC destination as per SAP Help. Table PDCODB contains a field called ITIMESTAMP of type DATETIME2:

In my agent, I have created a notification with an output expression using function DATENOW of type System.DateTime:

I then did the assignment in the destination mapping:

However, all timestamps appear as 01.01.0001 00:00:00 in table PCODB. When I test the message delivery, I can see the correct timestamp (e.g. [CDATA[2017-04-21T14:34:49]]) in the XML message. Yet, it does not get written into table PCODB for some reason.

Are SQL type DATETIME2 and PCo type System.DateTime perhaps compatible? Do I need to do a conversion?

Thanks & regards
Jan

pco-odbc.jpg (33.6 kB)
pco-output.jpg (29.3 kB)
pco-mapping.jpg (29.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jan Buchmann May 09, 2017 at 06:26 AM
0

FYI

This appears to be a problem only when doing 'Test Notification Delivery'. Otherwise the DB record as well as the XML file get created with the correct time stamp.

Share
10 |10000 characters needed characters left characters exceeded
Jan Buchmann May 09, 2017 at 06:35 AM
0

FYI

This appears to be a problem only when doing 'Test Notification Delivery'. Otherwise the DB record as well as the XML file get created with the correct time stamp.

Share
10 |10000 characters needed characters left characters exceeded