Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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

asked 11 Jun, 14:22

bgreiman's gravatar image

bgreiman
400182028
accept rate: 20%

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

(11 Jun, 14:23) bgreiman

Is there a stack that is generated?

(11 Jun, 20:30) Chris Keating

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)

(12 Jun, 08:30) bgreiman

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

(12 Jun, 15:20) JBSchueler

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

permanent link

answered 12 Jun, 15:50

Reg%20Domaratzki's gravatar image

Reg Domaratzki
7.9k343119
accept rate: 36%

edited 14 Jun, 08:53

2

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

(14 Jun, 08:59) bgreiman
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×3

question asked: 11 Jun, 14:22

question was seen: 259 times

last updated: 14 Jun, 08:59