Page 1 of 1

pxbridge error duing Column Analysis

Posted: Fri Jan 30, 2009 2:56 pm
by dsedi
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

Posted: Fri Jan 30, 2009 9:03 pm
by ray.wurlod
Is this the only table that contains a date/time/timestamp column? Does the problem happen every run, or only once?

Posted: Mon Feb 02, 2009 10:14 am
by dsedi
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

Posted: Mon Feb 02, 2009 2:54 pm
by ray.wurlod
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?