pxbridge error duing Column Analysis

dsedi · Post by **dsedi** » Fri Jan 30, 2009 2:56 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Jan 30, 2009 9:03 pm

Is this the only table that contains a date/time/timestamp column? Does the problem happen every run, or only once?

dsedi · Post by **dsedi** » Mon Feb 02, 2009 10:14 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Feb 02, 2009 2:54 pm

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?