2426578 - SMP 3.0 SP12 PL02. ORA-00972: identifier is too long | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2426578 - SMP 3.0 SP12 PL02. ORA-00972: identifier is too long

Symptom

Installed SAP Mobile Platform 3.0 SP12 PL02 on Linux RedHat with Oracle Release 12.1.0.2.

Now in the SMP Server log hourly this error :

2017 02 07 08:01:00#+0100#ERROR#com.sap.mobile.platform.server.online.statistics.configuration.api.StatisticsServiceImpl###
s-tenant-stats1#########Exception occurred while deleting Date Statistics: org.eclipse.persistence.exceptions.DatabaseException:

Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long

Error Code: 972

Call: SELECT STATID, APPLICATIONID, EXECUTIONDATE, EXECUTIONDATETIME, INITDOWNLOADCOUNT, INITDOWNLOADTIME, NAME,
REFRESHCOUNT, REFRESHTIME, VERSION FROM SMP_DEFINING_REQUEST_DATE_STATS WHERE (EXECUTIONDATE < ?)
 bind => [1 parameter bound]
Query:
ReadAllQuery(referenceClass=OfflineDefiningRequestDateStatistics sql="SELECT STATID, APPLICATIONID, EXECUTIONDATE, EXECUTIONDATETIME,
INITDOWNLOADCOUNT, INITDOWNLOADTIME, NAME, REFRESHCOUNT, REFRESHTIME, VERSION FROM SMP_DEFINING_REQUEST_DATE_STATS WHERE (EXECUTIONDATE < ?)")
 
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
 
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:646)
...


Read more...

Environment

  • SMP 3.0 SP12 PL02
  • Oracle Release 12.1.0.2
  • Linux RedHat

Product

SAP Mobile Platform 3.0

Keywords

ORA-00972: identifier is too long, Error Code: 972, Oracle, PL02, SMP 3.0 SP12 PL02, Exception, occurred, Statistics , KBA , MOB-ONP , SAP Mobile Platform on Premise , Problem

About this page

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

Search for additional results

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