Cognos Analytics

 View Only
Expand all | Collapse all

Email attachment name encoded Cognos 11.1.7

  • 1.  Email attachment name encoded Cognos 11.1.7

    Posted Wed September 02, 2020 12:39 PM
    After the update to 11.1.7, the attachment names in the mail were encoded, what could be the problem?



    The name is written in Cyrillic


    ------------------------------
    Илья Буланов
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Thu September 03, 2020 10:56 AM
    Hi Илья Буланов
    I am able to reproduce this issue. I will log this an get back to you with more information.

    Can you let me know which version you upgraded from?
    Cheers,
    Trevor

    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 3.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Thu September 03, 2020 05:03 PM
    Hi Trevor!
    I updated from 11.1.6, but it was more of a clean install. Deleted the old version and installed the new one. I used configuration files from version 11.1.6

    ------------------------------
    Илья Буланов
    ------------------------------



  • 4.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Wed September 09, 2020 02:34 AM
    Hi! I noticed a special feature if the name length is more than 15 characters, the name is encoded, and if it is less, it comes in normal form

    ------------------------------
    Илья Буланов
    ------------------------------



  • 5.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Wed September 09, 2020 10:01 AM

    I am also seeing this character length scenario in R6 as well as R7. 

    My original test name in R4 and R5 was as follows:
    А Б В Г Ґ Д Е Є Ж З И І Ї Й К Л М Н О П Р С Т У Ф Х Ц Ч Ш Щ Ь Ю Я

    It displayed the name correctly. I will need to reload those versions to ensure I'm not missing something else.


    I am still in the process of testing logging this. We had a couple holidays so some stuff was pushed back.



    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 6.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Wed September 09, 2020 10:30 AM
    Which mail server do you send the email to? We use Microsoft Exchange Server. When sending to gmail.com I don't see this problem

    ------------------------------
    Илья Буланов
    ------------------------------



  • 7.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Wed September 16, 2020 11:40 AM

    I was using Argosoft and Lotus notes as email servers but mainly Office Mail to open the files.

    I just retested and sent the following report name to 5 email clients:

    А Б В Г Ґ Д Е Є Ж З И І Ї Й К Л М Н О П Р С Т У Ф Х Ц Ч Ш Щ Ь Ю Я а б в г ґ д е є ж з и і ї й к л м н о п р с т у ф х ц ч ш щ ь ю я Ё Ѫ Ѧ ѳ ы ѣ Ѣ ъ ψ ξ.pdf

    Yahoo mail succeeded. I see the correct file name and can download it as such.
    Gmail and Hotmail failed. I see the encoded name for the file.
    Outlook gives me an "Untitled Attachment".
    Lotus gives me a partly encoded name with 32 of the correct characters.

    When you mentioned that you did not see this in R6. Was that also with names longer than 15 characters? I'm trying to narrow down the correct scenario here. I am not aware of any change to our email process between R6 and R7.



    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 8.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Mon September 28, 2020 01:46 AM
    Hi! Sorry for the long answer, in R6 longer than 15 characters came normally.

    ------------------------------
    Илья Буланов
    ------------------------------



  • 9.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Tue September 29, 2020 12:34 PM
    Hi.

    We saw this error in 11.1.4 too:
    https://www.ibm.com/support/pages/apar/PH18964

    We found that upgrading on-top does NOT solve the issue.
    You need to install the newer version in completely new folders and configure Cognos from scratch -> totally clean install.

    That being said we actually have a customer who is facing the same problem (again) - and we are currently investigating if the install was made on-top or in new folders - and if upgrades has been done on the Exchange server that could cause this issue to return.

    BR,
    Kasper

    ------------------------------
    Kasper Dueholm
    ------------------------------



  • 10.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Wed September 30, 2020 02:04 AM
    Hi, the installation was clean, with the removal of Cognos folders. From the previous version, only storage that is deployed on MS SQL Server 2014

    ------------------------------
    Илья Буланов
    ------------------------------



  • 11.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Thu October 08, 2020 09:14 AM
    Hi.

    Just heard from IBM Support that they are working on this as a new defect....
    APAR PH30212 - it has not been made public yet.

    BR,
    Kasper

    ------------------------------
    Kasper Dueholm
    ------------------------------



  • 12.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Thu October 29, 2020 04:51 PM
    Edited by System Fri January 20, 2023 04:11 PM
    Hi Илья

    Option 1:
    If you are not using Cognos Mobile can you try disabling that service and resending the email? 

    This may be a work-around for the issue you are seeing.  I can't post more about the issue at the moment but I was able to get the email attachments return properly doing this. 

    Option 2:
    Obtain the latest Apple Push Notification certificate from https://www.ibm.com/support/pages/node/313007 for Mobile and follow the instruction there.

    We've seen this work for a number of other clients as well as internally,

    Thanks,
    Trevor


    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 13.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Wed November 04, 2020 04:29 AM
    Hi.

    I can confirm that Trevors option 2 works.

    BR,
    Kasper

    ------------------------------
    Kasper Dueholm
    ------------------------------



  • 14.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Wed November 04, 2020 07:51 AM
    Hi Trevor, 

    Option 1 helped me, thanks very much!
    How come Cognos Mobile affects the name of attachment in email?

    Petr.

    ------------------------------
    Petr Jerabek
    ------------------------------



  • 15.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Thu November 05, 2020 04:07 AM
    Hi Trevor,

    It works, thank you very much!

    ------------------------------
    Илья Буланов
    ------------------------------



  • 16.  RE: Email attachment name encoded Cognos 11.1.7

    Posted Mon June 14, 2021 04:41 PM
    Thanks @Trevor , Awesome it worked !!!




    ------------------------------
    prashyuth bodla
    ------------------------------