Sunday, May 11, 2014

Host based concurrent program fails with Error: No such file or directory

A custom Concurrent program fails with Error: No such file or directory
====================================================
Basically this is a host-based concurrent program and a custom program ...

This custom program actually is a FTP process which transfers files from one server to another -- from and to specific locations.

--> checked if the program is unable to find the source directory/file it is trying to transfer ---  their permissions -- But that's not the issue.

Log file says it cannot find the Executable the program is trying to run

+---------------------------------------------------------------------------+

usdsop: exec failed during spawn/SID/applmgr/CUSTOM/***12.0.0/bin/***_ftp_out: No such file or directory
/SID/applmgr/CUSTOM/***/12.0.0/bin/***_ftp_out
Program exited with status 1

+---------------------------------------------------------------------------+
Executing request completion options...

Output file size:
0

---> Checked the executable -- it exists and fine with permissions.
---> Played around with some more similar files but different versions.

Other programs in same location work actually.

---> Checked for any scrap characters in the file finally opening the executable script. Found few , removed them

----> Finally done a dos2unix conversion on it .

Re-tested the issue which went fine atlast.

ICM and Wallet Issue

Issue
=====


You are running adcmctl.sh version 120.17.12010000.5

ORACLE error 28365 in afpgdbcf

Cause: afpgdbcf failed due to ORA-28365: wallet is not open
ORA-06512: at "APPS.FND_SECURITY_PKG", line 539
ORA-06512: at line 1.

The SQL statement being executed at the time of the error was:  SELECT /*+ USE_NL (A I) */  DISTINCT A.APPLICATION_ID, A.APPLICATION_NAME,  A.APPLICATION_SHORT_NAME, A.BASEPATH, I.PRODUCT_VERSION  FROM FND_APPLICATION_VL A, FND_PRODUCT_INSTALLATIONS I  WHERE A.APPLICATION_ID = I.APPLICATION_ID (+)  and was executed from the file &ERRFILE.
Internal Concurrent Manager status could not be determined.
===============================
  declare
*
ERROR at line 1:
ORA-20000: ORA-28365: wallet is not open Failed to call the procedure
fnd_apps_mode_util.set_to_maintenance_mode while enabling
maintenance mode.
ORA-06512: at line 38

=============================


Alert Log error
=================

kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
Errors in file /SID/oracle/product/112/admin/SID_host/diag/rdbms/SID/SID/trace/SID_smon_4269.trc:
ORA-28365: wallet is not open
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet


==============================

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2235208 bytes
Variable Size             427820216 bytes
Database Buffers          624951296 bytes
Redo Buffers               13930496 bytes
Database mounted.
ORA-28365: wallet is not open


Fix
====
bash-3.2$  cd /SID/oracle/product/112/network/admin/SID_host/wallet
bash-3.2$ ls
cwallet.sso  encryption_passwd  ewallet.p12

orapki wallet change_pwd -wallet $ORACLE_HOME/wallet
-------------------

SQL> SELECT * FROM gv$encryption_wallet;

   INST_ID WRL_TYPE
---------- --------------------
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS
------------------
  1 file
/SID/oracle/product/112/network/admin/SID_host/wallet
CLOSED


SQL> ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "*****";

System altered.

APP-FND-01931 -- Forms Issue R12

Forms Issue
===========

APP-FND-01931 Your session is no longer valid or your logon information could not be reestablished from your session

Solution tried
============
 Tried following ::
Please use adadmin utility to :

- regenerate jar files - select YES when prompted to force generation of jar files.
- recompile apps schema to check for invalid objects.
- regenerate forms and pll's.
- relink all applications programs - specifically f60webmx, although relinking all the applications executables is advisable.
- recreate grants and synonyms.
- recompile menus.

- Clear Oracle jinitiator cache on client machine - typically c:\programs\oracle\jinit...\jcache .
- Clear browser cache.
- Bounce Oracle application services and re-test the issue.

Supplier site Certificate issue

Problem Description/Question:          1. The requester logs on to Oracle iProcurement.
                                       2. From Oracle iProcurement, the requester clicks a punchout link to the supplier site.
                                       3. The supplier authenticates the requester and returns a response.

During this, unable to go to Supplier site
====================================
Error Code: 201 Unable To Reach Supplier Site
Unable to send the Login Request XML.

java.io.IOException: java.io.IOException: javax.net.ssl.SSLException: SSL handshake failed: X509CertChainInvalidErr

Solution :
===========
POR : CA Certificate File Name => this profile option points to a file where we have to add the certificate to this file.

The certificate has to be obtained by accessing the Website(Supplier site in the error logfile) from browser.
Then finally bounce the Complete MT ( just Apache bounce doesnot work in R12).