We had a requirement in our project to bulk insert in to tables of an oracle DB, so we have developed an orchestration which process the incoming message and sends the data to Oracle DB using a WCF-Oracle adapter,on the send port where we have set the “ambient transaction” property to true, as we need to revert back in case of any error while inserting in to any of the tables, but at this point we are getting an error as shown below.
Error Description: Microsoft.ServiceModel.Channels.Common.MetadataException: Metadata resolution failed for OperationId: "http://Microsoft.LobServices.OracleDB/2007/03/Server alias name /Table/Name of the table /Insert". ---> Microsoft.ServiceModel.Channels.Common.ConnectionException: Due to an Oracle Client limitation, the adapter failed to open a connection. This is because either (a) ambient transaction is present and the TNS alias is longer than 39 characters, or (b) ambient transaction is present and a non-TNS based URI was used. To resolve this, use a TNS alias to connect to Oracle and make sure it is not more than 39 characters. at Microsoft.Adapters.OracleDB.OracleDBConnection.OpenConnection(OracleCommonExecutionHelper executionHelper) --- End of inner exception stack trace
We have checked the TNS alias name in the TNSNames.ora which is just 6 characters long ,so that is also ruled out can anyone please help us in resolving this issue, if you need more information please reach me on 7829692692.
Thanks & Regards,