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

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

Unable to start method server after migrating from Oracle to SQL Server on Windchill 10.0 M010

kalidhas
1-Newbie

Unable to start method server after migrating from Oracle to SQL Server on Windchill 10.0 M010

Unable to start method server after migrating from Oracle to SQL Server. Error

1 REPLY 1

Kalidhas,

It looks like you have a disconnected principal preventing the MethodServer
from starting. It must be the Administrators group that is disconnected as
any other group probably wouldn't prevent it from starting. To compare the
group in the database to the group in your ldap, execute this query in the
SQL Server Management Studio...

select remoteObjectId from RemoteObjectId where remoteObjectId like
'%Administrators%';

This will give you the distinguished name that is stored in the db for this
group. Compare this to the location of the group in your ldap.

I this is right, you can also take a look at the WTGroup itself to see if
the repairNeeded flag was tripped.

select repairNeeded from WTGroup where idA2A2=15;

If this returns a value of 1, you could try to set it back to 0...

update WTGroup set repairNeeded=0 where idA2A2=15;

Of course, there may be some other issue that is triggering this group to
become disconnected. If that's the case, it will just disconnect again.
If that happens, you need to call PTC support for help.

Regards,
Bill



Top Tags