SAP Knowledge Base Article - Preview

2287998 - Solution Manager iCI access fails with ASE SQL257 - SAP ASE

Symptom

When running SOLMAN on ASE, you see the following error in transaction SM21: [ASE Error SQL257:42000][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed. Use the CONVERT function to run this query

Via ST05 trace you find the SQL commands causing the above error:

SELECT * FROM E2E_ICIDB_IMHT WHERE MANDT = 100 AND KPI_ID = ? AND INP_MEAS_ID = ? AND LANGU = ?
 

UPDATE E2E_ICIDB_IMHT SET LABEL_SERIES_NEW = ? WHERE KPI_ID = ? AND INP_MEAS_ID = ? AND LANGU = ? AND MANDT = 100


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
  • SAP Solution Manager (SOLMAN) 7.1

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.1

Keywords

SQL257, SM_EFWK, iCI, E2E_ICIDB_IMHT , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.