TM1 Forum

I have a TI process that updates a cube and load data, but some times it works fine, and most of the times the process is aborted and the log shows the next message:
"[0BUS_AREA].[001]","[0CHRT_ACCTS].[CMEX]","[0COMP_CODE].[01]","[0GL_ACCOUNT].[CMEX6105100001]","[0CALMONTH].[200701]","[0FISCPER].[K22007001]","[0FISCVARNT].[K2]","[0CURRENCY].[MXN]","[Measures].[0BALANCE]","[0CALMONTH2].[All]","174716.57",Data Source line (1) Error: Data procedure line (7): Wrong Number of Dimension Elements.

But i have all these dims in my cube, as I said before, it worked several times before...

Also I'm testing this process changing the number of accounts that is pulling from SAP BW, and if I choose more than 19 it stops working... and displays any of the next messages:
Error: Data procedure line (0): MDX query execution failed - HRESULT: 80004005, Minor Code: 0, Source: MDrmSap.2, Description: An unexpected internal provider error occurred.

Error: Data procedure line (0): MDX query execution failed - HRESULT: 80004005, Minor Code: 0, Source: MDrmSap.2, Description: Comando MDX no válido en 0GL_ACCO UNT

We are making some test to connect to SAP BW and import the cubes and information to TM1, but it is not working as expected.

Any Ideas or suggestions?

TIA

Victor

Victor

I have just had a similar error and it is spurious. TM1 has got its knickers in a twist. Unload the cube and you will stop the error occurring.