Date/Time (old style) input value range

[yousuf_gani]

Hi,
We are Doing a Migration project from CMOD 8.4 to CMOD V9.5.0.1

I get a Small Problem with the Migration for the Field data type Changed from Date/Time  to Date/Time (old style)
for V8.4 in the
When the input Value in IND file : 19700101 00:00:00
Ingestion for the Date/Time Field is Success

for V9.5.0.1 in the
When the input Value in IND file  : 19700101 00:00:00
Ingestion for the Date/Time (old Style) Field is failed.
Error Message: Row 1:  The string "19700101 00:00:00" could not be converted to a date from the format of %Y%m%d %T

for v9.5.0.1 in the
When the Value : 19700101 01:00:00
Ingestion for the Date/Time (old Style) Field is Success but stored value is  : 19700101 00:00:00

Its strange Behaviour, can somebody faced the similar problem, how to fix it

Please do the needful help...

[Justin Derrick]

Sounds like you just need to tweak the .ind file to have a value that's non-zero.  Maybe do a search-and-replace in the index file inside your favourite text editor to change the timestamp to 00:00:01.

But really, the timestamp was just a placeholder for a lack of time at all.  You might want to consider updating your Application Group to the new timestamp format (since this is one of the only times you can make this change with almost no effort) and consider changing the value, since it's practically meaningless.

-JD.

[yousuf_gani]

Hi,

Thanks a lot for your reply..
First option changing IND File, we cant change as it was auto generated by the Feed Team everyday.

Your Second Option, How we can update the APPL Group field from "Date/Time(old style)" to "Date/Time", as i see from the admin Console to update the DATAType for the FIELD defined in Application group was disabled.
 
Is there any option to Update the APPL GROUP fileds dataype?

Please do the needful help...

Thanks
Mohd Yousuf gani

[Alessandro Perucchi]

My advice would be, since it was working before, and today not anymore, this is a regression.

I would open a PMR at IBM to report that problem.

[yousuf_gani]

Thanks Alessandro
We already opened a PMR today witht the IBM even

We see from the IBM site
http://www-01.ibm.com/support/docview.wss?uid=swg27036188

Valid Date Range for
Date/Time (old style) from :1970-01-01 00:00:00  to 2038-01-18 19:14:07

But it failed with the input value : 1970-01-01 00:00:00

We need to know its a behaviour/bug  with CMOD 9.5.0.1 version

Thanks a lot for all your support and Help, If you have any idea please let me know as i am trying the APPL GROUP UPDATE,  or else i will even wait for the PMR response from the IBM team.

[Justin Derrick]

First option changing IND File, we cant change as it was auto generated by the Feed Team everyday.

Your Second Option, How we can update the APPL Group field from "Date/Time(old style)" to "Date/Time", as i see from the admin Console to update the DATAType for the FIELD defined in Application group was disabled.

Ah.  I understood that you were doing a migration, not daily loads, so my advice about changing the date/time stamp really doesn't apply.

My next question is:  Why are you loading a field with the date 1970-01-01 00:00:00, when it's the year 2015?  I'm not really getting the purpose of storing that value. 

-JD.

[yousuf_gani]

Hi,

Feed Team send the File with HEADER + DATA , And they generate the IND file with entry for each Record in the Inputfile.
While generatating the IND file they populate the default DATE/TIME value as 1970-01-01 00:00:00 for the HEADER record, and valid date for the DATA from the file.

We have the problem as multiple (around 1000 Feed team) team send the Input feed with these format  as it was working with CMOD 8.4 version,
But after we migrtate to CMOD v9.5 this date value is not accepted for the "date/time (old style)" data type.

Our Concern is in the IBM Webpage: it was mentioned "Date/Time (old style)" range of input from :1970-01-01 00:00:00  to 2038-01-18 19:14:07

But its not working/accpeting,

how to solve this issue, is this a Bug or behaviour in CMOD v9.5? anybody encountered such problem before.

Thanks

[yousuf_gani]

I got the reply from IBM for the PMR i opened with them, it says as folows

"The date value is out of bounds if the Time Zone adjustment produces a 
value less than zero. It cannot be supported.  "                         
 ie
> export TZ=GMT+0                                                       
> arsdate -z -f "%Y%m%d %T" "19700101 00:00:00"                         
19700101 00:00:00       ->      0                                       
                                                                       
> export TZ=GMT-1                                                       
> arsdate -z -f "%Y%m%d %T" "19700101 00:00:00"                         
19700101 00:00:00       ->      -1


----------
For My Current Server , TZ is BST. But the arsdate return -1 as invalid date as follows
$ TZ='Europe/London'; export TZ
$ date
Wed Oct 21 12:29:17 BST 2015
$ arsdate -z -f "%Y%m%d %T" "19700101 00:00:00"
19700101 00:00:00       ->      -1

If TZ Changed to GMT+1 the date value return 3600
$ TZ='GMT+1'; export TZ
$ date
Wed Oct 21 10:39:24 GMT 2015
$ arsdate -z -f "%Y%m%d %T" "19700101 00:00:00"
19700101 00:00:00       ->      3600

So it menas CMOD not accepting the TZ Env-Variable value different from GMT like BST or EST?
Can anybody please to help me to understand this behaviour.

Thanks
Mohd Yousuf gani