Azure DB for PostgreSQL mirroring

[felicial]

I have configured replication to Fabric for an Azure Database for PostgreSQL server and I keep getting "Internal system error occurred. ArtifactId: XXXXXX" and none of the tables replicate. What is the problem and where can I see some more info?

[v-sdhruv · Accepted solution]

Hi @felicial ,

The error typically indicates that something failed within the Fabric Data Factory pipeline or the Dataflow Gen2 process. You can follow these checks -
1.Check the Fabric Workspace Diagnostic Logs- Look for the specific run and click into it. If it still says only "Internal system error, then

2. Check Schema Compatibility in PostgreSQL-tick to basic types like int, text, boolean, timestamp, etc., and lowercase names.

3.Run Diagnostic Query in Fabric SQL Endpoint:
SELECT *
FROM INFORMATION_SCHEMA.TABLES

Additionally, you can visit for more details.
https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-database-postgresql-troubl...

If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You