SAP Knowledge Base Article - Preview

2979067 - Cannot create the database schema in CC 5.0 SP6 installation or update using SAP ASE

Symptom

When you try to install or update of SAP CC 5.0 SP6 with SAP ASE 15.7, SAP ASE 16 SP0 or SAP ASE 16 SP1, below error occurs in installation log (located in folder /tmp/sapinst_instdir/CC50/INSTALL/STANDARD/FIRST):

CREATE GLOBAL TEMPORARY TABLE DICO_TEMP (
COUN_KEY DECIMAL(4) NOT NULL,
HOLD_OID DECIMAL(28) NOT NULL,
VALUE DECIMAL(28,6) NULL
) LOCK DATAROWS
Error code : 156, ZZZZZ, com.sybase.jdbc4.jdbc.SybSQLException
com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'TABLE'.
at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4119)
at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3235)
at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:302)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:284)
at com.sybase.jdbc4.jdbc.SybStatement.executeLoop(SybStatement.java:2842)
at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:2829)
at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:1459)
at com.highdeal.admin.tools.DBTool.executeStatement(DBTool.java:542)
at com.highdeal.admin.tools.DBTool.executeFile(DBTool.java:478)
at com.highdeal.admin.tools.DBTool.main(DBTool.java:220)


Read more...

Environment

  • SAP Convergent Charging (SAP CC) 5.0 SP06
  • SAP Adaptive Server Enterprise (SAP ASE) 15.7
  • SAP Adaptive Server Enterprise (SAP ASE) 16 SP0
  • SAP Adaptive Server Enterprise (SAP ASE) 16 SP1

Product

SAP Convergent Charging 2020 ; SAP Convergent Charging 5.0

Keywords

ASE, SAP CC, installation, upgrade, install , KBA , IS-CC , Convergent Charging , 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.