Receiving SQL Error: INTERNAL_ERROR while executing the query

Dear All,

I am receiving the below error while executing a query.



The database system registered an SQL error. As available, the error number and a description are included in the short text. Possible causes for SQL errors include:

Overflow of database objects such as buffers, temporary tablespaces, rollback segments or data containers/tablespaces.

->These problems can generally be eliminated by system administrators.

Missing generated database objects such as tables or views based on inconsistent or inactive InfoCubes or InfoObjects. Examples of this include the view of the fact table for an InfoCube or the attribute SID table (X/Y table) of a characteristic.

-> These problems can generally be eliminated by a BW administrator.

SQL requests with incorrect content.

-> Problems of this type are generally programming errors.

System Response


Contact your system administrator.

Procedure for System Administration

If there is no error description, look for one in the reference from the database producer.

Decide on the correct category for the SQL error and check if it can be eliminated. Generally the error can also be found in the syslog (transaction sm21). From there, transactions sm51 and sm50, the developer's trace log of the work process can be determined and the erroneous statement can be viewed in the log. This procedure is described in SAP Note 568768.

Notification Number DBMAN 257

I verified the table spaces and also done RSRV Repair of InfoObjects and InfoCubes and didnt find any error. But I am receiving this error for one particular month and remaining months are executing fine. Any ideas why i am receiving this error.


Ravi Y