1 2 Previous Next 15 Replies Latest reply: Sep 21, 2013 9:09 PM by user3715462 RSS

    Guest and all users have invalid password

    user3715462

      Dear all,

       

      os oul5x64

      ebs 12.1.3

       

      when login from login page no one can connect because somehow guest user password was invalid.

      using note How To Successfully Change The Guest Password In E-Business Suite 11.5.10 and R12 (Doc ID 443353.1)

      and was able to change guest password and now had to change password for every users.

      This is a test ENV so not many users on it.

      Question: How can i find down what happened to GUEST and all users password.

      and where to check.

      Thanks in advance.

      Regards,

        • 1. Re: Guest and all users have invalid password
          Hussein Sawwan-Oracle

          Assuming you have already reviewed the application log files and found no pointers, I believe it's hard to find out what happened to GUEST user's password.

           

          Thanks,

          Hussein

          • 2. Re: Guest and all users have invalid password
            user3715462

            Thanks Hussein,

            there is some error in the application.log file.

            Would you please advise.

            Regards,

             

            13/09/18 15:27:53.717 html: Servlet error

            java.io.IOException: Broken pipe

                    at sun.nio.ch.FileDispatcher.write0(Native Method)

                    at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:29)

                    at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:72)

                    at sun.nio.ch.IOUtil.write(IOUtil.java:43)

                    at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:334)

                    at java.nio.channels.Channels.writeFullyImpl(Channels.java:59)

                    at java.nio.channels.Channels.writeFully(Channels.java:81)

                    at java.nio.channels.Channels.access$000(Channels.java:47)

                    at java.nio.channels.Channels$1.write(Channels.java:155)

                    at com.evermind.server.http.AJPOutputStream.endRequest(AJPOutputStream.java:117)

                    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:317)

                    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)

                    at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)

                    at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

                    at java.lang.Thread.run(Thread.java:662)

            13/09/18 15:32:25.704 html: OABodyBean, localName='body': Could not find partial target: PayablesReviewSettings

            13/09/18 15:33:50.414 html: OABodyBean, localName='body': Could not find partial target: PaymentMethodCode2

            13/09/18 15:33:50.414 html: OABodyBean, localName='body': Could not find partial target: PaymentDocumentName

            13/09/18 15:33:50.415 html: OABodyBean, localName='body': Could not find partial target: BankAccountName

            13/09/18 15:43:05.385 html: OABodyBean, localName='body': Could not find partial target: SendPaymentARFlag

            13/09/18 15:43:05.385 html: OABodyBean, localName='body': Could not find partial target: SSNId

            13/09/18 15:46:30.744 html: OABodyBean, localName='body': Could not find partial target: SendPaymentARFlag

            13/09/18 15:46:30.744 html: OABodyBean, localName='body': Could not find partial target: SSNId

            13/09/18 15:47:34.80 html: OABodyBean, localName='body': Could not find partial target: SendPaymentARFlag

            13/09/18 15:47:34.80 html: OABodyBean, localName='body': Could not find partial target: SSNId

            • 3. Re: Guest and all users have invalid password
              Hussein Sawwan-Oracle

              I believe this error is not related to the GUEST user password issue.

               

              Thanks,

              Hussein

              • 4. Re: Guest and all users have invalid password
                user3715462

                Thanks Hussein,

                 

                Hope you can help, a little bit of course...

                after changing GUEST password, can connect to system and accesses to any responsibility. but from Discoverer desktop, even replace with new XXXX.dbc, users can login but when click on responsibility get this error

                "Failed to connect to database- ORA-01017: Invalid username/password; logon denied.

                Thanks in advance.

                Regards,

                • 5. Re: Guest and all users have invalid password
                  Hussein Sawwan-Oracle

                  This is most likely a dbc issue, so can you please confirm that the new dbc file is used? You may try to copy it again and check then.

                   

                  Thanks,

                  Hussein

                  • 6. Re: Guest and all users have invalid password
                    user3715462

                    Thanks Hussein,

                     

                    i did copy the new file over, i am able to connect pass the first logon screen (it took the username and password)  , the next screen shows all responsibilities, when i double click on any  responsibility, then the error shown up.

                     

                    Regards,

                    • 7. Re: Guest and all users have invalid password
                      user3715462

                      You don't think that have any thing to do with changing GUEST password?

                      • 8. Re: Guest and all users have invalid password
                        Hussein Sawwan-Oracle

                        If the new dbc file was copied then I don't think so.

                         

                        Can you please review these docs and see if it helps?

                         

                        Using Discoverer 10g or 11g Connecting to an E-Business Suite EUL Fails With "Authentication Failed" or "ORA-01017: invalid username/password;logon denied" (Doc ID 1468623.1)

                        Disco Viewer Gets "Authentication Failed" Error in E-Business Suite (Doc ID 389840.1)

                         

                        Thanks,

                        Hussein

                        • 9. Re: Guest and all users have invalid password
                          user3715462

                          Thanks Hussein,

                           

                          i tried the note ORA-01017: invalid username/password;logon denied" (Doc ID 1468623.1)

                          set from SECURE to OFF and ran adautocfg.sh . still not working

                          the second note is  not that relevant.

                          Any suggestion please.

                          Thanks For your help.

                          • 10. Re: Guest and all users have invalid password
                            Asif Muhammad

                            Hi,

                             

                            Did you try recreating the dbc file. Use the below note and section: Configuring AppsDataSource, in order to create a new DBC (take a backup of the old DBC)

                             

                            Oracle E-Business Suite Software Development Kit for Java (includes AppsDataSource, Java Authentication and Authorization Service, session management) Readme - Patch 13882058 (Doc ID 974949.1)

                             

                            Please also check:

                            Actions to Verify When Running Iinto ORA-01017 While Creating Datasource (Doc ID 1556742.1)

                            R12: "ORA-01017: invalid username/password; logon denied" Error Message When Attempting to Create a JDBC Data Source (Doc ID 1099562.1)

                            Oracle Access Manager: Troubleshooting Errors Encountered When Attempting to Create Data Source (Doc ID 1439793.1)

                             

                            Thanks &

                            Best Regards,

                            • 11. Re: Guest and all users have invalid password
                              user3715462

                              Thanks


                              Authentication Failed" or "ORA-01017: invalid username/password;logon denied

                               

                              any other advices?

                               

                              Regards,

                              • 12. Re: Guest and all users have invalid password
                                Asif Muhammad

                                Hi,

                                 

                                Please provide the output of the following values:

                                GWYUID

                                FNDNAM

                                 

                                Also, check the application log file for more information, and please also refer the DB log file.

                                 

                                Thanks &

                                Best Regards,

                                • 13. Re: Guest and all users have invalid password
                                  user3715462

                                  These values are from XXX.dbc file.

                                   

                                   

                                  GWYUID=APPLSYSPUB/PUB

                                  FNDNAM=APPS

                                   

                                  i did check the database log, nothing usual.

                                  Thanks

                                  • 14. Re: Guest and all users have invalid password
                                    Hussein Sawwan-Oracle

                                    Have you verified the timestamp of the DBC file to confirm that a new one was generated after running AutoConfig?

                                     

                                    Is the issue with Discoverer Desktop only? If yes, have you verified that you are FND_SECURE on the client side is set correctly to the directory where you copies the DBC file?

                                     

                                    Thanks,

                                    Hussein

                                    1 2 Previous Next