You are viewing limited content. For full access, please sign in.

Question

Question

Can a remote worker agent service more than one data source?

Business Processes Laserfiche Cloud
Updated April 27, 2023
asked on April 13, 2023 • Show version history

I have deployed a Remote Worker Agent on a Server to Service SQL queries from a On prem SQL Server. It worked well with a single data source configured. I seem to be having issues getting configuring a Second DataSource Configured for the same Remote Worker Agent to Service. The second data source is on a Different SQL Server.  Any suggestions or comments would be appreciated.

Best 

Milton 

0 0

Replies

replied on April 13, 2023

Hey Milton,

You should be able to use the same remote agent for multiple data sources.

Is the second source on the same host as the first server? If it's hosted on a different machine, does the remote agent worker have the necessary permissions/ports open to access the second data source? 

-Kevin Roberts

0 0
View 1 previous reply
replied on April 14, 2023

The SQL Database I was trying to connect to was about 4GB and had tones of Tables.  It was constantly trimming out trying to Validate the connection. I finally Created a Smaller Database with only the Table data that I needed and was able to connect.

I guess that this is a workaround if you have very large datasets or Lots of Tables. Makes this function a little limited unless you are good a SQL and can create this smaller subset of the database to present to the Remote Agent. Would be nice to have some guidance on the limitations of this function.

Thanks for your reply,

Milton

0 0
replied on April 14, 2023

How many tables approximately?

Remote Agent does try to pull the table list for the database, so that's plausibly where the timeout occurred. The size of the database shouldn't matter for the connection step.

0 0
replied on April 14, 2023

At least a couple of thousand tables.  Anyway, it looks like Queries / Rules that potentially bring back allot of Results could affect the Cloud BP Engine and could be a problem. It may be best to test the Queries in SQL to see if you get the subset of data you are looking for. If your query is too broad and brings back Millions of results this will be a problem for you and will certainly affect Performance.

0 0
replied on April 14, 2023

Using the Test function in the Rule Creator is Ok if you have first tested the criteria in a SQL query and are simply confirming the Remote Agent connectivity and results from the rules UI in Cloud.  

1 0
replied on April 25, 2023

Just FYI. do not try to connect to a local SQL db with thousands of tables. it will time out trying to connect, but it also has the potential of taking the BP Engine down or taxing it tremendously. Hopefully Dev can mitigate this problem in the near future.

0 0
replied on April 27, 2023 • Show version history

We'll be looking to support larger sized data sources in the coming release. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...