Skip to main content
G
gwalker1-Visitor
1-Visitor
March 29, 2011
Question

Cannot retrieve family table neutral data and SQL Server database

  • March 29, 2011
  • 4 replies
  • 1357 views

We have encountered the dreaded "Cannot retrieve family table neutral data" problem with one of the parts in our database (see https://www.ptc.com/appserver/cs/view/solution.jsp?n=kA1A00000000IUzKAM).


I contacted PTC about this back in February and for some reason they have been unable to provide healing scripts that will run on our SQL Server database to fix the problem. They first sent what were obviously Oracle scripts that didn't work.


Has anyone with a SQL Server database received scripts to correct this issue? Are the scripts customized to your installation? If not, would you mind sharing the scripts?


Thanks.


PDMLink 9.1 M040 with MS SQL Server 2005


4 replies

P
pcnelson1-Visitor
1-Visitor
August 9, 2013

Bumping this up since I also could not find SQL related info on this, only Oracle. Have a call into PTC Tech Support and I will post an update here on results so others may be helped too.

S
SteveVinyard1-Visitor
1-Visitor
August 9, 2013
Hi Pete, I saw a lot of this on the 8 to 9 Migrations. There were copious amounts of WinDU scripting to fix these. If the upgrade was done without this, then you will see some of this stuff even when updated further until it got cleaned up.

Also, I saw this same error once we removed some CAD Document (EPMDocument) attributes in WC10. Removing these attributes screwed up the family tables but PTC provided scripting to get it fixed.

[cid:image001.gif@01CE9505.F0A95F50]

Steve Vinyard
Senior Solution Architect
B
byork17-Peridot
17-Peridot
August 10, 2013
Pete,

We have the same problem. We have been working with support for about a month to fix this. Hope yours goes better. The good news is that I think we are about there. Depending what errors are found with WinDU they have a couple of scripts to clean it up. We are using WC10 M040.

Brian
P
pcnelson1-Visitor
1-Visitor
August 10, 2013

Steve, ours was a 3.4 to 10.0 migration. PTC asked for some reports to determine what scripting is needed. I read somewhere else that removing attribute values in a family table could also be a cause. I dont know why someone would want to do that, but who knows. Thanks for the input!

Terms & ConditionsCookie settingsAccessibility statement