PostgreSQL error - system error 127: The specified procedure could not be found

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

PostgreSQL error - system error 127: The specified procedure could not be found

L1 Bithead

Hello Community,

 

we are getting this error message when trying to use the PostgreSQL platform, for both verify and change.

 

CACPM344E Verifying Password Error: Error when verifypass to User <userName> on Server <serverName> State: IM003 Native error: 160 Message: Specified driver could not be loaded due to system error 127: The specified procedure could not be found. (PostgreSQL Unicode, C:\Program Files (x86)\psqlODBC\1700\bin\podbc35w.dll).   The CPM is trying to verify this password because its status matches the following search criteria: ResetImmediately,Failure   Safe: <safeName> Folder: Root Object: Database-PostgreSQL-<data> failed (try #5) Code: 2103

we have tried to

  • istall the 64bit version, nothing, we reverted to 32 bit
  • tested the connection using the ODBC Data Source Administrator for 32bit, 'Test Successfull'
  • we enabled the debug mode for the platform, checked the log, couldn't find anything really useful

 

would you have any idea?

 

Thanks

Frank

1 accepted solution

Accepted Solutions

L1 Bithead

@Madat Yuzbashli​ 😁 it worked, thanks for the hint

 

solution: install an older version, keeping the 32bit version

View solution in original post

6 REPLIES 6

L5 Sessionator

Hi,

 

Have you installed posgtresql odbc unicode driver 32 bit? Check the version of driver you are installing. I remember this system error and it was related to postgre driver that is used by CPM

L1 Bithead

yes, I've installed the postgreSQL driver 32 bit and the C++ redistributable also 32 bit.....

but still same error

 

weird....

L5 Sessionator

Can you please show additional settings from platform settings and also screenshot from odbc 32 bit drivers tab in CPM?

L1 Bithead

sure, here are some settings.....

 

Field_Content_versions_oct20__068Vy00001FZluEIAT.pngField_Content_versions_oct20__068Vy00001FZ2gzIAD.pngField_Content_versions_oct20__068Vy00001FZuz3IAD.png 

if you need other settings of the platform, I can provide

Can you try to uninstall version 17 of odbc driver for postgre and try to install either 14 or 16? this should resolve the issue

L1 Bithead

@Madat Yuzbashli​ 😁 it worked, thanks for the hint

 

solution: install an older version, keeping the 32bit version

  • 1 accepted solution
  • 126 Views
  • 6 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!