SAP Knowledge Base Article - Preview

1902321 - Job SAP_COLLECTOR_FOR_PERFMONITOR gives ORA-00936 error

Symptom

Error ORA-00936 occurs while running job SAP_COLLECTOR_FOR_PERFMONITOR

C  *** ERROR => ORA-00936 occurred at SQL stmt (parse error offset=47)
[dbsloci.c    17262]
C  {root-id=005056A951DC1ED2A6EAA5CFF287CA9E}_{conn-
id=00000000000000000000000000000000}_0
C  Dump statement cache:
C  sc_p=6606b70,no=118,idc_p=
(nil),con=0,act=1,slen=73,smax=256,#vars=0,stmt=6ec6570,table=
C  DELETE FROM DB2CLINETSTATS WHERE intervalend < current timestamp - 7
days;


Read more...

Environment

  • Oracle 11.2.0.3
  • LINUX
  • SAP EHP2 FOR SAP NETWEAVER 7.0

Product

SAP Auto-ID Infrastructure 7.1

Keywords

 sdb_monitoring_data_auto_actions, rscoll00, export, import, rsdb_daily , KBA , BC-DB-ORA-DBA , Database Administration , Problem

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.