cancel
Showing results for 
Search instead for 
Did you mean: 

Update Staticstics fails in DB13

Former Member
0 Kudos

Hi All,

We have installed Application server & Database Server in a single Server, details as below

OS: Window 2003 Server

SAP : ECC 6.0 SR3

Oracle : 10.2.0.4.0

I am scheduling Update Staticstics in DB13, but some reasons Background Job "DBA:UPDATESTATS_____@152028/2000" getting failed every tiime throwing the following error (SM37 Log below)

Job started

Step 001 started (program RSDBAJOB, variant &0000000000000, user ID GANDHAM)

Execute logical command BRCONNECT On host ESSSAP-DEV01

Parameters:-u / -jid STATS20090728152028 -c -f stats -t PSAPSR3,PSAPSR3700,PSA...........

SXPG_COMMAND_EXECUTE(LONG)

COMMANDNAME = BRCONNECT

OPERATINGSYSTEM = ANYOS

TARGETSYSTEM = ESSSAP-DEV01

DESTINATION =

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 failed for BRCONNECT - Reason: x_error

Job cancelled after system exception ERROR_MESSAGE

but I am able to run Updtae Statics through BRTOOLS sucessfully.Can anybody please tell me the solution.

Thanks in advance.

Accepted Solutions (0)

Answers (3)

Answers (3)

JPReyes
Active Contributor
0 Kudos

check dev_cp and dev_xpg and post errors here, this seems like a problem to run external command.

Regards

Juan

Former Member
0 Kudos

Hi Jaun,

Please find the dev_cp log below

Trace file of control program (trace level 3)

< Function: BtcTrcInit> Function: main SAPXPG 700

2009-07-29--14-43-54 : Before BtcXpgDetach

> Function: BtcXpgDetach < Function: BtcXpgDetach Accept RFC connection from R/3 system

2009-07-29--14-43-54 : Before RfcAccept

2009-07-29--14-43-54 : RfcAccept returned OK

security check switched OFF

Install RFC call SAPXPG_START_XPG

Install RFC call SAPXPG_START_XPG_LONG

Install RFC call SAPXPG_END_XPG

Wait for RFC call SAPXPG_START_XPG or SAPXPG_START_XPG_LONG

2009-07-29--14-43-54 : Before first call of RFCDispatch

2009-07-29--14-43-54 : After first call of RFCDispatch

2009-07-29--14-43-54 : Before call of RfcClose (sequencing error)

2009-07-29--14-43-54 : After call of RfcClose (sequencing error)

< Function: main

2009-07-29--14-43-54 : End of SAPXPG: main

and I am unable to find dev_xpg.

Thanks in advance

JPReyes
Active Contributor
0 Kudos

Nothing relevant there,

Try to download the latest sapxpg from marketplace and run DB13 again.

Also, if your DB instance is in a different host you need to install a SAP Gateway.

Regards

Juan

Former Member
0 Kudos

Hi,

Your suggestion was very helpful, I am able to schedule the Check DB from DB13 but completed with warnings, below are the logs, any suggestion

BR0976W Database message alert - level: WARNING, line: 22956, time: 2009-08-03 16.31.20, message:

Checkpoint not complete

BR0280I BRCONNECT time stamp: 2009-08-04 12.26.45

BR0977I Checking database profile...

BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14262272 (>< 4096,512 KB)

BR0280I BRCONNECT time stamp: 2009-08-04 12.26.45

BR0980I Number of changed database profile parameters: 197

BR0280I BRCONNECT time stamp: 2009-08-04 12.26.46

BR0955I Number of signaled error/warning/exception alerts for database administration: 12/4/0

BR0956I Number of signaled error/warning/exception alerts for database operations: 0/4/0

BR0957I Number of signaled error/warning/exception alerts for database messages: 0/746/0

BR0958I Number of signaled error/warning/exception alerts for database profile: 0/1/0

BR0806I End of BRCONNECT processing: cebdzuxw.chk2009-08-04 12.26.46

BR0280I BRCONNECT time stamp: 2009-08-04 12.26.46

BR0803I BRCONNECT completed successfully with warnings

External program terminated with exit code 1

BRCONNECT returned error status E

Job finished

JPReyes
Active Contributor
0 Kudos

Parameter warnings can be adjusted via DB17,

Theres not enogh detail for the rest of the errors./warnings.

Regards

Juan

Former Member
0 Kudos

Hi Jaun,

Thanks.

Former Member
0 Kudos

Hi,

I am facing similar kind of problem on our production system.

Even in our case, the DB and CI are on different host.OS is Sun Solaris.

I have done gateway installation on the DB server.

The RFC connection to DB server SAPXPG_DBDEST_GBRMITUX011 is working fine.

Can you tell me what steps did you follow after installation of gateway on DB server.

The gateway entry is not present in /etc/hosts file.Do I have to update gateway entry there.

Please advice.

Regards,

Trupti

Former Member
0 Kudos

Brtools was missing in the kernel I used.After installting brtools, few oracle-related env varibales had to be set which solved my problem.

Former Member
0 Kudos

take a look @ notes

Check SAP note 446172 and 34219

setup SM59 connection SAPXPG_DBDEST_...it must point to the host where your DB is running.

Regards,

Ravi

Former Member
0 Kudos

Hi Ravi,

Thanks for your reply.

I have checked SAP note 446172 and 34219,

in SM59 connection SAPXPG_DBDEST_...it is pointing to the host where your DB is running and test connection getting ok.

but I am still facing the problem.

Thanks in advance.

Former Member
0 Kudos

take a look @ below post

and let us know if u find any issues later.

Regards,

Ravi

Former Member
0 Kudos

Hi Ravi,

Our Server OS is windows, and I am able to complete sucessfully Update staticstics through BRTOOLS.

below is the dev_rd logs

Wed Jul 29 14:05:49 2009

      • ERROR => GwISearchPartner: timeout, partner LU: >150.0.150.239<, TP: >sapxpg< [gwr3cpic.c 6135]

      • ERROR => GwISearchPartner: HOST: esssap-dev01.srhouse.com, conv ID: 65148935 [gwr3cpic.c 6148]

I am not able to even complete Database Check through BD13, any suggestions ????

Thanks in advance.

former_member187565
Active Contributor
0 Kudos

Hi,

Hope the SAP Note 583759 - R/3 error when you start jobs from DB13 will be helpful for you.

Regards

Rafikul

Former Member
0 Kudos

Hi Rafikul,

Thanks for you reply.

I have done as described in SAP Note 583759, but it could not solved my problem, any suggestions??

Thanks in advance.