BOFC cannot open package "An unknown error occured"

[Olj]

Hi Experts,

we have some problem with opening package.

We cannot open some package, error:

we check all bofc logs, but there is no any error message.

We didn't change any master data before.

Problem with the same package, other packages opens fine.

Start/stop datasource doesn't help.

[Former Member · Accepted solution]

Hi Again,

This error can occurs also when some objects used on the package has been deleted from the Dimension builder and still exists on the package

You can refer to the following KBA : 2210430 - FC : Error on the data engine ( that takes as example the list of account used on the package and deleted from the dimension builder)

Regards,

Soumaya

[Olj · Accepted solution]

Hi Soumaya,

I cannot execute this query from note:

select [columns], count(*)

from ct_pk0086

where entity in (select id from ct_entity where name='200425585')

group by [columns]

having count(*)>1

SQL cannot find field  "Columns" :

"Invalid column name 'columns'"

I check table ct_pk0086, but there is no field "Columns".

SQL Server 2008 R2.

[Former Member · Accepted solution]

Hello,

We mean by [ Columns ] the list of all the columns of the table ct_pk0086 except data_comment , version , amount

Regards,

Soumaya

[Olj · Accepted solution]

Soumaya, thanks, I tried that query, but there is no result (that means is there no dublicate?).

Now we found quick resolution:

1. We backup(export) package data

2. Empty package

3. Regenerate package

4. Import backuped data.

Package is opened!

I backuped BOFC database to find reason/solution of error.

What can be wrong?

SAP FC 10, sp 10 patch 1.

[Former Member · Accepted solution]

Hello,

This issue have various causes and can happen as a result of various events, notably:

• Loss of electrical power while the user is still working on the package
• The user improperly exited from precise packages
• The package is requested by many users: the packages simultaneously opened
• Some accounts has been deleted from the Dimension builder and still exists on the package

You can as already confirmed  export the package , reset it to zero and import it again in the package.

Regards,

Soumaya

[Former Member]

Hello,

Could you please if you have duplicates of the packages .

For that , you can refer to the note : 2072777 - FC: How to check duplication in package data?

Regards,

Soumaya

[sirine_belhadjrhouma]

Hi Daulet,

Were you able to open the same packages before?

Have you performed modifications in the category scenario related to these packages?

could you please try to open the Category Scenario of this packages and re-validate and re-distribute it to see if this can help to solve the issue or not.

Regards

Sirine.

[Olj]

Hi Sirine,

Yes, we able open same package before,   after 2.30 PM (user change data) we canno open that package (before opens fine). We didn't any modification last 5 days. Re-validate and re-distribute doesn't help.