Clarity Service Management

Back to discussions
Expand all | Collapse all

BOXI/WEBI shows question mark in a black diamond against lists

Jump to Best Answer

  • 1.  BOXI/WEBI shows question mark in a black diamond against lists

    Posted 03-09-2016 02:03 AM

    Hello,

     

    Looking for some suggestions on the following BOXI/WEBI question in CA Service Desk Manager 12.9.

     

    When viewing a list of values, there is a black diamond with a question mark against all values.

     

    BOXI with diamonds and question marks.png

    This is preventing sorting.

     

    Any suggestions?

     

    The following procedure has been tried without success:

    * Login to designer

    * Import the universe

    * Refresh structure from view

    * Export the universe

     

    Also editing an existing report and creating a new one.

     

    Windows 2008 R2.

     

    I see lots of issues about this against BOXI on the web, but not sure where to start in this instance.

     

    Thanks, Kyle_R.



  • 2.  Re: BOXI/WEBI shows question mark in a black diamond against lists
    Best Answer

    Posted 03-09-2016 04:18 AM

    Hello Kyle,

     

    We had the same problem with CA SDM 14.1 and this helped: When using CA Business Intelligence (CABI) Reports, strange special/non-printable characters are seen in the Query filte…

     

    Best Regards,

    Vedran



  • 3.  Re: BOXI/WEBI shows question mark in a black diamond against lists

    Posted 03-09-2016 08:15 AM

    Hi Kyle,

     

    I have seen this problem before. I think it is caused by a discrepancy wrt the 32bit vs. 64bit ODBC. So look in that direction. Maybe uninstall and reinstrall the oa60_server and oa60_client services?

     

    You could also try to apply the latest SP applicable to your CABI version.

     

    Good luck ;-)

     

    Kind Regards,

    Brian



  • 4.  Re: BOXI/WEBI shows question mark in a black diamond against lists

    Posted 03-09-2016 09:59 AM

    Hey Brian,

     

    The issue is more about older version of the ODBC Server program (on the SDM server) vs newer, as opposed to 32b vs 64b.

     

    Reinstall approach suggested in the techdoc above by Vedran should fix the case.

     

    _R



  • 5.  Re: BOXI/WEBI shows question mark in a black diamond against lists

    Posted 03-09-2016 07:49 PM

    Thank you, Everyone.

     

    I will follow up on these suggestions.

     

    Kyle_R.