Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Monday, August 24, 2009

How to get to Proxy settings dialog box from command line

Internet Explorer proxy settings dialog box is usually accessed with this navigation:

Start Internet Explorer
Click on Tools Menu > Internet Options
Connections Tab
Lan Settings button

You can also access this directly from command line by this:

Start Button > Run > inetcpl.cpl

Friday, August 21, 2009

AC-00002: Error: Unable to create log file

Makarand was doing a Fresh R12 install. The install was successful on the Database Node and Primary Application Node. On Primary Application node only 'Batch Processing Services' are enabled.

However while installing on the additonal application node the rapidwiz was giving errors

'AC-00002: Error: Unable to create log file - $INST_TOP/$CONTEXT_NAME/logs/08031631.log
Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: AC-00002: Unable to create log file -
$INST_TOP/$CONTEXT_NAME/logs/08031631.log

Makarand had tried installing multiple times but every time it failed with the same message

The truss of the rapidwiz process showed this:

/40: open64("$INST_TOP/$CONTEXT_NAME/logs/08200953.log",
O_WRONLY|O_APPEND|O_CREAT, 0666) Err#13 EACCES


Here’s the reason for the failure:

apps11i is the app tier and you are trying to write to an NFS mount. If you access an NFS mount from a server other than its origin, the root user of the application server is treated as nobody user. I verified this by touching a file while logged in as root:

-rw-r--r-- 1 nobody nobody 0 Aug 20 10:59 abc

This happens if the NFS share is shared without root= in the NFS mount command.

An examination of the /etc/dfs/dfstab file revealed that:

share -F nfs -o rw=visionerp.justanexample.com,root=visionerp.justanexample.com /gpshpc76/custom
share -F nfs -o rw=erpr12.justanexample.com,root=erpr12.justanexample.com /erpr12/erpapp
share -F nfs -o rw=erp11i.justanexample.com,root=erp11i.justanexample.com /erp11i/erpapp

If you compare the last line with a line for other instances it clearly shows that the application server has no read write rights and no root equivalence. I corrected this by executing this command:

share -F nfs -o rw=apps11i.justanexample.com,root=apps11i.justanexample.com /arpsysd1/erpapp

I also corrected it in the /etc/dfs/dfstab.

After this we retried the rapidwiz and it worked.

Wednesday, August 19, 2009

File Either has No Version or Unknown error(-4)

While running Update Current Snapshot during migration to shared application file system the DBAs reported this error:

“Update current view snapshot” throwing following error message.

Done processing object modules

File "INVRCVVB.pls"

Either has No Version or Unknown error(-4)


Failed in adusnapGetDetailFileInfo()

AD Administration error:

Failed store Snapshot file info

adusnapMaintainSnapshot() : Error calling adusnapUpdateCurrentView()

Error calling adusnapMaintainSnapshot


Backing up restart files, if any......Done.


You should check the file

$APPL_TOP/admin/$TWO_TASK/log/adadmin.log for errors.

The file INVRCVVB.pls in $INV_TOP/sql and $INV_TOP/patch/115/sql had a string _new in its version information:


$ adident Header INVRCVVB.pls.original

INVRCVVB.pls.original:

$Header INVRCVVB.pls 115.107.115100.85_new 2008/03/20 08:51:49 kagupta ship $

After removing the _new from the version information inside the file, the issue was resolved.

Monday, August 17, 2009

MAPI32.DLL is corrupt or the wrong version

Recently, I was helping Ashok in installing Outlook 2003 on his Laptop which had Vista Home Premium running on Windows Vista.

The setup program cancelled with this message:

Cannot start Microsoft Outlook. MAPI32.DLL is
corrupt or the wrong version. This could have
been caused by installing other messaging system.
Please reinstall Outlook.

I found a technote from Microsoft which asked to run windows\system32\fixmapi.exe.

That didn't help.

I found some other posts on the net which advised doing this:

Locate the file MSMAPI32.DLL in Program Files\Common Files\System\MSMAPI\1033
Rename the file to something like MSMAPI32.XXX or MSMAPI32.OLD

This worked for us.

Thursday, August 13, 2009

C program to test open file descriptors

Sun has given this program to test the number of open file descriptors here.


vi fopentestcase.c

#include
#include


#define NoOfFILES 65536

int main()
{
char filename[10];
FILE *fds[NoOfFILES];
int i;

for (i = 0; i < NoOfFILES; ++i)
{
sprintf (filename, "/tmp/%d.log", i);
fds[i] = fopen(filename, "w");

if (fds[i] == NULL)
{
printf("\nNumber of open files = %d. " \
"fopen() failed with error: ", i);
perror("");
exit(1);
}
else
{
fprintf (fds[i], "some string");
}
}
return (0);
}

/usr/local/bin/gcc -o fopentestcase fopentestcase.c

$ ./fopentestcase

Number of open files = 253. fopen() failed with error: Too many open files
$

It errors out on the 254th file. This is because it is a 32 bit program.

Monday, August 3, 2009

oaj2se.exe doesn't install

Michael sent me a mail with a screenshot where it was showing a dialog box with

The publisher could not be verified, Are you sure you want to install this software.

Name: oaj2se.exe

Publisher: Unknown publisher

There were two buttons Install and Don't Install.

The DBAs had recently migrated from jintiator to Sun JRE plugin on this instance. I checked by downloading JRE directly http://dev11i.justanexample.com/OA_HTML/oaj2se.exe

appesx76@tnsd2005 $ file j2se16014.exe.old
j2se16014.exe.old: executable shell script

$ head oaj2se.exe
#!/bin/sh
PATH=/usr/bin:/bin
umask 022

release_comp() {
if [ "$1" = "$2" ] ; then
echo "eq"
else
lrel=`printf "%s\n%s\n" $1 $2 | \
sort -t . -k 1,1n -k 2,2n -k 3,3n -k 4,4n -k 5,5n | \
appesx76@tnsd2005 $ head -100 j2se16014.exe.old
#!/bin/sh
PATH=/usr/bin:/bin
umask 022

release_comp() {
if [ "$1" = "$2" ] ; then
echo "eq"
else
lrel=`printf "%s\n%s\n" $1 $2 | \
sort -t . -k 1,1n -k 2,2n -k 3,3n -k 4,4n -k 5,5n | \
head -1`
if [ "$1" = "${lrel}" ]; then
echo "lt"
else
echo "gt"
fi
fi
}
.
.
.

This was strange. That file is supposed to be binary. So I downloaded Sun JRE client 1.6.0_14. Sure enough the file sizes differed. I uploaded the file and did these steps:

Login as applmgr on the web tier

cp jre-6uX-windows-i586-p.exe $COMMON_TOP/util/jinitiator/j2se160x.exe
X is the latest update version, for example:

mv jre-6u14-windows-i586-p.exe $COMMON_TOP/util/jinitiator/j2se16014.exe

cp $COMMON_TOP/util/jinitiator/j2se16014.exe $OA_HTML/oaj2se.exe

I stopped Apache.

Cleared Apache Cache: rm -rf $COMMON_TOP/_pages

Restarted Apache.

The problem was resolved. I informed the DBA team about this issue so that they could avoid this in future. Most probably the DBA got mixed up between Sun JRE migration and JDK upgrade. Sun JRE migration requires JRE package on client PC, which runs on Windows. Sun JDK upgrade requires JDK which runs on server, which is Solaris SPARC 10 in our case.