Forum Discussion

felicial's avatar
felicial
Microsoft Employee
1 year ago
Solved

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 t...
  • v-sdhruv's avatar
    1 year ago

    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-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