Consolidation Error Documentation (CSD)

[Former Member]

Hi all,

I have recently ended upon a consolidation engine error (CSD-070, CSD-080). Searching in the forum I have see some threads talking about some documentation about these errors. Could anyone please send that documentation?

About the CSD-070 (No Time available) & CSD-080 (No Group Available) errors, does anybody know what they can be related to?

Kind Regards,

Rafael

Edited by: Rafael Moreno on Oct 2, 2008 2:00 PM

[Former Member · Accepted solution]

Please find below a list of all errorcodes per stored procedure.

Alwin

MSG SPRUNCONVERSION

FX-000 ERROR FX-000 Application not Available !

Appset maintenance in progress

FX-010 ERROR FX-010 Wrong Application, check your logic

You may have hardcoded a wrong application in your logic.

FX-020 ERROR FX-020 No Currency in your Appset ! You must have a Dimension with dimension type = u2018Ru2019 in your Application. !

You must have at least one member with CURRENCY_TYPE = R In your currency dimension.

FX-030 Warning : Application without INTCO dimension

No INTCO Dimension IN your Application.(Dimtype = I)

FX-040 Warning : Application without Flow Dimension

No FLOW Dimension IN your Application.(Dimtype = S)

FX-050 Warning : Application without Datasrc Dimension

No DATASRC Dimension IN your Application.(Dimtype = D)

FX-060 ERROR FX-060 No Local currency, You must have a currency with CURRENCY_TYPE Equal to L

You must have one member with CURRENCY_TYPE = L (Local currency) In your currency dimension.

FX-070 ERROR FX-070 No Entity available in your Application

You have to select a parameter which is not a parent.

FX-080 ERROR FX-080 No Time available in your Application

Check if in the TIME Dimension, you have the property "MONTHNUM"

Check if in the TIME Dimension, you have filled properly the property "MONTHNUM". The first Period of the Fiscal year must be 1, and then the second 2u2026.

FX-090 ERROR FX-090 Problem IN Category Dimension check properties.

Your parameter CATEGORY is not valid.

FX-100 ERROR FX-100 Problem IN Category OR Ratedim Dimension check properties.

Your parameter CATEGORY is not valid OR

You don' t have the Property FX-SOURCE_CATEGORY In your Exchange Rate Dimension (For Simulation) OR

The Exchange Rate id you chose doesn't exist.

FX-110 ERROR FX-110 Problem IN Category Or Categhory_for_ope check properties.

Your parameter CATEGORY is not valid OR

You don' t have the Property CATEGORY_FOR_OPE In your CATEGORY Dimension OR

You don' t have the Property RATE_CATEGORY In your CATEGORY Dimension OR

You don' t have the Property FX-DIFFERENCE_ONLY In your CATEGORY Dimension

FX-120 ERROR FX-120 Problem IN Category Or TIME.

FX-130 ERROR FX-130 No Group available.

Check if the selected group has the property CURRENCY_TYPE = "G".

FX-140 ERROR FX-140 No Currency avalaible

FX-150 ERROR FX-150 Problem IN Ownership

Check if you have a base member equal to "METHOD" in the account dimension of the OWNERSHIP cube.

Check If you have valid information in the OWNERSHIP cube for the selected Category Time.

FX-160 ERROR FX-160 No Entity available

FX-170 ERROR FX-170 No Entity Available

FX-180 ERROR FX-180 No Datasrc to be converted

FX-190 ERROR FX-190 No Rate Application

FX-200 ERROR FX-200 No Rate Extract From FactRate

No Rate found for the selected category and time.

Check If the Rateentiy you enter in the parameter is the Same as the one in the Rateentity Dimension

Check If the Rates in the Rate Cube are in the RATE Dimension with Property Ratetype equal to "FX" OR "FX Rate".

FX-210 Warning : No Rates found in the opening period

FX-220 ERROR FX-220 No Rate for reference currency

Check If you Pivot currency (The base currency to enter the rate, Rate = 1) is filled.

FX-230 ERROR FX-230 Problem in your Entity Dimension id from your Rate application

The Rateentity (Dimension from the Rate cube with Evdimtype = E) you chose does not exist

FX-240 ERROR FX-240 : No Rate Extract From MbrRate

