Question Re: Database Comparison Tool Error in Technology Q&A

Database Comparison Tool Error

bgreiman — Tue, 11 Jun 2024 14:22:59 GMT

When we try to compare schema for 2 of our consolidated databases, we get an error: An unknown error has occurred. java.lang.AssertionError

Any idea how to troubleshoot further to resolve?

Thansk, Brian

Re: Database Comparison Tool Error

bgreiman — Tue, 11 Jun 2024 14:23:57 GMT

I should mention we are using v17.0.11.7312 at each database.

Re: Database Comparison Tool Error

chris_keating — Tue, 11 Jun 2024 20:30:27 GMT

Is there a stack that is generated?

Re: Database Comparison Tool Error

bgreiman — Wed, 12 Jun 2024 08:30:38 GMT

This is what shows in the UI: An unknown error has occurred. java.lang.AssertionError

In the Event Viewer: : [13136] 07:26:11 ***ERROR (:0): Java assert: Assertion in sybase.dbcloud.dbdiff.Dbdiff.getStartSyncSchemaChangeStatement(Dbdiff.java:919)

Re: Database Comparison Tool Error

jack_schueler — Wed, 12 Jun 2024 15:20:55 GMT

If it helps, the assertion in dbdiff is "assert !schemaChangeSubscriptions.isEmpty()".

Re: Database Comparison Tool Error

regdomaratzki — Wed, 12 Jun 2024 15:50:54 GMT

Based on the location of the assertion in the code that you provided, the tool has determined that there is a difference between at least one publications that has a synchronization subscription associated with it, but when it goes to iterate through the publication to determine the exact difference so it can generate a START SYNCHRONIZATION SCHEMA CHANGE statement, it doesn't find any real differences and asserts.

We would need the reload.sql generated when you run dbunload -n against the two databases to figure out exactly what's going wrong here.

Reg

Re: Database Comparison Tool Error

bgreiman — Fri, 14 Jun 2024 08:59:30 GMT

Thanks Reg! With this lead, we were able to make some adjustments to publications and synchronization subscriptions and this error does not populate now.