Skip to Content
avatar image
Former Member

Value for column or variable too long.

I have to increase the size of a field from numc05 to munc9.When i change in the domain and adjust the database its giving a runtime error saying "Value for column or variable ZZIP too long."ZZIP is my filed name.

Sometimes its activating the table and when i create entries its giving a runtime error.

If i create a new table(some Z table ) and change the data element its working absolutely fine.

What is the meaning of this error?Thhere are only 500 entries in Dev and I'm on version 4.0B.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    May 09, 2006 at 06:04 PM

    After changing and activating your data element/Domain goto se14, give your table name then select the button edit button. on the next screen click on the "activate & Adjust database". It will work.

    Hope this helps.

    Regards,

    Nagaraju Chidurupalli

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2006 at 06:14 PM

    As i already mentioned I'm getting the error when I'm adjusting the database in SE14.Am i missing something here

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2006 at 06:43 PM

    Hi Sirisha,

    What do you mean by "sometimes its activating the table" ? Assuming that it is activating some times, did you re-do the table maintenance generation after you changed the domiain? if not, delete the screen which you have generated in screen maintenance and then create a new one to adjust to the new table.

    Hope this will of some help to you.

    regards,

    vicky

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI Vicky,

      Thanks for the suggestion.

      I tried but still its' giving a dump.

      I totally removed the table maint screen and tried creating entries but it's not saving and if create table maint gen its giving a runtime error.

  • avatar image
    Former Member
    May 09, 2006 at 07:21 PM

    Hi Sirisha,

    Try looking at your existing table entries. Maybe there are values that are bigger than the the new domain you assign. I assume your are changing from NUMC 05 to NUMC 09, which should not cause problem during the conversion, but do check your data.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2006 at 07:27 PM

    Please do the following things.I’m assuming you have changed your domain to NUMC09. You did not make any view for that table right?

    - Activate the domain

    -Activate the data element

    -Activate the table

    -Adjust table in SE14

    Still if you’re getting short dump. Can you please post that short dump?

    Hope this’ll give you idea!!

    <b>P.S award the points.</b>

    Good luck

    Thanks

    Saquib Khan

    "Some are wise and some are otherwise"

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Sirisha,

      Other suggestion would be to download all the data with a small Z-program(your custom program) and then go to SE14 and while editing select "Delete data" while doing the change with Activate and adjust database.

      Once the table is adjusted and activated, upload the data to the table.

      Hope this is not the last resort but as you said you have only 500 records, I thought this will be of some help.

      But make sure to download the data before deleting it.

      Regards,

      Vicky

      PS: Award points if helpful.