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

KB441541:Error “Cannot find a function corresponding to XIRR” occurred during metadata update process when upgrading from MicroStrategy 9.x to MicroStrategy 10.x


Ruiyu Han

Senior Support Engineer • MicroStrategy


Error “Cannot find a function corresponding to XIRR” occurred during metadata update process when upgrading from MicroStrategy 9.x to MicroStrategy 10.x

SYMPTOM
Error “Cannot find a  function corresponding to XIRR” occurred during metadata update process when upgrading from Strategy 9.x to Strategy 10.x.


Executing Project Logical update on project 'Project_XXX': (Cannot find a 
function corresponding to XIRR.Cannot find a function corresponding to 
XNPV.Cannot find a function corresponding to TrainAssocModel2.Cannot 
find a function corresponding to RScriptSimple.Cannot find a function 
corresponding to RScriptU.Cannot find a function corresponding to 
RScript.Cannot find a function corresponding to RScriptAggU.Cannot 
find a function corresponding to RScriptAgg.Cannot find a function 
corresponding to PatternMatch.Cannot find a function corresponding to 
PatternMatchDiff.Cannot find a function corresponding to 
PatternMatchCorr.Cannot find a function corresponding to 
HistogramMedian.Cannot find a function corresponding to 
BandNames.Cannot find a function corresponding to Repeat.Cannot find a 
function corresponding to GetExtraOutput.Cannot find a function 
corresponding to NullToEmpty.Cannot find a function corresponding to 
PercentRankRelative.Cannot find a function corresponding to 
PercentRank.Cannot find a function corresponding to OrdinalRank.Cannot 
find a function corresponding to WeightedStDev.Cannot find a function 
corresponding to WeightedMean.Cannot find a function corresponding to 
WeightedCov.Cannot find a function corresponding to 
WeightedCorr.Cannot find a function corresponding to 
LastPosition.Cannot find a function corresponding to TitleCap.Cannot 
find a function corresponding to ConcatAgg.Cannot find a function 
corresponding to ToString.Cannot find a function corresponding to 
ToNumber.Cannot find a function corresponding to Replace.Cannot find a 
function corresponding to Match.Cannot find a function corresponding 
to Split.Cannot find a function corresponding to Char.Cannot find a 
function corresponding to RepeatStr.Cannot find a function 
corresponding to BeginsWith.Cannot find a function corresponding to 
EndsWith.Cannot find a function corresponding to FiscalWeek.Cannot 
find a function corresponding to FiscalMonth.Cannot find a function 
corresponding to FiscalQuarter.Cannot find a function corresponding to 
FiscalYear.Cannot find a function corresponding to ToDateTime.Cannot 
find a function corresponding to QuarterStartDate.Cannot find a 
function corresponding to WeekStartDate.Cannot find a function 
corresponding to DateDiff.Cannot find a function corresponding to 
Search.Cannot find a function corresponding to Ampersand.Cannot find a 
function corresponding to Descendants.Cannot find a function 
corresponding to Ancestors.Cannot find a function corresponding to 
Parents.Cannot find a function corresponding to Children.Cannot find a 
function corresponding to BitAnd.Cannot find a function corresponding 
to BitOr.Cannot find a function corresponding to BitXor.Cannot find a 
function corresponding to BitNot.Cannot find a function corresponding 
to BitLeftShift.Cannot find a function corresponding to 
BitRightShift.Cannot find a function corresponding to IfByDimty.Object 
with ID '2C05D4BF4FCDE07833FC42AE1E4CAB31' and type 61 (GraphStyle) is 
not found in metadata. It may have been deleted.Object with ID 
'4F2A6AB944DECA70877D99BE219F8873' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'4F7C919D474CC653F4F225B7AEF798E5' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'089994CB4BA7525250B7A39041AAADB5' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'1B6DE5724915554C50A513A5C6308785' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'157E50CE4328FC8CE021F2B0835A77D0' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'8634B58F446E7518DFB779B584C0DC08' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'C024C0B14348564299EBC9997451FFDB' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'78F7257C414A0FBA47CA399F2657590E' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'AC02ABD14FB1DEA66D7FD0A47A1DDEDA' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'F2A6D9A1454E6E1C1F1AA5B6FFECDE94' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'52C4764B412E749D187204B3DF52D919' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'A7EF52BB428D81082632329DFD48F0C7' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'B49B34C545F373C7F40D7AB761CB473A' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'B1E40B124A8F5E098EF488AFBB73031D' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'559BCD564BAADAA0CD795699BC09A7A7' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'46B27FC14FEDA6848DF22AAAA8BDBF5D' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'C756679B48F233488BCEBFB5B240094F' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'F9A4272B4BAB44F2F48F81AC6DCDF9B7' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'5FB954E4407B5457D3B3598F585D7263' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'735CCC3A4208FAA04E1EBCB0110639F7' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'D069B11D48FC5B5FDAA70199B67DC588' and type 61 (GraphStyle) is not 
found in metadata. It may have been deleted.Object with ID 
'7CFB55FE4DC7A977B07F5C9B35B0EDC7' and type 12 (Attribute) is not 
found in metadata. It may have been deleted.Object with ID 
'7CFB55FE4DC7A977B07F5C9B35B0EDC7' and type 12 (Attribute) is not 
found in metadata. It may have been deleted.Object with ID 
'AB50A68B4DE2386950BC3F85F47F49E0' and type 12 (Attribute) is not 
found in metadata. It may have been deleted.The source manipulator 
found a missing dependency. Object: <Metric 
id=00B7BFFF967F42C4B71A4B53D90FB095> is not found. A total of 7 
object(s) need it, one of which is GDP ($US Billions) <Metric 
id=A09123AB4D683F240342B994CFC696A7>. Please turn on the log for more 
information.)

Note:
The below GUID could be for other metric, which is shipped out-of-the-box in 10.x metadata. 

Object: <Metric id=00B7BFFF967F42C4B71A4B53D90FB095> is not found.

CAUSE
In some scenarios like KB43806, GUID of some System Objects are not unified during upgrade.
 
ACTION
Follow below steps to re-execute System Object ID Unification and upgrade metadata:

  1. Ensure the metadata with above error has been back up. 
  2. Connect to this metadata and run below SQL:
    update DSSMDOBJPROP set prop_val=0 where propset_id='C02146A211D46D60C0001786395B684F' and prop_id=4 and object_type=32;
  3. Use configuration wizard to upgrade all projects again


If the error is not eliminated, please contact Strategy Technical Support. 
KB441541


Comment

0 comments

Details

Knowledge Article

Published:

August 17, 2018

Last Updated:

November 9, 2018