topic Re: SQL Error '-501' occurred when accessing a custom table in Application Development and Automation Discussions

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

Former Member — Tue, 23 Dec 2008 08:33:13 GMT

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

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

Former Member — Tue, 23 Dec 2008 11:41:30 GMT

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

Thanks in advance.

Sanjeet

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

Former Member — Tue, 23 Dec 2008 13:16:25 GMT

Hi,

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

Regards,

Ratheesh

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

joginder_singh — Tue, 23 Dec 2008 13:33:14 GMT

Use SE14 and adjust the table and activate.

Hope this help you to resolve the issue.

Cheers

Joginder

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

Former Member — Wed, 24 Dec 2008 11:18:30 GMT

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

Thanks,

Sanjeet

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

joginder_singh — Wed, 24 Dec 2008 11:24:43 GMT

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

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

Former Member — Wed, 24 Dec 2008 11:35:13 GMT

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

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

joginder_singh — Wed, 24 Dec 2008 11:49:23 GMT

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