We are trying to use DBErrorRecoveryPlan class for each of our dataSources.
We trap for an Error Code 5 and would like to re-try to execute the SQL. The code
snippet below works fine for Oracle, but does not work fro DB2. That is, Oracle fails,
retries, and then succeeds. DB2 fails, doesn't retry, and gets weird CORBA errors
of some sort.
The particular error "end-of-file on communication channel" only happens first thing
EVERY SINGLE MORNING. Does anyone know what this error means and why it is
happening? Why does the DBErrorRecoveryPlan work for Oracle, but not DB2?
//[[SPIDER_EVENT<this_onAfterInitEvent>
public int this_onAfterInitEvent(CSpInitEvent event)
{
// Trapping for end-of-file on communication channel error
// Adding a recovery plan by trying to connect only once
CSpDataSource ds = (CSpDataSource) event.getSource();
ds.addDBErrorRecoveryPlan (
new CSpDBErrorRecoveryPlan (
5,
CSpDBErrorRecoveryPlan.IGNORE_ERROR,
CSpDBErrorRecoveryPlan.IGNORE_ERROR,
true,
CSpDBErrorRecoveryPlan.ALWAYS_RETRY,
2));
return (PROCEED);
}
//]]SPIDER_EVENT<this_onAfterInitEvent>
Our login requires connection to 2 different databases (Oracle and DB2).
The following DBErrorRecovery code has been added to each datasource of the 2
databases above:
//[[SPIDER_CLASS BEGIN
public class ds_IADB extends spider.database.CSpDataSource
//]]SPIDER_CLASS END
{
//[[SPIDER_EVENTS BEGIN
//[[SPIDER_EVENT<this_onAfterInitEvent>
public int this_onAfterInitEvent(CSpInitEvent event)
{
// Trapping for end-of-file on communication channel error
// Adding a recovery plan by trying to connect only once
CSpDataSource ds = (CSpDataSource) event.getSource();
ds.addDBErrorRecoveryPlan (
new CSpDBErrorRecoveryPlan (
5,
CSpDBErrorRecoveryPlan.IGNORE_ERROR,
CSpDBErrorRecoveryPlan.IGNORE_ERROR,
true,
CSpDBErrorRecoveryPlan.ALWAYS_RETRY,
1));
return (PROCEED);
}
//]]SPIDER_EVENT<this_onAfterInitEvent>
//]]SPIDER_EVENTS END
}
Below is the NetD error log we receive after logging in for the first time.
It appears that Oracle initially fails, but upon retry (from error recovery code
above) it succeeds. However, DB2 initially fails and it either does not retry
or fails again. I cannot tell.
We have run into differences between Oracle and DB2 before (eg, with PeopleSoft PAC),
and have found what works with Oracle does not necessarily work with DB2.
Note that "5" refers to the error code returned by the database.
// FIRST TIME ORACLE IS ACCESSED; FAILS (Error Code 5)
CPService c:965030880451:w:965030888589 ,IADBDataMapper.executeSelect(String, args[])
Thread-96 �select UserPin, DefaultPin, UseDefaultPin, to_char(ExpireOn,
'MM/DD/YYYY') , IsLocked, EMAIL_ADDRESS, ACTIVE from IL_USER_SECURITY where
EMPID='69879' and SYSDATAID=0
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Common Error Handler:
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Error code: 5
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 e Error message [SERVERERROR] Error from Server:
ORA-03113: end-of-file on communication channel
DSRdbmsService 3455 Is terminal: No
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor error 1: 3113
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor error 2: 0
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor message 1: rnd5
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor message 2:
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Common Error Handler:
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Error code: 5
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 O Error message [SERVERERROR] Error from Server:
ORA-01001: invalid cursor
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Is terminal: No
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor error 1: 1001
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor error 2: 0
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor message 1: rnd5
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor message 2:
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 cannot open sequential cursor
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Common Error Handler:
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Error code: 5
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 O Error message [SERVERERROR] Error from Server:
ORA-01001: invalid cursor
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Is terminal: No
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor error 1: 1001
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor error 2: 0
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor message 1: rnd5
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor message 2:
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 ddropOnLostConnection:Closing connection to
databaseType.ORACLE.databaseName..serverName.rnd5.il0308.
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Common Error Handler:
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Error code: 5
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 X Error message [SERVERERROR] Error from Server:
ORA-12545: TNS:name lookup failure
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Is terminal: No
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor error 1: 12545
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor error 2: 0
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor message 1: rnd5
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3455 Vendor message 2:
DSRdbmsService context
DSRdbmsService 3462 Common Error Handler:
DSRdbmsService context
DSRdbmsService 3462 Error code: 5
DSRdbmsService context
DSRdbmsService 3462 e Error message [SERVERERROR] Error from Server:
ORA-03113: end-of-file on communication channel
DSRdbmsService context
DSRdbmsService 3462 Is terminal: No
DSRdbmsService context
DSRdbmsService 3462 Vendor error 1: 3113
DSRdbmsService context
DSRdbmsService 3462 Vendor error 2: 0
DSRdbmsService context
DSRdbmsService 3462 Vendor message 1: rnd5
DSRdbmsService context
DSRdbmsService 3462 Vendor message 2:
DSRdbmsService context
DSRdbmsService 3462 ^getThreadContext:Should not happen: the context for this
thread contains no database handle.!!
DSRdbmsService context
DSRdbmsService 3462 IhandleError: should not happen: thread context returned a
NULL connection
// NEXT LINE IS SUCCESSFUL EXECUTION TO ORACLE DATABASE (I guess from the
DBErrorRecovery retry).
CPService c:965030880451:w:965030888589 ,IADBDataMapper.executeSelect(String, args[])
Thread-96 Execution completed
CPService c:965030880451:w:965030888589 %IASecurityManager.getLoggedEmployeeID
Thread-96 �Security object not found com.interlynx.exception.IAException:
IAException:com.interlynx.exception.IAException: IAException:Attempted to retrieve
IA_SECURITY_OBJECT but it was not found in session.:Error getting session object
IA_SECURITY_OBJECT
CPService c:965030880451:w:965030888589 IAAudit Thread-96 .User Not
initialize din security Object as yet
CPService c:965030880451:w:965030888589 IAAudit Thread-96
LoggedOnEmployeeID =
// ADDITIONAL SUCCESSFUL EXECUTION'S TO ORACLE DATABASE
CPService c:965030880451:w:965030888589 4IADBDataMapper.executeSelect(String, args[],
String) Thread-96 %insert into IL_AUDIT_DATA ( MEDIA, SYSDATAID, WORKFLOWID,
INITIATORID, SUBJECTID, ROUTETOID, PROCID, PROCESSSTEPNUM, EVENTNAME, USERID,
PROXYGIVERID, AUDITEVENTNAME, DATA ) values ( #1, #2, '#3' , '#4', '#5', '#6',
#7, #8, '#9', '#10', '#11', '#12', '#13' )[Ljava.lang.String;@1d27c46b
CPService c:965030880451:w:965030888589 4IADBDataMapper.executeSelect(String, args[],
String) Thread-96 �insert into IL_AUDIT_DATA ( MEDIA, SYSDATAID, WORKFLOWID,
INITIATORID, SUBJECTID, ROUTETOID, PROCID, PROCESSSTEPNUM, EVENTNAME, USERID,
PROXYGIVERID, AUDITEVENTNAME, DATA ) values ( 1, 0, '' , '', '', '', 90001, 1,
'FUNC', ' ', ' ', 'LoginView', '1 69879 69879
69879 01122882 0 0 1 [EMAIL PROTECTED]
' )
CPService c:965030880451:w:965030888589 4IADBDataMapper.executeSelect(String, args[],
String) Thread-96 Execution completed.
CPService c:965030880451:w:965030888589 IASessionDataManager Thread-96 /No
sysDataId set in session, default id is used
CPService c:965030880451:w:965030888589 4IADBDataMapper.executeSelect(String, args[],
String) Thread-96 cselect RoleCode from IL_ROLE_SECURITY where EMPID='#1' and
SYSDATAID=#2[Ljava.lang.String;@1d27b73f
CPService c:965030880451:w:965030888589 4IADBDataMapper.executeSelect(String, args[],
String) Thread-96 Iselect RoleCode from IL_ROLE_SECURITY where EMPID='69879' and
SYSDATAID=0
CPService c:965030880451:w:965030888589 4IADBDataMapper.executeSelect(String, args[],
String) Thread-96 Execution completed.
// FIRST TIME DB2 DATABASE IS ACCESSED; FAILS (Error Code 5)
CPService c:965030880451:w:965030888589 4IADBDataMapper.executeSelect(String, args[],
String) Thread-96 �select P.NAME, J.DEPTID, J.Y_HR_AREA_CD, R.Y_LEVEL02,
R.Y_LEVEL03 from PS_PERSONAL_DATA P, PS_JOB J, PS_Y_DEPT_ROLLUP R where P.EMPLID='#1'
AND J.EMPLID=P.EMPLID AND J.EMPL_RCD# = 0 and J.EFFDT=(SELECT MAX(EFFDT) FROM PS_JOB
J2 where J.EMPLID = J2.EMPLID AND J2.EMPL_RCD# = 0 AND J2.EFFDT <= CURRENT DATE) AND
J.EFFSEQ=(SELECT MAX(EFFSEQ) FROM PS_JOB J3 where J.EMPLID = J3.EMPLID AND
J3.EMPL_RCD# = 0 AND J3.EFFDT = J.EFFDT AND J3.EMPL_STATUS='A') AND
R.DEPTID=J.DEPTID[Ljava.lang.String;@1d27b1cf
CPService c:965030880451:w:965030888589 4IADBDataMapper.executeSelect(String, args[],
String) Thread-96 �select P.NAME, J.DEPTID, J.Y_HR_AREA_CD, R.Y_LEVEL02,
R.Y_LEVEL03 from PS_PERSONAL_DATA P, PS_JOB J, PS_Y_DEPT_ROLLUP R where
P.EMPLID='69879' AND J.EMPLID=P.EMPLID AND J.EMPL_RCD# = 0 and J.EFFDT=(SELECT
MAX(EFFDT) FROM PS_JOB J2 where J.EMPLID = J2.EMPLID AND J2.EMPL_RCD# = 0 AND J2.EFFDT
<= CURRENT DATE) AND J.EFFSEQ=(SELECT MAX(EFFSEQ) FROM PS_JOB J3 where J.EMPLID =
J3.EMPLID AND J3.EMPL_RCD# = 0 AND J3.EFFDT = J.EFFDT AND J3.EMPL_STATUS='A') AND
R.DEPTID=J.DEPTID
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3462 Common Error Handler:
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3462 Error code: 5
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3462 $ Error message SQL call failed.
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3462 Is terminal: No
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3462 Vendor error 1: -30081
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3462 Vendor error 2: 1
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3462 Vendor message 1: 40003
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3462 e Vendor message 2: [IBM][CLI Driver][DB2] SQL30081N A
communication error has been detected. Communication protocol being used: "TCP/IP".
Communication API being used: "SOCKETS". Location where the error was detected:
"10.127.17.9". Communication function detecting the error: "send". Protocol specific
error code(s): "32", "*", "0". SQLSTATE=08001
ޭ�� �m�$ �m��
DSRdbmsService c:965030875615:w:965136039778
DSRdbmsService 3462 cannot open sequential cursor
// DB2 ERRORS ABOVE AND WEIRD ERROR MESSAGES APPEAR BELOW. THIS DOES NOT HAPPEN WITH
ORACLE!!
// WHERE IS THE DB2 RETRY from the DBErrorRecoveryPlan).
DSRdbmsService KCNdCOSIThread:
netdyn.common.CNdObjectFactoryProxy.CNdFactoryProcessMonitor
Anetdyn.cosi.common.CNdObjectFactoryProxy$CNdFactoryProcessMonitor
<netdyn.common.CNdObjectFactoryProxy.CNdFactoryProcessMonitor
�CNdFactoryProcessMonitor: factory nd_DSWorker_41 -ORBagentAddr csg0015.msd.ray.com
-ORBagentPort 14020 -NetdynCell 138.127.17.9.DefaultPartition -NetdynPartition
DefaultPartitionObjectFactoryImpl has terminated abnormally java.lang.ThreadDeathޭ��
�m�� �m�m cosi CNdWorkerControl.update
$netdyn.cosi.service.CNdWorkerControl
<netdyn.common.CNdObjectFactoryProxy.CNdFactoryProcessMonitor update: worker
factory netdyn.cosi.common.CNdObjectFactoryProxy@1d26ffd5 of type nd_DSWorker_41
-ORBagentAddr csg0015.msd.ray.com -ORBagentPort 14020 -NetdynCell
138.127.17.9.DefaultPartition -NetdynPartition DefaultPartitionObjectFactoryImpl has
failed and is being restartedޭ�� �m�� �m�� cosi
CNdWorkerControl.update $netdyn.cosi.service.CNdWorkerControl
<netdyn.common.CNdObjectFactoryProxy.CNdFactoryProcessMonitor 1update: there are 1
workers in the failed factoryޭ�� �m� �m�� cosi
CNdWorkerControl.update 8netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry
<netdyn.common.CNdObjectFactoryProxy.CNdFactoryProcessMonitor RrevokeReservation:
org.omg.CORBA.COMM_FAILURE[completed=MAYBE, reason=java.net.SocketException:
Connection reset by peer]
org.omg.CORBA.COMM_FAILURE[completed=MAYBE, reason=java.net.SocketException:
Connection reset by peer]
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.lang.RuntimeException.<init>(Compiled Code)
at org.omg.CORBA.SystemException.<init>(Compiled Code)
at org.omg.CORBA.COMM_FAILURE.<init>(Compiled Code)
at com.visigenic.vbroker.orb.TcpConnection.read(Compiled Code)
at com.visigenic.vbroker.orb.GiopConnectionImpl.receive_message(Compiled Code)
at com.visigenic.vbroker.orb.GiopConnectionImpl.receive_reply(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.invoke(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.invoke(Compiled Code)
at org.omg.CORBA.portable.ObjectImpl._invoke(Compiled Code)
at netdyn.cosi.stubs._st_INdWorker.clientReleased(Compiled Code)
at
netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry.tryRemovingClient(Compiled
Code)
at
netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry.revokeAllReservations(Compiled
Code)
at netdyn.cosi.service.loadBalancing.CNdWorkerRegistry.unregister(Compiled
Code)
at
netdyn.cosi.service.loadBalancing.CNdLoadBalancingManager.unregisterWorker(Compiled
Code)
at netdyn.cosi.service.CNdWorkerControl.update(Compiled Code)
at java.util.Observable.notifyObservers(Compiled Code)
at netdyn.cosi.common.CNdObjectFactoryProxy.notifyObservers(Compiled Code)
at
netdyn.cosi.common.CNdObjectFactoryProxy$CNdFactoryProcessMonitor.run(Compiled Code)
ޭ�� �m� �m��
CPService c:965030880451:w:965030888589
.netdyn.services.dsrdbms.client.CNdDSRdbmsProxy Thread-96
�handleSystemException: org.omg.CORBA.COMM_FAILURE[completed=MAYBE,
reason=java.io.IOException: Peer disconnected socket]
org.omg.CORBA.COMM_FAILURE[completed=MAYBE, reason=java.io.IOException: Peer
disconnected socket]
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.lang.RuntimeException.<init>(Compiled Code)
at org.omg.CORBA.SystemException.<init>(Compiled Code)
at org.omg.CORBA.COMM_FAILURE.<init>(Compiled Code)
at com.visigenic.vbroker.orb.TcpConnection.read(Compiled Code)
at com.visigenic.vbroker.orb.GiopConnectionImpl.receive_message(Compiled Code)
at com.visigenic.vbroker.orb.GiopConnectionImpl.receive_reply(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.invoke(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.invoke(Compiled Code)
at org.omg.CORBA.portable.ObjectImpl._invoke(Compiled Code)
at netdyn.services.dsrdbms.stubs._st_INdDSRdbms.executeSQL(Compiled Code)
at netdyn.services.dsrdbms.client.CNdDSRdbmsProxy.executeSQL(Compiled Code)
at spider.database.CSpDS.executeRequest(Compiled Code)
at spider.database.CSpDS.executeRequest(Compiled Code)
at spider.database.CSpDataObject.executeImmediate(Compiled Code)
at spider.database.CSpDataObject.executeImmediate(Compiled Code)
at spider.database.CSpDataObject.executeImmediate(Compiled Code)
at com.interlynx.util.IAQueryExecutor.executeSelect(Compiled Code)
at com.interlynx.util.IADBDataMapper.executeSelect(Compiled Code)
at com.interlynx.security.IAUserInformation.getPeoplesoftData(Compiled Code)
at com.interlynx.security.IAUserManager.initializeUserObject(Compiled Code)
at Login.pgLogin.btnSubmit_onWebEvent(Compiled Code)
at spider.event.adapters.CSpEventAdapter.relayGenericEventProcessing(Compiled
Code)
at spider.event.adapters.CSpEventAdapter.relayGenericEvent(Compiled Code)
at spider.event.adapters.CSpPageEventAdapter.onWebEvent(Compiled Code)
at spider.visual.CSpCommand.processWebEvent(Compiled Code)
at spider.visual.CSpCommand.processEvent(Compiled Code)
at spider.CSpFileBased.dispatchEvent(Compiled Code)
at spider.CSpFileBased.dispatchEvent(Compiled Code)
at spider.util.CSpMethod.call(Compiled Code)
at com.interlynx.nd.IAPage.btnErrorHandler_onWebEvent(Compiled Code)
at spider.event.adapters.CSpEventAdapter.relayGenericEventProcessing(Compiled
Code)
at spider.event.adapters.CSpEventAdapter.relayGenericEvent(Compiled Code)
at spider.event.adapters.CSpPageEventAdapter.onWebEvent(Compiled Code)
at spider.visual.CSpCommand.processWebEvent(Compiled Code)
at spider.visual.CSpCommand.processEvent(Compiled Code)
at spider.CSpFileBased.dispatchEvent(Compiled Code)
at spider.CSpFileBased.dispatchEvent(Compiled Code)
at spider.util.CSpMethod.call(Compiled Code)
at spider.control.CSpWebEventProcessor.callThisMethod(Compiled Code)
at spider.control.CSpWebEventProcessor.run(Compiled Code)
at netdyn.services.cp.worker.CNdCPWorkerImpl.webEventMessage(Compiled Code)
at netdyn.services.cp.stubs._tie_INdCPWorker.webEventMessage(Compiled Code)
at netdyn.services.cp.stubs._INdCPWorkerImplBase._execute(Compiled Code)
at netdyn.services.cp.stubs._INdCPWorkerImplBase._execute(Compiled Code)
at com.visigenic.vbroker.orb.SkeletonDelegateImpl.execute(Compiled Code)
at com.visigenic.vbroker.orb.GiopProtocolAdapter.doRequest(Compiled Code)
at com.visigenic.vbroker.orb.GiopProtocolAdapter.dispatchMessage(Compiled Code)
at com.visigenic.vbroker.orb.ThreadPoolDispatcher.run(Compiled Code)
at com.visigenic.vbroker.orb.WorkerThread.run(Compiled Code)
ޭ�� �m�i �m�) cosi CNdWorkerControl.update
8netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry
<netdyn.common.CNdObjectFactoryProxy.CNdFactoryProcessMonitor DrevokeReservation:
org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]
org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.lang.RuntimeException.<init>(Compiled Code)
at org.omg.CORBA.SystemException.<init>(Compiled Code)
at org.omg.CORBA.NO_IMPLEMENT.<init>(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.bind(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.request(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.request(Compiled Code)
at org.omg.CORBA.portable.ObjectImpl._request(Compiled Code)
at netdyn.cosi.stubs._st_INdWorker.clientReleased(Compiled Code)
at
netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry.tryRemovingClient(Compiled
Code)
at
netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry.revokeAllReservations(Compiled
Code)
at netdyn.cosi.service.loadBalancing.CNdWorkerRegistry.unregister(Compiled
Code)
at
netdyn.cosi.service.loadBalancing.CNdLoadBalancingManager.unregisterWorker(Compiled
Code)
at netdyn.cosi.service.CNdWorkerControl.update(Compiled Code)
at java.util.Observable.notifyObservers(Compiled Code)
at netdyn.cosi.common.CNdObjectFactoryProxy.notifyObservers(Compiled Code)
at
netdyn.cosi.common.CNdObjectFactoryProxy$CNdFactoryProcessMonitor.run(Compiled Code)
ޭ�� �m�� �m�| cosi CNdWorkerControl.update
8netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry
<netdyn.common.CNdObjectFactoryProxy.CNdFactoryProcessMonitor DrevokeReservation:
org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]
org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.lang.RuntimeException.<init>(Compiled Code)
at org.omg.CORBA.SystemException.<init>(Compiled Code)
at org.omg.CORBA.NO_IMPLEMENT.<init>(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.bind(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.request(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.request(Compiled Code)
at org.omg.CORBA.portable.ObjectImpl._request(Compiled Code)
at netdyn.cosi.stubs._st_INdWorker.clientReleased(Compiled Code)
at
netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry.tryRemovingClient(Compiled
Code)
at
netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry.revokeAllReservations(Compiled
Code)
at netdyn.cosi.service.loadBalancing.CNdWorkerRegistry.unregister(Compiled
Code)
at
netdyn.cosi.service.loadBalancing.CNdLoadBalancingManager.unregisterWorker(Compiled
Code)
at netdyn.cosi.service.CNdWorkerControl.update(Compiled Code)
at java.util.Observable.notifyObservers(Compiled Code)
at netdyn.cosi.common.CNdObjectFactoryProxy.notifyObservers(Compiled Code)
at
netdyn.cosi.common.CNdObjectFactoryProxy$CNdFactoryProcessMonitor.run(Compiled Code)
ޭ�� �m�� �m��
CPService c:965030880451:w:965030888589
CSpDataObject Thread-96
executeImmediate: Unexpected Exception (org.omg.CORBA.COMM_FAILURE[completed=MAYBE,
reason=java.io.IOException: Peer disconnected socket]) caught. Top of stack:
|org.omg.CORBA.COMM_FAILURE[completed=MAYBE, reason=java.io.IOException: Peer
disconnected socket]
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.lang.RuntimeException.<init>(Compiled Code)
at org.omg.CORBA.SystemException.<init>(Compiled Code)
at org.omg.CORBA.COMM_FAILURE.<init>(Compiled Code)
at com.visigenic.vbroker.orb.TcpConnection.read(Compiled Code)
at com.visigenic.vbroker.orb.GiopConnectionImpl.receive_message(Compiled Code)
at com.visigenic.vbroker.orb.GiopConnectionImpl.receive_reply(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.invoke(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.invoke(Compiled Code)
at org.omg.CORBA.portable.ObjectImpl._invoke(Compiled Code)
at netdyn.services.dsrdbms.stubs._st_INdDSRdbms.executeSQL(Compiled Code)
at netdyn.services.dsrdbms.client.CNdDSRdbmsProxy.executeSQL(Compiled Code)
at spider.database.CSpDS.executeRequest(Compiled Code)
at spider.database.CSpDS.executeRequest(Compiled Code)
at spider.database.CSpDataObject.executeImmediate(Compiled Code)
at spider.database.CSpDataObject.executeImmediate(Compiled Code)
at spider.database.CSpDataObject.executeImmediate(Compiled Code)
at com.interlynx.util.IAQueryExecutor.executeSelect(Compiled Code)
at com.interlynx.util.IADBDataMapper.executeSelect(Compiled Code)
at com.interlynx.security.IAUserInformation.getPeoplesoftData(Compiled Code)
at com.interlynx.security.IAUserManager.initializeUserObject(Compiled Code)
at Login.pgLogin.btnSubmit_onWebEvent(Compiled Code)
at spider.event.adapters.CSpEventAdapter.relayGenericEventProcessing(Compiled
Code)
at spider.event.adapters.CSpEventAdapter.relayGenericEvent(Compiled Code)
at spider.event.adapters.CSpPageEventAdapter.onWebEvent(Compiled Code)
at spider.visual.CSpCommand.processWebEvent(Compiled Code)
at spider.visual.CSpCommand.processEvent(Compiled Code)
at spider.CSpFileBased.dispatchEvent(Compiled Code)
at spider.CSpFileBased.dispatchEvent(Compiled Code)
at spider.util.CSpMethod.call(Compiled Code)
at com.interlynx.nd.IAPage.btnErrorHandler_onWebEvent(Compiled Code)
at spider.event.adapters.CSpEventAdapter.relayGenericEventProcessing(Compiled
Code)
at spider.event.adapters.CSpEventAdapter.relayGenericEvent(Compiled Code)
at spider.event.adapters.CSpPageEventAdapter.onWebEvent(Compiled Code)
at spider.visual.CSpCommand.processWebEvent(Compiled Code)
at spider.visual.CSpCommand.processEvent(Compiled Code)
at spider.CSpFileBased.dispatchEvent(Compiled Code)
at spider.CSpFileBased.dispatchEvent(Compiled Code)
at spider.util.CSpMethod.call(Compiled Code)
at spider.control.CSpWebEventProcessor.callThisMethod(Compiled Code)
at spider.control.CSpWebEventProcessor.run(Compiled Code)
at netdyn.services.cp.worker.CNdCPWorkerImpl.webEventMessage(Compiled Code)
at netdyn.services.cp.stubs._tie_INdCPWorker.webEventMessage(Compiled Code)
at netdyn.services.cp.stubs._INdCPWorkerImplBase._execute(Compiled Code)
at netdyn.services.cp.stubs._INdCPWorkerImplBase._execute(Compiled Code)
at com.visigenic.vbroker.orb.SkeletonDelegateImpl.execute(Compiled Code)
at com.visigenic.vbroker.orb.GiopProtocolAdapter.doRequest(Compiled Code)
at com.visigenic.vbroker.orb.GiopProtocolAdapter.dispatchMessage(Compiled Code)
at com.visigenic.vbroker.orb.ThreadPoolDispatcher.run(Compiled Code)
at com.visigenic.vbroker.orb.WorkerThread.run(Compiled Code)
|ޭ�� �m�� �m�� cosi CNdWorkerControl.update
|8netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry
|<netdyn.common.CNdObjectFactoryProxy.CNdFactoryProcessMonitor DrevokeReservation:
|org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]
org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.lang.RuntimeException.<init>(Compiled Code)
at org.omg.CORBA.SystemException.<init>(Compiled Code)
at org.omg.CORBA.NO_IMPLEMENT.<init>(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.bind(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.request(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.request(Compiled Code)
at org.omg.CORBA.portable.ObjectImpl._request(Compiled Code)
at netdyn.cosi.stubs._st_INdWorker.clientReleased(Compiled Code)
at
netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry.tryRemovingClient(Compiled
Code)
at
netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry.revokeAllReservations(Compiled
Code)
at netdyn.cosi.service.loadBalancing.CNdWorkerRegistry.unregister(Compiled
Code)
at
netdyn.cosi.service.loadBalancing.CNdLoadBalancingManager.unregisterWorker(Compiled
Code)
at netdyn.cosi.service.CNdWorkerControl.update(Compiled Code)
at java.util.Observable.notifyObservers(Compiled Code)
at netdyn.cosi.common.CNdObjectFactoryProxy.notifyObservers(Compiled Code)
at
netdyn.cosi.common.CNdObjectFactoryProxy$CNdFactoryProcessMonitor.run(Compiled Code)
ޭ�� �m�� �m��
CPService c:965030880451:w:965030888589 IADBDataMapper.executeSelect Thread-96
rTrapped an exception while executing the select statement
:com.interlynx.exception.IAException: IAException:Error 4. executing select P.NAME,
J.DEPTID, J.Y_HR_AREA_CD, R.Y_LEVEL02, R.Y_LEVEL03 from PS_PERSONAL_DATA P, PS_JOB J,
PS_Y_DEPT_ROLLUP R where P.EMPLID='69879' AND J.EMPLID=P.EMPLID AND J.EMPL_RCD# = 0
and J.EFFDT=(SELECT MAX(EFFDT) FROM PS_JOB J2 where J.EMPLID = J2.EMPLID AND
J2.EMPL_RCD# = 0 AND J2.EFFDT <= CURRENT DATE) AND J.EFFSEQ=(SELECT MAX(EFFSEQ) FROM
PS_JOB J3 where J.EMPLID = J3.EMPLID AND J3.EMPL_RCD# = 0 AND J3.EFFDT = J.EFFDT AND
J3.EMPL_STATUS='A') AND R.DEPTID=J.DEPTID on PEOPLESOFT_DATA_SOURCE
CPService c:965030880451:w:965030888589 !IAUSerManager.resolveEmployeeData
Thread-96 .Couldn't Execute Select Query to get User Dataޭ�� �m�1 �m�
cosi CNdWorkerControl.update
8netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry
<netdyn.common.CNdObjectFactoryProxy.CNdFactoryProcessMonitor DrevokeReservation:
org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]
org.omg.CORBA.NO_IMPLEMENT[completed=MAYBE]
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.lang.RuntimeException.<init>(Compiled Code)
at org.omg.CORBA.SystemException.<init>(Compiled Code)
at org.omg.CORBA.NO_IMPLEMENT.<init>(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.bind(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.request(Compiled Code)
at com.visigenic.vbroker.orb.GiopStubDelegate.request(Compiled Code)
at org.omg.CORBA.portable.ObjectImpl._request(Compiled Code)
at netdyn.cosi.stubs._st_INdWorker.clientReleased(Compiled Code)
at
netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry.tryRemovingClient(Compiled
Code)
at
netdyn.cosi.service.loadBalancing.CNdWorkerRegistryEntry.revokeAllReservations(Compiled
Code)
at netdyn.cosi.service.loadBalancing.CNdWorkerRegistry.unregister(Compiled
Code)
at
netdyn.cosi.service.loadBalancing.CNdLoadBalancingManager.unregisterWorker(Compiled
Code)
at netdyn.cosi.service.CNdWorkerControl.update(Compiled Code)
at java.util.Observable.notifyObservers(Compiled Code)
at netdyn.cosi.common.CNdObjectFactoryProxy.notifyObservers(Compiled Code)
at
netdyn.cosi.common.CNdObjectFactoryProxy$CNdFactoryProcessMonitor.run(Compiled Code)
ޭ�� �m�Z �m�7
CPService c:965030880451:w:965030888589
Login.pgLogin Thread-96 IAUser
Initialization failureޭ�� �m�[ �m�B cosi CNdWorkerControl.update
$netdyn.cosi.service.CNdWorkerControl
<netdyn.common.CNdObjectFactoryProxy.CNdFactoryProcessMonitor Supdate: after
removing the failed worker, there are 1 workers in the failed factoryޭ�� �m��
�m��
CPService c:965030880451:w:965030888589 IAUserManager.setEmailAddress
Thread-96 �User Information not found in session
com.interlynx.exception.IAException: IAException:com.interlynx.exception.IAException:
IAException:Attempted to retrieve IA_USER_INFO but it was not found in session.:Error
getting session object IA_USER_INFOޭ�� �m�� �m��
CPService c:965030880451:w:965030888589 !IAUserManager.setProxyGrantorName
Thread-96
_________________________________________________________________________
To unsubscribe from this mailing list please send an email to:
[EMAIL PROTECTED]
Please remember to use the same email address you subscribed with.
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
