cancel
Showing results for 
Search instead for 
Did you mean: 

FX-130 error

Former Member
0 Kudos
60

Hi

I have just upgraded to SP09-2 on my system. I receive the error below when running a consolidation.

Package Log

****************************************************************************************************

Start time --->3:59:14 PM - Date:4/29/2009 (build code:254)

****************************************************************************************************

User:EACDK\jeha

Appset:EACGROUP_DEVELOP

App:FINANCE

Logic mode:1

Logic by:

Scope by:

Data File:

Debug File:E:\BPC\Data\Webfolders\EACGROUP_DEVELOP\FINANCE\PrivatePublications\jeha\TempFiles
DebugLogic_838_.Log

Logic File:E:\BPC\Data\WebFolders\EACGROUP_DEVELOP\FINANCE
..\AdminApp\FINANCE\ConsolEACGroup.lgf

Selection:E:\BPC\Data\WebFolders\EACGROUP_DEVELOP\FINANCE\PrivatePublications\jeha\TempFiles\FROM_838_.TMP

Run mode:1

Query size:0

Delim:,

Query type:0

Simulation:0

Calc diff.:0

Formula script:

Max Members:

Test mode:0

Is Modelling:1

Number of logic calls:1

-


Call no. 1, logic:E:\BPC\Data\WebFolders\EACGROUP_DEVELOP\FINANCE
..\AdminApp\FINANCE\ConsolEACGroup.lgf

-


signeddata is YTD

-


Building sub-query 1

-


Query Type:0

Max members:

Executing SPRUNCONVERSION 'FINANCE',[ACTUAL],[C_EACGROUP], 'GLOBAL','SPSCOPE_171884','SPLOG_896761'

SPRunConversion Version 5.0.510

ERROR FX-130 No Group available.

Time to run stored procedure:1.1 sec.

call 1 completed and data posted in 1.3 sec.

Run completed in 1.4 sec.

****************************************************************************************************

End time --->3:59:15 PM - Date:4/29/2009

****************************************************************************************************

SPRunConversion Version 5.0.510

ERROR FX-130 No Group available.

My ConsolView dimension

ID C_EACGroup

NEWID

EVDESCRIPTION EAC Group Consolidated

REPORTING

MD

SCALE

CURRENCY_TYPE G

GROUP_CURRENCY DKK

ENTITY EACCO1

STORE_ENTITY Y

FIRST_CONS_DATE 2005.DEC

PARENT_GROUP

My Entity dimension

ID EACCO1

NEWID

EVDESCRIPTION EAC Group Consolidation

PARENTH1 ConsolEntity

CURRENCY DKK

COUNTRY

OWNER [AdminTeam]

Reviewer

Style

GROUP Consol

ELIM

INTCO

DRILLKEY

FUNCTION

REGION

FX_METHOD

FX_TYPE

TopDownAlloc

SubsidGroup Admin

Any help is greatly appriciated.

Accepted Solutions (0)

Answers (1)

Answers (1)

i045436
Advisor
Advisor
0 Kudos

Hi,

Please check on the currency dimension if there is a property named CURRENCY_TYPE.

See if there are members with this property set to "G".

Does it work before the upgrade?

Best regards,

Mihaela

edwin_geel
Advisor
Advisor
0 Kudos

also, please check if you have all the required properties.

you seem to miss datasrc_level

-edwin

Former Member
0 Kudos

Yes It worked before I did the upgrade.

The property you mention i would expect to be in the ConsolView dimension not in the Currency dimension. I have it in the ConsolView dimension. For the consolidation i am trying to run it is set to G.

Jesper

Former Member
0 Kudos

You are correct I do not have the Datasrv_level property. As far as I know this i an optional property and not a required one.

Does it have to be defined?

Jesper

Former Member
0 Kudos

Hi again

Trying to find the reason for my error I have commented out various lines in my consolidation logic. The only line left is

*RUN_STORED_PROCEDURE=SPRUNCONVERSION([%APP%],[%CATEGORY_SET%],[C_EACGROUP],[%SCOPETABLE%],[%LOGTABLE%])

I still get the error??????

Jesper

edwin_geel
Advisor
Advisor
0 Kudos

you need to include a paramter RATEENTITY after the CURRENCY parameter.

Probably it is GLOBAL or DEFAULT or something like that:

This is the full ist:

Parameter Description

Application The application ID.

Category The Category ID.

Currency The currency, Yes , or Multi.

Rateentity The default Entity member for the Rate application.

%SCOPETABLE% %SCOPETABLE% is a variable used by the system to define the

name of a logic table.

%LOGTABLE% %LOGTABLE% is a variable used by the system to define the name of

a Log table.

Impact Not used, but you must enter u201CNu201D.

Destination 1 = WB; 2 = Fac2

Ratedimension The member of the simulation dimension, if used.

Maxstatus The maximum status level allowing write access.

Does it work now ?

-edwin

Former Member
0 Kudos

Hi

My mistake, i do have Global in the call.

Also found the solution, based on your earlier comment.

I checked the properties in the ConsolView dimension, and as you pointed out i missed the DATASRC_LEVEL property and the property STORE_GROUP_CURR

I have create both of these properties a updated the STORE_GROUP_CURR to Y for all my G Currency_type values.

The consolidation now runs without any error.

Where do I find documentation of these 2 properties searched the Admin guide without any luck.

Jesper

former_member1192543
Contributor
0 Kudos

Hi Jesper,

iam also working on consolidation.you can find the doc for two fields in

admin help----->Setting up a legal consolidation application set..

i think it will help you...

Hope you find the result...

Regards,

Naresh.K