2118541 - Error 257: "Implicit conversion from datatype ... is not allowed ..." when executing sp_configure to change the ASE optimization goal - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2118541 - Error 257: "Implicit conversion from datatype ... is not allowed ..." when executing sp_configure to change the ASE optimization goal - SAP ASE

Symptom

  • Execution of sp_configure to change the ASE server-wide optimization goal fails with error 257:

    sp_configure 'optimization goal', allrows_mix
    go

    Msg 257, Level 16, State 1:
    Server 'SYBASE', Procedure 'sp_configure':
    Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed.  Use the CONVERT function to run this query.
    (return status = -6)

  • The same error occurs if the goal is enclosed in quotes
  • Execution of sp_configure 'optimization goal' is successful
  • Execution of sp_configure '<other configuration parameter>', <new value> is also successful

Read more...

Environment

  • Sybase Adaptive Server Enterprise (ASE) 15.0
  • Sybase Adaptive Server Enterprise (ASE) 15.5
  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

'optimization goal' , 'implicit conversion' , error 257, message 257 , "sp_configure 'optimization goal'" , sp_configure , KBA , optgoal , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.