Timestamp issue when using Pivot Stage

Sandeepch19 · Post by **Sandeepch19** » Thu Dec 10, 2015 3:59 am

I am converting rows into columns so am using pivot stage. But while doing that am getting below warning for timestamp field. When I run the job without Pivot stage am not getting this warning. So it is something to do with Pivot stage. Can anyone give an advise as to how this warning could be resolved.

Warning is as below.
Data string '00:00:00' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': the value for tag %yyyy has fewer characters than expected.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 10, 2015 4:31 am

You're passing it a time (00:00:00) rather than a timestamp.

Sandeepch19 · Post by **Sandeepch19** » Thu Dec 10, 2015 6:33 am

Yes I am passing the values as date:00:00:00.000

qt_ky · Post by **qt_ky** » Thu Dec 10, 2015 7:13 am

Sandeepch19 wrote:Warning is as below.
Data string '00:00:00'

According to the quoted warning, you only passed the time part.

Sandeepch19 · Post by **Sandeepch19** » Thu Dec 10, 2015 7:24 am

When I checked in google I came across one solution where we need to update some patch because there is an issue with Pivot Stage in handling TimeStamp.

chulett · Post by **chulett** » Thu Dec 10, 2015 8:07 am

So check with support.

Sandeepch19 · Post by **Sandeepch19** » Thu Dec 10, 2015 9:09 am

Do we have any other resolution apart from doing patch update?

chulett · Post by **chulett** » Thu Dec 10, 2015 10:07 am

Fix your issue? You may think you are appending that zero time to a date but the error message says you are not, so I would ensure your dates are always valid before you add the time as all it takes is one bad apple to cause that message.

If you are sure everything you are doing is fine, contact support and see if there is even such a patch.

Sandeepch19 · Post by **Sandeepch19** » Thu Dec 10, 2015 12:24 pm

Thank Craig.. Its not that i think but i am appending 0's . Isvalid function is also used to check the validity of the data. anyone faced this kind of issue earlier and resolved it?.

chulett · Post by **chulett** » Thu Dec 10, 2015 1:10 pm

I know you are appending zeroes, the 'think' part was as to the validity of the date as in are you appending them to a valid date? We'd need to see your "IsValid" logic to check out that part of the puzzle...

Sandeepch19 · Post by **Sandeepch19** » Fri Dec 11, 2015 9:49 am

My Date Validation Logic is like this

Code: Select all

If INDATE <> ""  Then
  If IsValid('Date', INDATE[1,4] : "-" : INDATE[5,2] : "-" : INDATE[7,2]) = 1 Then
     StringToDate(INDATE,"%yyyy%mm%dd")
  Else SetNull()
Else SetNull()

DSXchange

Timestamp issue when using Pivot Stage

Timestamp issue when using Pivot Stage

Re: Timestamp issue when using Pivot Stage

Re: Timestamp issue when using Pivot Stage