Tm1 ProcessERROR

[ravi]

Hi All,

Need your help in understanding Tm1 Processerror - when a chore/process fails it will generate the two file in data directory

Example :

1) TM1ProcessError_20100605040004_Load_Assump_Dtl_Control.log

Error Details:
"3048",Data Source line (1) Error: Data procedure line (14): Errors occurred during execution of process "Load_Assump_DTL_PR_Hrs". Check error log file for that process for more details.

2) TM1ProcessError_20100605040002_Load_Assump_DTL_PR_Hrs.log

Error details:
"07974","Jun","2012","200.",Data Source line (27686) Error: Data procedure line (13): Invalid key: Dimension Name: "Department", Element Name (Key): "07974"
"07974","May","2012","160.",Data Source line (40253) Error: Data procedure line (13): Invalid key: Dimension Name: "Department", Element Name (Key): "07974"

I would like to know about fixing these issue and how i should be doing step by step analysis to take corrective action- please advise.

Regards,
Ravi

[asutcliffe]

Hi,

2) TM1ProcessError_20100605040002_Load_Assump_DTL_PR_Hrs.log

Error details:
"07974","Jun","2012","200.",Data Source line (27686) Error: Data procedure line (13): Invalid key: Dimension Name: "Department", Element Name (Key): "07974"
"07974","May","2012","160.",Data Source line (40253) Error: Data procedure line (13): Invalid key: Dimension Name: "Department", Element Name (Key): "07974"

This is the key bit. This is telling you that on line 13 of your data tab, you're trying to write data to a cell that doesn't exist in your cube. Specifically, it doesn't exist because "07974" doesn't exist in the department dimension. You probably want to look at how your department dimension is maintained to ensure that new departments get added when required.

HTH

[ravi]

Hi HTH,

Thanks for reply.

I looked at the Dept Dim '07974' is not existing.I am still not sure why element is not getting updated and fix steps.Please advice.

Data tab details:
CellPutN(Value, 'Assumptions Detail',
Dept,
'USD',
'Local Currency',
Fiscal_Period ,
Fiscal_Year,
vVersion,
'Payroll Hours' );-------------------- Line number 13


Regards,
Ravi

[asutcliffe]

I looked at the Dept Dim '07974' is not existing.I am still not sure why element is not getting updated and fix steps.Please advice.

Data tab details:
CellPutN(Value, 'Assumptions Detail',
Dept,
'USD',
'Local Currency',
Fiscal_Period ,
Fiscal_Year,
vVersion,
'Payroll Hours' );-------------------- Line number 13

the CellPutN function just tries to write data to the cell. It isn't going to add an element to the department dimension if it doesn't exist, it's just going to give you the error message you're seeing. You need to have some sort of way to add new elements to the dimension when required.

You could modify this TI process to add the element to the dimension. However, usually I like to separate the dimension updates and data loads into different processes. Have a look at DimensionElementInsert in the manual.

It sounds like you're working on a system that someone else has built. Is there a TI process hanging around that sounds like it might update the departments dimension? Or is there an XDI for the departments dimension? It might be that you need to take a step back to get your head around exactly what a TM1 dimension is.

[asutcliffe]

One more thing to point out, if you do want to update the Departments dimension via TI, remember that the necessary code should go on the metadata tab.