Message-ID: From: "Maniyur1Git (@Maniyur1Git)" To: "postgresql-interfaces/psqlodbc" Date: Fri, 31 May 2024 20:34:33 +0000 Subject: Re: [postgresql-interfaces/psqlodbc] issue #22: ODBC driver issue while working with Informatica Cloud In-Reply-To: References: List-Id: X-GitHub-Author-Login: Maniyur1Git X-GitHub-Comment-Id: 2142942756 X-GitHub-Comment-Type: issue_comment X-GitHub-Issue: 22 X-GitHub-Repo: postgresql-interfaces/psqlodbc X-GitHub-Type: comment X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/22#issuecomment-2142942756 Content-Type: text/plain; charset=utf-8 Dave, Informatica recommded to use driver version - 14.x or 15.x. Here is the article link - [(https://knowledge.informatica.com/s/article/FAQ-What-are-the-supported-application-versions-for-relational-NoSQL-and-real-time-connectors-and-supported-distribution-versions-for-big-data-connectors-in-IICS-Cloud-Data-Integration?language=en_US)] But job failed with same error, sharing the stack trace for your reference. 2024-05-31 20:16:46,656 UTC INFO [com.informatica.saas.dtm.executor.impl.ProcessStreamReader] dtm-executor-1-01CRID0E00000000025T-wf_mtt_01CRID0Z000000000005-39 - [01CRID0Z000000000005 01CRID0E00000000025T] ***********FATAL ERROR : Caught a fatal signal or exception. ********************** FATAL ERROR : Aborting the DTM process due to fatal signal or exception. *********** *********** FATAL ERROR : Signal Received: SIGSEGV (11) *********** Stack trace produced by process [pmdtm(:wf_mtt_01CRID0Z000000000005.s_mtt_01CRID0Z000000000005)] with pid [2394934]. ./libpmasrt.so(PmDumpStackTrace+0x79)[0x7f6128debd99] /opt/infaagent/apps/Data_Integration_Server/68.0.12.1/ICS/main/bin/rdtm/pmdtm[0x5e8c7a] /lib64/libpthread.so.0(+0x12d20)[0x7f612b2a2d20] /lib64/libc.so.6(+0xaa80b)[0x7f611da9f80b]. /libpmcrypto.so.1.0.0(lh_insert+0xa9)[0x7f612965c019] ./libpmcrypto.so.1.0.0(OBJ_NAME_add+0x79)[0x7f61295b9639] /lib64/libssl.so.1.1(+0x3718c)[0x7f60e7a0f18c]/lib64/libpthread.so.0(+0xfe97)[0x7f612b29fe97] /lib64/libcrypto.so.1.1(CRYPTO_THREAD_run_once+0xd)[0x7f60e76dea5d] /lib64/libssl.so.1.1(OPENSSL_init_ssl+0x5b)[0x7f60e7a0f3eb] /lib64/libpq.so.5(+0x2577c)[0x7f60e7c9177c] /lib64/libpq.so.5(PQconnectPoll+0xc70)[0x7f60e7c7c660] /lib64/libpq.so.5(+0x11805)[0x7f60e7c7d805] /lib64/libpq.so.5(PQconnectdbParams+0x28)[0x7f60e7c80748] /usr/local/lib/psqlodbcw.so(+0x16a5e)[0x7f60e7ed4a5e] /usr/local/lib/psqlodbcw.so(+0x1bad8)[0x7f60e7ed9ad8] /usr/local/lib/psqlodbcw.so(+0x1c3d7)[0x7f60e7eda3d7] /usr/local/lib/psqlodbcw.so(SQLConnect+0x9e)[0x7f60e7f1341e] /opt/infaagent/apps/Data_Integration_Server/../../drivers/misc/base/bin/libodbc.so.2(SQLConnect+0x1ee)[0x7f60e836973e] ./libpmodbc2.so(_ZN7TODBCDb7ConnectERK9PmUStringS2_S2_s+0x52a)[0x7f60e85dd5da] ./libpmodl.so(_ZN9TDatabase11ConnectImplERK9PmUStringS2_S2_s+0x67)[0x7f6125a19887] ./libpmodl.so(_ZN9TDatabase7ConnectERK9PmUStringS2_S2_si+0x12a)[0x7f6125a1a05a] ./libpmrelrdr.so(_ZN9relReader7connectEi+0xd8)[0x7f61180d4a98] ./libpmrelrdr.so(_ZN9relReader7ConnectEv+0x93)[0x7f61180d9893] /opt/infaagent/apps/Data_Integration_Server/68.0.12.1/ICS/main/bin/rdtm/pmdtm(_ZN15frame_blkReader4initEv+0xe2)[0x7c06f2] /opt/infaagent/apps/Data_Integration_Server/68.0.12.1/ICS/main/bin/rdtm/pmdtm(_ZN15SReaderRunnable13handleRequestERK15SManagerRequest+0x4d)[0x7c0a4d] /opt/infaagent/apps/Data_Integration_Server/68.0.12.1/ICS/main/bin/rdtm/pmdtm(_ZN7SWorker3runEv+0x372)[0x6341d2] /opt/infaagent/apps/Data_Integration_Server/68.0.12.1/ICS/main/bin/rdtm/pmdtm(_ZN12SDTMRunnable14MainEntryPointEv+0xf1)[0x60f901] ./libpmcef.so(_Z5runitPv+0xa)[0x7f612b08affa]/lib64/libpthread.so.0(+0x81ca)[0x7f612b2981ca]/lib64/libc.so.6(clone+0x43)[0x7f611da2e8d3]