BPC Error on dbo.Defaults when enter in the admin console

[Former Member]

Hi experts,

We were modifiying the appset web parameters and after that we could not enter in the administration console and the system returns next error: "Error message:Cannot insert duplicate key row in object dbo.defaults with unique index IX_tblDefaults. The statement has been terminated"

We've tried to restart the appset parameters into initial values but we got error again and again.

How can we solve this issue? Do Anybody have the same problem before?

Regards.

[sorin_radulescu]

Hi,

it seems you did some changes direct intoi table tbldefaults and you inserted two records with the same columns.

Or you are trying to insert some values already inserted into database.

I suggest to check that table to make sure you don't have duplicate records and after that the problem will be fixed.

Regards

Sorin Radulescu

[Former Member]

We didn´t enter any record in the tbldefault table.

I suppose this table is fill in automatically when you change the application set web parameters.

We have enter on the server manager to delete the duplicate records on the dob.tbldefault table but we didn´t find any duplicate records on this table. The error make reference to the IX_tbldefauld index.

Can you give me the steps to solve the issue on the server manager?

Other question is, how can we avoid to duplicate records can be saved on the database tblDefault?

Regards

Edited by: David Santos on Jul 1, 2009 11:07 AM

[Former Member]

I alredy know what is the problem.

When we insert some required appset web parameters, the data base return the error of duplicate keys on the dbo.tbldefaults table.

After that we can not enter on the admin console, and we can not able to delete this parameters from the appset web parameters window.

We have had to enter on the server manager to delete manually this parameters to can enter again on the admin console.

Parameters that couse us the error is ORG_OWNERSHIPCUBE.

Any help?

Regards.

[Former Member]

Problem solve with sap note 1326648

Regards.

[Former Member]

And David what is the sap note 1326648 for resolve that problem??

Thanks!