Problem with logs in DB13

[Former Member]

Hello!

I have problems with clearing logs via transaction DB13.

When I start this operation for the first time after starting SAP system this job is finished successfully.

But then I have error in this job:

Job started

Step 001 started (program RSDBAJOB, variant &0000000000033, user ID SAP*)

Format "X_PAPER" not defined for printer "$LOCL"

Execute logical command BRCONNECT On host SAP-TSC

Parameters: -u / -jid CLNUP20140505004009 -c -f cleanup

External communication error at program start (see system log)

SAPXPG_START_XPG_LONG: sy-subrc ne 0

destination = %_TCPIP_%1

SXPG_STEP_COMMAND_START: SXPG_STEP_XPG_START returned: 1.006

SXPG_COMMAND_EXECUTE(LONG)

<timestamp> = 20140505004031

COMMANDNAME = BRCONNECT

ADDITIONAL_PARAMETERS = -u / -jid CLNUP20140505004009 -c -f cleanup

LONG_PARAMS

OPERATINGSYSTEM = ANYOS

TARGETSYSTEM = SAP-TSC

DESTINATION

SY-SUBRC =  902

SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: x_error

Job cancelled after system exception ERROR_MESSAGE

And i have to restart the SAP for using DB13.

Why it's happening?

P.s. Yes, i changed SAPSR3 passwords via brtools and brconnect.

Thank you for answering.

[Former Member]

Hi,

     Check any ora user id locked with below query,

SQL> select username,account_status from dba_users;

Regards,

R.Ramkumar

[Syamkriz]

'Hello SAP Basis,

Could you please run cleanup job from D13 using another administrator other than SAP* ?

Thanks and REgards,

Syam

[Former Member]

Hello Syam,

Yes, I used idadmin also.

[Syamkriz]

Hi SAP Basis,

You mean idaadmin SAPuser right ( not OS user) . Have you tried running the brtools cleanup from operating system using brtools?

Thanks and Regards,

Syam

[Former Member]

Hello Syam.

Yes, without problems

[Syamkriz]

I suppose you have already opened an OSS message rt?

Thanks and Regards,

Syam

[janos_mucsi-besze]

Hi SAP Basis,

Please check SAPDBHOST parameter.

Read the developer traces - dev_rd,dev_rfc<x> - to see the real error. You may raise the trace level of the gateway process (in SMGW->Goto->Trace->Gateway->Increase Level) too see a detailed error message.

On the other hand make sure brconnect is located in the kernel directory with appropriaste user rights.

Regards,

János

[Former Member]

Hello Janos,

I checked SAPDBHOST parameter in DEFAULT.PFL:

SAPDBHOST = SAP-TSC

BRCONNECT is located in the directory with appropriate user rights.

Also I checked developer traces:dev_rd

LOCATION    SAP-Gateway on host SAP-TSC / sapgw00

*  ERROR       timeout during allocate

*

*  TIME        Wen May 07 16:08:10 2014

*  RELEASE     720

*  COMPONENT   SAP-Gateway

*  VERSION     2

*  RC          242

*  MODULE      gwr3cpic.c

*  LINE        6070

*  DETAIL      no connect of TP sapxpg from host SAP-TSC.localdomain after 20

*              sec

*  COUNTER     11

But i can't understand why rebooting sap system the first clearing logs finish successfully, but then i have errors.

[janos_mucsi-besze]

Hi,

I have to say, that opening an incident at SAP would be advisable now. There can be several reasons for this issue. E.g. sapxpg,gateway,sap configuration,etc.

Open an incident at BC-CST-GW. My colleagues will take care.

Regards,

János

[Former Member]

Hello,

you wrote that DB and SAP system are located on the same host. 
On the other hand, the error message seems to indicate that at least your SAP systems is assuming that the DB is on a different host.
So a few questions for clarification:

1) Are you using virtual hostnames? That means, even if DB and dialogue instance are running on the same physical host, they may be running on different virtual hosts. And then it will be difficult for SAP to find out whether or not they are on the same physical host.

2) Have you got more than one SAP application server, and if so, is at least one of them running on a physical host different from the DB hosts?

regards

[Former Member]

Hello Josef,

1) No i don't use a virtual host.

2) No, I don't have more than one SAP application server.

[janos_mucsi-besze]

Check in SM59 the corresponding RFC destination (SAPXPG....) if this can be started at all. From the error message it is visible that the RFC destination is not even able to execute any command.

Regards,

János

[Former Member]

Hello, Janos!

Yes, I run connection test for SAPXPG_DBDEST_SAP-TSC RFC connection without any problem

[Former Member]

Error is quite common, there can be many reasons!

First read the Note 446172 thoroughly as suggested by one of our friend here.

DB host being a separate host, please verify the rfc SXPG.

Verify environment variables as in SAP note 378648 for user sidadm.

Please do the cleanup of all the DB13 jobs first.

And what user do you use to run brtools at OS level ?

Thank you.

[Former Member]

Hello Bhudev,

I checked the notes but it wasn't help me.

In SM21 I have error:

Error 1006 when executing external command brconnect on %_TCPIP_%1 (xpgid=0,convid=.)

when i'm trying to clear logs via DB13.

I use TSCADM user to run brtools at OS level.

P.s. DB and SAP system are located on the same host. 

[former_member182505]

Hi

Please check the below notes may help you

SAP Note 446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13 - Point 8

Note 583759 - R/3 error when you start jobs from DB13

Thanks

Sadiq

[Former Member]

Hello Sadiq,

Thank you for the notes.

I checked them, but I didn't see things which were wrong in my system than in solutions of these notes.