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.
SAP Knowledge Base Article - Preview