Wednesday, April 30, 2008

PDF Printing general Checks

Recently we have issue with PDF Printing, although it was not because of setup. Here are the basic steps one should check for PDF Printing. All should be done at admin node (Where concurrent manager is running).
1. Display has been set properly and you can check that via $echo $DISPLAY at server end. And to make sure from application end too, just run "Print" Concurrent program and give "DISPLAY" as parameter.
2. you must be able to run xclock from server, whether you get output (in case of VNC) or not (in case of Xvfb).
3. Must have issued xhost + to access X server.
4. Software like xpdf or something has to be installed on Server. Which will help to view PDF as output files.
5. Pasta driver must be installed and setup correctly. pasta.cfg must be having reference to PDF software installed in step 4.

Happy Troubleshooting !!!

Monday, April 28, 2008

JAVA Mailer not Starting

Today was the bad day for us, we had an outage last weekend and after we finished our job lot of things start failing. Due to DBA errors and Java mailer is one off them. Here is what log says
------------------------------------------------------------------------------------
SVC-GSM-WFMLRSVC-67585-10006 : oracle.apps.fnd.cp.gsc.Logger.Logger(String, int) : Logging to System.out until necessary parameters are retrieved for Logger to be properly started.oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component; performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation failed for the following parameters -> {FRAMEWORK_USER=Unable to make a connection with the user and responsibility}. Parameters were -> {INBOUND_MAX_IGNORE_SIZE=1000, INBOUND_MAX_LOOKUP_CACHE_SIZE=100, ATTACH_IMAGES=N, ALLOW_FORWARDED_RESPONSE=Y, INBOUND_UNSOLICITED_THRESHOLD=2, NODENAME=PRODMAIL, SEND_UNSOLICITED_WARNING=N, AUTOCLOSE_FYI=N, PROCESSOR_READ_TIMEOUT_CLOSE=Y, INBOUND_PROTOCOL=IMAP, ATTACHED_URLS=WFMAIL:ATTACHED_URLS, TEST_ADDRESS=, EXPUNGE_ON_CLOSE=Y, PROCESSOR_OUT_THREAD_COUNT=1, ATTACH_STYLESHEET=N, OUTBOUND_CONNECTION_TIMEOUT=120, INBOUND_MAX_RET_EMAIL_SIZE=100, MAX_INVALID_ADDR_LIST_SIZE=100, PROCESSOR_MAX_LOOP_SLEEP=60, SEND_ACCESS_KEY=N, PROCESSOR_IN_THREAD_COUNT=1, FRAMEWORK_APP=1, CLOSED=WFMAIL:CLOSED, INBOUND_FETCH_SIZE=100, SUMMARY=WFMAIL:SUMMARY, ENABLE_STYLESHEET=N, PROCESSOR_ERROR_LOOP_SLEEP=60, OPEN_MAIL_FYI=WFMAIL:OPEN_MAIL_FYI, FRAMEWORK_RESP=20420, ALTERNATE_EMAIL_PARSER=oracle.apps.fnd.wf.mailer.DirectEmailParser, INBOUND_PASSWORD=_@8@!864^4$9#64#^@#8@@686##!#44@#!0!99@@`9+^+*#B$$@99*$, HTTP_USER_AGENT=Mozilla/4.76, RESET_NLS=N, PROCESS=Process, OPEN_MAIL_DIRECT=WFMAIL:OPEN_MAIL_DIRECT, PROCESSOR_LOOP_SLEEP=5, MESSAGE_FORMATTER=oracle.apps.fnd.wf.mailer.NotificationFormatter, REPLYTO=emailuser@edomain.com, FRAMEWORK_USER=0, CANCELED=WFMAIL:CANCELED, OUTBOUND_PROTOCOL=SMTP, ACCOUNT=emailuser, DISCARD=Discard, FROM=Expedite, PROCESSOR_DEFER_EVTDATA_READ=Y, SEND_CANCELED_EMAIL=N, WARNING=WFMAIL:WARNING, PROCESSOR_MAX_ERROR_COUNT=50, INBOUND_CONNECTION_TIMEOUT=120, HTMLAGENT=http://hostname.domainname.com:8000/pls/SID, INBOX=INBOX, OPEN_INVALID_MORE_INFO=WFMAIL:OPEN_INVALID_MORE_INFO, OUTBOUND_SSL_ENABLED=N, INBOUND_SERVER=mail.domain.com, OPEN_MORE_INFO=WFMAIL:OPEN_MORE_INFO, MAILER_SSL_TRUSTSTORE=NONE, INLINE_ATTACHMENT=N, OPEN_INVALID=WFMAIL:OPEN_INVALID, EMAIL_PARSER=oracle.apps.fnd.wf.mailer.TemplatedEmailParser, DIRECT_RESPONSE=N, OPEN_MAIL=WFMAIL:OPEN_MAIL, FRAMEWORK_URL_TIMEOUT=30, COMPONENT_LOG_LEVEL=1, SUMHTML=WFMAIL:SUMHTML, PROCESSOR_READ_TIMEOUT=10, DEBUG_MAIL_SESSION=N, INBOUND_SSL_ENABLED=N, OUTBOUND_SERVER=mailhost.domain.com}
at oracle.apps.fnd.cp.gsc.SvcComponentContainer.handleComponentEvent(SvcComponentContainer.java:2211)
at oracle.apps.fnd.cp.gsc.SvcComponentContainer.onBusinessEvent(SvcComponentContainer.java:300)
at oracle.apps.fnd.wf.bes.DispatchThread.run(DispatchThread.java:57)
----------------------------------------------------
And I think I know the issue, it was because of autoconfig only, you might be asking why? Our DBA ran autconfig without clearing FND_Nodes table. And as we were running on virtual host (clustering at db tier). It created a mess there. We have duplicate server_id for virtual and active physical host. Server ID for both of them were same, that's the reason Java mailer was not able to start and failing because of above error. Now what, another downtime---- I don't think customer will agree, but this issue is critical how to resolve this without big downtimes for running autoconfig. We raised Sev 1 tar to see if Oracle Support can help on this, but hard luck, they said the same old story of running autoconfig and all. But after spending few minutes, I got the solutions with 10 min of downtime. Here is what I did :

1. Shutdown Concurrent Manager
2. Take a backup of FND_Nodes.
3. Delete Physical host from OAM (OAM > Administrator > Hosts)
4. Register same host again from OAM.
5. Start Concurrent Manager
6. Mailer was working fine after this.

Happy Troubleshooting !!!

Sunday, April 27, 2008

Experience with Enterprise Linux

I tried installing Enterprise Linux on my home PC, which has decent configuration of 2.8 Ghz processer with 100GB HD and 512 MB RAM. I did download Enterprise Linux from Oracle Edelivery site. It has 5 parts zip file containing iso images, you have to cut DVD out off it.
It gave you an option of checking media (DVD which you just cut) although its not necessary. Rest all went smoother than Windows :-). I was able to finish my installation with in 35 min. I would say its easier and experience so far is good. I am planning to install 11i with 10g RAC on it. Will share my experience with that soon.
Happy Troubleshooting !!!

