Aphelion root.lde.id is corrupted - repairable?

[crosato]

Just as a background, this is my personal dev environment (v9.1m020) that I have setup on my laptop. It was all installed about 2 weeks ago, and was working fine until Monday. All of a sudden Tomcat was not starting up entirely and therefore the MS would not start at all. When I start up Tomcat I consistently get this error:

SEVERE: Servlet /Windchill threw load() exception
javax.servlet.ServletException: com.infoengine.exception.adapter.IEAdapterException; nested exception is:
javax.naming.CommunicationException: <my_machine_name>:<my_port_num> [Root exception is java.net.ConnectException: Connection refused: connect]
at com.infoengine.IeServlet.init(IeServlet.java:179)

One of our admins helped me out and mentioned that it appeared Aphelion wasn't running, and asked if the service was running and if I had an lde.exe processing going. I mentioned I had 3 aphelion services that are started, and their subsequent processes:
Aphelion Administration (MHADminServerMGr)
Aphelion Drive Mapping (MHMapDriveServerMgr)
Aphelion Services (MHServerMgr)
But didn’t see lde.exe in my running processes. We then checked the Aphelion logs, and in .general I noticed this:

2010/03/15 09:48:49.281-0400 E (9ebb5511/1808/0/0/0) loadIDmap - File /usr/var/lde/PTCLdap/PTCLdap_database/root.lde.id is corrupted
2010/03/15 09:48:49.281-0400 D65535 (9ebb5511/1808/0/0/0) deleteBlockMap: readers=0, writers=1
2010/03/15 09:48:49.281-0400 D65535 (9ebb5511/1808/0/0/0) dbFileOpen: Error loading IDmap, file: /usr/var/lde/PTCLdap/PTCLdap_database/root.lde.db.
2010/03/15 09:48:50.093-0400 D65535 (9ebb5511/1808/0/0/0) lde failed opening backends

Looks like it started happening on the 15th, which makes sense since it seems like it worked fine until Monday. I don’t know what caused it to go corrupt though…

I started reading through the ref docs, and searched the knowledge base, but can't seem to find anything. I'm wondering if there is a way to repair this file? I did not know about taking an export of the ldap, so no go with that.I tried seeing if I could just reinstall, but it doesn't like that. The directory server admin guide (m040) mentions uninstalling aphelion, but that's with the windchill dir server. Is there any issue with just uninstalling and then reinstalling aphelion?

Any other ideas?

[achukwuka]

Chris,

Since this is a dev environment, I would just uninstall and reinstall Aphelion. To uninstall Aphelion go the directory C:\<aphelion load=" point=">\UninstallerData. You will see the Uninstall_aphelion.exe script, use that to unistall it. This way it is cleaner, then try to reinstall it. If you can try to back up your entire root.ldif if it will let you, before you do the uninstall.

HTH


Alexius C. Chukwuka
IT Analyst, PDP Systems
John Deere Power Systems
Product Engineering Center
*Voice: 319-292-8575
*Mobile: 319-429-5336
*FaxFax:319-292-6282
*E-Mail: -

CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail.

[crosato]

Thanks Alexius...

I actually had an issue even exporting the DB to create a root.ldif, so I ended up reinstalling everything. I moved WC/Apache/Tomcat to a seperate directory, uninstalled Aphelion, and then just reinstalled it all.I'm able to get it in and all that, but now my wcadmin userid is not in the Admin group for some reason. This basically means I'm relegated to doing nothing, on the install. I can't see the Org or Site tab to do any admin functions, and can't even view a Lib that is still in the DB. Basically when the MS starts up, certain things don't start correctly because admin doens't have privileges to Site/System:

main: ERROR : wt.access.evaluation.report - "Administrator" does not have Modify permission for "Schedule Queue - CleanUpScheduleQueue" in Administrative Domain "Site /System".
main: (wt.access.accessResource/19) wt.access.NotAuthorizedException: ATTENTION: Secured Action. You do not have the necessary authorization for this operation. Contact your administrator if you believe you have received this message in error
main: at wt.access.StandardAccessControlManager.checkAccess(StandardAccessControlManager.java:419)

