cancel
Showing results forĀ 
Search instead forĀ 
Did you mean:Ā 
Read only

ReturnCode -1403

former_member182034
Active Contributor
0 Likes
2,775

Dear All,

FI users are facing delay when they are  trying to save the data in F-29. Please check the attached trace and guide me about rectification of this error ReturnCode -1403.

while system is running on window server 2008 with Oracle 10.2.0.5

Regards,

View Entire Topic
ACE-SAP
Active Contributor
0 Likes

Hello

I do not think that return code is indicating an error.

Sql 1403 return code is a kind of marker for "no (more) row(s) to retrieve from DB".

An ORA-01403 error occurs when a SQL statement, written within a PL/SQL block, does not fetch any data.

Errors in trace should appear on red background.

I did set some trace on F-29, and did get the same RC for table UST12 (list of authorization for a user).

I do not feel either that the time spent on the UST12 (that table is buffered at SAP level) is that much a problem, the unit here is micro second...

500 micro second, even 20000 micro second cannot explain performance problem.

I've tested on a sandbox the F-29 (tough job for a basis consultant) and I did get more time spent on UST12 and with the same RC.

I think the problem is elsewhere...