Solution : https://service.sap.com/sap/support/notes/1774187 (SAP Service marketplace login required)
Summary :
SAP HANA DB environments prior to SPS5 may encounter errors with GNav queries using "GROUPING SETS" in distributed systems, notably the error "[7]: feature not supported: not supported to insert table info at remote nodes". This issue arises as GNav querying on slave nodes lacks necessary feature support. Resolutions include disabling client distribution by running the SQL command: "ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') set ('distribution', 'client_distribution_mode') = 'off' with reconfigure", or upgrading to SAP HANA DB SPS5 or later versions to ensure full functionality.
Key words :
insert table infoat remote nodes, missing feature gnav queries result, alter system alter configuration, sap hana db lower, sap hana db sps5, solution - disable client distribution, symptom gnav queries, terms hana, guided navigation, grouping sets
Related Notes :
| 1920852 | |
| 1918550 | |
| 1913174 | SAP HANA Database Revision 66 |
| 1912291 | SAP HANA Database Revision 65 |
| 1908139 | SAP HANA Database Revision 64 |
| 1901670 | SAP HANA Database Revision 63 |
| 1894285 | SAP HANA appliance: Revision 62 of SAP HANA database |
| 1888585 | SAP HANA appliance: Revision 61 of SAP HANA database |
| 1880274 | SAP HANA appliance: Revision 60 of SAP HANA database |
| 1873115 | SAP HANA appliance: Revision 58 of SAP HANA database |
| 1869142 | SAP HANA appliance: Revision 57 of SAP HANA database |
| 1858938 | SAP HANA appliance: Revision 56 of SAP HANA database |
| 1852425 | SAP HANA appliance: Revision 55 of SAP HANA database |
| 1848035 | SAP HANA appliance: Revision 54 of SAP HANA database |
| 1830621 | SAP HANA appliance: Revision 52 of SAP HANA database |
| 1825895 | SAP HANA appliance: Revision 53 of SAP HANA database |
| 1823655 | SAP HANA appliance: Revision 51 of SAP HANA database |
| 1819928 | SAP HANA appliance: Revision 50 of SAP HANA database |
| 1808897 | SAP HANA appliance: Revision 48 of SAP HANA database |
| 1808882 | SAP HANA appliance: Revision 49 of SAP HANA database |
| 1803674 | |
| 1800724 | |
| 1793917 | |
| 1786963 | |
| 1774253 | SAP HANA appliance: Revision 40 of SAP HANA database |
| 1523337 | SAP In-Memory Database 1.0: Central Note |
| 1514967 | SAP HANA 1.0: Central Note |