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

[KatrinaHuberJuma]

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 pthom/northwind_psql@4aa7967 which fixes the issue inside the northwind example