Getting an SQL error when importing a new BO in 3.5.0.2


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 [com.tririga.platform.om.dataaccess .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 3.5.0.2?

Continue reading

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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