Run time error DBIF_RSQL_SQL_ERROR when saving Grant Master

[atif_farooq]

Hi:

I just activated EA-FIN in development to notice some impacts in depreciation. Test server is ECC 6 with EHP4. Immediately after its activation i started to get a run time error when i save Grant Master data. Its mentioned under

Runtime Errors	DBIF_RSQL_SQL_ERROR
Except.	CX_SY_OPEN_SQL_DB
Date and Time	11.10.2012 14:15:47

Short text

SQL error in the database when accessing a table.

Missing RAISING Clause in Interface

	Program	SAPLSBAL_DB_INTERNAL
	Include	LSBAL_DB_INTERNALU02
	Row	1
	Module type	(FUNCTION)
	Module Name	BAL_DB_INTERNAL_NO_UPDATE_TASK

Trigger Location of Exception

	Program	SAPLSBAL_DB_INTERNAL
	Include	LSBAL_DB_INTERNALU02
	Row	59
	Module type	(FUNCTION)
	Module Name	BAL_DB_INTERNAL_NO_UPDATE_TASK

Source Code Extract

Line  SourceCde

	29 *********************************************************************
	30   PERFORM delete_logs

31	USING
32	c_s_db_tables-balhdr_d
33	i_package_size.

34

35 *********************************************************************

36 * set dbversion for all logs to current version

37 *********************************************************************

38   LOOP AT c_s_db_tables-balhdr_u ASSIGNING <l_s_balhdr>.

39	<l_s_balhdr>-db_version = const_bal_db_ver_current.

40   ENDLOOP.

41   LOOP AT c_s_db_tables-balhdr_i ASSIGNING <l_s_balhdr>.

42	<l_s_balhdr>-db_version = const_bal_db_ver_current.

43   ENDLOOP.

44

45

46 ***********************************************************************

47 * delete data tables

48 ***********************************************************************

49   IF NOT c_s_db_tables-baldat_d IS INITIAL.

50	DELETE baldat CLIENT SPECIFIED FROM TABLE c_s_db_tables-baldat_d.

51   ENDIF.

52

53

54 ***********************************************************************

55 * insert all tables

56 ***********************************************************************

57 * first the data table ...modify

58   IF NOT c_s_db_tables-baldat_i IS INITIAL.

>>>	MODIFY baldat CLIENT SPECIFIED FROM TABLE c_s_db_tables-baldat_i.

60   ENDIF.

61 * and then the header table (otherwise another mode might find a

62 * log header whose data are not completely written on the database)

63   IF NOT c_s_db_tables-balhdr_i IS INITIAL.

64     INSERT balhdr CLIENT SPECIFIED FROM TABLE c_s_db_tables-balhdr_i.

65   ENDIF.

66

67

68 ***********************************************************************

69 * update all tables specified

70 ***********************************************************************

71   IF NOT c_s_db_tables-baldat_u IS INITIAL.

72     MODIFY baldat CLIENT SPECIFIED FROM TABLE c_s_db_tables-baldat_u.

73   ENDIF.

74   IF NOT c_s_db_tables-balhdr_u IS INITIAL.

75     UPDATE balhdr CLIENT SPECIFIED FROM TABLE c_s_db_tables-balhdr_u.

76   ENDIF.

77

78

Please suggest me how to overcome this issue.

Regards

[Former Member]

There is no such table named baldat in the database,But the table exist in the SAP,So you can display the table in T-code SE11,and active the table,then the problem will be done.