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
- SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
- SAP Solution Manager (SOLMAN) 7.1
SQL257, SM_EFWK, iCI, E2E_ICIDB_IMHT , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
About this pageThis 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.