Question Re: Database error 1017 at PRE access to table PAKDATBUF in Technology Q&A

Database error 1017 at PRE access to table PAKDATBUF

Former Member — Fri, 09 Aug 2013 01:47:03 GMT

Hi all,

I just simply use FK03 to display vendor master, system dumps, issuing runtime error DBIF_RSQL_SQL_ERROR. I checked system log in SM21 and it recorded Database error 1017 at PRE access to table PAKDATBUF.

Below is dump description and system log.

Can anyone help? Great thanks.

Re: Database error 1017 at PRE access to table PAKDATBUF

Former Member — Fri, 09 Aug 2013 02:54:11 GMT

Hi Hans,

From the logs it appears that write activity for a remote database is failing. Could you check whether there is enough space in the tablespaces for remote database specified in dbcon.

Hope this helps.

Regards,

Deepak Kori

Re: Database error 1017 at PRE access to table PAKDATBUF

stefan_koehler — Fri, 09 Aug 2013 07:34:54 GMT

Hi Hans,

unfortunately the corresponding work process trace file (WP 2 of app server saped1) is missing, but the error seems to be pretty clear.

DB_CON = R/3*INACT_PACK

ORA ERROR = ORA-01017

shell> oerr ORA 1017
01017, 00000, "invalid username/password; logon denied"
// *Cause:
// *Action:

Checkout the corresponding <ORACLE_SID> from the work process trace file and correct the user / password. That's it :-))

@Deepak: I don't get your connection between an "invalid username/password" and a full tablespace. How do you get to this conclusion?

Regards

Stefan

Re: Database error 1017 at PRE access to table PAKDATBUF

Former Member — Fri, 09 Aug 2013 08:11:17 GMT

Hi Deepak, at first we checked this table's space was highly used to 99%, so we increased table space, but the problem remained the same.

Re: Database error 1017 at PRE access to table PAKDATBUF

Former Member — Fri, 09 Aug 2013 08:16:07 GMT

Hi Stefan, thanks for your reply.

How Can I get the work process trace file ?

Re: Database error 1017 at PRE access to table PAKDATBUF

Reagan — Fri, 09 Aug 2013 12:52:12 GMT

Hello

cd /usr/sap/ED1/DVEBMGS00/work

check the trace file dev_w2

Good Luck