Error when Trying to Copy or Import Data via Data Manager

[Former Member]

Hello Experts,

I was trying to do an Import using the package in Data Manager and i Got this error:

[Admin-ProcessPartition]Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_tblFactAppname', Column: 'ACCOUNT', Value: '7061020702'. The attribute is 'AccountNom_ID1'

Also, I tried to do some Optimize in the Application and then a Copy from a Package and I still got this error.

Thanks for your help,

Rodrigo

[Former Member]

Hi Rodrigo,

Have you tried processing your applications?

Please process all your applications. See which application is giving error and please post the error as well.

[Former Member]

Hello Experts,

I deleted all the rows in tblFAC2<appname> and tbl.fact<appname> on the SQL Management Studio, and then I run a Optimize Application on the SAPBPC Admin and that solves my problem.

I just want to be sure of what exactly is the tblFAC2<appname> table.

Best Regards,

Rodrigo

[Former Member]

Hi,

FAC2TABLE is for short-term storage. When you load data via Data Manager, it loads the data to short-term storage so that the loaded data does not affect system performance. For more info on Fact tables and Optimization, please go through [this link|].

Hope this helps.

Regards,

Shoba

[Former Member]

Hi Rodrigo,

For every application, BPC creates 3 tables in the SQL.

1. FactWB<application> : writeback table - the data is stored whenever we send any data from the input schedules. This table is used for real term storage (the most current data sent to the system).

2. Fact2<application> : When we load data through DM packages, it gets stored in this table. Also called short term storage.

3. Fact<application> : Main data storage. All data eventually resides over here. Also termed long term storage.

Hope this helps.

[raghu_ram]

Hi,

Please do the following:

Identify the records that have an invalid value in the column YYYY (the value NULL for instance) in tblFactXXXX table, for example by running a query (via SQL Server Management Studio) in the SQL Server database corresponding to the application set: select * from tblfactXXXX where YYYY = 'NULL'

Delete these invalid records in the tblFactXXXX table.

Also have a look at SAP note 1391999.

Hope it helps.

Regards,

Raghu.

[Former Member]

Thanks for the answer,

Well, I found that in the tblFacXXXX there's no registry with the value YYYY. But in the tblFAC2XXXX there's more than 2500 with the value YYYY.

Can I delete those records from the tblFAC2XXXX ???

Regards,

Rodrigo

[raghu_ram]

Hi,

Please follow the SAP note....if it says to delete the records then you can go ahead.....once again follow the steps in sap note.

Regards,

Raghu.