PH08964: GERMAN USER APPLY A CLEAN FUNCTION ON A ITEM IN A DATA MODULE THEN THE FOLLOWING ERROR MESSAGE APPEARS: XQE-V5-0011

APAR status

• Closed as fixed if next.

Error description

• With a German user when apply a Clean function on a item in a
  data module then the following error message appears:
  
  The following error message appears: XQE-V5-0011 V5-Syntaxfehler
  in Ausdruck "nullif(Planned_revenue, 0)" gefunden. Ungültiges
  Token " " gefunden nach "nullif(Planned_revenue,".
  
  The cause of the issue is the comma in the expression
  nullif(Planned_revenue, 0). When change this expression into
  nullif(Planned_revenue; 0) then its working fine.
  
  ------------------------------------------------------------
  Testcase Environment Cognos Analytics
  ------------------------------------------------------------
  
  Content Store Database: MS SQL Server 2008 R2 Standart Ed.
  Query Database: MS SQL Server 2008 R2 Standart Ed.
  Relevant Package: GO Sales (Query)
  Relevant Cognos Version: Cognos Analytics 11.1.1
  
  ------------------------------------------------------------
  Steps to reproduce
  ------------------------------------------------------------
  
  (A)Steps to reproduce the customer issue:
  00. Change the content and the product languages to German
  01. Drag and Drop the attached file called 'GOSales.xls' into
  the welcome page on the buttom and select data module
  02. In the data module designer on the left side select the item
  'Planned Revenue' and in the context menue click on 'Bereinigen'
  03. Check the checkbox 'Diesen Wert durch NULL ersetzen' and
  click the button 'Bereinigen'
  --> The following error message appears: XQE-V5-0011
  V5-Syntaxfehler in Ausdruck "nullif(Planned_revenue, 0)"
  gefunden. Ungültiges Token " " gefunden nach
  "nullif(Planned_revenue,".
  
  (B) Attached files:
  cmplst.txt
  error_code.jpg
  ErrorWithComma.jpg
  GOSales.xls
  logs.7z
  OKWithSemicolon.jpg
  videoErrorDE.cap
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.1.2                       *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels