Creating new field took some time and still loading

[Tadz]

Hi,

I have this scope application where I'm trying to create a new field with the following details:

Label: Application

Name: application

Type: reference

Reference: Business Application (cmdb_ci_business_app)

Somehow its taking some time to load and still loading. and is not captured in the update set.

What could be the possible reason for this. 

Thanks,

Tads

[Maik Skoddow]

Hi

it depends on the number of records at the table you want to add s new field. In the background an ALTER TABLE Operation has to be performed. And this Operation has to be applied to each records.

And the number of records depends on the physical table in the background. For example if your custom table inherits the task table then the extension is performed on ALL records of all logical child tables.

Maik

[Tadz]

Is there a workaround for this? I already attempted twice. The field is created but the label is missing and it is not captured in the update set.

The transaction was also cancelled.

[Arav]

Hi @Tadz ,

This indicates that the transaction has not gone through completely. Field is created in backend but the associated tables like sys_documentation may not have been updated.

a. Please check if there are performance intensive scripts or transactions running in the instance. If so, address them

b. Delete the field and, before attempting to create it again, run "Debug Business Rules" and start field creation again

c. This will indicate if there are any slow Business rules

d. Troubleshoot logs for the field creation transaction period and look for any errors or slow scripts

Thanks,

Arav

[Arav]

Hi,

Please check "sys_progress_worker" table, identify this transaction, and check the status.

Any error messages will be displayed in column "Error message".

Please note that the dictionary addition will be captured in update set only when the field is created.

Thanks,

Arav