Clarity

Approved Timesheets Won't Post | Learn with Rego

Recommend

Nov 30, 2016 03:41 AM

navzjoshi00

Dear Community Members,

Today's Q&A looks at some helpful topics like how to set User IDs in JasperServer, shrink the PRJ_EV_HISTORY table, and troubleshoot Timesheets that won't post.

It's also worth mentioning that there are just a few days left to sign up for our How to Scale Agile webinar. Join Rego and ICON on December 6th @ 12:00PM EST. This webinar includes the story of a major retailer who successfully made the transition. If you're into Agile, you won't want to miss it.

And now for our weekly Q&A.

Q&A Summary

1. How do you set User IDs in JasperServer?

2. What's the best way to XOG out ALL Custom object instances of a custom object?

3. URGENT: Timesheets won't post.

4. How do we reduce the size of the PRJ_EV_HISTORY table? Shrink or Delete?

5. Is there a way to change the Process Instance Limit?

Please feel free to comment on any alternative answers you've found.

We love your input (always).

1.

Why is the User ID in JasperServer different than the unique name in Clarity? Our On Demand Environment is using the email address. Is there a table in DWH or CA PPM where it stores the mapping? The reporting works fine, but I have an issue with a security clause going against the TRN DB. The User ID I get in JasperReports is the JasperServer ID.

Answer

The cmn_sec_users table has a new field called user_uid. That is the one within jasperserver.

2.

How can I XOG out ALL Custom object instances of a custom object? The OOB read xml is below; I tried removing the instanceCode filter, but that didn’t work.

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
  <Header version="8.0" action="read" objectType="customObjectInstance" externalSource="NIKU"/>
  <CustomObjectInstanceQuery>
    <Filter name="objectCode" criteria="EQUALS">manufacturer</Filter>
    <Filter name="instanceCode" criteria="OR">sony,nikon</Filter>
  </CustomObjectInstanceQuery>
</NikuDataBus>

Answer

The wildcard is %, or an *.

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
  <Header version="8.0" action="read" objectType="customObjectInstance" externalSource="NIKU"/>
  <CustomObjectInstanceQuery>
    <Filter name="objectCode" criteria="EQUALS">manufacturer</Filter>
    <Filter name="instanceCode" criteria="OR">%</Filter>
  </CustomObjectInstanceQuery>
</NikuDataBus>

3.

We have several Timesheets in Approved status that won’t post. The time period is open. What's happening?

Answer

Check to make sure Other Work has a Start and Finish Date. You can find the issue discussed within the community here: https://communities.ca.com/message/97936808 and https://communities.ca.com/message/20259442.

4.

When we deleted a bunch of rows from PRJ_EV_HISTORY (which was multiple gigs), we didn't see a corresponding reduction in table space size. Is there a “truncate” or anything else we need to run, to free up the space?

Answer 1

The PRJ_EV_HISTORY is the main Earned Value history. It’s populated by the Update Earned Value job. It stores a huge amount of data at the project and task level. It will likely grow to the same size over time, but it’s a good idea to periodically shrink/rebuild tables and indexes. Most clients have some sort of maintenance packages that are run periodically to do these kinds of activities on their database.

Answer 2

https://msdn.microsoft.com/en-us/library/ms190488(v=sql.90).aspx

Deleting won’t reduce size. You have to shrink. This will probably fragment the index, and you may want to rebuild it.

Answer 3

Do a Google search for DBCCShrinkDB and DBCCShrinkFile. The commands are also available in the MSSQL Management Studio. Right click the DB view properties, then storage. That's where you should be able to remove it from the GUI.

5.

Is there a setting to limit the number of process instances in Clarity? Whenever the process instance count is near 499, the process goes on Hold, and there's an error message on the process definition. This is an auto-start process, and we don't want to change the trigger condition. I can run the delete process instances job more frequently, but I'm curious about where this setting is stored and whether it's global.

Answer

There is a setting in the NSA that can be adjusted. You can increase the limit or remove the limit entirely. For On Demand, you'll have to submit a ticket. See the image below and read the community discussion here: https://communities.ca.com/message/117544811