Category Archives: UTT

rm: cannot lstat file: Input/output error

Posted by on March 27, 2012 No comments

Problem:

While attempting to remove a file on Linux, the message ‘rm: cannot lstat file: Input/output error’ appears:

[applmgr@oel5vis3 applmgr]$ cd /u01/VIS3/oracle/vis3db/9.2.0/oem_webstage/oracle/sysman/vbo/vbos
[applmgr@oel5vis3 vbos]$ ls -ltr
total 16
?--------- ? ?       ?      ?            ? VbosLobStorage.class
?--------- ? ?       ?      ?            ? VbosLobSQLList.class
?--------- ? ?       ?      ?            ? VbosLobOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosDimensionOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosArrayTypeOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosClusterOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosDBLinkOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosIndexOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosJavaObjectHelper.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosJavaObjectOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosJavaSourceOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosJavaClassOperations.class
-rw-r--r-- 1 applmgr dba    0 Apr 26  2002 VbosLob.class
.
.
.
[applmgr@oel5vis3 vbos]$ rm VbosLobOperations.class 
rm: cannot remove `VbosLobOperations.class': Input/output error
[applmgr@oel5vis3 vbos]$ rm -f VbosLobOperations.class 
rm: cannot remove `VbosLobOperations.class': Input/output error
[applmgr@oel5vis3 vbos]$ touch VbosLobOperations.class
touch: cannot touch `VbosLobOperations.class': Input/output error

Solution:

Unmount partition with bad file and run fsck on partition (may need to exit Terminal window and open new Terminal window).

 

RW-20003: Error: Unzip failed: unknown reason

Posted by on March 23, 2012 No comments

Problem:

While installing a Vision instance of 11.5.10.2, the following errors appears:

RW-20003: Error: Unzip failed: unknown reason.
Check log file for details.

General solution:

Verify file owner and group settings for EBS staging area.
Redownload, restage installation media from DVD or E-Delivery.
Verify MD5 checksums for files downloaded from E-Delivery.

Solution (in this case):

/u00/Stage11i/oraApps/Disk4/appl/stage/fnd_WEB3.zip corrupt. Restage.

Read more »

-bash: ulimit: open files: cannot modify limit: Operation not permitted

Posted by on March 8, 2012 No comments

Problem:

While following online instructions for installing E-Business Suite, it is advised to add the following code to /etc/profile:

if [ $USER = "oracle" ]; then
 if [ $SHELL = "/bin/ksh" ]; then
 ulimit -p 16384
 ulimit -n 65536
 else
 ulimit -u 16384 -n 65536
 fi
fi

However, when a user logs on, the following message appears:

-bash: ulimit: open files: cannot modify limit: Operation not permitted

Solution:

Set the limits in /etc/security/limits.conf, not /etc/profile. Follow E-Business Suite installation documentation on My Oracle Support, not online!

 

 

Notifications Automatically Closing

Posted by on February 17, 2012 No comments

Problem:

A preparer creates a purchase request and send it to the approver, who approves it. The preparer then receives a notification that the PR was approved, but the notification automatically disappears from the list after the browser is refreshed or when the user logs off.

Solution:

The AutoClose_FYI parameter must be changed from ‘Y’ to ‘N’ in Notification Mailer.

Then the Notification Mailer must be stopped and started for the change to take effect.

Outbound Server Unable to Make a Network Connection

Posted by on February 17, 2012 1 comment

Problem:

The Notification Mailer shows the following error:

Navigation: Oracle Application Manager > Site Map > Administration tab >
Notification Mailer (under Workflow)
Click: Workflow Notification Mailer

Component Details: Workflow Notification Mailer: TEST3 shows an error in Status
Information:

This automatic Service Component has been restarted the maximum of 10 times after
stopping with error. Thus, it has been system deactivated ->
oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component;
performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation
failed for the following parameters -> {OUTBOUND_SERVER=Unable to make a network
connection.}.

Solution:

Change Outbound Server from EBS application tier server to mail server. The Outbound Server is usually automatically reset as part of the cloning process.

Change OUTBOUND_SERVER from oratestapps.domainname to 10.x.x.x.

Read more »

ORA-20100: File o0150175.tmp creation for FND_FILE failed

Posted by on December 14, 2011 No comments

Problem:

When running the Diagnostics: Apps Check from the Purchasing responsibility in Oracle Applications E-Business Suite 11i, the concurrent request completes in error and following error appears at the bottom of the output log:

declare
*
ERROR at line 1:
ORA-20100: File o0150175.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at “APPS.FND_FILE”, line 407
ORA-06512: at “APPS.FND_FILE”, line 581
ORA-06512: at line 120

Solution:

Ran out of disk space on the db machine. The temp directory used by EBS is in the /var directory, which is only 1GB in size. The /var directory is being filled by yum updates.

As root user, execute the command ‘yum clean all’. Stop the yum updates by issuing the command ‘/etc/init.d/yum-updatesd stop’.

AC-30202: Unrecognized action specified, Context Value Management Failed

Posted by on December 7, 2011 No comments

Problem:

After sourcing APPSORA.env on and 11.5.10.2 environment and running AutoConfig, the following error appeared:

$ ./adautocfg.sh appspass=password

The log file for this session is located at: /u01/test3/test3appl/admin/TEST3_uttoratestapp03/log/12070801/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using APPL_TOP location     : /u01/test3/test3appl
        Classpath                   : /u01/test3/test3comn/util/java/1.4/j2sdk1.4.2_04/jre/lib/rt.jar:/u01/test3/test3comn/util/java/1.4/j2sdk1.4.2_04/lib/dt.jar:/u01/test3/test3comn/util/java/1.4/j2sdk1.4.2_04/lib/tools.jar:/u01/test3/test3comn/java/appsborg2.zip:/u01/test3/test3comn/java

promptmsg=hide - AC-30202: Unrecognized action specified. Exiting.

ERROR: Context Value Management Failed.
Terminate.

The logfile for this session is located at:
    /u01/test3/test3appl/admin/TEST3_uttoratestapp03/log/12070801/adconfig.log
$

Solution:

After unsetting LD_ASSUME_KERNEL and applying patch 6365595, applied patch 5903765 (Applications Technology 11i.ATG_PF.H.delta.6). After patch completed, ran AutoConfig without problems.

 

EBS instance running out of processes

Posted by on October 18, 2011 No comments

Problem:

EBS instance running out of processes. Need to increase the database PROCESSES initialization parameter.

Solution:

Change the PROCESSES init parameter in the pfile or scope=spfile. Then restart the database (using addbctl.sh, not using the database stop immediate/startup command as shown below).

Read more »

Could not reserve record

Posted by on August 18, 2011 No comments

Problem: When trying to add lines to a Standard RFQ (Request for Quotation), the user encounters the following error:

Could not reserve record [2 tries].

Solution: Kill lock on session.

Read more »

SQL Code Not Running In EBS

Posted by on July 29, 2011 No comments

Problem: The following code runs in SQL Developer and SQL*Plus from the server:

SELECT person_name,
  employee_number,
  date_from,
  date_to,
  segment_details
FROM apps.hrfg_detailed_special_info
WHERE to_date('&1', 'RRRR/MM/DD HH24:MI:SS') BETWEEN date_from AND date_to
 AND information_type = 'ABC Full Time Payroll Remarks'
 AND segment_name = 'Remarks'
ORDER BY person_name
/

However, when it is registered as a concurrent program and run, no output appears.

Solution: The apps_initialize subroutine must be called before running the script.

Read more »