CI +DB Work process in error status

[Former Member]

Hi Experts,

The Work process for the CI is in error status, What impact will this have in the future. Is restarting the system a solution or is there any way to get rid of this error status.

Here is the log:

No Type PID Status Start

0 DIA 6164652 Running Yes Err

1 DIA 5951740 Waiting Yes 2

2 DIA 5636174 Waiting Yes 2

3 DIA 1957944 Waiting Yes 2

4 BGD 2187338 Waiting Yes 2

5 BGD 2637930 Waiting Yes 2

6 DIA 1003678 Waiting Yes 2

7 DIA 1548522 Waiting Yes 2

8 DIA 5542058 Waiting Yes 2

9 DIA 2277580 Waiting Yes 2

10 DIA 1405122 Waiting Yes 2

11 DIA 1745006 Waiting Yes 2

12 DIA 6045870 Waiting Yes 2

13 DIA 1986790 Waiting Yes 2

14 DIA 6111472 Waiting Yes 2

15 UPD 545020 Waiting Yes 3

16 UPD 2363514 Waiting Yes 3

17 UPD 2482392 Waiting Yes 2

18 UPD 2940932 Waiting Yes 2

19 ENQ 934020 Waiting Yes 2

20 ENQ 458768 Waiting Yes 2

21 DIA 5931208 Waiting Yes 5

22 DIA 6140122 Waiting Yes 8

23 DIA 6131804 Waiting Yes 9

24 DIA 5361756 Waiting Yes 5

25 SPO 1290466 Waiting Yes 2

26 SPO 5529838 Waiting Yes 1

27 UP2 2252906 Waiting Yes 1

28 UP2 5664954 Waiting Yes 1

Thanks and Regards

Jude Nazareth

[Former Member]

Hi Rahul,

Thanks for your reply. As you told restart of the Instance would remove the errors. we have been doing that, but that would not be a good idea to restart the instance often because all the Instance's are effected with the error message and it's happening on a regular basis.

And when the instance has these error "Load balancing is not taking place".i.e no user are directed to that WP which has lot of error messages. So what should be analysed to fix this situation other that restaring the instance often. Plz suggest.

Thanks and regards

Jude Nazareth.

[JPReyes]

post the details of dev_w0...

Regards

Juan

[Former Member]

Hi

Here is the Trace for the day:

trc file: "dev_w1", trc level: 1, release: "700"

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

M sysno 01

M sid CIP

M systemid 324 (IBM RS/6000 with AIX)

M relno 7000

M patchlevel 0

M patchno 131

M intno 20050900

M make: single threaded, Unicode, 64 bit, optimized

M pid 1163334

M

Mon Apr 28 01:43:44 2008

DbSlControl: returning SAPDBHOST='PEKAX571'

DbSlControl: returning SAPDBHOST='PEKAX571'

DbSlControl: returning SAPDBHOST='PEKAX571'

Mon Apr 28 04:22:19 2008

• ERROR in DB6Open[dbdb6.c, 3207] CON = 0 (BEGIN)

