Anonymous_User Absent Member.
Absent Member.
518 views

import portlets from userapp 3.6 to userapp 4.5 errors


Hello,

I'm migrating some portlets from an old 3.6.1 environment to a new IDM
4.5 environment. When trying to import some custom portlets with the
portal data import tools, it returns me some errors on the userapp like
these


Code:
--------------------
4 portlet(s) have failed to be imported
Failed to be imported:
testportlet - An error occurred while importing portal data
....
--------------------


And on the catalina.out log with the following errors



Code:
--------------------
2015-03-17 12:09:35,072 [http-bio-8080-exec-3] DEBUG com.novell.afw.portal.portlet.core.portaldata.PortalDataImportResult- [RBPM] current localProducer is IDMProv
2015-03-17 12:09:35,188 [http-bio-8080-exec-3] ERROR com.novell.afw.tools.imex.DataImportExportReport- [RBPM] Report Failed: Portlet Registration, SMAgentEdit, Failed
com.netiq.persist.PersistenceException: java.sql.BatchUpdateException: Batch entry 0 insert into securityaccessrights (version, fwelementiid, permissionid, elementtypeid, iid) values (0, 'f9d7ce8577c04588a8a887b9f82893ff', 3, 1604, 'f2efd44b22cb4915928f5c133c822a32') was aborted. Call getNextException to see the cause.
at com.netiq.persist.HibernateUtil.commit(HibernateUtil.java:249)
at com.novell.afw.tools.imex.DataImport.importPortletRegistrations(DataImport.java:762)
--------------------


Is there a way to import them? Is it possible to import them from 3.6.1
to 4.5? Or I will have to re-create them again manually?


--
sbenavidez
------------------------------------------------------------------------
sbenavidez's Profile: https://forums.netiq.com/member.php?userid=560
View this thread: https://forums.netiq.com/showthread.php?t=53140

Labels (1)
0 Likes
7 Replies
Anonymous_User Absent Member.
Absent Member.

Re: import portlets from userapp 3.6 to userapp 4.5 errors

On 03/17/2015 11:24 AM, sbenavidez wrote:
>
> Hello,
>
> I'm migrating some portlets from an old 3.6.1 environment to a new IDM
> 4.5 environment. When trying to import some custom portlets with the
> portal data import tools, it returns me some errors on the userapp like
> these
>
>
> Code:
> --------------------
> 4 portlet(s) have failed to be imported
> Failed to be imported:
> testportlet - An error occurred while importing portal data
> ....
> --------------------
>
>
> And on the catalina.out log with the following errors
>
>
>
> Code:
> --------------------
> 2015-03-17 12:09:35,072 [http-bio-8080-exec-3] DEBUG com.novell.afw.portal.portlet.core.portaldata.PortalDataImportResult- [RBPM] current localProducer is IDMProv
> 2015-03-17 12:09:35,188 [http-bio-8080-exec-3] ERROR com.novell.afw.tools.imex.DataImportExportReport- [RBPM] Report Failed: Portlet Registration, SMAgentEdit, Failed
> com.netiq.persist.PersistenceException: java.sql.BatchUpdateException: Batch entry 0 insert into securityaccessrights (version, fwelementiid, permissionid, elementtypeid, iid) values (0, 'f9d7ce8577c04588a8a887b9f82893ff', 3, 1604, 'f2efd44b22cb4915928f5c133c822a32') was aborted. Call getNextException to see the cause.
> at com.netiq.persist.HibernateUtil.commit(HibernateUtil.java:249)
> at com.novell.afw.tools.imex.DataImport.importPortletRegistrations(DataImport.java:762)
> --------------------
>
>
> Is there a way to import them? Is it possible to import them from 3.6.1
> to 4.5? Or I will have to re-create them again manually?
>
>

Greetings,

1) What are the portlets that you are trying to import? If they were
clones of a Portlet, what was the base Portlet (Message, iFrame,
Resource Request)?

