CA Service Management

Expand all | Collapse all

User is not able to login to ca sdm

  • 1.  User is not able to login to ca sdm

    Posted 08-04-2017 03:49 AM

    hi, error faced by one user while login to CA sdm 14.1, following is the error code :

     

    AHD04013:Internal error in method (found_matching_srel:profile_pic:id): AHD04199:An unexpected error occurred. Error log for the issueContact your administrator. [Microsoft OLE DB Provider for SQL Server] [ SQL Code=402 SQL State=42000] The data types nvarchar and ntext are incompatible in the equal to operator.

     

     

    Can anyone pls tell me, what can be the reason for this and how to resolve it.



  • 2.  Re: User is not able to login to ca sdm

    Posted 08-04-2017 04:15 AM

    Hi Mandar,

     

    Could you confirm on how you were able to come to this error message? Were you login to the application and you see this error message? OR are you using web services methods to login to the application?

     

    Also let us know the patch level at which you are currently. If this is on a test system, then you can use to turn on:

    pdm_logstat -a verbose

     

    and to turn off:

    pdm_logstat -a

     

    Don't do this on a production system, as it writes everything and more targeted logging is needed.

    We need more log data to understand the situation on this.



  • 3.  Re: User is not able to login to ca sdm

    Posted 08-04-2017 04:28 AM

    You may also want to attach some screenshot here for further investigation.



  • 4.  Re: User is not able to login to ca sdm

    Posted 08-04-2017 07:08 AM

    hi, attached is error screen shot.



  • 5.  Re: User is not able to login to ca sdm

    Posted 08-04-2017 07:11 AM

    From the screenshot I understand, You are running the login process using the web services method. Have you tried login to the system manually? What is the results on manual login?



  • 6.  Re: User is not able to login to ca sdm

    Posted 08-07-2017 05:12 AM

    hi, for login process no any web service called. 



  • 7.  Re: User is not able to login to ca sdm

    Posted 08-07-2017 05:24 AM

    Hi Mandar,

     

    Could you clarify the process you followed here:

     

    1. How are you trying to login to the application?

    2. What is the tool that you are using to get logged to the application

     

    Have you managed to use the same credentials to login to the application from web interface? If yes, what are the results?



  • 8.  Re: User is not able to login to ca sdm

    Posted 08-10-2017 04:42 AM

    hi Maheshwar,

     

    We have ca sdm 14.1, and using ca sdm login page for login to application, we are not using web service anywhere in the application.



  • 9.  Re: User is not able to login to ca sdm

    Posted 08-10-2017 02:59 PM

    Hello,

    Very difficult to diagnose ... errors come from stdlog?

    We now know the version of SDM (14.1) are there patches applied?

    Maybe a SQL incompatibility problem?
    A mistake of language?
    A "collation" problem on the database?
    Ideally you should know SDM works on which operating system, the same for the database as well as the browser used for authentication.

    The password is entered manually or as a single sign-on?