if I try to view the Lib it outputs:

wt.access.evaluation.report - "Administrator" does not have Read permission for "Library - Test Library" in Administrative Domain "Site, Organization - *******/System".

I have a call open with PTC, which I opened right after I posted this thread, but I'm exploring all avenues at this point, since it's totally stopped by ability to develop anything right now.

Anybody have any clues as to how to insert wcadmin back into the Site Admin domain?

In Reply to Alexius Chukwuka:

Chris,

Since this is a dev environment, I would just uninstall and reinstall Aphelion. To uninstall Aphelion go the directory C:\<aphelion load=" point=">\UninstallerData. You will see the Uninstall_aphelion.exe script, use that to unistall it. This way it is cleaner, then try to reinstall it. If you can try to back up your entire root.ldif if it will let you, before you do the uninstall.

HTH

[achukwuka]

Chris,

In your wt.properties files check the userid values of the below property. This should tell you if wcadmin is a site admin.


wt.sysadm.administrators

Ideally the values of this property should be Administrator,wcadmin.

Thanks

Alexius C. Chukwuka
IT Analyst, PDP Systems
John Deere Power Systems
Product Engineering Center
*Voice: 319-292-8575
*Mobile: 319-429-5336
*FaxFax:319-292-6282
*E-Mail: -

CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail.



-----End Original Message-----

[crosato]

It was not set to those values at first, it was actually set to $(wt.admin.defaultAdministratorName). I did go through and update the property and propogate the changes to be set to 'Administrator, wcadmin', but it just kicked back the exact same MS error.

Thanks
Chris

[achukwuka]

Chris,

Can you alos check the below properties? The settign in my environment are below.


wt.admin.defaultAdministratorName=Administrator

wt.federation.org.defaultAdminDirectoryUser=$(wt.admin.defaultAdministratorName)

wt.sysadm.administrators=Administrator,wcadmin

Thanks

Alexius C. Chukwuka
IT Analyst, PDP Systems
John Deere Power Systems
Product Engineering Center
*Voice: 319-292-8575
*Mobile: 319-429-5336
*FaxFax:319-292-6282
*E-Mail: -

CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail.

[ddemay]

Administrator is full name of the uid wcadmin. Make sure both are present in the wt.properties. That property is for command line. However what is really going on is the fresh aphelion install is missing an administrators group or the wcadmin is not a member. With write access to your directory server add one or both. If wcadmin as user doesn't exist add that also.

The database has a table called remoteobjectinfo to lookup the original dn (distinguished name) for all three. Write these down.

Some on here might be able to export an ldif with just these entries and you can edit them to match your dn's in the db.

Or create them from scratch by inserting the correct things and editing attribute values.

The query for the db table I mentioned will be much easier if you can browse in gui vs command line. The dns will show up so you don't anything fancy in query except where nameofcolumn like '%wcadmin%'

And do the others for admin groups. You'll be on your way.
15 minute fix if you are comfy trying it.


David DeMay







Sent from my Verizon Wireless BlackBerry

[crosato]

All that I had in there was uid=wcadmin. I created the Administrators and added wcadmin as a uniqueMember and it started up just fine. Thanks for all the help...

Thanks
Chris

[patrick.chin1]

My best advice to anyone who install Windchill is to stop using Windows OS. We did a few on a few (over 5 machines and also 3 laptops). All installs were producing errors after 2-3 weeks of java.io.exception missing classes and aphelion dying also. We did mirror/rehost of productions on windows and it worked for a couple of weeks then we had really bad performance issues. That's when we started looking at Red Hat Linux. This was back in 2008 on Windchill 9.0. and 9.1 for the upgrade. One major reason why at Psion, we did not go into production on an HP-UX itanium because the Aphelion was not supported on this OS. Red Hat was the savior of the day.

Windows just can't take the long class paths and the aphelion data file can get huge which can easily corrupt on Windows box. I hope you have done your due diligence in performing exports everyday and backups of everything for disaster recovery.

After a clean install, you should backup/copy everything to recover for an OOTB install. All you have to do after that is import your backup.

Good luck.