Thursday, April 24, 2008

FRM-92101: A failure has occured on the Server

After upgrading to 11.5.10.2 from 11.5.9, we have an issue of missing AP functions and menus. We did following to get those missing objects:
FNDLOAD APPS/password 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct $AP_TOP/patch/115/import/US/ap115fn.ldt
But After this when we tried to access any AP form we are getting "FRM-92101: A failure has occured on the Server" Error. To resolve this we did following

1. Recompile all invalids.
2. Regenerate all AP forms, PLL and Menus.
3. Bounce Services.

It worked after this.

Happy Troubleshooting !!!

Thursday, April 17, 2008

10giAS SSO Integration issue with 11i -- Followup

I haven't been able to resolve this issue yet but Oracle says its a Bug in 10.1.4.01 IDM which we are using and it can be resolved after applying patch 5867734. and make sure GenericPageBean.class file has the date 5/9/2007 on it. To get that use following command :

cd %ORACLE_HOME%/j2ee/OC4J_SECURITY/applications/sso/web/WEB-INF/lib$ORACLE_HOME/jdk/bin/jar tvf ossoui.jar

Although it didn't resolved my issue, but I felt sharing this info.

Happy Troubleshooting !!!

DISPLAY Settings

I never thought that even DISPLAY will going to give me tough time. Our client doesn't allow us to use VNC due to security reason. So we do not have any other option other than Xvfb at server End. We did start it and as expected xclock worked and no output. So I tried testing PDF output of my Active User conc program, it failed due to lack of Windoes Manager running at server. So I have to start twm at server end give xhost +. Vola it worked !!! Now another issue which I can forsee for my production as we were using Virtual host, to avoid any confusion in production cutover I used DISPLAY=`uname -n`:1.0

Happy Troubleshooting !!!

Monday, April 7, 2008

10giAS SSO Integration issue with 11i

We have successfully integrated our 11.5.10.2 instance with 10giAS SSO with AD and WNA. Everything is working fine, but we have some issues. One of them was unable to modify or delete Partner Application. Even with orcladmin user we are not able to Administer Partner Applications. We are working with Oracle to get this resolved, but found one workaround to modify them from backend. We can found them in table "WWSSO_PAPP_CONFIGURATION_INFO$" under orasso user. You can update this table as workaround. Till I get some solution to share.

Happy Troubleshooting !!!

Windows XP Shutdown and Reboot Shortcuts

Now as I have been moved to offshore, I am accessing my PC in US remotely. Now due to some reasons I want to reboot my PC, but non off the options allow me to do that, as I was accessing it remotely. Then I thought of putting a shortcut icons for reboot and shutdown. I need reboot icon. This is what I did :

Desktop Reboot Icon
Right click on the desktop
Click [New] [Shortcut] to open the Create Shortcut Wizard
Type [shutdown -r -t 00] without the brackets.
Click [Next] and type a descriptive name of your choosing for the shortcut
Click [Finish]

Desktop Shutdown Icon
Right click on the desktop
Click [New] [Shortcut] to open the Create Shortcut Wizard
Type [shutdown -s -t 00] without the brackets.
Click [Next] and type a descriptive name of your choosing for the shortcut
Click [Finish]

Hope you might need it sometime somewhere
Happy Troubleshooting !!!

Tuesday, April 1, 2008

April Fool

Today one of my user system made April fool to us. We have newly setup 10giAS instance with WNA Kerberose on our 11.5.10.2 Application Instance. This user was not able to get the Apps home page whenever he clicks the URL. He gets the SSO login page, which he should not get. I looked at sso log files and couldn't retrieve any information about his session. I thought of two choices, one to reboot his system if it works then no need for other. If doesn't I will ask him to login to some other system and try.
Once he rebooted his system and tried login again it works. I am not sure of cause but took it lightly too, thought system made April fool of us !!!

Happy Troubleshooting !!!