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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.