FR_3002, FR_3019 – Operating system error message [The parameter is incorrect]

You might get this error when running a session having File List. There are many of them but the very subtle one is that even if one of the file name is wrongly typed the session will fail when reading the very first file out of the list. This may lead to head scratching & you might end up as zombie. Ideally the filename which is wrong should be flagged in the logs, however what you see is the very first file tagged in front of Error No.

I had my stock Items file something like this

Here the last filename is not having txt suffixed to it, hence the session failed when reading the very first file, though this file in all essence was correct.

 

Error occurred loading library [pmora8.dll] & invalid Win32 application

Are you getting this error when connecting to oracle, while creating a repository?

Database driver event...Error occurred loading library [pmora8.dll].
System error encountered is 193. Error text is %1 is not a valid Win32 application

If so, then most probably you are connecting to a 64 bit database which does not have its 32 bit client installed on your machine. Your informatica is 32 bit and will always use 32 bit client to connect to the database. However you do not have a 32 bit client installed on your machine. Informatica can not find it and therefore could not connect to 64 bit oracle. Result is that you get this error.

Solution is to install Oracle 32 bit client for your version of oracle. Get it from oracle download center. Make sure that the home of this Oracle client should be different from your originally installed oracle 64 bit client & the home-path is listed in PATH environment variable.

You can also get an error when you run sqlplus after install …. the error could be TNS:protocol adapter . Don’t worry and try to check by going to Start > Programs > {Your 64 bit oracle} > sqlplus. It could be that the 32 bit client’s sqlplus got fired up.

For more info on TNS read this post from EdStevens:-

https://forums.oracle.com/forums/thread.jspa?threadID=1982093