PLUSCDSASSETLINK interface table won't create

[GrayS]

 

Having problems creating the interface table to interface to/from the PLUSCDSASSETLINK table/mbo.
Tried with various combinations of the PLUSCDSASSETLINKID and DSASSETLINKID columns being restricted or not, and with the non-persistent ITEMSETID column set to either include or exclude.  All to no avail.  The interface table refuses to create.

The WebSphere SYSTEMERR log file says "A column with this name already exists" but does not elaborate on which column?!

Code:

[07/04/09 11:31:33:794 BST] 000001d7 SystemErr     R psdi.util.MXApplicationException: A column with this name already exists.
at psdi.app.configure.FldMaxAttributeCfgColumnName.validate(FldMaxAttributeCfgColumnName.java:65)

Can anybody help please?

[vijet]

HI,

You might be creating the interface table with the combination of parent and child mbo... So there has been a conflict with the column name...

Say if there is a column with name assetnum in parent table and also a assetnum in related MBO then interface table cannot be created with as a table cannot have two column with same name. Then you will have to exclude one column.

Try to find out which column is conflicting.

Regards
Vijet

[GrayS]

 
Thank you.  We (eventually) for the same response from IBM, and by making a new integration object with PLUSDSPLAN at the top, and PLUSCDSASSETLINK as the second MBO, it worked just fine.

[Today]

• How to get list data whic... by kvnaresh [Today at 12:39:03 am]
• How to change an email ad... by kvnaresh [Today at 12:25:57 am]
• Difference between fixpac... by jithu1989 [Yesterday at 05:25:18 am]
• Maximo Programmer Require... by ravikorukonda [February 06, 2012, 05:59:58 pm]
• Demo Maximo 7.1 Online by hyubby [February 06, 2012, 11:05:43 am]
• Error loading the Object ... by G Jeevan [February 06, 2012, 07:21:36 am]
• plzz attribute in another... by Dileep Kumar [February 06, 2012, 07:02:09 am]
• Jpeg attachments within M... by zenagarfield [February 02, 2012, 02:02:53 pm]
• How to change senders ema... by zenagarfield [February 02, 2012, 10:28:06 am]
• Lead and Crew by G Jeevan [February 02, 2012, 07:08:45 am]