CUIC Data Source to SocialMiner

Version 1
    This document was generated from CDN thread

    Created by: Travis Cassell on 26-01-2012 10:27:15 AM
    I'm attempting to setup CUIC with SocialMiner for reporting.  I've followed all of the settings listed in the Wiki and the reporting section of SocialMiner but it says offline.  When I few the error details in CUIC this is what I see:
     
    java.sql.SQLException: Incorrect password or user com.informix.asf.IfxASFRemoteException: reportringuser@cuic.domain.com is not known on the database server.
     
    The username in SocialMiner is "reportinguser" and the Database User ID in CUIC is "reportinguser" but it looks like it's appending @ then the CUIC FQDN which I'm sure SocialMiner has no clue about.
     
    This is what I see in SocialMiner

    10:19:27  listener-thread: err = -951: oserr = 0: errstr = reportringuser@cuic.domain.com: Incorrect password or user reportringuser@cuic.domain.com is not known on the database server.

    My question is how do I either remove the FQDN from the CUIC user or how do I add it in SocialMiner?

    Thanks,
    Travis

    Subject: Re: New Message from Travis Cassell in Contact Center Reporting (CCR) - Con
    Replied by: Nathan Luk on 26-01-2012 11:33:41 AM
    Looks like you might have a typo in the reporting user name as the socialminer error says reportringuser instead of reportinguser.

    Cheers,
    Nathan

    From: Cisco Developer Community Forums <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>>
    Reply-To: "cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>" <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>>
    Date: Thu, 26 Jan 2012 10:27:15 -0500
    To: "cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>" <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>>
    Subject: New Message from Travis Cassell in Contact Center Reporting (CCR) - Contact Center Reporting: CUIC Data Source to SocialMiner

    Travis Cassell has created a new message in the forum "Contact Center Reporting":

    --------------------------------------------------------------
    I'm attempting to setup CUIC with SocialMiner for reporting.  I've followed all of the settings listed in the Wiki and the reporting section of SocialMiner but it says offline.  When I few the error details in CUIC this is what I see:

    java.sql.SQLException: Incorrect password or user com.informix.asf.IfxASFRemoteException: reportringuser@cuic.domain.com<mailto:reportringuser@cuic.domain.com> is not known on the database server.

    The username in SocialMiner is "reportinguser" and the Database User ID in CUIC is "reportinguser" but it looks like it's appending @ then the CUIC FQDN which I'm sure SocialMiner has no clue about.

    This is what I see in SocialMiner


    <pre style="line-height: normal; word-wrap: break-word; white-space: pre-wrap;">10:19:27 listener-thread: err = -951: oserr = 0: errstr = reportringuser@cuic.domain.com<mailto:reportringuser@cuic.domain.com>: Incorrect password or user reportringuser@cuic.domain.com<mailto:reportringuser@cuic.domain.com> is not known on the database server.</pre>
    <pre style="line-height: normal; word-wrap: break-word; white-space: pre-wrap;">
    </pre>
    <pre style="line-height: normal; word-wrap: break-word; white-space: pre-wrap;">My question is how do I either remove the FQDN from the CUIC user or how do I add it in SocialMiner?</pre>
    <pre style="line-height: normal; word-wrap: break-word; white-space: pre-wrap;">
    </pre>
    <pre style="line-height: normal; word-wrap: break-word; white-space: pre-wrap;">Thanks,</pre>
    <pre style="line-height: normal; word-wrap: break-word; white-space: pre-wrap;">Travis</pre>
    --
    To respond to this post, please click the following link:

    <http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/5065548>

    or simply reply to this email.

    Subject: RE: CUIC Data Source to SocialMiner
    Replied by: Travis Cassell on 26-01-2012 11:36:04 AM
    LOL, that was it.  Oh the simple things.

    Thanks Nathan!