Error processing Import on item - a form

[xren]

Hi,

When I import a project from my dev server to production server, one of the form cannot be imported, all others are fine including scripts for this failed form. The error is:

Error inserting client callable function record ORA-00001: unique constraint (EBASE_UFS.CLIENT_CALLABLE_FUNCTIONS_PK) violated.

There is no such form in other projects.

How can this be fixed?

Thanks
Xiaoli

[Hovik]

Hello Xiaoli,

There is an error in the script which creates the repository from scratch.

The following 2 DDL commands will correct the error in your production system.

Code: Select all

drop index client_callable_functions_pk;
create unique index client_callable_functions_pk on client_callable_functions(FORM_ID, SCRIPT_LANGUAGE, SCRIPT_NAME, POSITION);

Please confirm once you can import your form.

[Hovik]

Correction to the previous post:

There is no need for a unique index any longer. In fact, any unique index may present the same issue, so the DDL you need to run is:

Code: Select all

drop index client_callable_functions_pk;