Connection description for remote database not found

[Former Member]

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

[Former Member · Accepted solution]

Gurunadh,

Which version of Visiprise you are using?

[Former Member · Accepted solution]

Hi ,

Visiprise 4.3.2

Regards,

Guru.

[agentry_src · Accepted solution]

Guru,

SAP-ME now has their own Forum. So questions regarding the Visiprise - MII - Database connections would probably be better posed there.

If you do post your question there, please post a link back in this thread so those of us familiar with both applications can monitor it as well.

Regards,

Mike

[Former Member · Accepted solution]

Thanks for giving the information Michael.

Regards,

Guru.

[Former Member]

What is the status of the Oracle DB dataserver connection in MII?