Problem:
When I executed the DIP script “DIPRTBLOP - R Table Operator” failing, it failing with following error:
Error in file:
CREATE FUNCTION td_sysgpl.ExecR()
RETURNS TABLE VARYING USING FUNCTION ExecR_contract
LANGUAGE R
NO SQL
PARAMETER STYLE SQLTABLE
EXTERNAL NAME 'CS!ExecR!udfexecR.c!F!ExecR';
*** Create function completed with error(s).
*** Warning: 5603 Errors encountered in compiling UDF/XSP/UDM/UDT/JAR.
*** Total elapsed time was 1 second.
Errors/Warnings reported during compilation
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/usr/bin/gcc -D_REENTRANT -D_LIBC_REENTRANT -I/usr/tdbms/etc -L/usr/td
bms/lib -DHOSTCHARSET=0 -fpic -c ExecR.c
ExecR.c: In function 'executeRUDF':
ExecR.c:747: warning: assignment from incompatible pointer type
ExecR.c:762: warning: assignment from incompatible pointer type
/usr/bin/gcc -D_REENTRANT -D_LIBC_REENTRANT -I/usr/tdbms/etc -L/usr/td
bms/lib -DHOSTCHARSET=0 -fpic -c Teradata_new_delete.cpp
/usr/bin/gcc -D_REENTRANT -D_LIBC_REENTRANT -I/usr/tdbms/etc -L/usr/td
bms/lib -DHOSTCHARSET=0 -fpic -c pre_ExecR_contract.c
/usr/bin/gcc -D_REENTRANT -D_LIBC_REENTRANT -I/usr/tdbms/etc -L/usr/td
bms/lib -DHOSTCHARSET=0 -fpic -c pre_ExecR.c
/usr/bin/gcc -shared -fpic -Xlinker -rpath -Xlinker /usr/tdbms/lib -Wl,--ve
rsion-script=/var/opt/teradata/tdtemp/UDFTemp/03FC.30718.1D2e6/UserUdf_vers
ions.scr -D_REENTRANT -D_LIBC_REENTRANT -I/usr/tdbms/etc -L/usr/tdbms/
lib -DHOSTCHARSET=0 -o @FileList -ludfGPLudf -lm -lstdc++
/usr/lib64/gcc/x86_64-suse-linux/4.3/../../../../x86_64-suse-linux/bin/ld: cannot find -ludfGPLudf
collect2: ld returned 1 exit status
make: *** [libudf_03fc_0_17.so] Error 1
/var/opt/teradata/tdtemp/UDFTemp/03FC.30718.1D2e6/libudf_03fc_0_17.so: cannot open shared object file: No such file or directory
+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
Solution:
The dip script has failed due to compatible issue. The functionality for R/udfgpl is tightly coupled with the ptdbms version. So, it's mandatory that the ptdbms and udfgpl package versions must match.
The mismatch will not harm the Teradata database in any way, but R will clearly not work and R startup errors will be prevalent in /var/log/messages.
You can see the current ptdbms running version on the system using the following command:
psh pdepath -i
<--------------------- localhost -------------------------------->
PDE: 16.20.07.01
TDBMS: 16.20.07.01
TDGSS: 16.20.07.01
TGTW: 16.20.07.01
TCHN: 16.20.10.60
PDEGPL: 16.20.07.01
you can check teradata-udfgpl version following way:
# rpm -qa|grep -E 'teradata-udfgpl'
teradata-udfgpl-16.20.23.01-1
If you see ptdbms version and udfgpl version is not matching. To solve this problem:
1. Install the Teradata-udfGPL package that matches your version of the PTDBMS.
2. Run DIP script DIPRTBLOP again