SAP Knowledge Base Article - Preview

3522810 - What is the <CURRENT_TIMESTAMP> format ?

Symptom

When investigating high database size issues, you may be asked by SAP Support to execute some SQL queries, such as:

SELECT COUNT(*) AS MSG_COUNT FROM BC_MSG WHERE (STATUS='DLVD' OR STATUS='FAIL') AND PERSIST_UNTIL < <CURRENT_TIMESTAMP>; 

SELECT COUNT(*) AS MSG_COUNT FROM BC_MSG_LOG WHERE DELIVERY_SEMANTICS='BE' AND LAST_VERSION = '1' AND PERSIST_UNTIL < <CURRENT_TIMESTAMP>;

You need to know the correct format for <CURRENT_TIMESTAMP>.


Read more...

Environment

SAP NetWeaver.

Product

SAP NetWeaver all versions

Keywords

database size,database , SQL query, sql, CURRENT_TIMESTAMP, format, BC_MSG, BC_MSG_LOG, SAP Support,investigation,message count, PERSIST_UNTIL, DLVD status, FAIL status, high database size, SAP KBA,2842580 , KBA , BC-XI-CON-MSG , Messaging System , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.