2) Please be advised that we only support migrating from version 4.0.2
to 4.5.0. It is not supported to move directly from 3.6.1 to 4.5.0

--

Sincerely,
Steven Williams
Lead Software Engineer
NetIQ
0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: import portlets from userapp 3.6 to userapp 4.5 errors


I also faced the same issue yesterday and then I noticed that if we
create a portlet with default values, I tried Detail with user entity,
in IDM 4.5 export it and remove the one created or don't remove and say
replace existing and import back we get this error. I raised a SR for
this yesterday. The error I get is

-2015-03-17 16:22:01,100 ERROR
[org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-8180-6) Batch
entry 0 insert into securityaccessrights (version, fwelementiid,
permissionid, elementtypeid, iid) values (0,
'd4f420c1459643a58fd02636abbd3d49', 3, 1604,
'cfe83af9eadb4df3a9a5b235a31d3755') was aborted. Call getNextException
to see the cause.
2015-03-17 16:22:01,100 WARN [org.hibernate.util.JDBCExceptionReporter]
(http-0.0.0.0-8180-6) SQL Error: 0, SQLState: 23505
2015-03-17 16:22:01,100 ERROR [org.hibernate.util.JDBCExceptionReporter]
(http-0.0.0.0-8180-6) ERROR: duplicate key value violates unique
constraint "accrts_eliid_uk"
Detail: Key (fwelementiid,
permissionid)=(d4f420c1459643a58fd02636abbd3d49, 3) already exists.
2015-03-17 16:22:01,122 ERROR
[com.novell.afw.tools.imex.DataImportExportReport] (http-0.0.0.0-8180-6)
[RBPM] Report Failed: Portlet Registration, XXXDetail, Failed-

And if we check securityaccessrights there is no entry with fwelementiid
value d4f420c1459643a58fd02636abbd3d49.

thanks
Koithodan


--
skoithodan
------------------------------------------------------------------------
skoithodan's Profile: https://forums.netiq.com/member.php?userid=228
View this thread: https://forums.netiq.com/showthread.php?t=53140

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: import portlets from userapp 3.6 to userapp 4.5 errors

On 03/18/2015 09:34 AM, skoithodan wrote:
>
> I also faced the same issue yesterday and then I noticed that if we
> create a portlet with default values, I tried Detail with user entity,
> in IDM 4.5 export it and remove the one created or don't remove and say
> replace existing and import back we get this error. I raised a SR for
> this yesterday. The error I get is
>
> -2015-03-17 16:22:01,100 ERROR
> [org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-8180-6) Batch
> entry 0 insert into securityaccessrights (version, fwelementiid,
> permissionid, elementtypeid, iid) values (0,
> 'd4f420c1459643a58fd02636abbd3d49', 3, 1604,
> 'cfe83af9eadb4df3a9a5b235a31d3755') was aborted. Call getNextException
> to see the cause.
> 2015-03-17 16:22:01,100 WARN [org.hibernate.util.JDBCExceptionReporter]
> (http-0.0.0.0-8180-6) SQL Error: 0, SQLState: 23505
> 2015-03-17 16:22:01,100 ERROR [org.hibernate.util.JDBCExceptionReporter]
> (http-0.0.0.0-8180-6) ERROR: duplicate key value violates unique
> constraint "accrts_eliid_uk"
> Detail: Key (fwelementiid,
> permissionid)=(d4f420c1459643a58fd02636abbd3d49, 3) already exists.
> 2015-03-17 16:22:01,122 ERROR
> [com.novell.afw.tools.imex.DataImportExportReport] (http-0.0.0.0-8180-6)
> [RBPM] Report Failed: Portlet Registration, XXXDetail, Failed-
>
> And if we check securityaccessrights there is no entry with fwelementiid
> value d4f420c1459643a58fd02636abbd3d49.
>
> thanks
> Koithodan
>
>

Greetings,
Thanks. We have been able to reproduce and a bug has been logged.

--

Sincerely,
Steven Williams
Lead Software Engineer
NetIQ
0 Likes
scauwe Absent Member.
Absent Member.

