Hi ,
I am integrating xMII 11.5.4 and visiprise(oracle Db).
while sending data(Idoc) to visiprise websevice call is failing. The reason is ORA-02019: connection description for remote database not found.
..............................................................................................................................................................................................
[DEBUG]: 00000.62500 End Transaction 'Visiprise/ERPShopFloorIntegration/Inbound/CreateProductionOrderWebService'
[INFO ]: Execution Completed At: 14:36:44 Elapsed Time was 172 mS
[DEBUG]: 00000.62500 End Action ProductionOrderWebServiceCall : (Transaction Call)
[DEBUG]: 00000.62500 Begin Sequence Sequence_26 : ()
[DEBUG]: 00000.62500 Begin Action BuiltXSLTURLForProductionOrder : (Builds and assigns the URL for the response action XSLT.)
[DEBUG]: 00000.62500 End Action BuiltXSLTURLForProductionOrder : (Builds and assigns the URL for the response action XSLT.)
[DEBUG]: 00000.62500 Begin Sequence Sequence_6 : ()
[DEBUG]: 00000.62500 Begin Action SetReturnXMLToLocalAttribute_ProdOrder : (Assigns the Response XML from the webservice to an local attribute.)
[DEBUG]: 00000.62500 End Action SetReturnXMLToLocalAttribute_ProdOrder : (Assigns the Response XML from the webservice to an local attribute.)
[DEBUG]: 00000.62500 End Sequence Sequence_6 : ()
[DEBUG]: 00000.62500 End Sequence Sequence_26 : ()
[DEBUG]: 00000.62500 End Sequence Sequence_17 : ()
[DEBUG]: 00000.62500 End Sequence Sequence_13 : ()
[DEBUG]: 00000.62500 Begin Sequence Sequence_8 : ()
[DEBUG]: 00000.62500 Begin Action LogSOAPResponse : (Logs the SOAP Response)
[DEBUG]: 00000.62500 End Action LogSOAPResponse : (Logs the SOAP Response)
[DEBUG]: 00000.62500 Begin Sequence Sequence_0 : ()
[DEBUG]: 00000.62500 Begin Action RefDocForResponseActionXML : (Reference Document for Response Action XML.)
[DEBUG]: 00000.62500 End Action RefDocForResponseActionXML : (Reference Document for Response Action XML.)
[DEBUG]: 00000.62500 Begin Sequence Sequence_2 : ()
[DEBUG]: 00000.62500 Begin Action SOAPResponseToResponseAction : (Converts the SOAP response to a Response Action XML format.)
[DEBUG]: 00000.64100 End Action SOAPResponseToResponseAction : (Converts the SOAP response to a Response Action XML format.)
[DEBUG]: 00000.64100 Begin Sequence Sequence_9 : ()
[DEBUG]: 00000.64100 Begin Action CheckXSLTTransform : (Checks if the XSLT call succeded or not.)
[DEBUG]: 00000.64100 End Action CheckXSLTTransform : (Checks if the XSLT call succeded or not.)
[DEBUG]: 00000.64100 Begin Sequence Sequence_7 : ()
[DEBUG]: 00000.64100 Begin Action AssignOutputXML : (Assign the output XML from XSLT Transform to a Txn Property.)
[DEBUG]: 00000.64100 End Action AssignOutputXML : (Assign the output XML from XSLT Transform to a Txn Property.)
[DEBUG]: 00000.64100 Begin Sequence Sequence_20 : ()
[DEBUG]: 00000.64100 Begin Action LogResponseAction : (Logs the response action xml.)
[DEBUG]: 00000.64100 End Action LogResponseAction : (Logs the response action xml.)
[DEBUG]: 00000.64100 Begin Sequence Sequence_12 : ()
[DEBUG]: 00000.64100 Begin Action CheckWebServiceStatus : (Checks if the webservice call succeded or not.)
[DEBUG]: 00000.64100 End Action CheckWebServiceStatus : (Checks if the webservice call succeded or not.)
[DEBUG]: 00000.64100 Begin Sequence Sequence_19 : ()
[DEBUG]: 00000.64100 Begin Action TerminateTxnOnWebServiceFailure : (Terminate Transaction when web service call failed.)
[ERROR]: Terminating Transaction Execution...
[ERROR]: STEP EXCEPTION (TerminateTxnOnWebServiceFailure) : WebServiceDelegate.TerminateTxnOnWebServiceFailure: Terminated the txn because of webservice call failure. The failure message is: com.visiprise.frame.webservices.StackTraceRemoteException: java.rmi.RemoteException: null; nested exception is:
Exception Occurred. Exception is javax.ejb.EJBException: nested exception is: java.sql.SQLException: ORA-02019: connection description for remote database not found.
........................................................................................................................................................................................................
Any help is appreciated.
Regards,
Guru.
Edited by: gurunadh kumar on Apr 21, 2010 6:53 PM