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.
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
caught nor passed along using a RAISING clause, in the procedure "STDO_REF_CRE"
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
"(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)
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
procedure "STDO_REF_CRE" "(FORM)" but was not handled locally, not declared in
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
004830 FORM STDO_REF_CRE USING OBJ_NAME OBJ_TYPE IND_NAME ACTION
004840 S_OR_M O_OR_PUT
004850 REFERENCE LIKE DDLREF
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.
004940 * Generate the name of the reference log:
004950 CALL FUNCTION 'DD_LOGNPROT_NAME_GET'
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
005040 PROTNAME = LOGNAME
005060 OTHERS = 01.
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