Hello,
I’m using the webMethods Portal 6.5.2.0.82, it was workign fine until a couple of days ago when out of no where some pdps got uninstalled ! Here’s what I found in the log file
2009-02-24 19:13:10 GMT (Framework : INFO) [RID:3159] - :::: org.apache.struts.action.LOCALE --> fr
2009-02-24 19:13:10 GMT (Framework : INFO) [RID:3159] - :::: formulaire is instance of ME020Bean ::::
2009-02-24 19:13:10 GMT (Framework : DEBUG) - Computed dependencies for component: wm_popchart.pdp
2009-02-24 19:13:10 GMT (Framework : DEBUG) -
2009-02-24 19:13:10 GMT (Framework : INFO) - UNINSTALL DONE: wm_popchart.pdp
2009-02-24 19:13:10 GMT (Framework : DEBUG) - Items left to uninstall: 327
2009-02-24 19:13:10 GMT (Framework : INFO) - UNINSTALLING: TT_role_driving.cdp
2009-02-24 19:13:10 GMT (Framework : DEBUG) - Computed dependencies for component: TT_role_driving.cdp
2009-02-24 19:13:10 GMT (Framework : DEBUG) - dep[0]=wm_ntlmauthadmin.pdp
dep[1]=wm_xt_ldapqueryprovider
dep[2]=wm_basicAuth.cdp
dep[3]=wm_formsAuth.cdp
dep[4]=wm_anonAuth.cdp
dep[5]=wm_xt_role
2009-02-24 19:13:10 GMT (Framework : DEBUG) - Set user path locator: [protocol, root] [deploytemp:/, /opt/webmethods/Mportal/Portal/server/TTPortal/temp/temp_816307867/]
2009-02-24 19:13:10 GMT (Framework : DEBUG) - Unset user path locator: [protocol] [deploytemp:/]
2009-02-24 19:13:10 GMT (Framework : INFO) - UNINSTALL DONE: TT_role_driving.cdp
2009-02-24 19:13:10 GMT (Framework : DEBUG) - Items left to uninstall: 326
2009-02-24 19:13:10 GMT (Framework : INFO) - UNINSTALLING: wm_ldapattributes.pdp
2009-02-24 19:13:10 GMT (Framework : DEBUG) - Computed dependencies for component: wm_ldapattributes.pdp
2009-02-24 19:13:10 GMT (Framework : DEBUG) - dep[0]=wm_ldapattributes
2009-02-24 19:13:10 GMT (Framework : DEBUG) - Set user path locator: [protocol, root] [deploytemp:/, /opt/webmethods/Mportal/Portal/server/TTPortal/temp/temp_678700573/]
2009-02-24 19:13:11 GMT (portlet : DEBUG) - Unregistering xtype [wm_ldapattributes]
2009-02-24 19:13:11 GMT (dataAccess : INFO) - Unregistering XType:wm_ldapattributes
2009-02-24 19:13:11 GMT (Framework : DEBUG) - Unset user path locator: [protocol] [deploytemp:/]
2009-02-24 19:13:11 GMT (Framework : INFO) - UNINSTALL DONE: wm_ldapattributes.pdp
2009-02-24 19:13:11 GMT (Framework : DEBUG) - Items left to uninstall: 325
2009-02-24 19:13:11 GMT (Framework : INFO) - UNINSTALLING: TT_manage_portes.cdp
2009-02-24 19:13:11 GMT (Framework : DEBUG) - Computed dependencies for component: TT_manage_portes.cdp
2009-02-24 19:13:11 GMT (Framework : DEBUG) - dep[0]=wm_ntlmauthadmin.pdp
dep[1]=TT_gp008_detail_message
dep[2]=wm_xt_shortcut
dep[3]=wm_psuedoportlet
dep[4]=TT_gp007_liste_messages
dep[5]=wm_basicAuth.cdp
dep[6]=wm_formsAuth.cdp
dep[7]=wm_anonAuth.cdp
dep[8]=TT_gp022_validation_sp
2009-02-24 19:13:11 GMT (Framework : DEBUG) - Set user path locator: [protocol, root] [deploytemp:/, /opt/webmethods/Mportal/Portal/server/TTPortal/temp/temp_1813784444/]
2009-02-24 19:13:12 GMT (Framework : DEBUG) - Unset user path locator: [protocol] [deploytemp:/]
2009-02-24 19:13:12 GMT (Framework : INFO) - UNINSTALL DONE: TT_manage_portes.cdp
2009-02-24 19:13:12 GMT (Framework : DEBUG) - Items left to uninstall: 324
2009-02-24 19:13:12 GMT (Framework : INFO) - UNINSTALLING: wm_wikibrowse.pdp
2009-02-24 19:13:12 GMT (Framework : DEBUG) - Computed dependencies for component: wm_wikibrowse.pdp
2009-02-24 19:13:12 GMT (Framework : DEBUG) -
2009-02-24 19:13:12 GMT (Framework : DEBUG) - Set user path locator: [protocol, root] [deploytemp:/, /opt/webmethods/Mportal/Portal/server/TTPortal/temp/temp_232332935/]
2009-02-24 19:13:13 GMT (portlet : DEBUG) - Unregistering xtype [wm_wikibrowse]
2009-02-24 19:13:13 GMT (dataAccess : INFO) - Unregistering XType:wm_wikibrowse
2009-02-24 19:13:13 GMT (Framework : DEBUG) - Unset user path locator: [protocol] [deploytemp:/]
2009-02-24 19:13:13 GMT (Framework : INFO) - UNINSTALL DONE: wm_wikibrowse.pdp
2009-02-24 19:13:13 GMT (Framework : DEBUG) - Items left to uninstall: 323
2009-02-24 19:13:13 GMT (Framework : INFO) - UNINSTALLING: TT_admin_skin_rule.cdp
2009-02-24 19:13:13 GMT (Framework : DEBUG) - Computed dependencies for component: TT_admin_skin_rule.cdp
2009-02-24 19:13:13 GMT (Framework : DEBUG) - dep[0]=wm_ntlmauthadmin.pdp
dep[1]=wm_xt_rule
dep[2]=wm_basicAuth.cdp
dep[3]=wm_formsAuth.cdp
dep[4]=wm_anonAuth.cdp
2009-02-24 19:13:13 GMT (Framework : DEBUG) - Set user path locator: [protocol, root] [deploytemp:/, /opt/webmethods/Mportal/Portal/server/TTPortal/temp/temp_911385371/]
2009-02-24 19:13:13 GMT (Framework : DEBUG) - Unset user path locator: [protocol] [deploytemp:/]
2009-02-24 19:13:13 GMT (Framework : INFO) - UNINSTALL DONE: TT_admin_skin_rule.cdp
2009-02-24 19:13:13 GMT (Framework : DEBUG) - Items left to uninstall: 322
2009-02-24 19:13:13 GMT (Framework : INFO) - UNINSTALLING: wm_xt_basictemplate.pdp
2009-02-24 19:13:13 GMT (Framework : DEBUG) - Computed dependencies for component: wm_xt_basictemplate.pdp
2009-02-24 19:13:13 GMT (Framework : DEBUG) -
2009-02-24 19:13:13 GMT (Framework : DEBUG) - Set user path locator: [protocol, root] [deploytemp:/, /opt/webmethods/Mportal/Portal/server/TTPortal/temp/temp_414620308/]
2009-02-24 19:13:13 GMT (portlet : DEBUG) - Unregistering xtype [template]
2009-02-24 19:13:13 GMT (dataAccess : INFO) - Unregistering XType:template
2009-02-24 19:13:13 GMT (Framework : DEBUG) - Unset user path locator: [protocol] [deploytemp:/]
2009-02-24 19:13:13 GMT (Framework : INFO) - UNINSTALL DONE: wm_xt_basictemplate.pdp
2009-02-24 19:13:13 GMT (Framework : DEBUG) - Items left to uninstall: 321
2009-02-24 19:13:13 GMT (Framework : INFO) - UNINSTALLING: wm_simplepropertyeditors.pdp
2009-02-24 19:13:14 GMT (Framework : DEBUG) - Computed dependencies for component: wm_simplepropertyeditors.pdp
2009-02-24 19:13:14 GMT (Framework : DEBUG) -
2009-02-24 19:13:14 GMT (Framework : DEBUG) - Set user path locator: [protocol, root] [deploytemp:/, /opt/webmethods/Mportal/Portal/server/TTPortal/temp/temp_2068749083/]
2009-02-24 19:13:16 GMT (Framework : INFO) [RID:3160] - Processing request [1q47t6efhpm94:f.rachdi] http://Mportal.yyyy.fr/meta/default/folder/0000005481 (GET) {wmp5486.wmp_ws = maximized; wmp5486.pca_m = wiringfromME016; wmp5486.idMessage = 7130}
2009-02-24 19:13:16 GMT (portlet : DEBUG) [RID:3160] - Setting returnUrl to null
2009-02-24 19:13:16 GMT (Framework : INFO) [RID:3160] - ::::::::::Beging wiringfromME016:::::::::::::::
2009-02-24 19:13:16 GMT (Framework : INFO) [RID:3160] - Calling wiring from wiringFromME016
2009-02-24 19:13:16 GMT (Framework : INFO) [RID:3160] - and then after some time I got the following error
2009-02-24 19:14:04 GMT (Framework : FATAL) [RID:3162] - [POP.001.0002] A "java.sql.SQLException" occurred with the Message "[wm-cjdbc37-0008][Oracle JDBC Driver][Oracle]ORA-20001: Object no longer exists
ORA-06512: at "WMPORTAL2.SPTHINGBASICS", line 46
ORA-06512: at line 1
"
java.sql.SQLException: [wm-cjdbc37-0008][Oracle JDBC Driver][Oracle]ORA-20001: Object no longer exists
ORA-06512: at "WMPORTAL2.SPTHINGBASICS", line 46
ORA-06512: at line 1
at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.wm.dd.jdbc.base.BaseStatement.executeInternal(Unknown Source)and more :
2009-02-24 19:14:27 GMT (Framework : INFO) [RID:3162] - ======fin session====>
2009-02-24 19:14:27 GMT (Framework : DEBUG) [RID:3162] - Could not construct URI implementation, provider not found for URI shell.wm_shell_power_drill.foot
2009-02-24 19:14:41 GMT (portlet : DEBUG) - Unregistering xtype [folder]
2009-02-24 19:14:41 GMT (dataAccess : INFO) - Unregistering XType:folder
2009-02-24 19:14:45 GMT (Framework : WARN) - Unable to unregister XType:folder
java.sql.SQLException: [wm-cjdbc37-0008][Oracle JDBC Driver][Oracle]ORA-20001: ORA-02292: integrity constraint (WMPORTAL2.FK_005_GROUP_MUSTBE_THING) violated - child record found
ORA-06512: at "WMPORTAL2.SPTHINGDESTROYIMPL", line 166
ORA-02292: integrity constraint (WMPORTAL2.FK_005_GROUP_MUSTBE_THING) violated - child record found
ORA-06512: at "WMPORTAL2.SPTHINGDESTROY", line 8
ORA-06512: at line 1I checked the database and the procedures and fonctions mentioned in the log file don’t seem to have anything wrong as well as the tables that they’re reffering to ,
It’s impossible now to start the portal instance as I keep getting the exception :
2009-02-26 14:42:02 GMT (Framework : DEBUG) - Could not construct URI implementation, provider not found for URI folder.system.service.data
2009-02-26 14:42:02 GMT (Framework : INFO) - No registered exception delegate
2009-02-26 14:42:02 GMT (Framework : WARN) - Error initializing component: ConnectionManager
java.lang.NullPointerException
at com.webmethods.portal.service.sql.core.ConnectionInfo.getServiceID(ConnectionInfo.java:247)
at com.webmethods.portal.service.sql.core.ConnectionManager.postInit(ConnectionManager.java:212)
at com.webmethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:163)
at com.webmethods.portal.system.init.impl.DefaultPhase$InitializableWrapper.init(DefaultPhase.java:118)My question is what is the possible cause that those objects went missing and if anyone has seen something similar ,
I’am not a webMethods expert and any help is much needed.
Thanks.