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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.