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 for Me (Login required).

Search for additional results

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