My linux install always fails so I decided to do
the basicConfig=no option, then I ran WPSconfig basic-config. When it gets to
the WMM database it fails. It is looking for an xml DTD file and can not find
it. I can not find any mention of this error anywhere. I've appended the log
below.
Could someone please post wmmAttributesMap.dtd it
should be in /opt/WebSphere/PortalServer/wmm
[exec] ALTER TABLE
WMMUSERREG
[exec] ADD CONSTRAINT
wmmf_40
[exec]
FOREIGN KEY (user_id)
[exec]
REFERENCES WMMDBMBR
[exec]
ON DELETE CASCADE
[exec]
---- --- ---
[exec] left over
file contents :
[exec]
[exec]
[exec]
---
[exec] -> import
complete <-
[exec]
---
[exec] loading
attributes from
/opt/WebSphere/PortalServer/wmm/wmmDBAttributes.xml....
[exec] File: /opt/WebSphere/PortalServer/wmm/wmmDBAttributes.xml is
processing...
[exec]
java.io.FileNotFoundException:
/opt/WebSphere/PortalServer/wmm/wmmAttributesMap.dtd (No such file or
directory)
[exec] at
java.io.FileInputStream.open(Native Method)
[exec]
at
java.io.FileInputStream.<init>(FileInputStream.java:78)
[exec] /opt/WebSphere/PortalServer/wmm/wmmDBAttributes.xml file has been
successfully loaded into database!
[exec]
done.
[exec] at
sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:99)
[exec] at
sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:164)
[exec] at
java.net.URL.openStream(URL.java:826)
[exec]
at
org.apache.xerces.impl.XMLEntityManager.startEntity(XMLEntityManager.java:748)
[exec] at
org.apache.xerces.impl.XMLEntityManager.startDTDEntity(XMLEntityManager.java:708)
[exec] at
org.apache.xerces.impl.XMLDTDScannerImpl.setInputSource(XMLDTDScannerImpl.java:258)
[exec] at
org.apache.xerces.impl.XMLDocumentScannerImpl$DTDDispatcher.dispatch(XMLDocumentScannerImpl.java:833)
[exec] at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:333)
[exec] at
org.apache.xerces.parsers.StandardParserConfiguration.parse(StandardParserConfiguration.java:525)
[exec] at
org.apache.xerces.parsers.StandardParserConfiguration.parse(StandardParserConfiguration.java:581)
[exec] at
org.apache.xerces.parsers.XMLParser.parse(XMLParser.java:147)
[exec] at
org.apache.xerces.parsers.DOMParser.parse(DOMParser.java:221)
[exec] at
org.apache.xerces.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:209)
[exec] at javax.xml.parsers.DocumentBuilder.parse(Unknown
Source)
[exec] at
com.ibm.ws.wmm.dbload.DBLoadManager.initialize(DBLoadManager.java:585)
[exec] at
com.ibm.ws.wmm.dbload.AttributePreLoader.main(AttributePreLoader.java:55)
action-wmm-dev:
[logmsg] 2004.01.28
09:21:50.570 action-wmm-dev
[logmsg] EJPC3068I Updating database "wps50"
[logmsg]
[java] WARNING: Cloudscape (instance
c013800d-00fa-5d80-4931-ffff8ebae0b8) is attempting to boot the database
/opt/WebSphere/PortalServer/cloudscape/wps50 even though Cloudscape (instance
c013800d-00fa-5d7f-fbf8-ffff8ebae0b8) may still be active. Only one
instance of Cloudscape should boot a database at a time. Severe and
non-recoverable corruption can result and may have already
occurred.
[java] Connected to
jdbc:db2j:wps50;create=true
[java] Reading file
/opt/WebSphere/PortalServer/config/work/db/cloudscape/wmm_initdb_dev.sql
[java] INSERT INTO WMMDBMBR(wmmdbmbr_id, member_type, member_unique_id,
member_dn, trunc_member_dn) VALUES (-1000, 'P', 'THIS-IS-THE-WPSADMIN-USER',
'uid=wpsadmin,o=default organization', LOWER('uid=wpsadmin,o=default
organization'))
[java]
[java] INSERT INTO WMMDBMBR(wmmdbmbr_id, member_type, member_unique_id,
member_dn, trunc_member_dn) VALUES (-1001, 'G', 'THIS-IS-THE-WPSADMINS-GROUP',
'cn=wpsadmins,o=default organization', LOWER('cn=wpsadmins,o=default
organization'))
[java]
[java] insert into wmmdbasval (WMMDBASVAL_ID, WMMDBATR_ID, WMMDBADTYP_ID,
WMMDBMBR_ID, STRINGVALUE, LOWER_STRINGVAL, HAS_CONTEXT) VALUES (-1, (select
WMMDBATR_ID from wmmdbatr where name = 'cn'), 'STRING', (select wmmdbmbr_id from
WMMDBMBR where member_dn = 'uid=wpsadmin,o=default organization'), 'wpsadmin',
LOWER('wpsadmin'), 0)
[java]
[java] SQL Exception: Column 'WMMDBATR_ID'
cannot accept a NULL value.
BUILD FAILED
/opt/WebSphere/PortalServer/config/wpconfig.xml:458: Java returned:
4
Total time: 1 minute 37
seconds