- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2024 12:33 AM
Hello everyone,
I had to add 3 fields in the table "cmn_cost_center", while in development and test instances i didn't had any issue, I got errors when committing update set to PROD instance.
I got these errors :
It created me the fields but the column label where empty, when i try to fill them it delete what I put automatically.
I deleted the fields and created them, I got these errors
when i look for the label active, and I do "show matching" it finds it and in the filter we can see the name of the field
when I export the fields with xml getting same errors
Did anyone got these kind of errors, any help would be welcome
Thank you all
Best regards
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2024 07:01 AM
For information,
my team raised a case for servicenow and the solution was this :
Issue:
You are unable to create a new dictionary entry in the “cmn_cost_center” table.
When you attempt to add the column you get the below error:
(conn=136513) ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY”
Most Probable Cause:
You are running into this issue because your instance is attempting to use ‘instant alter’ to modify the table when adding the column.
The ‘instant alter’ feature was recently enabled on all eligible instances where the previous default for the property was ‘false’.
However, not all tables can be modified by using the ‘instant alter’ method and there is currently a known issue where the system does not fall back to the ‘online alter’ method when this occurs.
The issue has been recorded through PRB1672320 and is listed to be fixed in the following versions:
- Vancouver Patch 6
- Washington DC
As a workaround, kindly change the value from ‘true’ to ‘false’ for the ‘glide.db.instant_alter.enabled’ system property and retry adding the column.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2024 07:01 AM
For information,
my team raised a case for servicenow and the solution was this :
Issue:
You are unable to create a new dictionary entry in the “cmn_cost_center” table.
When you attempt to add the column you get the below error:
(conn=136513) ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY”
Most Probable Cause:
You are running into this issue because your instance is attempting to use ‘instant alter’ to modify the table when adding the column.
The ‘instant alter’ feature was recently enabled on all eligible instances where the previous default for the property was ‘false’.
However, not all tables can be modified by using the ‘instant alter’ method and there is currently a known issue where the system does not fall back to the ‘online alter’ method when this occurs.
The issue has been recorded through PRB1672320 and is listed to be fixed in the following versions:
- Vancouver Patch 6
- Washington DC
As a workaround, kindly change the value from ‘true’ to ‘false’ for the ‘glide.db.instant_alter.enabled’ system property and retry adding the column.