When running Flux 7.0 and Sybase together if you receive the error:

Invalid column name 'CREATION'. com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'CREATION'.

The issue may be coming from your FLUX_LOGGING, and FLUX_LOCK table.

Could you:

1. Check to make sure FLUX_LOCK table exists

2. Update your FLUX_LOGGING table to include the CREATION (CREATION DATETIME NOT NULL) and MESSAGE (MESSAGE TEXT NOT NULL) columns:

CREATE TABLE FLUX_LOGGING(PK NUMERIC(18,0) IDENTITY, ENGINE VARCHAR(200) NOT NULL, USERNAME VARCHAR(200), GROUPNAME  VARCHAR(200), NAMESPACE VARCHAR(200), LOGGER_TYPE VARCHAR(200) NOT NULL, LOGGING_LEVEL VARCHAR(200) NOT NULL, CREATION DATETIME NOT NULL, MESSAGE TEXT NOT NULL);

3. Update your FLUX_LOCK table to index on CREATION instead of CREATION_TIME:

CREATE INDEX FLUX_LOCK3 on FLUX_LOCK(CREATION)