Issues and Solutions - Part IV

Issue:


<ERROR><default.collaxa.cube.activation><JMSAdapter::Inbound> JmsConsumer_run: A resource exception occurred while waiting for inbound messages: Generic error.

oracle.jms.AQjmsException: JMS-120: Dequeue failed

at oracle.jms.AQjmsError.throwEx(AQjmsError.java:308)

at oracle.jms.AQjmsConsumer.dequeue(AQjmsConsumer.java:2094)

at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:922)

at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:835)

at oracle.jms.AQjmsConsumer.receive(AQjmsConsumer.java:776)

at oracle.tip.adapter.jms.JMS.JMSMessageConsumer.consumeBlockingWithTimeout(JMSMessageConsumer.java:405)

at oracle.tip.adapter.jms.inbound.JmsConsumer.run(JmsConsumer.java:330)

at oracle.tip.adapter.fw.jca.work.WorkerJob.go(WorkerJob.java:51)

at oracle.tip.adapter.fw.common.ThreadPool.run(ThreadPool.java:280)

at java.lang.Thread.run(Thread.java:595)
[Linked-exception]

java.sql.SQLException: ORA-00600: internal error code, arguments: [kwqidrdq: loop], [0], [0], [0], [0], [], [], []

ORA-06512: at "SYS.DBMS_AQIN", line 571

ORA-06512: at line 1
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)



Solution: This error occurs due to manual deletion of the AQ messages, due to this error DB Connection pool gets exhausted after certain time limit.

Delete and recreate the queues.

Note: Don't delete the messages from the queue manually from the database

----------------------------------------------------------------------------------------------------------------

Issue:

Unable to convert the XSD element P_CONTACT_IDS whose collection type is AIA.AIA_AGGREGATOR_LIST_OF_IDS_TBL. Cause: java.sql.SQLException: Fail to construct descriptor: Unable to resolve type: "AIA.AIA_AGGREGATOR_LIST_OF_IDS_TBL" [Caused by: Fail to construct descriptor: Unable to resolve type: "AIA.AIA_AGGREGATOR_LIST_OF_IDS_TBL"]


Solution:

Check all the packages are compiled. If not compile all the packages and procedures.



----------------------------------------------------------------------------------------------------------------

Issue:

Error on AIASessionPoolManager.bpel: Operation=Get

SessionPoolHost.getSession(SEBL_01,80002): SessionPoolHost.create() thread[RMICallHandler-55]: Failed to obtain a session after 2 attempts. The web server did not reponded with a session.Login credentials [endpoint: http://:80/eai_enu/start.swe?SWEExtSource=SecureWebService&SWEExtCmd=Execute&UserName=123&Password=1234 ]

java.lang.Throwable: Fault response (or timed out)


Solution:

Set proper AIAConfigurationProperties.xml data

<!-- === Specific values for SEBL_01 === -->

<Property name="SEBL_01.UserId">intuser</Property>

<Property name="SEBL_01.Password">intuser123</Property>

<Property name="SEBL_01.EndpointURI">http://10.18.19.210:80/eai_enu/start.swe?SWEExtSource=SecureWebService&SWEExtCmd=Execute&WSSOAP=1</Property>