cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Select query Issue on HANA Cloud Replicated table from S/4

Chandru_SAP
Discoverer
0 Likes
452

Hi Team,

Requirement: Replicate the S/4 table into Hana Cloud and query the record from Iflow-Groovy script and modify the Json payload

(1) I did replicate on prem(S/4) table into Hana cloud.

Chandru_SAP_0-1739809013686.png

(2) Query is working in SQL Console.

Chandru_SAP_1-1739809143721.png

(3) I did small test via JDBC which is getting me a result what i need.

Chandru_SAP_2-1739809210613.png

PostMan:

Chandru_SAP_3-1739809247176.png

(4) When i implement the same query via Groovy script, its not working as expected.

Chandru_SAP_4-1739809320015.png

(5) Groovy script:

Chandru_SAP_5-1739809401145.png

(6) PostMan result:

Chandru_SAP_6-1739809436697.png

Attribute value is not getting modified. Apparently query is not getting executed. Pls suggest.

Thanks

 

 

Accepted Solutions (1)

Accepted Solutions (1)

Chandru_SAP
Discoverer
0 Likes

Found the Issue. It is due to case sensitive at 'dbUrl'. Its working now.

Thanks

Answers (1)

Answers (1)

Chandru_SAP
Discoverer
0 Likes

found the issue. Its due to case sensitive at 'dbUrl'.

 

Thanks