Re: import portlets from userapp 3.6 to userapp 4.5 errors

Has this been fixed?
We are having the same issue when migrating from 4.0.2 to 4.5.2.
We see the following in the log (increasing loglevel to trace for com.novell.afw.tools.imex) for every portlet we do not want to import:
Failed to compute portlet settings for portlet registartion :<portletname>due to: There was an error during the marshall/unmarshall of the object to XML/XML to object.

And then an exception for every portlet we do want to import:

Report Failed: Portlet Registration, <portlet name>, Failed
com.netiq.persist.PersistenceException: ORA-00001: uniqueness constraint violation (IDMUSER.ACCRTS_ELLID_UK)
at ...

Stefaan
0 Likes
skoithodan1 Absent Member.
Absent Member.

Re: import portlets from userapp 3.6 to userapp 4.5 errors


Not yet. I am still waiting for this fix.

Koithodan


--
skoithodan
------------------------------------------------------------------------
skoithodan's Profile: https://forums.netiq.com/member.php?userid=228
View this thread: https://forums.netiq.com/showthread.php?t=53140

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: import portlets from userapp 3.6 to userapp 4.5 errors

On 2/8/16 10:57 AM, skoithodan wrote:
>
> Not yet. I am still waiting for this fix.
>
> Koithodan
>
>

Greetings,
The issue has not been resolved yet. There should have been a note
added to the Release Notes of IDM 4.5 (I logged a bug for it to be
added as a known issue with the work-around).

The work-around was to import your Portlets without any Security.
During the import, you will be presented with the ability import
security settings. You will have to select "No". After the portles
have been successfully imported, you will then add any security to them
that you had originally.



--
Sincerely,
Steven Williams
Lead Software Engineer
Micro Focus
0 Likes
skoithodan1 Absent Member.
Absent Member.

Re: import portlets from userapp 3.6 to userapp 4.5 errors


Hi Steven,
I have tried that option previously and with that we can import the
portlets successfully, but when we try to add those in a custom
container it fails. This is the details I sent previously to the support
team.

We tried the workaround you suggested and it worked and all portlets
imported successfully.
Since we are not using any portlet level permissions we no need to
assign any permissions after that.
Now the issue we are facing is
We have a custom Container page and when I add the imported portlet to
this container page (Arrange Contents -> Add Content) and Save I get SQL
error. The error is

2015-04-14 12:04:37,207 WARN [org.hibernate.util.JDBCExceptionReporter]
(http-0.0.0.0-8180-3) SQL Error: 0, SQLState: 23505
2015-04-14 12:04:37,208 ERROR [org.hibernate.util.JDBCExceptionReporter]
(http-0.0.0.0-8180-3) Batch entry 0 insert into securitypermissions
(version, permissioniid, principalname, principaltype, iid) values (0,
'ccb7f245c7724c1e9897417c3fa71638', 'ffffffffffffffffffffffffffffffff',
NULL, '4d141860df0f4d91a653d2df0b335d14') was aborted. Call
getNextException to see the cause.
2015-04-14 12:04:37,208 WARN [org.hibernate.util.JDBCExceptionReporter]
(http-0.0.0.0-8180-3) SQL Error: 0, SQLState: 23505
2015-04-14 12:04:37,208 ERROR [org.hibernate.util.JDBCExceptionReporter]
(http-0.0.0.0-8180-3) ERROR: duplicate key value violates unique
constraint "erms_periid_uk"
Detail: Key (permissioniid,
principalname)=(ccb7f245c7724c1e9897417c3fa71638,
ffffffffffffffffffffffffffffffff) already exists.

In the case of portlet import sql error, the constraint entry was not in
the table, still it gave constraint error, but in this case
securitypermissions table has this combination already.

thanks
Koithodan


--
skoithodan
------------------------------------------------------------------------
skoithodan's Profile: https://forums.netiq.com/member.php?userid=228
View this thread: https://forums.netiq.com/showthread.php?t=53140

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.