cancel
Showing results for 
Search instead for 
Did you mean: 

Error in HRPAD31 ( Short dump Analysis )

Former Member
0 Kudos

Hi friends,

When i am changing the existing qualification or adding new qualification it is showing this error in short dump

Pls advise me if there is some relationship i am missing in 031 ?

here is the description of short dump

Runtime Error DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Occurred on 10.09.2008 at 10:48:39

An SQL error occurred when accessing a table.

What happened?

What can you do?

Make a note of the actions and input which caused the error.

To resolve the problem, contact your SAP system administrator.

You can use transaction ST22 (ABAP Dump Analysis) to view and administer

termination messages, especially those beyond their normal deletion

date.

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', wasneither

caught nor passed along using a RAISING clause, in the procedure"ADATA_DB" "FORM)"

.

Since the caller of the procedure could not have expected this exception to occcur, the running program was terminated.

The reason for the exception is:

How to correct the error

The exception must either be prevented, caught within the procedure "ADATA_DB"

"(FORM)", or declared in the procedure's RAISING clause.

To prevent the exception, note the following:

Database error text........: "ORA-01653: unable to extend table SAPR3.HRPAD31 by 80 in tablespace PSAPSTABD"

Internal call code.........: "RSQL/INSR/HRPAD31"

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

You may able to find an interim solution to the problem

in the SAP note system. If you have access to the note system yourself, use the following search criteria:

-


"DBIF_RSQL_SQL_ERROR" CX_SY_OPEN_SQL_DBC

"SAPLRHAP" or "LRHAPF1K"

"ADATA_DB"

-


System environment

SAP Release.............. "620"

Application server....... "Development"

Network address.......... "200.200.200.10"

Operating system......... "Windows NT"

Release.................. "5.2"

Hardware type............ "2x IA64 Level 3"

Character length......... 8 Bits

Pointer length........... 64 Bits

Work process number...... 1

Short dump setting....... "full"

Database server.......... "Development"

Database type............ "ORACLE"

Database name............ "VC3"

Database owner........... "SAPR3"

Character set............ "English_United State"

SAP kernel............... "640"

Created on............... "Aug 16 2007 23:23:39"

Created in............... "NT 5.0 2195 Service Pack 4 x86 MS VC++ 13.10"

Database version......... "OCI_920_SHARE "

Patch level.............. "196"

Patch text............... " "

Supported environment....

Database................. "ORACLE 9.2.0.., ORACLE 10.1.0.., ORACLE

User, transaction...

Client.............. 600

User................ "HUSER"

Language key........ "E"

Transaction......... "PP01 "

Program............. "SAPLRHAP"

Screen.............. "MP100100 6000"

Screen line......... 16

Information on where terminated

The termination occurred in the ABAP program "SAPLRHAP" in "ADATA_DB".

The main program was "MP100100 ".

The termination occurred in line 57 of the source code of the (Include) program LRHAPF1K"

of the source code of program "LRHAPF1K" (when calling the editor 570).

Processing was terminated because the exception "CX_SY_OPEN_SQL_DB" occurred in

the procedure "ADATA_DB" "(FORM)" but was not handled locally, not declared in the RAISING clause of the procedure.

The procedure is in the program "SAPLRHAP ". Its source code starts in line 8 of the (Include) program "LRHAPF1K ".

PLS LET ME KNOW IF I NEED TO CHECK ALL MY CONFIGURATION ?

Accepted Solutions (1)

Accepted Solutions (1)

ted_dinh
Active Contributor
0 Kudos

Looks like resource issue. Send this error 'ORA-01653: unable to extend table SAPR3.HRPAD31 by 80 in tablespace PSAPSTABD' to your SAP BASIS / dba admin to check table space.

Rgds.

Former Member
0 Kudos

Hi Ted,

Thanks for your response, Basis team has increased the space of this table "PSAPSTABD" but still it is showing the same error.

Pls advise me..

Thanks

HR user

Former Member
0 Kudos

Hi Ted,

It is working, i just logged off and logged in. Now there is no error.

Thanks for all your support. I am struggling on this isse from 3 days and could not sort it out.

I appreciate on more time for your knowledge.

I have rewarded the points also....

Regards

HR user

Answers (0)