Home  > Collaboration > Discussion Forum > Active Discussions

Welcome to the COE Discussion Forum! 

 

To participate in the discussion forum, you must be logged in to the website.  If you forget your login information, please contact COE Headquarters at coe@coe.org or (800) 263-2255.

If you are new to the COE Discussion Forum and would like to participate, please register.
Register Today
COE 2009 Annual PLM Conference & TechniFair

COE DISCUSSION FORUM
Forums > COE Forums > SmarTeam
Subject: Error No: 00050

You are not authorized to post a reply.   
Author Messages
ASD-AAC

18 Nov 2008 05:10 AM

Hi !

When i start a new process  in the SmartBox, show the message:

" Error No:00050  The link between objects 'pis073508' and 'start' already exist in the system". "

and OK to closed window.

Please, help me !

Thanks !

Luiz Claudio
bwfisher

17 Dec 2008 04:04 PM
Hello Luiz,

I don't have a definite solution, but I did find Technote Reference #: 1204558 for
Error N0: 00050 when adding a user to workflow

The Technote can be found on the IBM PLM Technical Support main web page at URL http://www.ibm.com/software/applications/plm/support/

Please note that this was for a problem in SmarTeam V5R12 (2004), so
caution should be taken while investigating. SmarTeam has had a lot of
major changes since this release.


The following is from the Technote.
************************************************************************
Problem
Error N0: 00050 when adding a user to workflow

Scenario:
Error No: 00050 the link between objects "Drawing Change' and
garellano ' already exists in the system.
I get this error whenever I go to the next node in the workflow
and try to assign the user for that node. I right-click on the
node, select Users, specify the user, then click OK that s when I get
the message above. I thought that I might be entering the user twice,
but I have double-checked using a different user and have gotten the same result.
Error No: 01522
No executors are assigned to nodes 'Drawing Change'.
After clicking OK to the first error, I tried to continue with
the Accept process. Since I already had a user specified, I
thought I would go ahead and try to Accept the Project forward.
I clicked on the Accept button, and then selected Comment
before sending response. This seemed to work alright because
the Comment dialog appeared and allowed me to enter my comment.
However, when I clicked the Send button, I got the error above
and the Project did not move in the workflow.
Error No 00055
The item already exists in the system. Adding item '09 FLD-004077
1 AS 00' caused a duplicate value error in 'Folder'.
When adding a new Folder to the technicians Document Tree, the
error above was encountered. After getting the error, I tried to
create new Folders (to ensure several new SmarTeam numbers were
assigned), all with the same result.

**** Resolution ********
It was determined that the customer had problems with the Max Object ID
for the major classes in their SmarTeam pre-production environment. For
multi-site it was demonstrated that the Max Object ID is the combination
of a base plus a reference number. As the customer walked through, one
class at a time, the functionality returned to the application.

Three issues were fixed directly in the WebEx:
1 - inability to add a new Document
2 - inability to create a link for the new Document created
3 - inability to add/assign a recipient in a work flow
It is suspected that the root cause of the problem was in the merge when
the customer went from three sites down to two. Objects were merged
with blocks of IDs into an existing site and that may have corrupted the
database. Note that initially, ran the FixLastObjectID tool to
correct such errors. This tool may not handle multi-site environments
correctly.

Work around:
1. Bring up Oracle Enterprise Manager and logon to the database in
question with DBA privileges.
2. Open a SQL Plus Worksheet from the "Tools-Database Tools" menu.
3. Connect to the database as a SmarTeam user.
4. Query for MAX(Object ID) from TN DOCUMENTATION
== MAX(Object ID) is returned (ie- 536870936)
5. Determine the class ID for the class having the problem
Select Class ID from TDN CLASS where table name like
'TN DOCUMENTATION;
== Class ID is returned (ie- 5)
6. Determine the object ID for the "last object ID used" corresponding
to the class in question. This is the reference number for the
site database in question.
Select Object ID from TDM LAST OBJECT ID where Class ID = 5;
== Object ID is returned (ie- 23)
7. Increment the "last object ID used" (reference) to a number higher
such that Range BASE + Last Object Used > Max Object ID.
Update TDM LAST OBJECT ID Set Object ID = 30 where Class ID = 5;
8. Commit the update.
9. Test the results.
Repeat this for all tables that have gotten out of synch.
For all sites, you should get the same base number if replication is
working (even though all tables don't actually replicate):
Select Count* from TN DOCUMENTATION
For the problem with linking objects, the table was "TN LINK 00006"
The last object ID for "Root Object Class" may also need to be updated.
1. Determine the class ID for the Root Class.
Select * from TDM CLASS where Class Name like '%Root%';
== Class ID is returned (ie- 16386)
2. Determine the max object ID for the root class
Select MAX(Object ID) from ROOT OBJECTS;
3. Determine the Object ID for the Last Object ID Used corresponding to
the Root Class.
Select Object ID from TDM LAST OBJECT ID where Class ID = 16386;
== Object ID is returned for last object used (ie- 10)
4. Increment the last object ID used to avoid conflict.
Update TDM LAST OBJECT ID set Object ID = 12 where Class ID = 16386;
5. Commit the update.
6. Test the results.
---------
I applied it but still have Object Id issues with the second site.
We found that the second site was listed as inactive in the
TDM DB Site table even though when you look at the databases using
Smarteam's DB Site Manager utility both sites were active. We changed
the TDM IS Active field on the TDM DB Site table to the active
indicator (-1) see if that would fix our problem. I did some testing on
Friday and it looks like things are working OK as far as the last
object ID problem is concerned.
************************************************************************



The point to consider here is, this could be a corruption in the
database. As such, a qualified DBA may be needed.
And remember to always backup the database before making changes.

Hopefully this helps in your investigation.


Barry Fisher
IBM PLM Technical Support Americas
You are not authorized to post a reply.
Forums > COE Forums > SmarTeam > Error No: 00050


ActiveForums 3.6

    

401 North Michigan Avenue, Chicago, IL 60611-4267 | (312) 321-5153 | (800) COE-CALL (U.S.)