Troubleshooting

The following troubleshooting tips might help you resolve issues with this Micro-Integration. If problems persist, contact Solace.

Connection and Authentication Errors

If the Micro-Integration fails to connect to the target Microsoft SQL Server database:

  • Verify that the db.hostname, db.port-number, db.database-name, db.user, and db.password properties are correct.

  • If you connect over TLS, verify that db.encrypt matches your server's TLS configuration. If your server uses a self-signed certificate, set db.trust-server-certificate to true, or configure db.trust-store and db.trust-store-password for custom certificate authority validation.

  • Confirm that the database user has SELECT privileges on the target table. The Micro-Integration reads column metadata from the target table at startup and fails to start if it cannot.

Destination Not Found or Misconfigured Errors

If the Micro-Integration logs errors indicating that the target table or destination cannot be found:

  • Verify that the destination is in the format schema.table (for example, dbo.customers) and that the table already exists. The Micro-Integration does not create tables automatically.

  • If you use dynamic destinations, verify that the scst_targetDestination header value uses the dot-separated format schema.table.primaryKey, with a comma-separated list of column names if the primary key is composite.

Write Failures

If the Micro-Integration logs errors while writing to the target table:

  • Verify that the configured primary key column or columns exist in the target table and match its actual primary key.

  • Confirm that the database user has INSERT and UPDATE privileges on the target table. The default UPSERT operation uses a SQL MERGE statement, which requires both.

  • Check that the message payload is valid JSON. The Micro-Integration does not support XML payloads for Microsoft SQL Server targets.

Error Output and Logging

Review the application logs for specific error messages, such as connection errors, SQL exceptions, or authentication failures.