Hi Oracle Gurus,
I am using Salesforce Adapter 'Query' operation. This worked fine last week when I had one service to invoke SFDC API. But after I added a second invoke of the same Query operation, I am getting this error.
Error invoking Salesforce Adapter service - java.lang.IllegalStateException: Cipher not initialized
Pls look at below doc for Composite.xml and BPEL source.
https://drive.google.com/file/d/0B8E4JtTUuzitQ1lpUkVxNnV5UGM/edit?usp=sharing
It does look like an access issue but I'm able to invoke the SFDC API using SOAP UI. Please help.
Error stack from soa-diagnostic.log
--======================
[2014-07-09T17:47:04.272-07:00] [soa_server22] [NOTIFICATION] [] [oracle.soa.adapter.cloud] [tid: orabpel.invoke.pool-4.thread-9] [userId: GOPAL_TARITLA] [ecid: c17d2d5e5766b07e:-65660a9c:14711d970c3:-8000-00000000000d3eba,1:33309] [APP: soa-infra] [composite_instance_id: 50029] [composite_name: Dell_Zuora_to_Oracle_Invoice_Iface!1.4] [component_name: SFDC] Resource found by location resolver
[2014-07-09T17:47:05.266-07:00] [soa_server22] [WARNING] [] [javax.xml.ws.Service] [tid: orabpel.invoke.pool-4.thread-9] [userId: GOPAL_TARITLA] [ecid: c17d2d5e5766b07e:-65660a9c:14711d970c3:-8000-00000000000d3eba,1:33309] [APP: soa-infra] [composite_instance_id: 50029] [composite_name: Dell_Zuora_to_Oracle_Invoice_Iface!1.4] [component_name: SFDC] Could not read WSDL Definition from URL wsdlDocumentLocation: null
[2014-07-09T17:47:05.718-07:00] [soa_server22] [ERROR] [] [oracle.soa.adapter] [tid: orabpel.invoke.pool-4.thread-9] [userId: GOPAL_TARITLA] [ecid: c17d2d5e5766b07e:-65660a9c:14711d970c3:-8000-00000000000d3eba,1:33309] [APP: soa-infra] [composite_instance_id: 50029] [composite_name: Dell_Zuora_to_Oracle_Invoice_Iface!1.4] [component_name: SFDC] Salesforce Dell_Zuora_to_Oracle_Invoice_Iface:SFDC [ SFDCPortType::query(parameters,parameters) ] Error sending bytes to socket: java.lang.IllegalStateException: Cipher not initialized
[2014-07-09T17:47:05.720-07:00] [soa_server22] [ERROR] [] [oracle.soa.adapter] [tid: orabpel.invoke.pool-4.thread-9] [userId: GOPAL_TARITLA] [ecid: c17d2d5e5766b07e:-65660a9c:14711d970c3:-8000-00000000000d3eba,1:33309] [APP: soa-infra] [composite_instance_id: 50029] [composite_name: Dell_Zuora_to_Oracle_Invoice_Iface!1.4] [component_name: SFDC] JCABinding=> Dell_Zuora_to_Oracle_Invoice_Iface:SFDC [ SFDCPortType::query(parameters,parameters) ] Could not invoke operation 'query' against the 'Salesforce' due to: [[
Error sending bytes: java.lang.IllegalStateException: Cipher not initialized
]]
[2014-07-09T17:47:05.722-07:00] [soa_server22] [NOTIFICATION] [] [oracle.soa.adapter] [tid: orabpel.invoke.pool-4.thread-9] [userId: GOPAL_TARITLA] [ecid: c17d2d5e5766b07e:-65660a9c:14711d970c3:-8000-00000000000d3eba,1:33309] [APP: soa-infra] [composite_instance_id: 50029] [composite_name: Dell_Zuora_to_Oracle_Invoice_Iface!1.4] [component_name: SFDC] JCABinding=> Dell_Zuora_to_Oracle_Invoice_Iface:SFDC [ SFDCPortType::query(parameters,parameters) ] Change logging level to TRACE:n to see full error stack
[2014-07-09T17:47:05.745-07:00] [soa_server22] [ERROR] [] [oracle.soa.adapter] [tid: orabpel.invoke.pool-4.thread-9] [userId: GOPAL_TARITLA] [ecid: c17d2d5e5766b07e:-65660a9c:14711d970c3:-8000-00000000000d3eba,1:33309] [APP: soa-infra] [composite_instance_id: 50029] [composite_name: Dell_Zuora_to_Oracle_Invoice_Iface!1.4] [component_name: SFDC] JCABinding=> [default/Dell_Zuora_to_Oracle_Invoice_Iface!1.4*soa_bee5ce9f-a39a-4023-b5a6-8c13cbcbf2ad.SFDC]:query Two-way operation query() failed
[2014-07-09T17:47:05.748-07:00] [soa_server22] [ERROR] [] [oracle.soa.bpel.engine.ws] [tid: orabpel.invoke.pool-4.thread-9] [userId: GOPAL_TARITLA] [ecid: c17d2d5e5766b07e:-65660a9c:14711d970c3:-8000-00000000000d3eba,1:33309] [APP: soa-infra] [composite_instance_id: 50029] [component_instance_id: 50029] [composite_name: Dell_Zuora_to_Oracle_Invoice_Iface!1.4] [component_name: Dell_Zuora_to_Oracle_Invoice_Iface] got FabricInvocationException[[
java.lang.IllegalStateException: Cipher not initialized
Regards
TV Gopal