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