No Rate in the RATE Dimension with Property Ratetype equal to "FX" OR "FX Rate".

FX-250 ERROR FX-250 No Rates found

FX-260 ERROR FX-260 No Rate in Fact corresponding with Rate dimension

Check If the Rates in the Rate Cube are in the RATE Dimension with Property Ratetype equal to "FX" OR "FX Rate".

FX-270 ERROR FX-270 No Formulas extract from FXTRANS

No Rate formulas in your Fxtrans Table.

Check if the application name in the Logic.

FX-280 ERROR FX-280 No values found (T_FIN)

No values found for the selected Entities . Check if you have values in LC for the selected Entities OR

Check if the LC values are fro DATASRC with Property IS_CONVERTED not equal to "N"

FX-290 ERROR FX-290 No values found (Entity - T_FINANCETMP)

FX-300 ERROR FX-300 No values found (CLCFXTRANS - T_FINANCE)

No values found from FACT table for Account / Flow. Check if you have values in LC for the selected Account / Flow OR

Check our Fxtrans Table.

FX-310 ERROR FX-310 No values found (RATE - T_DATA)

No account extracted have a corresponding Rate_formula in the Fxtrans table.

FX-320 ERROR FX-320 No values found (ENTITY - GROUPS - T_FINAL2)

Check your Ownership and your group_currency values.

SPRUNCONSO

CSD-000 ERROR CSD-000 Application not Available !

Appset maintenance in progress

CSD-010 ERROR CSD-010 No Subtables. Verify properties FLOW_TYPE, IS_INPUT, SEGNOINV, SUBTABLES_ORIG

No Flow available, check the flow dimension, you must have the property "FLOW_TYPE"

CSD-011 ERROR CSD-011 No instruction retreived from the ELIM table

No instruction retreived from ELIM Table.

Check If the Elim id in ELIM table Exist in the ELIMH Table.

Check if the Account in the ELIM Table Exist. (as Base Member or as Agregat or as Value in property DIMLIST or value from property TYPELIM in the ACCOUNT Dimension)

CSD-012 ERROR CSD-012 No instruction retreived from the ELIM Table : GROUP_ACC Problem

No instruction retreived from ELIM Table. GROUP_ACC Problem

Check if the GROUP_ACC in the ELIM Table Exist. (as Base Member or as Agregat or as Value in property DIMLIST or value from property TYPELIM in the ACOUNT Dimension)

CSD-013 ERROR CSD-013 No instruction retreived from the ELIM Table : MINO_ACC Problem

No instruction retreived from ELIM Table. MINO_ACC Problem

Check if the MINO_ACC in the ELIM Table Exist. (as Base Member or as Agregat or as Value in property DIMLIST or value from property TYPELIM in the ACOUNT Dimension)

CSD-014 ERROR CSD-014 No instruction retreived from the ELIM Table : EQUITY_ACC Problem

No instruction retreived from ELIM Table. EQUITY_ACC Problem

Check if the EQUITY_ACC in the ELIM Table Exist. (as Base Member or as Agregat or as Value in property DIMLIST or value from property TYPELIM in the ACOUNT Dimension)

CSD-015 ERROR CSD-015 No instruction retreived from the ELIM Table with FLOW Dimension

Check if the SUBTABLE_ORIG in the ELIM Table Exist. (as Base Member or as Agregat or as Value in property DIMLIST in the FLOW Dimension)

CSD-020 ERROR CSD-020 No Currency in your Appset ! You must have a Dimension with dimension type = u2018Ru2019 in your Application. !

No Account extracted from CLCELIM Table, please check the Account from CLCELIM.

Check if the ACCOUNT in the ELIM Table Exist. (as Base Member or as Agregat or as Value in property DIMLIST or value from property TYPELIM in the ACOUNT Dimension)

CSD-030 ERROR CSD-030 No Entity Available

No Entity extracted. Check if you have the Property INTCO and the property CURRENCY in your ENTITY Dimension

CSD-040 ERROR CSD-040 No Account

No Account Extract from Account Dimension

CSD-050 ERROR CSD-050 No datasrc. Verify Properties DATASRC_TYPE,DATASRC_ORIG, IS_CONSOL

No Datasrc extracted.

