Load data fails due to ActiceX component

[Former Member]

Hi!

I´m trying to load data inot BPC cubes with data manager in BPC and when I run packkage the status shows this:

1. Convert Data: completed in 0 sec.

2. Load and Process: Failed in 13 sec.

3. Import: completed in 13 sec.

-

-

---

FILE=xxxBUDGETAPPDataManagerDataFiles

Transaktionsdataxxx.txt

TRANSFORMATION=xxxBUDGETAPPDataManagerTransformationFiles

System FilesTRANSFDATAKxxx.xls

CLEARDATA= No

RUNLOGIC= Yes

CHECKLCK= No

-

-

---

Convert Data

Success

Record Count : 45

Accept Count : 45

Reject Count : 0

Skip Count : 0

ActiveX component can't create object

What I conclude from this is that the data in the flat file is ok but can be writen to the cubes because of an error with the ActiveX component. I have read diffrent threads about ActiveX components errors but I havent found any solutions that works for me. The Workstatus for the dimensions are all set to No and when I run the package I have chooose the settings Merge data and Dont check workstatus, I have even tried to set the settings to Replace and Clear data.

Do anyone have another suggestion of solution?

Thanks!

[Former Member]

I solved the problem by doing a new transformationfile from scratch and suddenly it worked.

Thanks for all help!

[Former Member]

Hi,

Please make sure that you validate the default logic even if its empty. By the way, can you please check the data in the application whether it has been loaded or not. Because I can see that all the records have been accepted by the system.

I have a strong feeling that the default logic is not validated.

Hope this helps.

[Former Member]

Hi Nilanjan

Thanks for your reply! What do you mean by default logic? I have validated the transformation file is something moore that I have to validate?

Thanks!

Patrick

[Former Member]

Hi,

You need to login to BPC Admin. Then navigate to your application -> script logic -> default. Validate and save this logic.

Hope this helps.

[Former Member]

Hi Nilanjan!

Nope that didn´t help still same error unfortunaly.Could it be some thing with IE settings or User credentials? my User is Admin in BPC and on the machine.

[Former Member]

Hi,

There are few things which you can try:

1. If you are using SQL 2008, then make sure that you have installed the SQL server 2005 backward compatibility pack.

2. You can re-register K2processing.dll, K2processingInternal.dll, and K2logic.dll files.

You need to, first, unregister them as regsvr32 /u C:\BPC\Websrvr\bin\K2Logic.dll. And then register them by regsvr32 C:\BPC\Websrvr\bin\K2Logic.dll.

You need to do this in the application server and my assumption is that BPC is installed in C:\BPC.

Hope this helps.