Troubleshooting

Troubleshoot installation errors with the provided solutions.

Libiconv configuration failure

To resolve this error, follow the steps.

./stdio.h:1010:1: error: 'gets' undeclared here (not in a function)
    _GL_WARN_ON_USE (gets, "gets is a security hole - use fgets instead");
    ^

Unpack the libiconv-1.14.tar.gz package:
```
tar -xvzf libiconv-1.14.tar.gz
```
You downloaded libiconv-1.14.tar.gz from
Open stdio.in.h:
```
vi libiconv-1.14/srclib/stdio.in.h
```

Find the following code in the stdio.in.h file:

_GL_WARN_ON_USE (gets, "gets is a security hole - use fgets instead");

Replace the line from step 3 with the following code:

#if defined(__GLIBC__) && !defined(__UCLIBC__) && !__GLIBC_PREREQ(2, 16)
_GL_WARN_ON_USE (gets, "gets is a security hole - use fgets instead");
#endif

tar -cvzf libiconv-1.14.tar.gz libiconv-1.14

R is installed, but the R adapter is not installed

Check if R is installed correctly.

/nz/export/ae/languages/r/3.5/host64/bin/R--version

Example:

/nz/export/ae/languages/r/3.5/host64/bin/R--version
R version 3.5.1 (2018-07-02) -- "Feather Spray"
Copyright (C) 2018 The R Foundation for Statistical Computing
Platform: x86_64-pc-linux-gnu (64-bit)

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under the terms of the
GNU General Public License versions 2 or 3.
For more information about these matters see http://www.gnu.org/licenses/.

This output means that R is successfully installed on the system.

Verify whether the R adapter is installed correctly.

nzcm --installed | grep r_ae

Example:

nzcm --installed | grep r_ae
r_ae                           | 11.2.1.1   |

This output confirms that the R adapter is installed.

If no output is returned, run the following commands:

ln -s /nz/export/ae/languages/r/3.5/ /nz/export/ae/languages/r/3.0

```
nzcm -i r_ae -d inza
```
```
nzcm -r r_ae -d inza
```

Verify that the installation was successful by running the following SQL command:

SYSTEM.ADMIN(ADMIN)=> SELECT * FROM TABLE WITH FINAL(nzr..r_udtf('CODE_PLAIN="getNext();setOutput(0,''output value'');outputResult()"'));
 COLUMNID |    VALUE
----------+--------------
        0 | output value
(1 row)