EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB441902: Error message "Function 'TD_RIGHT' called with an invalid number or type of parameter" appears when users run reports with OOTB attributes using TD_RIGHT function in Enterprise Manager 10.x against Teradata database


Yihuan Qian

Senior Support Engineer • MicroStrategy


If user runs report with OOTB attribute using TD_RIGHT funtion in Enterprise Manager 10.x against Teradata database, user will geterror "Function 'TD_RIGHT' called with an invalid number or type of parameter".

SYMPTOM:
If users run reports with OOTB attributes using TD_RIGHT function in Enterprise Manager 10.x against Teradata database,the error message "Function 'TD_RIGHT' called with an invalid number or type of parameter" appears.
STEPS TO REPRODUCE:

  1. Configure Enterprise Manager using Teradata as Enterprise Manager Repository;
  2. Create a report with the OOTB attribute Connection Source ( Location - >Enterprise Manager\Schema Objects\Attributes\All Indicators & Flags);
  3. Execute the report. Users will get error: Function ‘TD_RIGHT’ called with an invalid number or type of parameter.
  4. Copy the report sql and modify 'length' to 'char_length' in DB Query Tool. No error.

CAUSE:
Right function with length parameter is not supported.
ACTION:
The issue will be fixed in Strategy 2019. Upgrade to this version to take advantage of the fix.
KB441902


Comment

0 comments

Details

Knowledge Article

Published:

September 26, 2018

Last Updated:

June 13, 2022