cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

SQL Excpetion in using WTPartUsageLink

ptc-2217063
1-Newbie

SQL Excpetion in using WTPartUsageLink

Hello,

We have couple of modelled object (say Model1, Model2) which are extended from WTPart & also few soft types of WTPart.(say Soft 1, Soft 2 etc)

We tried to build a structure between Model1 & Model2 using WTPartUsageLink & also build a structrure between Soft1 & Model2 using the same WTPartUsageLink. Infact we used the standard Edit Bill of Material to build this structure.Windchill doesn't throw any error while building this structure.

When we tried to view the 'Where used' on Model2, its giving an database error

Nested exception is: java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got BLOB

This issue doen't occur when the Model2 is linked only to Model1 or only to Soft 1 types. Issue comes only when it is linked to 2 different types. Is it bug with Windchill Data Model or we not supposed to implement this way?

Thanks in Advance,

Regards,

P.Karthick

0 REPLIES 0
Top Tags