BluAge - L3 Workshop - org.hsqldb.HsqlException: type not found or user lacks privilege: BIGSERIAL

The error you're encountering during the Tomcat server startup in the BluAge L3 Workshop is related to a database schema creation issue. Specifically, the error message indicates that the database doesn't recognize the "BIGSERIAL" data type.

This problem is likely occurring because the workshop environment is using HSQLDB (Hyper SQL Database), which doesn't support the BIGSERIAL data type. BIGSERIAL is typically used in PostgreSQL, but HSQLDB has different data type conventions.

To resolve this issue, you should check the database configuration in your project. It's possible that the database dialect or configuration is set for PostgreSQL, while the actual database being used is HSQLDB. You may need to adjust the database configuration to match the HSQLDB syntax.

Here are a few steps you can try:

1. Review your database configuration files (like application.properties or application.yml) and ensure they are set up correctly for HSQLDB.

2. If you have control over the schema creation scripts, consider replacing BIGSERIAL with a compatible HSQLDB data type. For example, you might use "BIGINT GENERATED BY DEFAULT AS IDENTITY" instead of BIGSERIAL.

3. Check if there's an option to use a different database that supports BIGSERIAL, such as PostgreSQL, if that's what the workshop intends.

4. Verify that all required datasources (jics, bluesam, bac, primary) are correctly configured and that the database server is running properly.

If the issue persists after trying these steps, you may need to consult the workshop documentation for any specific instructions related to database setup, or reach out to the workshop support for further assistance.
Sources
AWS Blu Age L3 workshop - Automation step error | AWS re:Post
AWS BluAge L3 Workshop : bac.war causing issues in loading KSDS files to postgres | AWS re:Post