Tips for languages, peoplecode, navigation, and email

1) You can use this SQL to find out which languages arealready installed for your installation.select * from PSLANGUAGES where installed = 1
2)You can use this in your peoplecode to determine ifthe current logged in user has role assigned to him.&IND = %Roles.Find("MYROLENAME");IF &IND <> 0 Then /* User has this Role */or /* User does not have this Role */end-ifYou can also use the peoplecode functionIsUserInRole("ROLENAME") to find the same.
3)If you do not see a folder or content Reference (MenuItem) in Left hand side navigation, (Applicable to8.4x ) then you must check to see if the folder orcontent reference is not marked as hidden. Otherreasons could be security. Here is a SQL to find outall the objects that are hidden.To find all the folders which are hidden from PortalNavigation.select * from PSPRSMSYSATTRVL where portal_name ='EMPLOYEE' and PORTAL_ATTR_NAM ='PORTAL_HIDE_FROM_NAV' and portal_Reftype = 'F' selecta.portal_objname,b.portal_label,b.portal_prntobjname,c.portal_labelfrom PSPRSMSYSATTRVL a,psprsmdefn b,psprsmdefn c wherea.portal_name = 'EMPLOYEE' and a.PORTAL_ATTR_NAM = 'PORTAL_HIDE_FROM_NAV' and b.portal_Reftype = 'F' and a.portal_name =b.portal_name and a.portal_objname = b.portal_objnameand b.portal_name = c.portal_nameand b.portal_prntobjname = c.portal_objname To find all the content references which are hiddenfrom Portal Navigation. select * from PSPRSMSYSATTRVL where portal_name ='EMPLOYEE' and PORTAL_ATTR_NAM ='PORTAL_HIDE_FROM_NAV' and portal_Reftype = 'C' selecta.portal_objname,b.portal_label,b.portal_prntobjname,c.portal_labelfrom PSPRSMSYSATTRVL a,psprsmdefn b,psprsmdefn c wherea.portal_name = 'EMPLOYEE' and a.PORTAL_ATTR_NAM = 'PORTAL_HIDE_FROM_NAV' and b.portal_Reftype = 'C' and a.portal_name =b.portal_name and a.portal_objname = b.portal_objnameand b.portal_name = c.portal_nameand b.portal_prntobjname = c.portal_objname Replace EMPLOYEE with Your portal name. Some of theOther names are. CUSTOMERDEMOSITEEMPLOYEEMOBILEPORTALPS_SITETEMPLATESUPPLIER Portal Content Reference/folder Attributes are storedin PSPRSMSYSATTR PSPRSMSYSATTRVL
4)Tuesday, February 20, 2007Troubleshoot Workflow EMAIL (SMTP Server) issues. Many time End users get an Error message : Unable toSend Email, Invalid ID, while saving the page. Thisusually means some kind of issue while sending emailfrom your appserver or batchserver using the SMTPServer. The error message is not correct and to getthe exact reason, why send email is failing, you needto add/Update the following in your appserverconfiguration (PSAPPSERV.CFG) or batch serverConfiguration (PSPRCS.CFG) under SMTP Settings.SMTPTrace=11 means enabled, 0 - Disabled. This setting issometimes not present in PSPRCS.CFG. You have to addit manually opening the file. This setting is dynamicand does not require reboot of the Server, which isvery good for troubleshooting in productionenvironments. Once turned on, it will generate Trace file SMTP.LOGin LOGS Folder under $PS_HOME/tools/appserv/DOMAIN forAppserver and $PS_HOME/tools/appserv/prcs/DOMAIN forBatchserver.Open SMTP.LOG and fix the issues logged in it. Thiswill make your users to save the page.