topic Re: Unable to Create a User Defined Function in Replicate in Qlik Replicate

Unable to Create a User Defined Function in Replicate

Machholz — Mon, 17 Jun 2024 14:58:42 GMT

Hello all,

I have followed the documentation, read the README in the /addons folder, and compiled the sample UDF 'My Transformation' successfully. But the Qlik service is unable to load, and I am thinking it is because there is an error either in the addons_def.json file or something within the .dll. I am unable to figure it out and would appreciate any help.

Here is my addons_def.json:

I have already tried using an absolute path as well, but that did not work. Any help is appreciated.

Thanks

Re: Unable to Create a User Defined Function in Replicate

john_wang — Mon, 17 Jun 2024 16:10:17 GMT

Hello @Machholz ,

Thanks for reaching out to Qlik Community!

Looks to me the addons_def.json is correct, would you please confirm:

1- the .dll file location is "samples\\MyTransformation\\MyTransformation.dll", and the service was restarted

2- the "unable to load" is error message or just a warning? In my labs, I got warning in Qlik Replicate 2023.11 however the function works fine indeed, the screen shot :

Regards,

John.

Re: Unable to Create a User Defined Function in Replicate

Machholz — Mon, 17 Jun 2024 16:50:03 GMT

Hey @john_wang,

Yes that is the path where the .dll is located, but the service itself did not start.

I tested something where I commented out the path of the dll in the addons_def.json, and the service started and the UDF did not appear as expected. I suspect that it is unable to load the .dll due to the type 'STARTUP' but I am not too sure.

Thanks.

Re: Unable to Create a User Defined Function in Replicate

Heinvandenheuvel — Mon, 17 Jun 2024 18:21:18 GMT

From the Readme:

>> Copy the shared library to <installation_dir>\addons\<addon_name>\<addon_name>.[dll/so]

That's the proper, default place. You can indeed provide an explicit location like the 1- the .dll file location is "samples\\MyTransformation\\MyTransformation.dll", but I do not like that as much myself.

Now what about "MyPasswordProvider". It is listed in your addons_def.json.

WHY? Did you built that? I suspect not. If you didn't then be sure to remove that whole section otherwise Replicate will go out to <installation_dir>\addons\MyPasswordProvider\MyPasswordProvider.[dll/so] and of course fail to find it

Hein.

Re: Unable to Create a User Defined Function in Replicate

Machholz — Mon, 17 Jun 2024 18:38:00 GMT

Sorry for the confusion, by accident I uploaded the wrong screen shot. I did have the "MyPasswordProvider" deleted in the json.

Thanks

Re: Unable to Create a User Defined Function in Replicate

john_wang — Tue, 18 Jun 2024 01:02:37 GMT

Hello @Machholz ,

I'm not sure if DLL was compiled on the same Replicate server or not. If it's compiled on another machine please make sure the module was build in RELEASE mode rather than DEBUG mode (which is the default option) as the DLL dependencies impact the DLL load.

We'd like help to verify DLL function if you can share it (removing the sensitive information and important logic codes and then re-compile it again).

Hope this helps.

John.

Re: Unable to Create a User Defined Function in Replicate

Machholz — Wed, 19 Jun 2024 14:54:07 GMT

Hey @john_wang,
I have compiled it on a different machine, but I'm not sure what you mean by RELEASE or DEBUG mode? Is there a certain flag I should've used during compilation? Or does it have something to do with Replicate itself?

I have also attached the dll file I compiled originally.

Thanks.

Re: Unable to Create a User Defined Function in Replicate

john_wang — Wed, 19 Jun 2024 15:01:21 GMT

Hello @Machholz ,

Thanks for sharing the file, I'm going to have a test on it and get back to you shortly.

Regarding the RELEASE or DEBUG mode, it's a setting in Visual Studio. Let me find a sample for you. Please allow me some minutes.

Regards,

John.

Re: Unable to Create a User Defined Function in Replicate

john_wang — Wed, 19 Jun 2024 15:07:05 GMT

Hello @Machholz ,

Please check Microsoft Doc Set debug and release configurations in Visual Studio

From the Build menu, select Configuration Manager, then select Debug or Release.

Regards,

John.

Re: Unable to Create a User Defined Function in Replicate

john_wang — Wed, 19 Jun 2024 15:27:16 GMT

Hi @Machholz ,

The DLL does not work for me. "repcmd.log" show the error message like:

2024-06-19T23:18:30:235401 [ADDONS ]W: Failed to load add-on path <C:\Program Files\Attunity\Replicate\addons\samples\MyTransformation\MyTransformation.dll>, error: <%1 is not a valid Win32 application. > (at_addons_manager.c:251)

Would you please confirm you compiled it to a 64-bit DLL ? and also please set to RELEASE mode then re-compile.

Hope this helps.

John.

Re: Unable to Create a User Defined Function in Replicate

Machholz — Wed, 19 Jun 2024 18:30:11 GMT

Hello @john_wang,

I also received that same error in "repcmd.log" but wasn't sure what that was. I used a cli compiler instead of Visual Studio directly, so I will try your instructions and see if the problem continues.

Thanks.

Re: Unable to Create a User Defined Function in Replicate

john_wang — Thu, 20 Jun 2024 00:59:12 GMT

Hello @Machholz ,

thanks for the update.

Regards,

John.

Re: Unable to Create a User Defined Function in Replicate

gideeeh — Sun, 03 Nov 2024 13:04:29 GMT

Hi John,

I wanted to check in to see if there have been any updates on this issue. I'm encountering the same error:

00016704: 2024-11-03T20:49:16 [ADDONS ]W: Failed to load add-on path <C:\Program Files\Attunity\Replicate\addons\MyTransformation\MyTransformation.dll>, error: <%1 is not a valid Win32 application. > (at_addons_manager.c:251)

I’ve tried compiling the DLL as a 64-bit application using Visual Studio Developer Command Prompt, but I’m still running into the same problem. Do you have any solutions or suggestions?

The compile code I used was this:

cl /LD /O2 /MACHINE:x64 MyTransformation.c /Fe:MyTransformation.dll /I "C:\Program Files\Attunity\Replicate\addons\include"

addons_def.json

{ "addons": [ { "name": "MyPasswordProvider", "type": "STARTUP", //"lib_path": "samples\\MyPasswordProvider\\MyPasswordProvider.dll", //"lib_path": "samples/MyPasswordProvider/MyPasswordProvider.so", "init_function": "ar_addon_init" }, { "name": "MyTransformation", "type": "STARTUP", "lib_path": "MyTransformation\\MyTransformation.dll", //"lib_path": "samples/MyTransformation/MyTransformation.so", "init_function": "ar_addon_init" } ] }

Thanks for your help!

Re: Unable to Create a User Defined Function in Replicate

john_wang — Fri, 08 Nov 2024 06:54:43 GMT

Hello @gideeeh ,

Please use the default project to compile the DLL rather than the command line. I guess the issue was caused by the compiling.

Regards,

John.