Oozie - Is it OK to modify its database?

doronve — Sun, 22 May 2016 17:42:59 GMT

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

Re: Oozie - Is it OK to modify its database?

nsabharwal — Sun, 22 May 2016 18:02:24 GMT

@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.

question Oozie - Is it OK to modify its database? in Archives of Support Questions (Read Only)

Oozie - Is it OK to modify its database?

Re: Oozie - Is it OK to modify its database?