The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Recompiling the fjsonparser

Hi All,


I'm trying to load some json data with the fjsonparser but I've received the following error:


ERROR 6999: The library [FlexTableLib] for the function [fjsonparser()] was compiled with an incompatible SDK Version [v7.1.2-4]
HINT: Recompile the library with the SDK version [7.2.1] and then recreate the library and functions


I am running Vertica 7.2.1, but I have absolutely no idea where the source for fjsonparser might be, or how to recompile it.  Any pointers would be greatly appreciated!




  • Hi!


    1. Post full version of your Vertica instance(with minor fixes).

    Hint: select version();

    daniel=> select version();
    Vertica Analytic Database v7.2.1-1
    (1 row)


    2. Post your OS distribution + version.

    For example:

    (~)$ cat << EOF | python
    import platform as os
    print '*' * 20
    print os.linux_distribution()
    print os.uname()
    ('Ubuntu', '14.04', 'trusty')
    ('Linux', 'synapse', '3.13.0-74-generic', '#118-Ubuntu SMP Thu Dec 17 22:52:10 UTC 2015', 'x86_64', 'x86_64')


    3. Post content of dir: /opt/vertica/packages/flextable/lib

    For example:


    (~)$ ls -1l  /opt/vertica/packages/flextable/lib
    total 11768
    lrwxrwxrwx 1 root root 29 Dec 16 02:30 ->
    -rw-r--r-- 1 root root 12048320 Dec 16 01:48


    3. Post md5sum of /opt/vertica/packages/flextable/lib/

    For example:


    (/opt/vertica/packages/flextable/lib)$ md5sum ./
    05e6c13e03cdaae66aac0c78b9dfe431 ./


    4. Post output of file.

    For example:

    (/opt/vertica/packages/flextable/lib)$ file ./ 
    ./ ELF 64-bit LSB shared object, x86-64, version 1 (SYSV), dynamically linked, BuildID[sha1]=72738bb8a579ebb2f7afa9cf7eec2011f23a1877, not stripped



    >> but I have absolutely no idea where the source for fjsonparser might be

    It's not open source, actuaally you can't recompile by yourself.


    Disclimer: Im not a Vertica employee.

  • Hi,


      You appear to have experienced an upgrade issue that we're currently investigating.  You actually have the right version of Flex in /opt/vertica/packages, it just needs to get installed:


      /opt/vertica/bin/admintools -T install_package -P default -d <database> -p <password>


      Note: do not uninstall flex - there is no need to uninstall/install.  Just install over the top of the existing old flex package.


      Please let me know if this works.



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file