Siebel Date to NULL

, ,
1

Hi to all,

I have problem inserting null field (Brokerdate object) in DTYPE_DATE or DTYPE_DATETIME in Siebel 7.
The error message is “unable to insert, the date must be between January 1st 1753 and 31 december 4712”…
Any Idea?
Thx
Sylvain - s.heudes@vistali.com

2

Hi Sylvain,

we experienced a similar problem when we had Siebel Adapter ithout any patch installed. What happens is that when receive a null value the Siebel Adapter tries to set ‘30 November 0002’ . In our environment we did not received any error, but instead of writing a null value we write ‘30 November 0002’ .
This has been resolved installing patches.

Hope this helps

Raffaele

3

thanks for your kick answer!
What patch can correct this pb???
I nistalled the ESIE_4-2-1_SP3_WIN two month ago but I didn’t find any new patch?

take care
S./

4

Hi,
the Raffaele’s issues were solved in ADK 4.1.1, but it seems that you have the adapter version 4.2.1.

For this release in now available ESIE_4-2-1_SP4_WIN.exe and in the README you can read:

"7.0 Cautions and Warnings

When using the Broker Date API to construct a Broker Date object,
you must initialize the object with the full date and time in
order for the adapter to interpret it correctly.

For example, if you want to initialize the Broker Date object
using just a time, such as “04:15:45”, then you must initialize
it with both a date and time, with 01/01/1970 as the date, as
follows: “01/01/1970 04:15:45”.

If you want to initialize the Broker Date object using just a
date, such as “10/5/2001”, then you would have to initialize it
with both a date and time, as follows: “10/5/2001 00:00:00”."

Bye,
Nello