Internal communication error when execute procedure on HANA MPP Cluster

[former_member269047]

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!

[umashankar_poojar]

Hi Experts,

  Did anybody faced same problem mentioned above? how to fix it.

Thanks,

Umashankar