Gigibin - Thursday, February 10, 2011 9:15 AM:
Hello ppl,
I'm a little bit new into Aras and just starting to learn, because i need it for my work. Today i get a problem that never occures before, and after a lot of search for solution i didi't find so i decide to post here.
My problem is that i cannot delete Item Type, i create a new Itemtype without adding any other properties. (Just trying to make multiple relationship) and than i was unable to delete it there is the error that pumps up:
"Invalid column name 'SOURCE_ID'. Invalid column name 'RELATED_ID'. Invalid column name 'SOURCE_ID'. Invalid column name 'RELATED_ID'.Invalid column name 'SOURCE_ID'. Invalid column name 'RELATED_ID'. Invalid column name 'SOURCE_ID'. Invalid column name 'RELATED_ID'."
It's already happen to 3-4 ItemTypes that i create so rightnow i'm a little bit scary to make new ones.. it doesent metter is they are singel poly federated or relationship.
Please Help!
P.S. sorry for my bad english :)
RobMcAveney - Thursday, February 10, 2011 10:15 AM:
I also had this error recently. I had been experimenting with relationships and somehow created a new RelationshipType that had no Source ItemType, then converted the relationship ItemType to a PolyItem. This resulted in a View in the database that did not have source_id or related_id columns. It's a bug that will have to get fixed in a future version. The only way I was able to work around it was to go into the database and manipulate the View. I'll be happy to give you instructions on how to do that, but please confirm that it is the same issue before I give you SQL code that may mess up your database worse. To confirm it, go to RelationshipsTypes on the TOC, set the search mode to Advanced Search and search for items whose Source ItemType is null. In a normal database there should be three: Desktop, LockedItems and Workflow. If you have another one, that is probably the culprit. Click on the link to the Relationship ItemType and confirm that it is a PolyItem. Let me know what you find.
authentic - Monday, August 15, 2011 3:54 AM:
fvdgTiger3:
A woman has all the right to be nice to herself. Thus, the Christian Louboutin Boots come into the spotlight. Any lady should make herself comfortable and happy and buy all that she wants with her hardearned money. Thus, she should get herself a pair of Christian Louboutin Pumps to wear to the parties. This may be least she could do for herself, making herself sparkle and bright and beautiful.The Christian Louboutin Canada is a wonderfal maker of women shoes. He knows the needs of ladies and thus, knowing the right shoes that ladies would love. The Christian Louboutin Peep Toe is a good choice to wear on the hot summer evenings. Christian Louboutin Bridal will help make your leg long and slender and sexy, attracing the eyeballs of all those around you and getting those envious eyes of your fellow ladies, making you the pretiest bride ever. So what are you waiting for? The Christian Louboutin Sale provides you with a wide variety of wonderful Christian Louboutin Slingbacks and Christian Louboutin Sandals for you to choose from. Not to forget there is also Christian Louboutin Mens for the men. You are sure to be able to find your dream Christian Louboutin Wedges here.
Gigibin - Tuesday, February 22, 2011 8:54 AM:
Hi, Rob McAveney,
Sorry for my late response but my office is changeing place so i did't get Acsses to my work. I done what you tell me to do and yep i have 3 more item Types, i see if they are PolyItems and they all are, 2 of them are read only, third (he is a copy of one of the others, that i make by mistake isn't) Please send me next instructions how to do with it.
But i looked now and i have 2 more ItemTypes (SingleItems) with same error, but they aren't relationships one of them is again only Read - Only.. :S
Thanks!
Gigibin - Monday, March 21, 2011 6:14 AM:
Anyone can help me, it's really important. :(