Check if you have the Property "DATASRC_TYPE" and the property "IS_CONSOL" in your DATASRC Dimension

CSD-060 ERROR CSD-060 No Rules

No rules in your CLCRULES Table

Make sure the METHOD from the CLCRULES is not blank.

Make sure the I_METHOD from the CLCRULES is not blank.

CSD-070 ERROR CSD-070 No Time available

Check if in the TIME Dimension, you have the property "MONTHNUM"

Check if in the TIME Dimension, you have filled properly the property "MONTHNUM". The first Period of the Fiscal year must be 1, and then the second 2u2026.

CSD-080 ERROR CSD-080 No Group Available

Check if the selected group has the property CURRENCY_TYPE = "G".

CSD-090 ERROR CSD-090 Nothing Extracted From Ownership

Check if You have the property "IS_INPUT" in the Account dimension of the OWNESHIP Cube

Check if You have some base member from the Account dimension of the OWNESHIP Cube with IS_INPUT = "Y"

Check If you have valid information in the OWNERSHIP cube for the selected Category Time.

CSD-100 Warning : Nothing Extract From Ownership for OPENING Period

Nothing extracted from Opening period in the Ownership cube.

CSD-110 ERROR CSD-110 No AccountOwn available

Check if You have the property "IS_INPUT" in the Account dimension of the OWNESHIP Cube

Check if You have the property "RATETPE" in the Account dimension of the OWNESHIP Cube

Check if You have some base member from the Account dimension of the OWNESHIP Cube with IS_INPUT = "Y"

CSD-120 ERROR CSD-120 No Entity - Method available

No data found in OWNERSHIP Cube for this method.

Check if you have METHOD in your ownership cube for the selected CATEGORY - TIME - GROUP

CSD-125 ERROR CSD-125 No Entity - Method available

No data found in OWNERSHIP Cube for this method.

Check if you have METHOD in your ownership cube for the selected CATEGORY - TIME - GROUP

CSD-130 ERROR CSD-130 Problem Extracting data from the Fact Table

No Values found

Check if You have Some Account from the ELIM Table.

Check if You have some DATASRC with IS_CONSOL = "Y"

CSD-135 ERROR CSD-135 Problem Extracting data - C_FINANCE

No Values found

Check the Account in the FACT Tables

CSD-140 ERROR CSD-140 Problem Extracting data - C_DATA

No Values found

Check the Entity in the FACT Tables

Check the INTCO in the FACT Tables

CSD-145 ERROR CSD-145 Problem Extracting data - C_DATA_ALL

No Values found for those Account And/Or Flow.

Check the DATASRC in the FACT Linked to the DATASRC_ORIG in the ELIMH Table.

CSD-150 ERROR CSD-150 Problem Extracting data - C_REPART

No Values found for those rules.

Check the method between METHOD Table and your ownership Cube.

Check your Rules between the RULES Table and The ELIM Table.

Check The INTCO.

CSD-160 ERROR CSD-160 Problem Extracting data - C_CONSO

SPRUNCALC

CALC-000 ERROR CALC-000 Application not Available !

Appset maintenance in progress

CALC-010 ERROR CALC-010 Nothing Extract from CALCACCOUNT TABLE

Nothing Extracted from CALCACCOUNT Table, check the account, The account must be a as Base Member or an Agregat or a Value in property DIMLIST or a value from property TYPELIM in the ACOUNT Dimension)

CALC-020 ERROR CALC-020 Nothing Extract from CALCACCOUNT TABLE (FLOWS)

Nothing Extracted from CALCACCOUNT Table, check the Subtables, The Subtables must be a as Base Member or an Agregat or a Value in property DIMLIST in the FLOW Dimension)

CALC-030 ERROR CALC-030 NoTime extract.

Check your TIME Dimension

CALC-040 ERROR CALC-040 NoTime extract for YTD

Check your TIME Dimension.

Check if in the TIME Dimension, you have the property "MONTHNUM"

Check if in the TIME Dimension, you have filled properly the property "MONTHNUM". The first Period of the Fiscal year must be 1, and then the second 2u2026.

CALC-050 ERROR CALC-050 NoEntity extract

Check your Parameter Entity, it must be an base member (Or a list of base member) from the ENTITY Dimension

CALC-060 ERROR CALC-060 NoEntity extract

