Scribe Labs Lookup Table Connector - On-premise agent connection error every 2-3 hours

Hi,

 

I have a solution running every minute. I have just started using the Lookup Table Connector a few days ago, and ever since, every two hours or so execution errors out with a "Fatal Error: Failed to open one or more connections: Unable to get the tables. Unable to get the tables. "

 

It doesn't even have any records to process at the time, and I think it errors out when initializing the map.

 

Is this normal for the Lookup Table Connector to have such connectivity issues?

 

Below is an excerpt from Scribe Agent's logs showing the error as well.

 

 

 

---------------------------------------

----------------------------------------

Timestamp: 12/3/2017 12:08:54 AM

 

Severity: Error

 

Title:Scribe.Core.Processor.ConnectManager

 

Win32 ThreadId:11228

 

Message: Unable to open connection for Map 3f809556-75c4-4dbd-b8d7-04ed1574efcd. ConnectionId=a091a8a6-e85e-4287-9002-a35a0a3be6de MapConnectionId=84b95a4d-e591-4a83-af16-a2640af4ba39 AdapterTypeId=fac75ac0-09b4-4824-89ee-97794bd1537e

Exception Type : InvalidConnectionException 

Message : Unable to get the tables. 

StackTrace :  at ScribeLabs.Connector.Lookup.Core.Connector.Connect(IDictionary`2 properties)

  at Scribe.Core.Access.Connection..ctor(IConnector adapterInstance, IDictionary`2 connectionProperties)

  at Scribe.Core.Access.Engine.Connect(Guid adapterTypeId, IDictionary`2 connectionProperties)

  at Scribe.Core.Processor.ConnectManager.GetNewConnection(Guid connectionInfoDbId)

  at Scribe.Core.Processor.ConnectManager.GetConnection(Guid connectionInfoDbId, Guid processDefinitionConnectionId)

  at Scribe.Core.Processor.ProcessSupport.GetConnectionDirect(Guid connectionInfoDbId, Guid processDefinitionConnectionId)

  at Scribe.Core.Processor.ConnectManager.BackgroundConnect(Object state) 

--- Inner Exception --- 

Type : InvalidOperationException 

Message : Unable to get the tables. 

StackTrace :  at ScribeLabs.Connector.Lookup.Service.Client..ctor(String user, String pw, String baseUrl, Int32 orgId)

  at ScribeLabs.Connector.Lookup.Core.LookupConnectorType.Connect(IDictionary`2 properties)

  at ScribeLabs.Connector.Lookup.Core.Connector.Connect(IDictionary`2 properties) 

 

 

 

----------------------------------------

----------------------------------------

Timestamp: 12/3/2017 12:08:54 AM

 

Severity: Error

 

Title:Scribe.Core.Processor.Executions.ProcessExecutor

 

Win32 ThreadId:8632

 

Message: The process 'a0391dde-49d5-4b02-aa67-8461e3f23807' completed with an exception: Exception Type : FatalErrorException 

Message : Failed to open one or more connections: Unable to get the tables.

Unable to get the tables.

 

StackTrace :  at Scribe.Core.Processor.ConnectManager.ConnectAll(HashSet`1 processDefinitionIds, ProcessSupport processSupport)

  at Scribe.Core.Processor.SysProcessSupport.ConnectAll(HashSet`1 processDefinitionIds)

  at Scribe.Core.Processor.Executions.ProcessExecutor.OpenConnections(Guid processDefinitionId, ProcessSupport processSupport)

  at Scribe.Core.Processor.Executions.ProcessExecutor.OpenConnections(ProcessDefinition processDefinition)

  at Scribe.Core.Processor.Executions.ProcessExecutor.ExecuteProcess() 

 

 

 

Login