cancel
Showing results for 
Search instead for 
Did you mean: 

DBIF_SETG_SQL_ERROR when running SWNCTOTAL Report

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Problem Solved by myself.

Debugged the SWNCTOTAL program and forced the first time aggregation.

Former Member
0 Kudos

I forgot to say that the following SAP Notes was already applied without results:

Note 1229062

Note 1222907

Thanks in advance,

Marco