Create first GL Account (Attribute key error)

[shane_mann]

Hi all,

Just found this forum and hopefully will be able to contibute (and get some help) regarding maximo.

The big picture is that we have a version 4 production installation, and are migrating to version 6.2. However, before we do the migration, we are attempting to prove some functionality using a standard version 6 installation. The install went well and we have both the Maximo application and database up and running 9the DB is empty). I've followed the admin guide to create a customer but we cannot create a GL Account.

When we try to add a new row for the GL Account - we get an error as follows:
"More than one attribute has primary column equal to 1. They must be different for each attribute"

I assume there is a primary key constraint on a table in the database but can't find where/how to reset or fix it?

Any ideas? is this a known bug/issue?

Any help appreciated.

Cheers,
Shane

[amdisuk]

Hi Shane,

I assume that this is a customization gone wrong. If you know the table that is causing the problem then you should be able to find the fields in Database Configuration.  I am surprised that you were allowed to do this. Anyway it shouldn't be difficult to change.

Hope that helps.

Al

[shane_mann]

Not sure if it was our customisation or not - but I found this:

http://www-01.ibm.com/support/docview.wss?uid=swg1IZ29232

And it shed enough light on the problem to find the problem Attribute. Once I reset them it seems to be working OK.

Cheers,
Shane

[amdisuk]

Lol, ok that is not a customization then. It's an IBM bug

[shane_mann]

yeah - I don't think the database should allow itself to get into this situation. In our case the 'TOOLINV' objectname had multiple rows where primarykeycolseq was 1, then some other rows where it was 2,3,4. So after nulling out the rows equal to 1, there was a primarykeycolseq 'gap' error as it went null,2,3,4 if that makes sense.

eg:

SQL> update maximo.maxattribute set primarykeycolseq=null where objectname='TOOL
INV' and primarykeycolseq=1;

2 rows updated.

SQL> select objectname, attributename, primarykeycolseq from maximo.maxattribute
 where objectname='TOOLINV' and primarykeycolseq<>1;

OBJECTNAME         ATTRIBUTENAME   PRIMARYKEYCOLSEQ

TOOLINV            ITEMSETID      4

TOOLINV            SITEID      3

TOOLINV            LOCATION      2
         

SQL> update maximo.maxattribute set primarykeycolseq=null where objectname='TOOL
INV' and attributename='ITEMSETID';

1 row updated.

SQL> update maximo.maxattributecfg set primarykeycolseq=null where objectname='T
OOLINV' and attributename='ITEMSETID';

1 row updated.

SQL> update maximo.maxattribute set primarykeycolseq=null where objectname='TOOL
INV' and attributename='SITEID';

1 row updated.

SQL> update maximo.maxattributecfg set primarykeycolseq=null where objectname='T
OOLINV' and attributename='SITEID';

1 row updated.

SQL> update maximo.maxattribute set primarykeycolseq=null where objectname='TOOL
INV' and attributename='LOCATION';

1 row updated.

SQL> update maximo.maxattributecfg set primarykeycolseq=null where objectname='T
OOLINV' and attributename='LOCATION';

1 row updated.

SQL> commit;

Commit complete.

Seems to be working now. Not sure if this is a very good fix though - will probably cause problems in the long run. This won't be our production database anyway so not too concerned.

Cheers,
Shane

[Yesterday]

• PM Estimated Due Date whe... by canislupus [Yesterday at 01:56:48 pm]
• unable to get wpmaterial ... by G Jeevan [Yesterday at 12:28:50 pm]
• KPIMAIN lookup not workin... by G Jeevan [Yesterday at 12:26:23 pm]
• add user access by Sarbjeet.Jassal [Yesterday at 08:04:33 am]
• Not able to access the ma... by Sarbjeet.Jassal [Yesterday at 07:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]
• Enabling Attachment on CL... by G Jeevan [May 11, 2012, 12:24:33 pm]