I’m trying to create some custom fields for the SalesContract LU. I understand that I have to activate the rowkey before I can publish the new fields.
When I try to use the Direct option to activate the RowKey for the SalesContract LU, it aborts after 30 minutes. I put the debug on and it shows “java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation.
If I use the Background Job option, it gives me a popup application information message: “Request Aborted”, but the background job still appears in the list of jobs with a state of “executing”. I can’t stop/kill it without asking the DBA to get involved.
There’s only 3 Sales Contracts in the instance. Why is the job taking so long and where do we adjust the timeout so it can run longer without stopping?