Hi
While running column analysis on one of the tables, I am getting below error.
pxbridge,0: ?? (IIS-CONN-DAAPI-000045; Can not convert to framework type timestamp; CC_PXAccessor; setCalendar; CC_PXAccessor.cpp; 3883)
Column analysis on other tables in the same schema runs fine.
Thanks
Dsedi
pxbridge error duing Column Analysis
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is this the only table that contains a date/time/timestamp column?
There are other tables which do have data/timestamp columns and they did fine. It is only with this one column.
Does the problem happen every run, or only once?
Yes, I tried running it atleast 3 times. Everytime it failed with same error.
Thanks
There are other tables which do have data/timestamp columns and they did fine. It is only with this one column.
Does the problem happen every run, or only once?
Yes, I tried running it atleast 3 times. Everytime it failed with same error.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The message is telling us that there is something about that particular timestamp that precludes its being converted to DataStage internal format. Are there any differences in this particular timestamp compared to the others - for example order of components, separator characters, fractional seconds?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.