on 11-10-2009 10:42 AM
HI All.
I'm managing a strange issue related to the SAP_COLLECTOR_FOR_PERFMONITOR standard job.
When the Job execute the report SWNCTOTAL, it leads to the following dump:
DBIF_SETG_SQL_ERROR
Database error text........: "SQL0902C A system error (reason code = "9")
occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005"
Internal call code.........: "[SETG/STB /SWNCMONI ]"
Please check the entries in the system log (Transaction SM21).
If the error occures in a non-modified SAP program, you may be able to
find an interim solution in an SAP Note.
If you have access to SAP Notes, carry out a search with the following
keywords:
"DBIF_SETG_SQL_ERROR" " "
"CL_SWNC_COLLECTOR_DB==========CP" or "CL_SWNC_COLLECTOR_DB==========CM009"
"LOAD_AGG_HITLIST_RESPTI"
I'm running with AIX 5.3 and DB2 LUW 9.5
I've searched everywhere, but was not able to find something useful.
Any help will be rewarded.
Thanks,
Marco Viani
Problem Solved by myself.
Debugged the SWNCTOTAL program and forced the first time aggregation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I forgot to say that the following SAP Notes was already applied without results:
Note 1229062
Note 1222907
Thanks in advance,
Marco
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.