on 10-21-2010 4:42 AM
Dear All,
I am facing problem in prd ,we have 2 active node the job SAP_COLLECTOR_FOR_PERFMONITOR keep on running eg 44,21sec,tan I have to cancel it manual this is suddenly. this happened with not all the hourly jobs ,but only 1 or 2 time in a day a any time.
Please find the below . Please suggest how to solved it
We are using ECC6 on oracle 10g
25 BGD 1696 Running Yes 4 2 SWNCTOTAL 000 DDIC Insert SWNCMONI
Sm37 log
Job started
Step 001 started (program RSCOLL00, variant , user ID DDIC)
Clean_Plan:Cleanup of DB13 Plannings
Clean_Plan:started by RSDBPREV on server nodea
Clean_Plan:Cleaning up jobs of system PRD
Clean_Plan:finished
Database destination not found
Cannot determine operating system data for database
kind regards,
kumar
Dear Experts,
we have a database where the collector job runs and more number of archive logs gets generated. Kindly let know the possibilities of reducing the same
regards
Mani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manikandan,
Can you please execute transaction STZAC and check that the system and user time zone are same.
Refer Note 741734 - Incorrect times due to the time zone settings.
Also please execute Temse consistency check in SP12. Once done please rerun the collector job again from client 000 with user DDIC.
Thanks,
Manas
Hi,
You can check SAP note 1233020 and also check whether the time at which this jobs hangs,you have sufficient amount of background process free or not.
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Sunny
Thanks for you suggestion , no it happened any time and there is sufficient no of background process are free
I have see it stuck in table SWNCMONI while Insert ans i have checked the snote .Please suggest
sm21 log
Time Type Nr Clt User TCode Priority Grp N Text
04:51:46 DIA 001 100 BASIS AB 0 Run-time error "TIME_OUT" occurred
04:51:46 DIA 001 100 BASIS AB 1 > Short dump "101021 045146 clusa " generated
04:51:46 DIA 001 100 BASIS D0 1 Transaction Canceled SY 002 ( Time limit exceeded. )
05:01:04 RD Q0 I Operating system call connect failed (error no. 10061)
05:01:45 RD Q0 I Operating system call connect failed (error no. 10060)
05:01:45 DIA 000 100 BASIS R4 9 Communication error, CPIC return code 017, SAP return code 236
05:01:45 DIA 000 100 BASIS R6 4 > CPI-C function: CMINIT(SAP)
05:20:11 RD Q0 I Operating system call connect failed (error no. 10060)
05:20:11 DIA 001 100 BASIS R4 9 Communication error, CPIC return code 017, SAP return code 236
05:20:11 DIA 001 100 BASIS R6 4 > CPI-C function: CMINIT(SAP)
05:20:24 RD Q0 I Operating system call connect failed (error no. 10061)
05:21:18 RD Q0 I Operating system call connect failed (error no. 10060)
05:21:18 DIA 001 100 BASIS R4 9 Communication error, CPIC return code 017, SAP return code 236
05:21:18 DIA 001 100 BASIS R6 4 > CPI-C function: CMINIT(SAP)
05:22:56 RD Q0 I Operating system call recv failed (error no. 10054)
08:46:50 BTC 025 000 DDIC BY 4 Database error 24909 at UPD access to table TST01
08:46:50 BTC 025 000 DDIC F6 H Database error: TemSe->XRTAB(3)->1 for table TST01 key
08:46:56 RD Q0 I Operating system call recv failed (error no. 10054)
08:47:11 BTC 025 000 DDIC F3 T Invalid object name for TemSe object: " "
08:47:13 BTC 025 000 DDIC EC F Failed to create log for job SAP_COLLECTOR_FOR_PERFMONITOR 19301600 %NEWSTEP/
08:47:13 BTC 025 000 DDIC F2 0 Calling program reports invalid handle for TemSe object (magic==X'NULL-ptr')
08:47:13 BTC 025 000 DDIC R4 7 Delete session 001 after error 023
09:38:51 DP Q0 I Operating system call recv failed (error no. 10054)
09:38:51 DP Q0 4 Connection to user 9850 ( ), terminal 90 (233 ) lost
10:00:24 RD Q0 I Operating system call recv failed (error no. 10054)
10:00:24 RD S2 3 Connection to CPI-C client 101 was closed
10:00:24 DIA 001 100 PORTAL R4 9 Communication error, CPIC return code 020, SAP return code 223
10:00:24 DIA 001 100 PORTAL R5 A > Conversation ID: 909935
10:00:24 DIA 001 100 PORTAL R6 4 > CPI-C function: CMSEND(SAP)
10:26:36 DP Q0 I Operating system call recv failed (error no. 10
and just now the sm37 log is different
Job started
Step 001 started (program RSCOLL00, variant , user ID DDIC)
Clean_Plan:Cleanup of DB13 Plannings
Clean_Plan:started by RSDBPREV on server
Clean_Plan:Cleaning up jobs of system PRD
Clean_Plan:finished
Database destination not found
Cannot determine operating system data for database
Buffer statistics for clusa transferred to MONI
Please suggest
Kind Regards,
Kumar
Edited by: kumar9 on Oct 21, 2010 12:30 PM
Edited by: kumar9 on Oct 21, 2010 2:37 PM
hI,
> Clean_Plan:finished
> Database destination not found
> Cannot determine operating system data for database
> Buffer statistics for clusa transferred to MONI
>
As per your logs, it says it is not able to find database destination. Is your database on different host ?? If yes, then register CCMS agent on your database, as a result of which you will see database connection in OS07 and also check saposcol should be running on your database as well. Please check this and share the result.
Thanks
Sunny
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.