Popular Tags

  • Query for Users and their Security Groups

    Hi, I just want to ask for an SQL query for the security group each users belong? Thanks and regards, Bryan

  • Erreur dans le rapport quotidien (SQL Loader)

    Bonjour Je rencontre l'erreur suivante dans l’exécution d'un rapport quotidien a cause d'un blocage au nivreau d'une commande SQL loader, vous allez trouver l'erreur ci-joint merci pour votre aide

  • Error while running Excel Report with template epmo/EPMOProjectBaselineReportTemplateV1.xlsx java.lang.NullPointerException

    Hi, Etienne. Trust that you're well and keeping safe. This is a possible duplication of a post that my colleague sent 2 years ago before I joined the team. - https://community.microfocus.com/adtd/sws-ppm/f/itrc-935/232143/excel-report-using-a-java…

  • net.sf.jett.exception.AttributeExpressionException: Null value or expected variable missing

    Hi, team. Kindly assist... I am getting an error when trying to run a report that was working perfectly fine earlier today. The message seems to point to a null exception when attempting to retrieve data from the source destination. (See image…

  • Adding a new portlet for existing project in project overview page

    Hello, I have created a portlet definition and portlet and need to add it to all existing projects. How do I do it? Does Project override setting will do this job for us? I think it works sometime and but not all the time Is there any backend tables…

  • XSSFSheet: Sheet index is out of range

    Good Day, team. Kindly assist with the following... I am trying to write the contents of an xlsx file using the Apache POI library and I am receiving a " java.lang.IllegalArgumentException ". The xlsx file in question is a template that we use to…

  • Need SQL for Workflow and Sub Workflow link

    Hello All, Im trying to build a query to display main workflows with their associated sub workflows and linked request type. Here is what im using so far: SELECT DISTINCT reqt.request_type_name, kw.workflow_name FROM kwfl_workflows kw, kcrt_request_types…

  • Stake Holders Groups list

    Hi, Can any one pelase let me know the SQL query to pull the list of Security groups assigned to project as stake holders. I am able to get the list of Resources but not groups. Attached screenshot. Thanks, Vamsee.
    • stakeholders.zip

  • PPM Support Tip: Improved behavior of SQL Drop-Down/Auto-Complete Fields

    When upgrading to 9.22 version, improved behavior of SQL Drop-Down/Auto-Complete Fields Platform issue - Feature to help with a previous Multilingual User Interface (MLU) Guide Starting from PPM Center version 9.22, custom drop-down fields and auto-complete…

  • how to write the query of request type

    Hi, i want the query for a request type. Regards

  • HP PPM with MS SQL Server

    Hi Everybody. in a implementation, the customer not have the Database Oracle, and his question is: Is it posible to implement HP PPM with a DataBase MS SQL server? I checked the matrix of compatibilities and not view the support for it. thks

  • SQL Server JDBC - No suitable driver found

    We have an integration with a SQL 2008 server and use Web Services to read the SQL server table and then create a request for a new entry in the table that was setup for us. The SQL server was not in a failover implementation. The DB was moved over into…

  • What to check when SQL reports do not run? Think its something with the profile?

    This should be easy but I am stuck. JSP reports run fine. But all SQL reports like Security Detail report, validation report etc timeout. I think its either something with our profile ( but ssh manual logon and echo $ORACLE_HOME is set properly) or the…

  • KSC Copy Request is not allowing Name field with apostrophe (')

    Hi, We are on PPM 9.14.0009 and are facing issue while creating request using KSC Copy Request which gives following error, Beginning command: KSC Copy Request Running PL/SQL procedure KCRT_REQUEST_UTIL.COPY_REQUEST Summary of parameters: FROM_REQUEST_ID…

  • PPM Support Tip: When doing tablespace maintenance, sample rebuild and move sql

    A new KCS article was published: KM00651735. The database tablespaces are created by Database Administrator (DBA) Users. In the past, sometimes there have been mistakes when creating these tablespaces. For example, the DATA, INDEX, and CLOB information…

  • can you use ksc_store to update workflow parameter?

    I'm trying to add 2 workflow parameter tokens to a workflow. I have a step on the workflow that I would like to save a SQL output to each of the 2 tokens. Is this possible or can you only update workflow parameter tokens by using the wf step parameter…

  • Oracle error when trying to execute a SQL script im a workflow step

    Good afternoon my PPM family, I need help from you SQL heads out there. Here is the script im trying to run: select decode(count(a1.status),0, 'NO', 'YES'), decode(count(a1.status),0, 'No', 'Yes') from ( select to_char(count(kstt.status)) status from…

  • How to Implement JSP Report

    Hi All, As of now we are running manual SQL queries in toad to generate the reports for deployment management. I want to automate this with the help of JSP report. Can someone tell me how to create the JSP reports fpr deployment management. Thanks

  • Trying to run SQL/CASE statement to get value then populate field

    Hello Team, We have a business need to calulate a custom value/result between delivery dates in a work plan from a project. We are pulling the dates/tables needed directly from the database so the only token being used is the 'Project Name' in the SQL…

  • PPM Support Tip: Make sure SQL Rule populates Field with valid Values

    When a SQL Rule select a Code that does not exist in a Validation's Option, JavaScript error thrown from CompValidation.js Error thrown when using a Drop-Down List to fill a custom Field: Uncaught TypeError: Object function (element) { for (;;) { var…

  • SQL for Package Migrations

    Hello All, I have been working on this idea for awhile now. During Project implementation, it is very difficult to keep a spreadsheet updated with packages that have successfully migrated to an environment. My question is....has anyone come up with a…

  • HP PPM - Resource Requests Portlet

    Hi, There is a OOTB portlet 'Resource Requests' in HP PPM. This portlet displays requests which are not fulfilled 100% i.e. resource request is partially fulfilled. I want to customize this portlet and want to show requests - 1. All resource request which…

  • Last Login details in HP PPM

    Hi, I need list of users who did not logged in the HP PPM last 6 months. I am writing a query on this but not able to find the field name and table which can give me last login details. Could anyone please help me on this. Any help in this regard would…

  • Query to show me the reached Workflow dates of the projects and requests

    Hello, I have a query which shows me the dates, when the project reached a status. SELECT LAST_UPDATE_DATE, STEP_NAME, FROM kwfl_step_transaction_hist_v WHERE TOP_INSTANCE_SOURCE_TYPE_CODE = 'IR' AND CURRENT_FLAG = 'Y' AND TOP_INSTANCE_SOURCE_SET_ID …

  • Token (Filter Fields) in View

    Hello, I wrote a sql query and have two tokens inside the query '[STARTDATE]' and '[ENDDATE]'. Due to the query is very long I created a view. When I create a datasource, with to filterfield (Validation = Date) and then create a portlet definition I get…

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.