# Database-BadTableMapping-KeyPropertyTooBig - Column length has been increased and DB Table/Class saved

**URL:** <https://forums.pega.com/t/database-badtablemapping-keypropertytoobig-column-length-has-been-increased-and-db-table-class-saved/5326>\
**Category:** General\
**Tags:** installation-and-deployment, 8-8-2, data-model\
**Created:** [November 6, 2023, 11:08am UTC](https://forums.pega.com/t/database-badtablemapping-keypropertytoobig-column-length-has-been-increased-and-db-table-class-saved/5326 "2023-11-06T11:08:08Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![KOMARINA](https://avatars.discourse-cdn.com/v4/letter/k/df788c/32.png) [@KOMARINA](https://forums.pega.com/u/KOMARINA)\
**Post date:** [November 6, 2023, 11:08am UTC](https://forums.pega.com/t/database-badtablemapping-keypropertytoobig-column-length-has-been-increased-and-db-table-class-saved/5326/1 "2023-11-06T11:08:08Z")

</div>

Hi,

Greetings. I am getting the below error, i have increased the column size to 256 and also re-saved Database Table mapping as well as class instance

Database-BadTableMapping-KeyPropertyTooBig PXINSNAME PegaDATA pr\_perf\_stats 128 132

Is there anything else i should be doing?

I am on Pega 8.8.2 (containarized deployments)

Regards,  
Bharat

---

<div class="post-metadata">

**Author:** ![Bhumireddy](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/bhumireddy/32/23248_2.png) [@Bhumireddy](https://forums.pega.com/u/Bhumireddy)\
**Post date:** [November 6, 2023, 12:28pm UTC](https://forums.pega.com/t/database-badtablemapping-keypropertytoobig-column-length-has-been-increased-and-db-table-class-saved/5326/2 "2023-11-06T12:28:16Z")

</div>

Hi @KOMARINA

My understanding is that you can’t increate the size of the colom.

When updating or overriding a property that has a Max Length defined, you can enter a smaller Max Length value but not a larger value.

Please refer below articles

> **[Property form Completing the Advanced tab](https://community.pega.com/sites/default/files/help_v73/rule-/rule-obj-/rule-obj-property/advanced.htm)**

[https://support.pega.com/question/increase-max-length-property](https://support.pega.com/question/increase-max-length-property)

Thanks,

Ashok

---

<div class="post-metadata">

**Author:** ![KOMARINA](https://avatars.discourse-cdn.com/v4/letter/k/df788c/32.png) [@KOMARINA](https://forums.pega.com/u/KOMARINA)\
**Post date:** [November 6, 2023, 12:30pm UTC](https://forums.pega.com/t/database-badtablemapping-keypropertytoobig-column-length-has-been-increased-and-db-table-class-saved/5326/3 "2023-11-06T12:30:24Z")

</div>

@Bhumireddy Thank you but pxInsName has no length defined within Pega. Increased length can be seen via Modify Schema wizard within Pega, just that error is still being trhown on old/original length.

Regards,

Bharat

---

<div class="post-metadata">

**Author:** ![Bhumireddy](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/bhumireddy/32/23248_2.png) [@Bhumireddy](https://forums.pega.com/u/Bhumireddy)\
**Post date:** [November 6, 2023, 12:40pm UTC](https://forums.pega.com/t/database-badtablemapping-keypropertytoobig-column-length-has-been-increased-and-db-table-class-saved/5326/4 "2023-11-06T12:40:51Z")

</div>

Hi @KOMARINA,

Could you please give a try by using below activity.

**CL:Code-Pega-DB-Column**  **ID:pzUpdateColumnLength**

Can you try the following after increasing the column in the schema

1. Open the class rule form

2. Do a test connection

3. Save the class rule form

4. Open Data-Admin-DB-Table instance of the class

5. Do a test connection

6. Save the Data-Admin-DB-Table instance

Thanks,

Ashok

---

<div class="post-metadata">

**Author:** ![KOMARINA](https://avatars.discourse-cdn.com/v4/letter/k/df788c/32.png) [@KOMARINA](https://forums.pega.com/u/KOMARINA)\
**Post date:** [November 6, 2023, 1:44pm UTC](https://forums.pega.com/t/database-badtablemapping-keypropertytoobig-column-length-has-been-increased-and-db-table-class-saved/5326/5 "2023-11-06T13:44:22Z")

</div>

@Bhumireddy We are using Oracle, i do not see a way to execute this activity standalone however column length has been increased and can be seen via Modify Schema. I did do re-save of class and database table.

Regards,

Bharat

---

<div class="post-metadata">

**Author:** ![KOMARINA](https://avatars.discourse-cdn.com/v4/letter/k/df788c/32.png) [@KOMARINA](https://forums.pega.com/u/KOMARINA)\
**Post date:** [November 7, 2023, 12:17am UTC](https://forums.pega.com/t/database-badtablemapping-keypropertytoobig-column-length-has-been-increased-and-db-table-class-saved/5326/6 "2023-11-07T00:17:35Z")

</div>

Clearing the Conclusion Cache from Admin Studio for type “property” resolved the issue.
