Skip to Content
0
Former Member
Apr 22, 2009 at 09:17 AM

Database error DBIF_RSQL_SQL_ERROR - related to program?

108 Views

Dear users,

We are stuck with a rather unusual problem.

There's this program which runs in batch every week providing information from a few database tables and all of a sudden it wants to playup!

The following error comes up with the cancelled batchjob.

Runtime Errors         DBIF_RSQL_SQL_ERROR  
Exception              CX_SY_OPEN_SQL_DB    
  Database error text........: "[1101] Could not allocate a new page for database   
   'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'. Create the   
   necessary space by dropping objects in the filegroup, adding additional files    
   to the filegroup, or setting autogrowth on for e"                                
  Internal call code.........: "[RSQL/OPEN/AUFK ]"

This error happens at the following SELECT query.

SELECT A~AUFNR B~BELNR B~BUZEI B~KSTAR B~MEINB B~WKGBTR B~MBGBTR E~KTEXT

INTO CORRESPONDING FIELDS OF COST_TAB

FROM ( AUFK AS A INNER JOIN COEP AS B
       ON A~OBJNR = B~OBJNR

       INNER JOIN COBK AS C
       ON B~BELNR = C~BELNR

       INNER JOIN CSKA AS D
       ON B~KSTAR = D~KSTAR

       INNER JOIN CSKU AS E
       ON D~KSTAR = E~KSTAR )

WHERE     A~AUFNR IN AUFNR
          AND B~VERSN IN VERSN
          AND B~WRTTP IN WRTTP
          AND B~BEKNZ IN BEKNZ
          AND C~BUDAT IN BUDAT
          AND D~KSTAR IN S_KSTAR.

APPEND COST_TAB.

ENDSELECT.

I was wondering if the SELECT query could be written any better to ensure that this error doesn't happen.

If not, what other options am I left with please?

Thanks,

VJ