下午接了个活,销售给我出难题:客户的JD EDWARDS Oneworld fat client登录不上,报SEC0000007-Unable to locate security server错误;客户的这个JDE版本是7333(估计是仁科在被Oracle收购前出的版本),搜了下metalink结果只找到8.93版本相关的Note。我和销售说这玩样跟我不是一个系的出身,销售让我调动资源尝试下,那我就调动下。以下是目前找到的资料:
1.metalink与之相关的bug note介绍可能因为服务程序down掉造成该问题: OW Version: B9 SP: SP_F WEB: qaweb2:86 Problem: If the enterprise server is down and the user tries to login with his/her correct user id and password, the following error is displayed. ............ Incorrect user id and password ............ For the fat client, the following error is displayed. --------------------------- OneWorld Error --------------------------- SEC0000007 - Unable to locate security server --------------------------- Retry Cancel --------------------------- If I select "Cancel", then --------------------------- Error --------------------------- SEC0000001 - Failure in communicating with Security Server --------------------------- OK --------------------------- If I click "OK", then --------------------------- Error: User ID - Password --------------------------- OneWorld could not sign you on. Make sure your User ID is correct and retype your Password. --------------------------- OK --------------------------- ............ Since this error message is not appropriate, please change it to some appropriate phrase, for instance, "Security server is down, please re-try later". QE: sr4890282 ============================================================ This SAR has been fixed, but changes was overwritten by Bhale, Bhushan on 4/30/02 Fix Information System Code: H93F-Enterprise Foundation Object: B9 JDBJ Code Change/ESU: None Date Completed: 03-Jul-2002 Target Delivery Information: 30-Apr-2002 Product: 4781 - JD Edwards EnterpriseOne Tools Members Affected: $PFinternetsrccomjdedwardsjas JDESignon.java Rights given 5/23/02 mkl Data Dictionary: User Defined Code: Final Disposition: Modify JDESignon.java, when the security server is down, set the errorID to 5( security server cannot be reached) instead of 331 (bad password and userID) 2.网上对该SEC0000007错误的评论认为引发该错误的有多种可能性: You will get this message for a number of reasons. Check the user profile OneWorld and make sure it's enabled. Also check the user id that you have attached to users... Also, you may need to bounce your services. Another reason is that when logging on the ini usually uses PD7333 as your main pathcode for security. Make sure this pathcode is not damaged & is usable. Check the spec folder... I have had all of the above problems at different times... Hope this helps, 3.就目前来看如果重启服务解决不了问题的话,就麻烦了。。
谁有JDE方面的经验能帮个忙,我请他吃饭!
这个case提交SR后,metalink要求提供更多有用的信息:
Please provide more information on this:
1. Was it working fine before?
2. What changes have been made recently to JDE software and server software or hardware?
3. Attach Server JDE.INI
4. What is the symptom/issue?
5. Does it happen to all users, including JDE?
6. Does it happen to all machines?
7. Is this production environment?
8. How many environments get affected? Are there any working environment?
9. Please provide all jde.log from server.
今天上午去到客户现场了解情况,本来只想收集jde.log和jde.ini信息以供MOS进一步诊断。不过顺着MOS给出的思路先后找到了jde.log和jde.ini文件(windows下就在C:\根目录),尝试登陆后观察jde.log日志文件发现出现invalidhostname错误,再研究jde.ini配置文件发现SECURITY选项指定的SQL Server数据库所在主机名在客户端主机无法解析,尝试将这个主机名更换为ip地址后继续就能成功登陆了。
总结这个case的root cause是因为客户在域服务器做了某种变更后导致域中的pc都无法正确解析数据库服务器的主机名了,所以导致出现Unable to locate security server的错误。在这之前虽然已经反复和客户方的技术人员确认是否有任何变更了,但仍没有得到有用信息;可能我的交流方式仍待改进!