SAP Knowledge Base Article - Preview

1944086 - sp_iqwho command fails due to error: 'cannot convert " into timestamp.'

Symptom

  • sp_iqwho;
    ConnHandle IQconnID Userid ReqType IQCmdType BlockedOn BlockUserid IQCursors IQThreads IQIdle SAIdle TempTableSpaceKB TempWorkSpaceKB
    ----------------------- ----------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------- ----------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- ----------------------- ----------------------- ----------------------- -----------------------
    5 20 tsgops EXEC_ANY_IMM NONE 0 NULL 0 0 54 54 0 0
    87 419 apazda DROP_STMT NONE 0 NULL 0 0 9408 9407 0 0

    (2 rows affected, return status = -2)
    Msg 257, Level 16, State 0

    SQL Anywhere Error -157: Cannot convert '' to a timestamp
    >


Read more...

Environment

  • SAP IQ 16.x

Product

SAP IQ 16.0

Keywords

sp_iqwho, IQ, time conversion error, SQL Anywhere Error -157: Cannot convert '' to a timestamp , KBA , BC-SYB-IQ , Sybase IQ , 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.