IBM Support

Attempting to modify template I am getting duplicate
row error.

Question & Answer


Question

Why when I modify my template am I getting a duplicate row error?

Answer

Here's a few things to check -


When updating the layout table when editing a startcenter template the
contentuid is taken from the contentuid property on the startcenter tag
in the presentation column for that startcenter template (that table is
sctemplate). If that attribute is missing it uses the sctemplateid for
the start center template (typically, they will be the same).

When it writes out the records for layout table, the contentuid for that
tables columns will be the <contentuid> + P + <numberic counter for each
portlet>

So, for example, if the contentuid for the template in question is 42
then the query: select * from layout where contentuid like '42P%' should
show any stranded rows.

Also verify that there are no stranded full sessions. When the
temporary startcenter is created for editing it is added to the scconfig
table with a null groupname, so before removing any layout records
verify that there isn't a pending session being editing by querying the
scconfig table, i.e. select * from scconfig where groupname is null.
[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Configurable Start Center","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.1.1;7.5;7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

More support for:
IBM Maximo Asset Management

Software version:
7.1.1, 7.5, 7.6

Operating system(s):
Linux, Windows

Document number:
256835

Modified date:
17 June 2018

UID

swg21698469

Manage My Notification Subscriptions