Oozie - Is it OK to modify its database?

[#1]

hi We've got the following error:

org.apache.openjpa.persistence.PersistenceException: ERROR: value too long for type character varying(255) {prepstmnt 190305649 INSERT INTO WF_JOBS (id, app_name, app_path, conf, created_time, end_time, external_id, group_name, last_modified_time, log_token, parent_id, proto_action_conf, run, sla_xml, start_time, status, user_name, wf_instance) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=0, state=22001]

and to solve it we've altered the WF_JOBS table, resizing the app_path and app_name to be varchar(1024).

Is it acceptable to modify the oozie database?

Will it cause us problems in other parts of oozie?

We did while using postgreSQL for oozie db.

Thanks

Doron

[#2 · Accepted solution]

@Doron Veeder

I would have done the same thing to fix the issue. This is a minor alteration. I won't change column names or anything drastic.