Getting an SQL error when importing a new BO in

When I try to import an OM package with a new BO, I receive this error:

java.sql.SQLException: Procedure or function SP_INSERT_SPEC_TYPE has too many arguments specified.

The OM will then fail with duplicate key issues:

2016-06-27 12:02:38,200 ERROR [ .BusinessObjectMigrationDAOAnsi] Exception in BusinessObjectMigrationDAOAnsi .insertLayoutNonSmartSection(): java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_SOBJTYPE_SECTIONS'. Cannot insert duplicate key in object 'dbo.SOBJTYPE_SECTIONS'. The duplicate key value is (10032031, 0, 1).

I added this parameter to the stored procedure:

@p_enable_snapshot SMALLINT,

So I could import the OM package correctly. Has anyone experienced this issue with

Continue reading


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s