Syncing Project From P6 Not Initiating ReqABCS

(Doc ID 1348626.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Project Portfolio Management Integration Pack for Primavera P6 and Oracle E-Business Suite - Version 3.1 and later
Information in this document applies to any platform.

Symptoms

AIA FP 3.1
P6-e-Business PIP

Trying to sync project from P6 to e-Business, no BPEL instance is initiated in AIA.
Click on "Send To ERP" link from P6 and no instance seen initiated in EM console.

Verified the following
1) In PIP Implementation guide, on page 43/44, has "Setting Up the Primavera P6 Application" section where need to define the Configuration Settings in P6.
2) Test Configuration button to test the connection and verified was successful
3) Confirmed definition of AIA_ProjP6EPPM_DS Datasource
4) Disabled ProjectListP6EPPMJMSConsumer, replicated issue and obtained the message from the Q
(select * from AIA_ProjP6EPPMJMSQTAB)

Here is important results from message.
  <MESSAGE_TYPE>0</MESSAGE_TYPE>
   <TEXT_LEN>313</TEXT_LEN>
   <BYTES_LEN />
   <TEXT_VC />
   <BYTES_RAW />
   <TEXT_LOB />
   <BYTES_LOB><BLOB></BYTES_LOB>

-->> This tells us, the TextMessage has 313 characters, but the dequeued is corrupted. One of the textLob(CLOB) and textVc(String) must not be null. In this failure, both are null.

5) So obtain the SOA logs with increased level for adapter logger which showed error during dequeue of the message.

a. Remove logs from Middleware/user_projects/domains/<domain>/servers/<manage_server>/logs directory
b. Bounce SOA
c. Go to EM console, SOA > Right click on soa-infra and select Logs > Log Configuration
> Drill down to oracle.soa.adapter
> Set to TRACE:32 (FINEST)
d. Sync project from P6 by going to Send to ERP
d. Go to Middleware/user_projects/domains/<domain>/servers/<manage_server>/logs directory and upload the logs created

soa_server.out is showing the following :

<Error> <oracle.soa.adapter> <BEA-000000> <JMSAdapter ProjectListP6EPPMJMSConsumer JMSMessageConsumer_ConsumeMessage: Jms Exception while trying to receive a message - [destination = aqjms/aia/AIA_ProjP6EPPMJMSQueue (payload = 1)]>
<Error> <oracle.soa.adapter> <BEA-000000> <JMSAdapter ProjectListP6EPPMJMSConsumer
oracle.jms.AQjmsException: JMS-120: Dequeue failed
at oracle.jms.AQjmsError.throwEx(AQjmsError.java:315)
at oracle.jms.AQjmsConsumer.jdbcDequeue(AQjmsConsumer.java:1626)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:1035)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:960)
at oracle.jms.AQjmsConsumer.receiveFromAQ(AQjmsConsumer.java:938)
at oracle.jms.AQjmsConsumer.receive(AQjmsConsumer.java:790)
at oracle.tip.adapter.jms.JMS.WLSJMSMessageConsumer$4.run(WLSJMSMessageConsumer.java:123)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.jms.common.CrossDomainSecurityManager.runAs(CrossDomainSecurityManager.java:131)
at weblogic.jms.extensions.JMSDestinationAvailabilityHelper$DestinationAvailabilityListenerWrapper.runAs(JMSDestinationAvailabilityHelper.java:478)
at oracle.tip.adapter.jms.JMS.WLSJMSMessageConsumer.receiveMessage(WLSJMSMessageConsumer.java:120)
at oracle.tip.adapter.jms.JMS.JMSMessageConsumer.consumeBlockingWithTimeout(JMSMessageConsumer.java:1070)
at oracle.tip.adapter.jms.inbound.JmsConsumer.run(JmsConsumer.java:1014)
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:120)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:183)
at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
Caused by: oracle.jms.AQjmsException: JMS-122: Internal error Corrupted message

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms