Stuart, I have loaded the profile columns manually with the data available in jetspeed.script data looks like: 3c3f786d6c2076657273696f6e3d2.......... Should I convert it to byte array and load the tables??. I still have the columns defined as varchar.
Regards, Prashanth -----Original Message----- From: Stuart Belden [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 3:53 PM To: [EMAIL PROTECTED] Subject: RE: You do not have access to these portlets The "profile" column in JETSPEED_ROLE_PROFILE (or whatever) should contain a valid XML document (a psml document); it looks to me like the XML parser is throwing fits b/c it's not well-formed. My guess would be garbage before the "<?xml version="1.0" encoding="UTF-8"?>" line. Select the profile column out manually and see what it's returning. >>> [EMAIL PROTECTED] 11/25/03 08:40AM >>> Stuart, Thank you for the response. I forgot to change the property services.PsmlManager.classname to org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService from org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService After changing it, I see below exception in the log file: [25 Nov 2003 09:26:23 DEBUG] - Profiler: fallback called with: BaseProfile[anon/en/US/html/default.psml] [25 Nov 2003 09:26:23 DEBUG] - DatabasePsmlManagerService: Returning locator string: User:anon$Page:default.psml$MediaType:html$Country:US$Language:en [25 Nov 2003 09:26:23 DEBUG] - DatabasePsmlManagerService: Returning locator string: User:anon$Page:default.psml$MediaType:html$Country:US$Language:en [25 Nov 2003 09:26:23 DEBUG] - DatabasePsmlManagerService.refresh: no document found: profile: User:anon$Page:default.psml$MediaType:html$Country:US$Language:en [25 Nov 2003 09:26:23 DEBUG] - DatabasePsmlManagerService: Returning locator string: User:anon$Page:default.psml$MediaType:html$Language:en [25 Nov 2003 09:26:23 ERROR] - PSMLManager: Could not unmarshal the inputstream org.xml.sax.SAXParseException: Content is not allowed in prolog. at org.apache.xerces.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:118 3) at org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:338) at org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:270) And on the console, I see [Fatal Error] :1:1: Content is not allowed in prolog. This looks something to do with data type. What do you think?, please let me know. I am about to send a request to our DBA. Regards, Prashanth -----Original Message----- From: Stuart Belden [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 8:27 AM To: [EMAIL PROTECTED] Subject: Re: You do not have access to these portlets Turn debug logging on; does that give any clues as the the "access denied" problem? BLOB will work fine. >>> [EMAIL PROTECTED] 11/24/03 11:04AM >>> Hi, As there was a restriction in our DB2 environment not to use BLOBs, I have created the tables with long varchar data types in place of binary(objectdata/profile) fields. Now, the default page comes up with "You do not have access to these portlets." message. I have changed the MapBuilder classes to set the objectdata type to String from Object. When I was debugging the code, found that the objectdata is actually a serialized Hashtable with user id as key and a corresponding value. And when I checked the TURBINE_USER table, the objectdata field got updated with data: *� I am not able to figure out if the data updated is correct and why is it throwing error message?. Is it because of incompatible data types??. We talked to our DBA and they have accepted this as a special case to recreate tables with BLOB or CLOB, I was wondering which one should we use?. I am thinking of using BLOB since it is storing byte array, please let me know if that creates any problems. Thanks for any response. Regards, Prashanth ======================================================================== This email message is for the sole use of the intended recipient (s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. To reply to our email administrator directly, send an email to [EMAIL PROTECTED] Toys "R" Us, Inc. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ======================================================================== This email message is for the sole use of the intended recipient (s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. To reply to our email administrator directly, send an email to [EMAIL PROTECTED] Toys "R" Us, Inc. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ======================================================================== This email message is for the sole use of the intended recipient (s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. To reply to our email administrator directly, send an email to [EMAIL PROTECTED] Toys "R" Us, Inc. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