&+ dsql_db6_open( SQLExecute 😞 [IBM][CLI Driver][DB2/AIX64] SQL0969N Ther

&+ error "-99999" in the message file on this workstation. The error was r

&+ al tokens

&+

&+ CALL GET_DB_CONFIG

&+ cursor type=NO_HOLD, isolation=UR, cc_release=NO, optlevel=5, degree=1

&+ ABAP location info: 'CL_SQL_STATEMENT==============CP', 383

&+

&+ ABAP location info 'CL_SQL_STATEMENT==============CP', 383

&+

• ERROR in DB6Open[dbdb6.c, 3207] (END)

***LOG BY2=> sql error -99999 performing OPC [dbds#1 @ 482] [dbds

***LOG BY0=> SQL0969N There is no message text corresponding to SQL error "-99

***LOG BY1=> sql error -99999 [dbacds#2 @ 1433] [dbacds 1433 ]

Mon Apr 28 04:22:32 2008

• ERROR in DB6Open[dbdb6.c, 3207] CON = 0 (BEGIN)

&+ dsql_db6_open( SQLExecute 😞 [IBM][CLI Driver][DB2/AIX64] SQL0969N Ther

&+ error "-99999" in the message file on this workstation. The error was r

&+ al tokens

&+

&+ CALL GET_DB_CONFIG

&+ cursor type=NO_HOLD, isolation=UR, cc_release=NO, optlevel=5, degree=1

&+ ABAP location info: 'CL_SQL_STATEMENT==============CP', 383

&+

&+ ABAP location info 'CL_SQL_STATEMENT==============CP', 383

&+

• ERROR in DB6Open[dbdb6.c, 3207] (END)

***LOG BY2=> sql error -99999 performing OPC [dbds#1 @ 482] [dbds 0482 ]

***LOG BY0=> SQL0969N There is no message text corresponding to SQL error "-99999" in the message file on this workstation. T

***LOG BY1=> sql error -99999 [dbacds#2 @ 1433] [dbacds 1433 ]

• ERROR in DB6Open[dbdb6.c, 3207] CON = 0 (BEGIN)

&+ dsql_db6_open( SQLExecute 😞 [IBM][CLI Driver][DB2/AIX64] SQL0969N There is no message text corresponding to SQL

&+ error "-99999" in the message file on this workstation. The error was returned from module "SQL08025" with origin

&+ al tokens

&+

&+ CALL GET_DB_CONFIG

&+ cursor type=NO_HOLD, isolation=UR, cc_release=NO, optlevel=5, degree=1, buffer_lobs=YES, op_type=24, reopt=0

&+ ABAP location info: 'CL_SQL_STATEMENT==============CP', 383

&+

&+ ABAP location info 'CL_SQL_STATEMENT==============CP', 383

&+

• ERROR in DB6Open[dbdb6.c, 3207] (END)

***LOG BY2=> sql error -99999 performing OPC [dbds#1 @ 482] [dbds 0482 ]

***LOG BY0=> SQL0969N There is no message text corresponding to SQL error "-99999" in the message file on this workstation. T

***LOG BY1=> sql error -99999 [dbacds#2 @ 1433] [dbacds 1433 ]

Mon Apr 28 04:26:10 2008

• ERROR => ExecPWaitForProcess: waitpid(2007152) failed: errno 10 (No child processes) [execuxi.c 1271]

• ERROR => ExecPWaitForProcess: waitpid(4571186) failed: errno 10 (No child processes) [execuxi.c 1271]

• ERROR => ExecPWaitForProcess: waitpid(5943376) failed: errno 10 (No child processes) [execuxi.c 1271]

• ERROR => ExecPWaitForProcess: waitpid(6070374) failed: errno 10 (No child processes) [execuxi.c 1271]

• ERROR => ExecPWaitForProcess: waitpid(3051714) failed: errno 10 (No child processes) [execuxi.c 1271]

Mon Apr 28 04:26:11 2008

• ERROR => ExecPWaitForProcess: waitpid(557166) failed: errno 10 (No child processes) [execuxi.c 1271]

• ERROR => ExecPWaitForProcess: waitpid(1462344) failed: errno 10 (No child processes) [execuxi.c 1271]

• ERROR => ExecPWaitForProcess: waitpid(1171664) failed: errno 10 (No child processes) [execuxi.c 1271]

• ERROR => ExecPWaitForProcess: waitpid(1916936) failed: errno 10 (No child processes) [execuxi.c 1271]

• ERROR => ExecPWaitForProcess: waitpid(1441948) failed: errno 10 (No child processes) [execuxi.c 1271]

M *** ERROR => ExecPWaitForProcess: waitpid(5783786

M *** ERROR => ExecPWaitForProcess: waitpid(790626)

M *** ERROR => ExecPWaitForProcess: waitpid(819234)

M *** ERROR => ExecPWaitForProcess: waitpid(5509172

M *** ERROR => ExecPWaitForProcess: waitpid(2998388

M

M Mon Apr 28 04:26:12 2008

M *** ERROR => ExecPWaitForProcess: waitpid(1499242

M *** ERROR => ExecPWaitForProcess: waitpid(2584786

M *** ERROR => ExecPWaitForProcess: waitpid(4587536

M *** ERROR => ExecPWaitForProcess: waitpid(5943382

M *** ERROR => ExecPWaitForProcess: waitpid(4571188

M *** ERROR => ExecPWaitForProcess: waitpid(2007154

M *** ERROR => ExecPWaitForProcess: waitpid(1462346

M *** ERROR => ExecPWaitForProcess: waitpid(1441950

M *** ERROR => ExecPWaitForProcess: waitpid(1171666

M *** ERROR => ExecPWaitForProcess: waitpid(557168)

M *** ERROR => ExecPWaitForProcess: waitpid(962770)

M *** ERROR => ExecPWaitForProcess: waitpid(5816532

M *** ERROR => ExecPWaitForProcess: waitpid(2969628

C

C Mon Apr 28 04:28:44 2008

C DbSlControl: returning SAPDBHOST='PEKAX571'

C

C Mon Apr 28 05:43:44 2008

C DbSlControl: returning SAPDBHOST='PEKAX571'

C DbSlControl: returning SAPDBHOST='PEKAX571'

C DbSlControl: returning SAPDBHOST='PEKAX571'

M

M Mon Apr 28 08:00:16 2008

M change reqtype from DIA to BTC

M PfSetStatLevel: new stat level = 1

W ipl_ipl_HookSwitchOpMode: switch to BTC

MM Mon Apr 28 08:00:19 2008

M SecAudit(check_daily_file): audit file closed /usr/sap/C

M SecAudit(check_daily_file): audit file opened /usr/sap/C

M

M Mon Apr 28 08:02:53 2008

M VB-RC 9 received, save into ztta and sy

M ***LOG R65=> ThVBRqPrepare, vb error (9 ) [thxxvb.c

M

M Mon Apr 28 08:05:20 2008

M VB-RC 9 received, save into ztta and sy

M ***LOG R65=> ThVBRqPrepare, vb error (9 ) [thxxvb.c

M

M Mon Apr 28 09:00:04 2008

M change reqtype from BTC to DIA

M PfSetStatLevel: new stat level = 1

W ipl_ipl_HookSwitchOpMode: switch to DIA, init already do

C

C Mon Apr 28 09:43:44 2008

C DbSlControl: returning SAPDBHOST='PEKAX571'

C

C Mon Apr 28 13:43:44 2008

C DbSlControl: returning SAPDBHOST='PEKAX571'

C DbSlControl: returning SAPDBHOST='PEKAX571'

C DbSlControl: returning SAPDBHOST='PEKAX571'

C

C Mon Apr 28 15:08:11 2008

C DbSlControl: returning SAPDBHOST='PEKAX571'

Thanks and Regards,

Jude Nazareth

[JPReyes]

This seems to be a problem with your DB...

ERROR in DB6Open

sql error -99999

Read SAP Note 1081745 - DB6: SQL error -99999 and SQL error -55555

Regards

Juan

[Former Member]

Hi

Thanks Juan for the Snote. Could you please help me with some more related Snotes.

Thanks and Regards,

Jude Nazareth

[JPReyes]

You can do your own search as SAP MArketplace...

Reading won't kill you.

Regards

Juan

[Former Member]

Hi

This error status shows that while trying to restart the work process some error occured.

Usually whenever there is some job failure or if we cancel some running job, the work processes restarts it self. Just have a look at the numbers below the Err message which states number of time process restarted.

So this status not a matter of concern, if its not on regualr basis, one restart would remove this message.

Hope this helps.

Regards

Rahul