Skip to main content

Knowledge Base
Knowledge Base
17 followers
11 questions
89 posts

Do you have questions about Knowledge Base?

Log in to ask questions about Knowledge Base publicly or anonymously.

Fathia JamaSemarchy Team
Sr. Customer Success Consultant at Semarchy

How to Correctly Configure Postgres Search Path

When installing Semarchy on a PostgreSQL database, customers sometimes run into errors like this:

+- ERROR: function uuid_generate_v1() does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts.

This error can occur when the search path in the database is not correctly configured.

Do you have a search_path problem?

The above error will be thrown if:

  • The function does not exist.
  • The function exists, but you do not have access to it.
  • The function exists, and you have access, but it is not in the search_path.
/* First confirm... (More)
David JonesSemarchy Team
Technical Client Success Manager at Semarchy

Configuring Conditional Validation

The purpose of this article is to explain and illustrate configuration steps for conditional validation. In the context of the article, conditional validation refers to an operation whereby validation for a secondary attribute is triggered/enabled when a condition on a primary attribute is met. The article extends concepts covered in our official Application Design Guide, and utilizes the best practice of combining a form validation (which shows useful information but is non-blocking) with a step validation (blocking), used when the user should be forced to fix an issue before proceeding.

In many cases, a Semarchy user may want to... (More)

Anna RiderSemarchy Team
Customer Success Consultant at Semarchy

Business View "Transitions": What's the difference between "Create New Business Entity" and "Use Existing Business Entity"?

When you create a new Business View for an entity, this Business View allows you to display data to business users in the front-end application.

In Business Views, you can add Transitions. A Transition allows you to add child entities and other objects so that you can provide more information to the business user.

What's a Transition?

For example, if your Business View is for Customers, you could add a transition to the child entity Addresses. This transition will allow the business user to browse Customers and then see all the Addresses linked to that particular customer record.

Other examples... (More)

Fathia JamaSemarchy Team
Sr. Customer Success Consultant at Semarchy

How to create a custom Job to run in Duplicate Managers

By default when creating and configuring Duplicate Managers a pre-defined Semarchy job is triggered starting with the prefix DUJ. This Semarchy job contains tasks that are not necessary for a duplicate manager to run, and can sometimes slow the performance of your batch job. If you are experiencing slowness when Confirming Matches, Merging Suggestion, or other related Duplicate Managers tasks, then creating a custom job can help to improve batch performance. In this guide we will remove the Delete tasks from Duplicate Managers, which add unnecessary extra time to your batch process.

Create a Custom Job

  • Navigate to the... (More)