Full load from MSSQL to PG is failing

[gkaur]

 We deployed a new task to production last night but the full load is failing with below error ; same load worked perfectly in non-production. Need help to findout what are we missing in production.

FYI- Source and target DB versions are exactly the same.

---------------------------------------------------------------------------------

1691690: 2024-08-26T21:10:22:790018 [TARGET_LOAD ]T: Going to load file '/opt/attunity/replicate/data/tasks/MSSQL_MX_PG2_FLEETINVOICING/data_files/2/LOAD00000001.csv' (csv_target.c:1932)
01691690: 2024-08-26T21:10:22:790106 [TARGET_LOAD ]T: Load data command. Path: , Exe name: psql, Exe params: -h dbpginst2p.prod.fleet.ad -p 50002 -U gen_qlik_auth -w -d tcvd1_mfdc -c """\\copy \""REP_FLEETEINVOICING_CATALOG\"".\""CUSTOMER\"" from '/opt/attunity/replicate/data/tasks/MSSQL_MX_PG2_FLEETINVOICING/data_files/2/LOAD00000001.csv' WITH DELIMITER ',' CSV NULL 'attNULL' ESCAPE '\\'""" (provider_syntax_manager.c:3779)
01691690: 2024-08-26T21:10:22:790114 [TARGET_LOAD ]T: The final load string is '-c "\copy \"REP_FLEETEINVOICING_CATALOG\".\"CUSTOMER\" from '/opt/attunity/replicate/data/tasks/MSSQL_MX_PG2_FLEETINVOICING/data_files/2/LOAD00000001.csv' WITH DELIMITER ',' CSV NULL 'attNULL' ESCAPE '\' " "postgresql://@dbpginst2p.prod.fleet.ad:50002?dbname=tcvd1_mfdc&user=gen_qlik_auth&sslmode=prefer&sslrootcert=(null)&sslcert=(null)&sslkey=(null)&sslcrl=(null)&sslcompression=1"' (csv_target.c:1985)
01691690: 2024-08-26T21:10:22:790119 [TARGET_LOAD ]T: Going to run load statement, '/psql' (csv_target.c:1251)
01691690: 2024-08-26T21:10:22:790172 [TARGET_LOAD ]V: Load command parameters (1): (csv_target.c:1287)
01691690: 2024-08-26T21:10:22:790175 [TARGET_LOAD ]V: (1) -c "\copy \"REP_FLEETEINVOICING_CATALOG\".\"CUSTOMER\" from '/opt/attunity/replicate/data/tasks/MSSQL_MX_PG2_FLEETINVOICING/data_files/2/LOAD00000001.csv' WITH DELIMITER ',' CSV NULL 'attNULL' ESCAPE '\' " "postgresql://@dbpginst2p.prod.fleet.ad:50002?dbname=tcvd1_mfdc&user=gen_qlik_auth&sslmode=prefer&sslrootcert=(null)&sslcert=(null)&sslkey=(null)&sslcrl=(null)&sslcompression=1" (csv_target.c:1289)
01691690: 2024-08-26T21:10:22:792499 [TARGET_LOAD ]T: Before wait for command (csv_target.c:1030)
01691690: 2024-08-26T21:10:22:812642 [TARGET_LOAD ]T: Command failed to load data with exit error code 127, Command output: psql: symbol lookup error: psql: undefined symbol: PQmblenBounded [1020403] (csv_target.c:1084)
01691690: 2024-08-26T21:10:22:812668 [TARGET_LOAD ]T: Failed to wait for previous run [1020403] (csv_target.c:2205)
01691690: 2024-08-26T21:10:22:812772 [TARGET_LOAD ]V: Removing table folder '/opt/attunity/replicate/data/tasks/MSSQL_MX_PG2_FLEETINVOICING/data_files/2' (odbc_endpoint_imp.c:8455)
01691690: 2024-08-26T21:10:22:812833 [TARGET_LOAD ]T: Failed to load data from csv file. [1020403] (odbc_endpoint_imp.c:8461)
01691690: 2024-08-26T21:10:22:812840 [TARGET_LOAD ]T: Handling End of table 'REP_FLEETEINVOICING_CATALOG'.'CUSTOMER' loading failed by subtask 1 thread 1 [1020403] (endpointshell.c:3062)
01691690: 2024-08-26T21:10:22:812642 [TARGET_LOAD ]E: Command failed to load data with exit error code 127, Command output: psql: symbol lookup error: psql: undefined symbol: PQmblenBounded [1020403] (csv_target.c:1084)
01691690: 2024-08-26T21:10:22:812668 [TARGET_LOAD ]E: Failed to wait for previous run [1020403] (csv_target.c:2205)
01691690: 2024-08-26T21:10:22:812833 [TARGET_LOAD ]E: Failed to load data from csv file. [1020403] (odbc_endpoint_imp.c:8461)
01691690: 2024-08-26T21:10:22:812840 [TARGET_LOAD ]E: Handling End of table 'REP_FLEETEINVOICING_CATALOG'.'CUSTOMER' loading failed by subtask 1 thread 1 [1020403] (endpointshell.c:3062)
01691682: 2024-08-26T21:10:22:828837 [TASK_MANAGER ]W: Table 'Catalog'.'Customer' (subtask 1 thread 1) is suspended. Command failed to load data with exit error code 127, Command output: psql: symbol lookup error: psql: undefined symbol: PQmblenBounded
; Failed to wait for previous run; Failed to load data from csv file.; Handling End of table 'REP_FLEETEINVOICING_CATALOG'.'CUSTOMER' loading failed by subtask 1 thread 1thread 1 (replicationtask.c:3150)
01691690: 2024-08-26T21:10:22:832391 [TARGET_LOAD ]T: Command 'STOP' received in component 'st_1_PG_TGT_TCVISION' (streamcomponent.c:2358)
01691690: 2024-08-26T21:10:22:832410 [TARGET_LOAD ]T: Enter csv_target_free (csv_target.c:2261)
01691690: 2024-08-26T21:10:22:832669 [TARGET_LOAD ]T: Stream component 'st_1_PG_TGT_TCVISION' terminated (streamcomponent.c:2067)
01691690: 2024-08-26T21:10:22:833182 [TARGET_LOAD ]T: Entering 'odbc_endpoint_free_imp' (odbc_endpoint_imp.c:6021)
01691692: 2024-08-26T21:10:22:833612 [TARGET_LOAD ]T: Command 'STOP' received in component 'st_2_PG_TGT_TCVISION' (streamcomponent.c:2358)
01691692: 2024-08-26T21:10:22:833632 [TARGET_LOAD ]T: Enter csv_target_free (csv_target.c:2261)
01691692: 2024-08-26T21:10:22:833639 [TARGET_LOAD ]T: Stream component 'st_2_PG_TGT_TCVISION' terminated (streamcomponent.c:2067)
01691692: 2024-08-26T21:10:22:834008 [TARGET_LOAD ]T: Entering 'odbc_endpoint_free_imp' (odbc_endpoint_imp.c:6021)

[sureshkumar]

Hello @gkaur 

It seems this version of Replicate requires the ODBC and supporting libraries from PostgreSQL.

Refer: postgresql - psql: symbol lookup error: psql: undefined symbol: PQsetErrorContextVisibility - Stack ...

PostgreSQL: Re: PG 14.1 psql: symbol lookup error: psql: undefined symbol: PQmblenBounded

Regards,

Suresh

[gkaur]

Suresh , we  have already checked out these links and found no clue.

FYI- We have other Qlik tasks reading this PG instance as source and writing to Snowflake as target, the only difference between this failing task is that we are now writing to the this PG instance as target. I don;t think driver or library should be a problem.

[sureshkumar]

Hello @gkaur 

Please open a support ticket with us to analyze further.

Regards,

Suresh

[john_wang]

Hello @gkaur ,

Obviously this is an ODBC installation and setup issue. Please check How to Install PostgreSQL ODBC client on Linux for PostgreSQL Target Endpoint.

Hope it helps.

John.