6 Replies Latest reply: May 4, 2012 8:11 AM by William Phelps RSS

    Microsoft Login on UCM and IIS 7.5 - CHECK_USER_CREDENTIALS problem

    user13321560
      Hi,

      we moved UCM Version:10.1.3.5.1 (091014) (Build:7.2.4.29) to new servers and changed IIS server v 6.0 to IIS v 7.5. Everything looks to be working except of the Microsoft Login.
      After clicking on the "Microsoft Login" browser there is this message displayed:

      Access denied to UCM Server managed resource. Unable to execute service CHECK_USER_CREDENTIALS and function remoteCredentialsCheck. (System Error: Unable to execute query 'Uuser(UPDATE/*+ INDEX (Users PK_Users)*/ Users SET dPassword='', dPasswordEncoding='', dUserAuthType='EXTERNAL', dUserOrgPath='', dUserSourceOrgPath='DC=our-domain,DC=local', dUserSourceFlags=0, dUserArriveDate={ts '2009-05-13 09:46:54.480'}, dUserChangeDate={ts '2012-05-02 14:25:37.186'}, dUserTimeZone='', dFullName = 'Lastname,Firstname', dEmail = 'Firstname.Lastname@domain.com', dUserType = 'Project Staff', dUserLocale = '', dUserTimeZone = '' WHERE dName = 'OUR-DOMAIN\username')'. ORA-00957: duplicate column name)

      Strange behavior.

      I tried deleting the entry from the users table, but then this error appeared:

      Access denied to UCM Server managed resource. Unable to execute service CHECK_USER_CREDENTIALS and function remoteCredentialsCheck. (System Error: Unable to execute query 'Iuser(insert into Users (dName, dPassword, dPasswordEncoding, dUserAuthType, dUserOrgPath, dUserSourceOrgPath, dUserSourceFlags, dUserArriveDate, dUserChangeDate, dUserTimeZone, dFullName, dEmail, dUserType, dUserLocale, dUserTimeZone) values('OUR-DOMAIN\username', '', '', 'EXTERNAL', '', 'DC=our-domain,DC=local', 0, {ts '2009-05-13 09:46:54.480'}, {ts '2012-05-02 14:39:32.620'}, '', 'Lastname,Firstname', 'Firstname.Lastname@domain.com', 'Project Staff', '', ''))'. ORA-00957: duplicate column name)

      Strange is that on our old servers with iis 6 it works and user is logged in via Microsoft Login... What could be causing this? Any ideas?