As of 6.0, bpchar causes some transitions to fail with "Element does not exist"

[KatrinaHuberJuma]

trafficstars

This error occurs with the sample Postgres database, even when created with current product but using old SRA.

[valhuber]

A specific example is the transition to see Customer Detail (appears to be any customer).

[valhuber]

This is due to use of the bpchar datatype - blank padded character, more fully described in this SQLAlchemy issue.

As a work-around, it can be resolved by editing the created model file, like this:

We are considering a more fully comprehensive solution.

[valhuber]

A revised docker image has been created that resolves this as described here.

[pthom]

See https://github.com/pthom/northwind_psql/commit/4aa7967a33b84e693db56d4c23ada410a3ff04a6 which fixes the issue inside the northwind example