Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

8
Replies
2285
Views
ParijatM3165 Member since 2013 1 post
Capgemini
Posted: Oct 3, 2016
Last activity: Oct 14, 2016
Closed

postgresql 9.3 could not load library pljava.dll %1 is not valid win32 application

I am installing Pega 7.2.1 on Apache Tomcat and Postgresql 9.3 version. As per the instructions had installed postgresql 9.3.5 x64.exe.

Copied the pljava.jar and pljava.dll file from the resource kit to postgres lib directory. Also updated the postgresql.conf file as instructed.

On a windows 2008R2 server 64 bit and jdk 1.7.

When I try to run the install sql , I keep getting an error "ould not load library pljava.dll %1 is not valid win32 application". I did try both 32 bit and 64 bit Postgresql but in all cases get the same error.

 

Can anyone advise me how to fix this.

To see attachments, please log in.
Installation and Deployment

Posted: 8 years ago

The error suggests that pljava.dll and pljava.jar were not deployed or your system is not allowing you to install .dll files. Please check you should have admin rights and avoid installing postgresql in C:/Program files location.

 

To see attachments, please log in.
Posted: 8 years ago

Hi Baigh,

Thanks for your response. But I checked the article and actually followed it step by step.

I am stuck when i run this

   java -classpath "<Postgres JDBC.jar path>;<pljava/deploy.jar path>" org.postgresql.pljava.deploy.Deployer -install -database <dbname> -user <user name> -pass <user password>

and that is when i get the exception that could not library pljava.dll %1 is not a valid win32 application.

 

Thanks & regards

Parijat

To see attachments, please log in.
Posted: 8 years ago

Postgres 9.3 needs MSVCR 2013 installed. You would need to use dependency walker to see what pljava.dll is looking for. This will tell which version of MSVCR they need for sure.

http://www.dependencywalker.com/

 

PG 9.1 -> Visual Studio 2008  à MSVCR.DLL (I think)

PG 9.2 -> Visual Studio 2010 à MSVCR110.DLL

PG 9.3 -> Visual Studio 2013 à MSVCR120.DLL

PG 9.4 -> Visual Studio 2013 à MSVCR120.DLL

 

 

To see attachments, please log in.
Posted: 8 years ago

Parijat,

I believe you may need MSVCR 2013 installed for Postgres 9.3. The best way to tell is to use dependency walker (freeware) to look at pljava.dll and see which MSVCR DLL it is dependent on.

If you see a dependency on MSVCR120.dll, then you need MSVCR 2013 installed. If the dependency is for MSVCR110.dll, then you need MSVCR 2010. If the dependency is for MSVCR.dll, then you need MSVCR 2008.

MSVCR = Microsoft Visual C++ Redistributables

I attached an example of what you see in dependency walker for reference.

To see attachments, please log in.
Posted: 8 years ago

Thanks a ton for this reply it shows MSVRC100.dll in the dependency seems it is looking for 2010 visual C++ distributables. Let me try installing the same and see if it works but again thanks for the suggestion.

To see attachments, please log in.
Posted: 8 years ago

Hi All,

I am still stuck with %1 is not valid win32 application. I am installing  postgresql-9.4.9-2-windows-x64 with jdk 1.8 and jdbc postgresql-9.4-1202.jdbc42.jar on windows 2008 sp2 server with MSVC 2013. Attached is the dependency walker scrrenshot.

I had done all the steps as mentioned in the resource kit readme and trying to install Pega 7.2.1 licensed software. Have copied the pljava.dll and pljava.jar into postgres lib folder. 

It would be hugely helpful if someone can send me detailed steps for installing and any fixes if possible.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice