Support Questions
Find answers, ask questions, and share your expertise

Oozie - Is it OK to modify its database?

Solved Go to solution

Oozie - Is it OK to modify its database?

Explorer

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

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

View solution in original post

1 REPLY 1

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

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

View solution in original post