Clarity PPM

Expand all | Collapse all

GEL Script log not displayed 15.3

Jump to Best Answer
  • 1.  GEL Script log not displayed 15.3

    Posted 10-05-2017 10:45 AM

    I am on version 15.3 and this basic script is not displaying any logs in the process messages

     

    <gel:script

    xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
    xmlns:jelly="jelly:core">

    <gel:log>*** TEST TEST TEST ***</gel:log>

    </gel:script>

     

    But when i am looking at the bg-ca.log i can see the following error messages

    ERROR 2017-10-05 12:27:05,118 [Custom script execution pool-12-thread-13] utilities.BpmErrors (clarity:admin:5118300__249BBB92-EDEF-4036-AD40-DBADF4D76AE5:none)   Begin Error Information:   Step Action Id: 5014012   Process Instance Id: 5000041   Step Instance Id: 5000189   Error: bpm.raw.message   Error Code: bpm.raw.message   Exception Trace: *** TEST TEST TEST *** End Error Information

    bg-ca.log
    Process log

    Any pointers would be helpful.


  • 2.  Re: GEL Script log not displayed 15.3
    Best Answer

    Posted 10-05-2017 11:03 AM

    Hi Rajat,

     

    In 15.3 we have added a flag in CSA where you would like to store logs in BPM_ERRORS table, by default its set to Error and you want to do info logging then you would need to change 

     

     

    Restart the services and you should see its populating in the UI also. This is done to prevent the excessive logging.

     

    Regards

    Suman Pramanik 



  • 3.  Re: GEL Script log not displayed 15.3

    Posted 10-05-2017 11:05 AM

    We have documented it too in our release notes 

     

    Release Notes (On Premise) - CA PPM - 15.3 - CA Technologies Documentation 

     



  • 4.  Re: GEL Script log not displayed 15.3

    Posted 10-05-2017 11:11 AM

    Thanks a lot Suman.

    You prompt response is really appreciated.

    Seems i have missed this in the documentation.



  • 5.  Re: GEL Script log not displayed 15.3

    Posted 10-05-2017 11:21 AM

    You are always welcome and I hope you are liking the CA PPM 15.3 release.  Have a great day  

     

    Regards

    Suman Pramanik 



  • 6.  Re: GEL Script log not displayed 15.3

    Posted 11-09-2017 08:36 PM

    Hi Suman, we just experienced this when verifying our DEV V15.3 environment which is SaaS.  Our release notes only have:

    "BPM_ERRORS Table Management: In previous releases, the size of the BPM_ERRORS table
    typically expanded with debug statements and process details. To reduce the size of this table,
    this release includes a new pre-scheduled daily recurring instance of the Delete Process Instance
    job."

    No mention of this new parameter, and as it is SaaS, I don't believe we have access to change it.  Should the release notes for SaaS be updated to reflect this change, including contacting CA Support to request them to change it?

     

    Additional observation, as part of the V15.3 upgrade, the upgrade deleted all records from BPM_ERRORS table.  Appreciate why this parameter was introduced, but if we need this data (eg I may have scripts using it ), then the upgrade should not delete this data as part of the V15.3 upgrade, just because there is an introduction of a new parameter.  Can this please be reviewed as part of the V15.3 upgrade process.



  • 7.  Re: GEL Script log not displayed 15.3

    Posted 11-10-2017 02:33 AM

    Hi Ronald,

     

    Very valid concern and thanks for letting me know. Rest be assured we don't delete the data and its moved to back up table BPM_ERRORS_BKP. As you are a SAAS customer, please raise a case and request the team to implement the solution. I have documented internally in a defect DE37432

     

    Run the following query to get back the last 90 days of data into the BPM_ERRORS table.
    INSERT INTO BPM_ERRORS
    SELECT * FROM BPM_ERRORS_BKP WHERE LAST_UPDATED_DATE >= (SELECT (MAX(LAST_UPDATED_DATE)-91) CUTOFF_DATE FROM BPM_ERRORS_BKP)
    AND NOT EXISTS (SELECT 1 FROM BPM_ERRORS WHERE BPM_ERRORS_BKP.ID = BPM_ERRORS.ID);

     

    On the setting in CSA, you can access make the change by going to http://CPPMXXXX/niku/nu#action:security.logs and then Edit configuration and you will see under 

     

     

    Regards

    Suman Pramanik 

     



  • 8.  Re: GEL Script log not displayed 15.3

    Posted 11-12-2017 08:12 PM

    Many thanks Suman, I was able to reset this parameter, and in my case, it didn't need the Services to be restarted.

    The two clients I have who are upgrading to V15.3 at this time, don't need the bpm_errors data, but glad to see it is backed up as I do have an additional client who still needs to schedule to move to V15.3.



  • 9.  Re: GEL Script log not displayed 15.3

    Posted 11-13-2017 02:33 AM

    Roland, You are welcome and I am sorry I got your name incorrect in my earlier post.

     

    Regards

    Suman Pramanik