cancel
Showing results for 
Search instead for 
Did you mean: 

Error in HANA

Former Member
0 Kudos

Hi All,

Doesn't anyone knows the reason for the following error?

Msg=[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;3584 distributed SQL error:  [2617] executor: plan operation execution failed with an exception

Thanks,

Tal.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182302
Active Contributor
0 Kudos

are you firing any select/alter query and getting this error? Can you share the exact SQL you are using?

Regards,

Krishna Tangudu

Former Member
0 Kudos

Hi Krishna,

I'm using a simple query on a system table:

SELECT TABLE_NAME FROM SYS.M_TABLES WHERE TABLE_NAME='xxx' AND SCHEMA_NAME='yyy'

BR,

Tal.

former_member182302
Active Contributor
0 Kudos

Hi Tai,

Not sure why you want to keep filter condition on TABLE_NAME and again SELECT TABLE_NAME.

Have executed the below query:

SELECT TABLE_NAME FROM SYS.M_TABLES

In System ( with single node) it executed without any errors.

In System ( with multiple nodes ) It hit the same error you have got.

But if you are looking for Table_Name information you can do union on these 2 tables as below:

SELECT TABLE_NAME FROM M_CS_TABLES

UNION ALL

SELECT TABLE_NAME FROM M_RS_TABLES

The above query should work fine.

But yes am also interested to know why that "Distributed" error comes up.

Regards,

Krishna Tangudu

Former Member
0 Kudos

Thank you Krishna,

Is there someone who can expain why the issue abiove occurs?

Thanks,

Tal.