Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL error in ALV_GRID

Former Member
0 Kudos

Hi friends,

When i use

DATA: GRID TYPE REF TO CL_GUI_ALV_GRID.

i m getting the error like following

" SQL error 1654 occurred when accessing program "Z1V10007 " part "LREF". "

How to resolve this probelm ???

Thanks in advance

Ajay kumar

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Ajay,

Check the free space available in the tablespace..

2. Check when the indexes in ur database ( all indexes.. not just that one)

are rebuilt last time. Rebuilding the indexes at regular intervals is

required as it may contain deleted entries. try a rebuild ( may be later )

3. Add more space to the tablespace ( add a datafile ) or if you have

another tablespace designated for Indexes and it has sapce in it, the

rebuild ur index in the second tablespace

Also,

Be that your tablespace has reached its max ext.

Check the properties of the table space and make sure your ext value is not

set too low.

If the tablespace reaches it max it wont matter what is set at the table

level.

Or

other wise the datafile file size would have got exhausted. in that case

either add a new datafile to your tablespace or resize the existing

datafile.

Try to perform this,

Maybe you can try the following:

- Rebuild the index

- Rebuilt the index in a different tablespace

- Resize the datafile of the tablespace that stores the index

- Add a new datafile to the tablespace that stores the index

also, Alter index <index name> allocate extent;

Mohinder

2 REPLIES 2

Former Member
0 Kudos

Can you provide the detail code?

Former Member
0 Kudos

Hi Ajay,

Check the free space available in the tablespace..

2. Check when the indexes in ur database ( all indexes.. not just that one)

are rebuilt last time. Rebuilding the indexes at regular intervals is

required as it may contain deleted entries. try a rebuild ( may be later )

3. Add more space to the tablespace ( add a datafile ) or if you have

another tablespace designated for Indexes and it has sapce in it, the

rebuild ur index in the second tablespace

Also,

Be that your tablespace has reached its max ext.

Check the properties of the table space and make sure your ext value is not

set too low.

If the tablespace reaches it max it wont matter what is set at the table

level.

Or

other wise the datafile file size would have got exhausted. in that case

either add a new datafile to your tablespace or resize the existing

datafile.

Try to perform this,

Maybe you can try the following:

- Rebuild the index

- Rebuilt the index in a different tablespace

- Resize the datafile of the tablespace that stores the index

- Add a new datafile to the tablespace that stores the index

also, Alter index <index name> allocate extent;

Mohinder