|
Home > Archive > WebSphere Portal Server > June 2007 > XmlAccess fails on Websphere Portal 6.0 after executed once.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
XmlAccess fails on Websphere Portal 6.0 after executed once.
|
|
|
| Hello,
I am facing an issue while installation of my application using XmlAccess.
I have created "DeployPortlet.xml" ,contains installation of war file (which has been manually installed ) using export ,and then manually created a page with subpages and then created another xml "Create_Page.xml" file by exporting this.
Now when i execute DeployPortlets.xml and Create_Page.xml. It executes successfully. Now I unsinstall both and then try to install using same files again , it gives an error :
<request xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" build="wp600_244" type="update" version="6.0.0.0" xsi:noNamespaceSchemaLocation="PortalConfig_1.4.xsd">
<status element="[content-node 6_V33E129000P8002EF05UCU2GD1 uniquename=com.itfactory.itfwp]" result="failed">
<message id="EJPXA0043E">com.ibm.wps.command.xml.XmlCommandException: EJPXA0043E: An error occurred while creating or updating the resource. [content-node 6_V33E129000P8002EF05UCU2GD1 uniquename=com.itfactory.itfwp]</message>
<message id="EJPDB0099E">com.ibm.wps.util.DataBackendException: EJPDB0099E: Error occurred during database access. Last SQL statement is [INSERT INTO release.PAGE_INST (OID, CREATED, MODIFIED, IS_ACTIVE, IS_SYSTEM, IS_SHARED, IS_PROVIDED, ALL_PORT
_ALLOWED, ORDINAL, PARENT_OID, PARENT_SL, CONT_PARENT_OID, CONT_PARENT_SL, SKIN_DESC_OID, SKIN_DESC_SL, THEME_DESC_OID, THEME_DESC_SL, CREATE_TYPE, TYPE, TF_INST_OID, SERVER_INFO_OID, SERVER_INFO_SL) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?)]. Transaction has status [STATUS_ACTIVE], global ID & #91;0000010f044aed4a000000010000325cf25c
55e2205d497d7d7dfcfd1e865f08b4e232e00000
010f044aed4a000000010000325cf25c55e2205d
497d7d7dfcfd1e865f08b4e232e000000001] and local ID [12892].</messag
e>
<message>com.ibm.websphere.ce.cm.DuplicateKeyException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint defined on 'PAGE_INST(OID)'.</message>
</status>
</request>
Strange , even when i deleted the already existing page , checked on the portal server if page with this unique id exists or not , and found there is no such page, xmlAccess says that page with this unique id already exists.
Please help. Is it a issue with Portal 6.0? or i need to manually delete this entry from some properties/xml file?
I have been working on Portal version 5.0.1 and WSE 2.6 ,never faced such issue.
Any reply would be highly appreciated.
Thanks,
Regards,
Reetika Budhiraja
| |
|
| No help, sorry, just wanted to tell you that I'm facing the same problem today. For me it might be my own lack of skills causing the problem, since this is my first time working with xmlAccess, anyhow - the script below is causing the same problem.
<?xml version="1.0" encoding="UTF-8"?>
<request xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="PortalConfig_1.4.xsd"
type="update">
<portal action="locate">
<!-- Delete the application if it exists -->
<!-- To be implementet -->
<!-- Install the application -->
<web-app action="create" active="true" uid="WebApp">
<url>file:///$server_root$/installableApps/CognosBIPortlets_c81.war</url>
<!-- The uid must match uid attribute of concrete-portlet-app in portlet.xml. -->
<portlet-app action="create" active="true" uid="CognosWSPortlets.4.f0ad8d6e309800171e82a889d584bc94d">
<!-- The name attribute must match content of portlet-name subtag of concrete-portlet in portlet.xml. -->
<portlet action="create" active="true" objectid="CognosNavigator" />
<portlet action="create" active="true" objectid="CognosSearch" />
<portlet action="create" active="true" objectid="Cognosviewer" />
<portlet action="create" active="true" objectid="CognosSdk" />
<portlet action="create" active="true" objectid="CognosWatchlist" />
</portlet-app>
</web-app>
</portal>
<status element="all" result="ok"/>
</request>
****************************************
**********
Rune Hellem http://hellem.org
| |
|
| I do see this error sometimes.
Could you export your pages using XMLAccess or the UI(Portal 6 has a button) and check ?
If your page is still there you could run a XMLAccess script with the 'delete' task for that particular page.
Thanks,
Mohan
| |
|
| Thanks you for all your replies.
But Mohan , as you said , I have already tried deleting pages manually/using xmlaccess ,also installing pages which are created manually once ,then exported using xmlaccess only. Seems as if problem lies somewhere else.
Regards,
Reetika
| |
| Jerome Curlier 2006-11-22, 1:40 am |
| See the following:
Problem: Re-creating and browsing a page can result in a duplicate key error
[url]http://publib.boulder.ibm.com/infocenter/wpdoc/v6r0/topic/com.ibm.wp.ent.doc/wps/adxmltrb.html? resultof=%22%63%6c%65%61%6e%75%70%22%20[
/url]
[url]http://publib.boulder.ibm.com/infocenter/wpdoc/v6r0/topic/com.ibm.wp.ent.doc/wps/adclndel.html? resultof=%22%63%6c%65%61%6e%75%70%22%20[
/url]
Jerome
<reetika.luthra@itf.as> wrote in message
news:1420936990.1164083885142.JavaMail.wassrvr@ltsgwas010.sby.ibm.com...
> Thanks you for all your replies.
>
> But Mohan , as you said , I have already tried deleting pages
> manually/using xmlaccess ,also installing pages which are created manually
> once ,then exported using xmlaccess only. Seems as if problem lies
> somewhere else.
>
>
> Regards,
> Reetika
| |
| Marc van Glabbeek 2006-12-01, 7:26 am |
| The reason is that one of the UIDs in the XML Access script already exists in your portal configuration. You can tell XML Access to generate new UIDs for the configuration items to be imported in your portal configuration. When you do so, the UIDs in the
script are only used for reference within the script, they will not be stored in the database. New UIDs are generated, enforcing unique UIDs.
To do so, add the following parameter to the <request> tag in the XML Access script: create-oids="true"
| |
|
| Dear Jerome & Marc,
Thanks for sharing the valuable information.
Now its working fine.
By the way , I am facing another issue :
Whenever i install WAR file on WPS 6.0 server (using IBM Portlet Factory 6.0 to create WAR file) , it creates "WebAppRunn_pplication_PA_j40x5aa.ear" inside installedApps directory on wps_root. "WebAppRunn_pplication_PA_" remains same everytime , "j40x5aa"
gets changed everytime i install WAR file.
How can i make uniquename generated after "WebAppRunn_pplication_PA_" , i.e. "j40x5aa" stable ?
I need to know this uniquename before i install war file as i need to refer this name in url being used in schemas.
Thanks and Regards
Reetika
| |
| Harisankar Gopalan 2007-06-13, 7:25 pm |
| Hi Reetika,
I want to create pages/assign Portlet to Pages/Authorisation using XML .Where I have to keep the XML files in portalserver(6.0) and how can I run the same.
Do you have sample XML files to create pages/assign Portlets for wps 6.0?
Thanks.
Hari
| |
| L D Jones 2007-06-19, 7:23 pm |
| Harisankar Gopalan wrote:
> Hi Reetika, I want to create pages/assign Portlet to
> Pages/Authorisation using XML .Where I have to keep the XML files in
> portalserver(6.0) and how can I run the same.
>
> Do you have sample XML files to create pages/assign Portlets for wps
> 6.0?
>
> Thanks. Hari
See the files in <wps>/doc/xml-samples
|
|
|
|
|