Check your Parameter Currency, it must be a base member (Or a list of base member) from CURRENCY Dimension

CALC-070 ERROR CALC-070 NoEntity extract

No values found, check if you have something to calculate for the selected CATEGORY - TIME - CURRENCY

Check your CALCACCOUNT Table.

Check : The account must be a as Base Member or an Agregat or a Value in property DIMLIST or a value from property TYPELIM in the ACOUNT Dimension)

CALC-080 ERROR CALC-080 NoEntity extract

No Values found.

Check your CALCACCOUNT Table.

Check : The SUBTABLES must be a as Base Member or an Agregat or a Value in property DIMLIST in the FLOW Dimension)

SPCOPYCATEGORY

CCAT-000 ERROR CCAT-000 Application not Available !

Appset maintenance in progress

CCAT-010 ERROR CCAT-010 No Time available in your Application

Check your Parameter "Time".

CCAT-020 ERROR CCAT-020 Nothing extracted from the Account Dimension

Check the property in the parameter.

Check that this property is in the ACCOUNT Dimension

CCAT-030 ERROR CCAT-030 No Entities available

Check your Parameter "Entity".

CCAT-040 ERROR CCAT-040 No Currency available

Check your Parameter "Currency".

CCAT-050 ERROR CCAT-050 No data found

No data found, check if you have data for the selected CATEGORY - TIME - CURRENCY

SPCOPYOPENING

COPYO-000 ERROR COPYO-000 Application not Available !

Appset maintenance in progress

COPYO-010 ERROR COPYO-010 No Datasrc Available

Check if you have Datasrc with DATASRC_TYPE different from "A"

Check if COPYOPENING Property is equal to Y

COPYO-020 ERROR COPYO-020 Nothing extracted from COPYOPENING TABLE

Check your COPYOPENING TABLE

COPYO-030 ERROR COPYO-030 No Time available

Check your Parameter "Time".

COPYO-040 ERROR COPYO-040 No category available

Your parameter CATEGORY is not valid OR

You don' t have the Property CATEGORY_FOR_OPE In your CATEGORY Dimension OR

You don' t have the Property OPENING_YEAR In your CATEGORY Dimension OR

You don' t have the Property OPENING_PERIOD In your CATEGORY Dimension

COPYO-045 ERROR COPYO-045 No category available

Your parameter CATEGORY is not valid

COPYO-050 ERROR COPYO-050 Problem in COPYOPENING Properties

Check Opening_year and / Or Opening period properties in CATEGORY Dimension.

COPYO-060 ERROR COPYO-060 No Entities available

Check your Parameter "Entity".

COPYO-070 ERROR COPYO-070 No Currency available

Check your Parameter "Currency".

COPYO-080 ERROR COPYO-080 No Account available

Check your COPYOPENING Table

Check if the Account in the COPYOPENING Table Exist. (as Base Member or as Agregat or as Value in property DIMLIST or value from property TYPELIM in the ACCOUNT Dimension)

COPYO-090 ERROR COPYO-090 No Data found

Check if you have data for the selected CATEGORY - TIME - GROUP

SPRUNVALID

VALID-000 ERROR VALID-000 Application not Available !

Appset maintenance in progress

VALID-010 ERROR VALID-020 Nothing extracted from VALIDATION TABLE

Check your VALIDATION TABLE

VALID-020 ERROR VALID-020 Nothing extracted from VALIDATION_H TABLE

Check your VALIDATION_H TABLE

VALID-030 ERROR VALID-030 Wrong Application, check your logic

You may have hardcoded a wrong application in your logic.

VALID-040 ERROR VALID-040 No Datasrc available

Check your Parameter "DATASRC".

VALID-050 ERROR VALID-050 No Time available

Check your Parameter "Time".

VALID-060 ERROR VALID-060 Nothing extracted from VALIDATION - VALIDATION_H Table

Check your VALIDATION TABLE

Check your VALIDATION_H TABLE

Check the validation iD in VALIDATION and VALIDATION_H Table.

VALID-070 ERROR VALID-070 No Data found

Check if you have data for the selected CATEGORY - TIME - GROUP

VALID-080 ERROR VALID-080 No Data found for the selected period

Check your PERIOD Property in the VALIDATION_H Table