Forum Discussion
Azure DB for PostgreSQL mirroring
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?
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, then2. 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-troubleshoot
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
1 Reply
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, then2. 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-troubleshoot
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