[BTS] BizTalk Oracle Adapter Error 01

 

Log name: Application
Source: XLANG/s
Date: 13:41:56 event ID: 10034
Task Type: NO level: Error Keyword: Classic User:
Computer missing: BTS2010
Description: xlang/s engine event log entry: Uncaught exception (see the 'inner exception' below) has suincluded an instance of service' XZSoftware. oracle. bizTalk. getEmployeeProcess (ae8d5556-0664-d7d8-0af5-d0b7d7dfa7d8 )'. the service instance will remain susponded until administratively resumed or terminated. if resumed the instance will continue from its last persisted state and may re-throw the same unexpected exception. instanceId: af0741a2-79c9-4895-9825-73b318cb66a8 Shape name: ShapeId: Exception thrown from: segment-1, progress-1 Inner exception: An error occurred while processing the message, refer to the details section for more information Message ID: {6B79479E-1BDB-4AFF-A0C6-16B8F56115CC} Instance ID: {966C9DD4-FD60-4D82-8621-D963A84362E5} Error Description: Microsoft. serviceModel. channels. common. metadataException: Metadata resolution failed for OperationId: "http://Microsoft.LobServices.OracleDB/2007/03/HR/Table/EMPLOYEES/Select ". ---> 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 ---

Server stack trace: at System. runtime. asyncResult. end [TAsyncResult] (IAsyncResult result) at System. serviceModel. channels. serviceChannel. sendAsyncResult. end (SendAsyncResult result) at System. serviceModel. channels. serviceChannel. endCall (String action, Object [] outs, IAsyncResult result) at System. serviceModel. channels. serviceChannel. endRequest (IAsyncResult result)

Exception rethrown at [0]: at System. runtime. remoting. proxies. realProxy. handleReturnMessage (IMessage reqMsg, IMessage retMsg) at System. runtime. remoting. proxies. realProxy. privateInvoke (MessageData & msgData, Int32 type) at System. serviceModel. channels. IRequestChannel. endRequest (IAsyncResult result) at Microsoft. bizTalk. adapter. wcf. runtime. wcfClient '2. requestCallback (IAsyncResult result)

Exception type: XlangSoapException Source: Microsoft. XLANGs. bizTalk. engine Target Site: Void VerifyTransport (Microsoft. XLANGs. core. envelope, Int32, Microsoft. XLANGs. core. context) The following is a stack trace that identifies the location where the exception occured

At Microsoft. bizTalk. XLANGs. BTXEngine. BTXPortBase. verifyTransport (Envelope env, Int32 operationId, Context ctx) at Microsoft. XLANGs. core. subtasks. receive (Segment s, Context ctx, Envelope & env, Boolean topOnly) at Microsoft. XLANGs. core. portBase. getMessageId (subpartition, Segment currentSegment, Context cxt, Envelope & env, CachedObject location) at XZSoftware. oracle. bizTalk. getEmployeeProcess. segment1 (StopConditions stopOn) at Microsoft. XLANGs. core. segmentScheduler. runASegment (Segment s, StopConditions stopCond, Exception & exp)

Event Xml: <Event xmlns = "http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name = "XLANG/s"/> <EventID Qualifiers = "0"> 10034 </EventID> <Level> 2 </Level> <Task> 0 </Task> <Keywords> 0x80000000000000 </Keywords> <TimeCreated SystemTime = "2013-06-16T05: 41: 56.000000000Z "/> <EventRecordID> 3172 </EventRecordID> <Channel> Application </Channel> <Computer> BTS2010 </Computer> <Security/> </System> <EventData> <data> xlang/s engine event log entry: uncaught exception (see the 'inner exception' below) has suincluded an instance of service' XZSoftware. oracle. bizTalk. getEmployeeProcess (ae8d5556-0664-d7d8-0af5-d0b7d7dfa7d8 )'. the service instance will remain susponded until administratively resumed or terminated. if resumed the instance will continue from its last persisted state and may re-throw the same unexpected exception. instanceId: af0741a2-79c9-4895-9825-73b318cb66a8 Shape name: ShapeId: Exception thrown from: segment-1, progress-1 Inner exception: An error occurred while processing the message, refer to the details section for more information Message ID: {6B79479E-1BDB-4AFF-A0C6-16B8F56115CC} Instance ID: {966C9DD4-FD60-4D82-8621-D963A84362E5} Error Description: Microsoft. serviceModel. channels. common. metadataException: Metadata resolution failed for OperationId: "http://Microsoft.LobServices.OracleDB/2007/03/HR/Table/EMPLOYEES/Select ". --- & gt; 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 ---

Server stack trace: at System. runtime. asyncResult. end [TAsyncResult] (IAsyncResult result) at System. serviceModel. channels. serviceChannel. sendAsyncResult. end (SendAsyncResult result) at System. serviceModel. channels. serviceChannel. endCall (String action, Object [] outs, IAsyncResult result) at System. serviceModel. channels. serviceChannel. endRequest (IAsyncResult result)

Exception rethrown at [0]: at System. runtime. remoting. proxies. realProxy. handleReturnMessage (IMessage reqMsg, IMessage retMsg) at System. runtime. remoting. proxies. realProxy. privateInvoke (MessageData & amp; msgData, Int32 type) at System. serviceModel. channels. IRequestChannel. endRequest (IAsyncResult result) at Microsoft. bizTalk. adapter. wcf. runtime. wcfClient '2. requestCallback (IAsyncResult result)

Exception type: XlangSoapException Source: Microsoft. XLANGs. bizTalk. engine Target Site: Void VerifyTransport (Microsoft. XLANGs. core. envelope, Int32, Microsoft. XLANGs. core. context) The following is a stack trace that identifies the location where the exception occured

At Microsoft. bizTalk. XLANGs. BTXEngine. BTXPortBase. verifyTransport (Envelope env, Int32 operationId, Context ctx) at Microsoft. XLANGs. core. subtasks. receive (Segment s, Context ctx, Envelope & amp; env, Boolean topOnly) at Microsoft. XLANGs. core. portBase. getMessageId (subpartition, Segment currentSegment, Context cxt, Envelope & amp; env, CachedObject location) at XZSoftware. oracle. bizTalk. getEmployeeProcess. segment1 (StopConditions stopOn) at Microsoft. XLANGs. core. segmentScheduler. runASegment (Segment s, StopConditions stopCond, Exception & amp; exp)

</Data> </EventData> </Event>