Skip to Content
0
Aug 18, 2014 at 02:01 AM

Internal communication error when execute procedure on HANA MPP Cluster

44 Views


Hi All,

I'm executing a hana POC at customer environment, it's a 6 nodes hana cluster (with one master & 5 work node).

When I create a table cross all nodes, and than execute a procedure with that table, it's failed by internal error

create columnt table CC.AA (NEWDATE DATE primary key) replica AT all locations;

create procedure CC.P_INS_ADW_DIM_DATE( )

LANGUAGE SQLSCRIPT

SQL SECURITY INVOKER

AS

FULLDATE DATA;

MONTHNUMBER INTEGER;

YEARNUMBER INTEGER;

DAYNUMBER INTEGER;

BEGIN

FULLDATE:=TO_DATE('19800101','YYYYMMDD');

INSERT INTO "CC"."AA" CALUES(FULLDATE);

END;

CALL CC.P_INS_ADM_DIM_DATE( );

The error message like below:

SAP DBTech JDBC: Cannot connect to VolumeID=7 [Cannot connect to host 172.21.36.58:34215 [Connection timed out]]

172.21.36.58 is internal communication IP address of the cluster node, while is public IP should be 192.168.1.123

I'm wonder if Hana call data through internal channel, does the port should be 3××003

And I saw in /etc/hosts internal IP bound to host name, not public IP

hana003 172.21.36.58

Can anyone help?

thanks!

Attachments

Error message.jpg (142.5 kB)