We are frequency getting entries like

Received no response from <node name> in gather local state? in error_messags


It's a warning message with error_code=64


Has anyone encountered it before?



  • That is a warning ! It means you are doing something wrong and it will come with an messege.

     This specific error is related to the fact that your hint/label identifier starts with numeric character which cannot.

    - this happened to me in Microstrategy while setting labes using Reports GUIDs.

    Here is shot demo of this warning in action:

    - this warning msg you will get it at vsql command line. 


    -- wrong label
    dbadmin=> select /*+label(1label_name)*/ 4 from dual;
    WARNING 3628: Invalid character in hint at or near "(1" at character 16
    (1 row)
    -- good label
    dbadmin=> select /*+label(label_name)*/ 4 from dual;
    (1 row)

    dbadmin=> SELECT session_id FROM CURRENT_SESSION;
    (1 row)

    dbadmin=> \x
    Expanded display is on.
    dbadmin=> select * from error_messages where session_id='prodvert01-47446:0x189bb';
    -[ RECORD 1 ]---+------------------------------------------
    event_timestamp | 2015-10-08 10:40:39.275538+11
    node_name | v_analytics_node0004
    user_id | 45035996273704962
    user_name | dbadmin
    session_id | prodvert01-47446:0x189bb
    request_id | 0
    transaction_id | 45035996307835116
    statement_id | -1
    error_level | WARNING
    error_code | 64 -- here is your error code
    message | Invalid character in hint at or near "(1"
    detail |
    hint |

    - i hope this help, and there are some other posts where people state is a bug, is not. 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file