4 Replies Latest reply: May 18, 2012 5:06 AM by 936685 RSS

    Problems with the password with WebClient but not with Siebel Tools

    936685
      Hello, I am having problems when I am trying to connect with the WebClient against local database. When I put the user and the password i obtain a message that said me that the password and user is incorrect.

      When I use the same password and user in Siebel Tools I have access without any problem.

      Someone kwows which would be my problem?

      Thank you.
        • 1. Re: Problems with the password with WebClient but not with Siebel Tools
          Robert Ponder
          Hi,

          I think you must be on Siebel 8.x. Starting in 8.0 the web client’s security was enhanced. You now have to make sure both the local and local odbc are both point to the correct local. This is not the case with Tools.

          If you turned logging on you could see this.

          Robert Ponder
          • 2. Re: Problems with the password with WebClient but not with Siebel Tools
            936685
            Thank you for answer. Siebel is 8.1.7.

            Yes, the local odbc is point to the correct path.

            My log for the client said:

            GenericLog     GenericInfo     3     000000024fb40848:0     2012-05-17 09:35:32     Before call security business service
            ObjMgrBusServiceLog     Create     4     000000024fb40848:0     2012-05-17 09:35:32     Business Service 'Docking Service' was created at 88888b0
            ObjMgrBusServiceLog     Create     4     000000024fb40848:0     2012-05-17 09:35:32     Business Service 'Docking Service' (address: '88888b0')was regsitered at model '35f7cc0' for session ''
            ObjMgrBusServiceLog     InvokeMethod     4     000000024fb40848:0     2012-05-17 09:35:32     Begin: Business Service 'Docking Service' invoke method: 'VerifyLocalSecurity' at 88888b0
            Trace     TracingInfo     3     000000024fb40848:0     2012-05-17 09:35:32     Value for the key 4_Kim_l is not found.
            Trace     TracingInfo     3     000000024fb40848:0     2012-05-17 09:35:32     Value for the key DCK:PwdLockoutFlg is not found.
            Trace     TracingInfo     3     000000024fb40848:0     2012-05-17 09:35:32     Value for the key 4_Kim_l is not found.
            Trace     TracingInfo     3     000000024fb40848:0     2012-05-17 09:35:32     Value for the key DCK:PwdExpireFlg is not found.
            ObjMgrBusServiceLog     InvokeMethod     4     000000024fb40848:0     2012-05-17 09:35:32     Business Service 'Docking Service' invoke method 'VerifyLocalSecurity' Execute Time: 0.004 seconds.
            ObjMgrBusServiceLog     InvokeMethod     4     000000024fb40848:0     2012-05-17 09:35:32     End: Business Service 'Docking Service' invoke method: 'VerifyLocalSecurity' at 88888b0
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     SECMGR: DBSecAdpt_SecAdptDllName=sscfsadbmfcext
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     stored CRC = ''
            SecAdptLog     API Trace     4     000000024fb40848:0     2012-05-17 09:35:32     DB Initialize security adapter.
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     SecAdptName = DBSecAdpt
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     SecAdptMode = 0
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     SecAdptDllName = sscfsadbmfcext
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     PropagteChange = TRUE
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     computed checksum of security adapter library = ''
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     HashUserPwd = FALSE
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     SaltUserPwd = FALSE
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     HashDBPwd = FALSE
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     HashAlgorithm = RSASHA1
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     bMFCShell = TRUE
            SecMgrLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     datasourcename = Local
            SecAdptLog     API Trace     4     000000024fb40848:0     2012-05-17 09:35:32     DB SecurityLogin with username=jasanchez1, parameters=8613310.
            SecAdptLog     Debug     5     000000024fb40848:0     2012-05-17 09:35:32     DB security adapter: Load data source configuration
            Trace     TracingDebug     5     000000024fb40848:0     2012-05-17 09:35:32     Malformed file. Key "viewbarcaption" is duplicated. Duplicate is ignored.
            Trace     TracingDebug     5     000000024fb40848:0     2012-05-17 09:35:32     Malformed file. Key "sortascendingcaption" is duplicated. Duplicate is ignored.
            Trace     TracingDebug     5     000000024fb40848:0     2012-05-17 09:35:32     Malformed file. Key "sortdescendingcaption" is duplicated. Duplicate is ignored.
            Trace     TracingDebug     5     000000024fb40848:0     2012-05-17 09:35:32     Malformed file. Key "calendarfieldcaption" is duplicated. Duplicate is ignored.
            Trace     TracingDebug     5     000000024fb40848:0     2012-05-17 09:35:32     Malformed file. Key "calculatorfieldcaption" is duplicated. Duplicate is ignored.
            CchMgrLog     CchMgrStatsInfo     5     000000024fb40848:0     2012-05-17 09:35:32     Cache statistics 28ee9f0 set for cache Data Cursor.
            CchMgrLog     CchMgrStatsInfo     5     000000024fb40848:0     2012-05-17 09:35:32     Cache statistics 28eea88 set for cache SQL Cursor.
            ObjMgrDBConnLog     Create     5     000000024fb40848:0     2012-05-17 09:35:32     DataBase Connection Object was created at 28ee940; DB User: 'JASANCHEZ1'
            ObjMgrLog     Error     1     000000024fb40848:0     2012-05-17 09:35:33     (wccon.cpp (2156)) SBL-DAT-00522: A Siebel local database error has occurred. Possibly the database name is invalid.

            Please continue or ask your systems administrator to check your application configuration if the problem persists.

            SecAdptLog     API Trace     4     000000024fb40848:0     2012-05-17 09:35:33     Security DB user connect to DB D:\Siebel\8.1\Tools_1\local\sse_data.dbf -q -m -x NONE -gp 4096 -c15p -ch25p with username=jasanchez1 returns err 7668234 and connection 28ee940.
            SecAdptLog     API Trace     4     000000024fb40848:0     2012-05-17 09:35:33     Security DB user delete DB connectoin 28ee940
            ObjMgrDBConnLog     Delete     5     000000024fb40848:0     2012-05-17 09:35:33     DataBase Connection was deleted at 28ee940
            GenericLog     GenericError     1     000000024fb40848:0     2012-05-17 09:35:33     (secmgr.cpp (2697) err=4597538 sys=2) SBL-SEC-10018: A Siebel local database error has occurred. Possibly the database name is invalid.
            Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00522)
            Incorrect or missing encryption key

            SecAdptLog     Memory Mgmt Trace     5     000000024fb40848:0     2012-05-17 09:35:33     DB SecurityFreeErrMessage, message=<?INT?>.
            GenericLog     GenericError     1     000000024fb40848:0     2012-05-17 09:35:33     (secmgr.cpp (2769) err=4597521 sys=0) SBL-SEC-10001: An internal error has occurred within the authentication subsystem for the Siebel application. Please contact your system administrator for assistance.
            ObjMgrSessionLog     Error     1     000000024fb40848:0     2012-05-17 09:35:33     (physmod.cpp (9378)) SBL-DAT-00565: An internal error has occurred within the authentication subsystem for the Siebel application. Please contact your system administrator for assistance.
            ObjMgrSessionLog     Error     1     000000024fb40848:0     2012-05-17 09:35:33     (model.cpp (5970)) SBL-DAT-00565: An internal error has occurred within the authentication subsystem for the Siebel application. Please contact your system administrator for assistance.
            ObjMgrSessionLog     Warning     2     000000024fb40848:0     2012-05-17 09:35:36     (physmod.cpp (9452)) SBL-SFR-00116: The user has cancelled the logon request
            ObjMgrBusServiceLog     InvokeMethod     4     000000024fb40848:0     2012-05-17 09:35:36     Begin: Business Service 'Docking Service' invoke method: 'VerifyLocalSecurity' at 88888b0
            Trace     TracingInfo     3     000000024fb40848:0     2012-05-17 09:35:36     Value for the key 4_Kim_l is not found.
            Trace     TracingInfo     3     000000024fb40848:0     2012-05-17 09:35:36     Value for the key DCK:PwdLockoutFlg is not found.
            ObjMgrBusServiceLog     InvokeMethod     4     000000024fb40848:0     2012-05-17 09:35:36     Business Service 'Docking Service' invoke method 'VerifyLocalSecurity' Execute Time: 0.014 seconds.
            ObjMgrBusServiceLog     InvokeMethod     4     000000024fb40848:0     2012-05-17 09:35:36     End: Business Service 'Docking Service' invoke method: 'VerifyLocalSecurity' at 88888b0
            ObjMgrBusServiceLog     Delete     4     000000024fb40848:0     2012-05-17 09:35:36     Business Service 'Docking Service' (address: '88888b0')was unregsitered at model '35f7cc0' for session ''
            ObjMgrBusServiceLog     Delete     4     000000024fb40848:0     2012-05-17 09:35:36     Business Service 'Docking Service' was deleted at 88888b0
            GenericLog     GenericInfo     3     000000024fb40848:0     2012-05-17 09:35:36     In destructor Sync
            GenericLog     GenericInfo     3     000000024fb40848:0     2012-05-17 09:35:36     Before unlock mutex 777
            ObjMgrBusServiceLog     Create     4     000000024fb40848:0     2012-05-17 09:35:36     Business Service 'Smart Script Execution Cleanup' was created at 36d9308
            ObjMgrBusServiceLog     Create     4     000000024fb40848:0     2012-05-17 09:35:36     Business Service 'Smart Script Execution Cleanup' (address: '36d9308')was regsitered at model '35f7cc0' for session ''
            ObjMgrBusServiceLog     InvokeMethod     4     000000024fb40848:0     2012-05-17 09:35:36     Begin: Business Service 'Smart Script Execution Cleanup' invoke method: 'CleanUp' at 36d9308
            ObjMgrBusServiceLog     InvokeMethod     4     000000024fb40848:0     2012-05-17 09:35:36     Business Service 'Smart Script Execution Cleanup' invoke method 'CleanUp' Execute Time: 0.000 seconds.
            ObjMgrBusServiceLog     InvokeMethod     4     000000024fb40848:0     2012-05-17 09:35:36     End: Business Service 'Smart Script Execution Cleanup' invoke method: 'CleanUp' at 36d9308
            ObjMgrLog     Info     3     000000024fb40848:0     2012-05-17 09:35:36     (modpref.cpp (949)) SBL-DAT-50806: SavePreferences: D:\Siebel\8.1\Client_1\bin\Siebel Universal Agent.spf: Save is not needed. Preferences are not dirty.
            ObjMgrBusServiceLog     InvokeMethod     4     000000024fb40848:0     2012-05-17 09:35:36     Begin: Business Service 'Smart Script Execution Cleanup' invoke method: 'CleanUp' at 36d9308
            ObjMgrBusServiceLog     InvokeMethod     4     000000024fb40848:0     2012-05-17 09:35:36     Business Service 'Smart Script Execution Cleanup' invoke method 'CleanUp' Execute Time: 0.000 seconds.
            ObjMgrBusServiceLog     InvokeMethod     4     000000024fb40848:0     2012-05-17 09:35:36     End: Business Service 'Smart Script Execution Cleanup' invoke method: 'CleanUp' at 36d9308
            ObjMgrBusServiceLog     Delete     4     000000024fb40848:0     2012-05-17 09:35:36     Business Service 'Smart Script Execution Cleanup' (address: '36d9308')was unregsitered at model '35f7cc0' for session ''
            ObjMgrBusServiceLog     Delete     4     000000024fb40848:0     2012-05-17 09:35:36     Business Service 'Smart Script Execution Cleanup' was deleted at 36d9308
            ObjMgrBusServiceLog     Delete     4     000000024fb40848:0     2012-05-17 09:35:36     Business Service '' was deleted at 12fab4
            ObjMgrLog     Info     3     000000024fb40848:0     2012-05-17 09:35:36     (modpref.cpp (949)) SBL-DAT-50806: SavePreferences: D:\Siebel\8.1\Client_1\bin\Siebel Universal Agent.spf: Save is not needed. Preferences are not dirty.
            ObjMgrBusServiceLog     Delete     4     000000024fb40848:0     2012-05-17 09:35:36     Business Service '' was deleted at 12fce8
            SecAdptLog     API Trace     4     00
            ----------------------------------------------------------------------

            This is not the complete log, only the part when the authentication fails.

            Edited by: 933682 on May 17, 2012 12:37 AM
            • 3. Re: Problems with the password with WebClient but not with Siebel Tools
              WSiebel-Oracle
              Hi,

              Check if Doc ID 780547.1 on support.oracle.com is helpful, it has the same error "Incorrect or missing encryption key" as in your log file.

              Thanks,

              Wilson
              • 4. Re: Problems with the password with WebClient but not with Siebel Tools
                936685
                Thank you Wilson, I found the answer looking through this DOC.

                Now the problem is solved.

                For help other with a similar issue I am going to post the solution.


                The problem was the parameters into the database extraction. I set the parameters below in the Database Extract:


                Encrypt client Db password = False
                Client Database encryption method = none


                And using this now I can connect with the webClient to local and to server. And with the tools too.

                Thank you again for all the answers.

                Edited by: 933682 on 18-may-2012 3:06