Database Comparison Tool Error

[bgreiman]

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

[bgreiman]

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

[chris_keating]

Is there a stack that is generated?

[bgreiman]

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)

[jack_schueler]

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

[regdomaratzki]

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

[bgreiman]

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