Skip to main content

error_code=64

  • October 7, 2015
  • 1 reply
  • 9 views

DMM

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?

 

1 reply

Adrian_Oprea_1
Forum|alt.badge.img+1
  • Participating Frequently
  • October 7, 2015

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
?column?
----------
4
(1 row)
-- good label
dbadmin=> select /*+label(label_name)*/ 4 from dual;
?column?
----------
4
(1 row)

dbadmin=> SELECT session_id FROM CURRENT_SESSION;
session_id
--------------------------
prodvert01-47446:0x189bb
(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.