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
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.