SQL Error '-501' occurred when accessing a custom table

[Former Member]

Hi All,

I have modified two fields ( data length change ) in one custom table.

Now the program gives a short dump saying "SQL Error '-501' occurred when accessing table ZZZZ"

when the control reach to the select statement for this table.

If I remove the "Where" condition in the select statement, it is working fine.

Can you please guide to find the error cause.

If I try to create new entry to this table , then also short dum occurs saying "SQL Error '-302ccurred when accessing a custom table".

Any idea why it is giving short dump???

Thanks,

Sanjeet

[Former Member]

Can any one please have a look on the below issue..

Thanks in advance.

Sanjeet

[Former Member]

Hi,

Have you convert the table using database utility after the change in data length ?

Regards,

Ratheesh

[Former Member]

Can you please suggest how to convert the table ? I am not getting any option as such.

Thanks,

Sanjeet

[joginder_singh]

Hi

Did you given a try using se14.

Once your done with the changes then go to tcode se14. Click on edit after entering the table name and when ur in then click on activate and adjust database ( Be careful that radio button save data is selected ) .

If after doing also if your not able to activate it sucessfully .Please provide me with field name and the length before & length your are changing along with the Type of it.

Cheers

Joginder

[Former Member]

Hi Joginder,

I have done what you have suggested, but it did not work.

There is one table ZZZ in which there are only three fields , all together as the composite primary key.

I have changed the data type of first two fields from CHAR5 to CHAR8, and hence data length being increased from 5 to 8.

Still I am stuck with this issue...

Regards,

Sanjeet

[joginder_singh]

Hi Now i am not able to understand why your facing an issue . Sorry for that i cant help you for this.

I have given a try by creating a table with the below fields

MANDT PRIMARY KEY MANDT

TEXT1 PRIMARY KEY CHAR5

TEXT2 PRIMARY KEY CHAR5

TEXT3 PRIMARY KEY CHAR5

TEXT4 CHAR 5.

then i have entered the some test data in the table .After doing so then i have changed the data type for text1 & text2 fields from char5 to char8. It has activated perfectly fine and able to see the previous data..

Some type of problem cause when it is currrecy fields with decimals .But in case of char i dont thing it should give a problem when ur increasing a length.

Try to have a word with basis person why it is causing an issue .Alterantely u can create a some test table same as what i have created and check the difference . You can solve if you find what is the difference in both.

Cheers

Joginder

[joginder_singh]

Hi

Use SE14 and adjust the table and activate.

Hope this help you to resolve the issue.

Cheers

Joginder