Job failed with ABAP dump DBIF_RSQL_SQL_ERROR

[Former Member]

Hello All,

Job failed with ABAP dump DBIF_RSQL_SQL_ERROR

How to correct the error

Database error text........: "ORA-01114: IO error writing block to file 1607

(block # 542217)#ORA-27063: number of bytes read/written is incorrect#IBM AIX

RISC System/6000 Error: 28: No space left on device#Additional information:

-1#Additional information: 253952#ORA-01114: IO error

Internal call code.........: "[RSQL/FTCH/VBUK ]"

Please check the entries in the system log (Transaction SM21).

SM21 >>

BY0 > ORA-01114: IO error writing block to file 1607 (block #

BY0 > 542217)#ORA-27063: number of bytes read/written is

BY0 > incorrect#IBM AIX RISC System/6000 Error: 28: No space left

BY0 > on device#Additional information: -1#Additional information:

BY0 > 253952#ORA-01114: IO error writing block to file 1607 (block

BY0 > # 542217)#ORA-27063: number of bytes read/written is

BY0 > incorrect#IBM AIX RISC System/6000 Error: 28: No space left

BY0 > on device#Additional information: -1#Additional information:

BY0 > 253952#

Please suggest me to resolve the issue

Regards

M

[Former Member]

Hi,

Make sure that you have enough space at the OS level for the archive logs and also make sure that the tablespace is not full.

Regards,

Varadharajan M

[Former Member]

Database error text........: "ORA-01114: IO error writing block to file 1607

(block # 542217)#ORA-27063: number of bytes read/written is incorrect#IBM AIX

RISC System/6000 Error: 28: No space left on device#Additional information:

Check available space and increase it

Br

GYaan

[Former Member]

Hello,

BY0 > ORA-01114: IO error writing block to file 1607 (block #
BY0 > 542217)#ORA-27063: number of bytes read/written is
BY0 > incorrect#IBM AIX RISC System/6000 Error: 28: No space left

Check if there is enough space in archive logs. Check for the free space in all the file systems and if not clear or extend it

Regards,

Anand