Skip to Content
0
Former Member
May 17, 2013 at 04:39 AM

Domain is partly active.

628 Views

Hi Experts,

I changed the data type of the domain from DATS to CHAR and reverted. When I tried to activate the domain I am getting a dump 'DBIF_RSQL_SQL_ERROR - An SQL error occurred when accessing a table'.

Here is the dump details and suggest me with ideas to get the domain activated successfully:

After seeing the Database error text in How to Correct the error section, I guess something is wrong in the DB level.

Error analysis


An exception occurred. This exception is dealt with in more detail below
. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was
neither
caught nor passed along using a RAISING clause, in the procedure "STDO_REF_CRE"
"(FORM)"
.
Since the caller of the procedure could not have expected this exception
to occur, the running program was terminated.

How to correct the error


The exception must either be prevented, caught within the procedure
"STDO_REF_CRE"
"(FORM)", or declared in the procedure's RAISING clause.
To prevent the exception, note the following:
Database error text........: "[IBM][CLI Driver][DB2] DSNT408I SQLCODE = -913,
ERROR: UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE
00C9008E, TYPE OF # RESOURCE , AND RESOURCE NAME "
Internal call code.........: "[RSQL/DELE/DDPRS ]"

Information on where terminated


The termination occurred in the ABAP program "RADBTLOG" in "STDO_REF_CRE".
The main program was "SAPMSRD0 ".

The termination occurred in line 510 of the source code of the (Include)
program "RADBTLO0"
of the source code of program "RADBTLO0" (when calling the editor 5100).
Processing was terminated because the exception "CX_SY_OPEN_SQL_DB" occurred in
the
procedure "STDO_REF_CRE" "(FORM)" but was not handled locally, not declared in
the
RAISING clause of the procedure.
The procedure is in the program "RADBTLOG ". Its source code starts in line 483
of the (Include) program "RADBTLO0 ".

Source code extract


004800 * REFNAME, here you can insert a filename that does not fit into
004810 * REFERENCE-PROTNAME
004820 *
004830 FORM STDO_REF_CRE USING OBJ_NAME OBJ_TYPE IND_NAME ACTION
004840 S_OR_M O_OR_PUT
004850 REFERENCE LIKE DDLREF
004860 REFNAME.
004870
004880 DATA: PRID LIKE SYST-TABIX.
004890 DATA: LOGNAME LIKE TSTRF01-FILE,
004900 REAL LIKE TSTRF01-FILE.
004910 DATA: DDPRS_WA LIKE DDPRS.
004920 DATA: DDPRH_WA LIKE DDPRH.
004930
004940 * Generate the name of the reference log:
004950 CALL FUNCTION 'DD_LOGNPROT_NAME_GET'
004960 EXPORTING
004970 TASK = ACTION
004980 SINGLE_OR_MASS = S_OR_M
004990 OBJ_TYPE = OBJ_TYPE
005000 ONLINE_PUT = O_OR_PUT
005010 OBJ_NAME = OBJ_NAME
005020 IND_NAME = IND_NAME
005030 IMPORTING
005040 PROTNAME = LOGNAME

005050 EXCEPTIONS

005060 OTHERS = 01.

005070

005080 IF SYST-SUBRC <> 0. EXIT. ENDIF.

005090 PERFORM BASENAME(RADBTOUT) USING LOGNAME '/\' LOGNAME.

> DELETE FROM DDPRS WHERE PROTNAME = LOGNAME. ********The dump points to this line

Regards,

Karthik