Highlighted
Absent Member.. Absent Member..
Absent Member..
165 views

Trend report hanging in 'Publishing' state

Jump to solution

I've been using the Trend Report for a project, we are load testing every-other week when a new code base gets deployed and the trending report has been great for this purpose.

 

However, I have 2 runs that are stuck in the 'publishing' state.  One for almost 6 weeks now, and another from 3 days ago.

 

I've been trying to search on:

http://support.openview.hp.com/selfsolve/documents


But I keep getting random 'access denied' errors.  This is a separate issue, please answer to the Trend Report issue if you have comments / questions.

 

I've deleted the run and attempted to re-publish but that doesn't work, either.

 

Any ideas? Thanks!

0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.
Absent Member.

Re: Trend report hanging in 'Publishing' state

Jump to solution

Check if you can delete the data processing tasks from the database and see if you can publish the results for the run that is stuck in publishing.

 

Regards,

Mario M

HP LR/PC Support

If you are customer you can try posting on our internal forums for more personalized support.

LoadRunner:
http://h30499.www3.hp.com/t5/LoadRunner-Support-Customer/bd-p/loadrunner-support-customer-forum

Performance Center:
http://h30499.www3.hp.com/t5/Performance-Center-Support/bd-p/performance-center-support-customer

How to:
http://www.youtube.com/watch?v=4ChlysWupWM

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.

View solution in original post

0 Likes
7 Replies
Highlighted
Absent Member.
Absent Member.

Re: Trend report hanging in 'Publishing' state

Jump to solution

So you have other trend reports that have published before? How many data procesors are you working with? Are all data processors on the same patch level?

 

Regards,

Mario M.

HP LR/PC Support

If you are customer you can try posting on our internal forums for more personalized support.

LoadRunner:
http://h30499.www3.hp.com/t5/LoadRunner-Support-Customer/bd-p/loadrunner-support-customer-forum

Performance Center:
http://h30499.www3.hp.com/t5/Performance-Center-Support/bd-p/performance-center-support-customer

How to:
http://www.youtube.com/watch?v=4ChlysWupWM

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Trend report hanging in 'Publishing' state

Jump to solution

Our PC install has 10 machines, all are all things :Load Generator, Controller and Data Processor.

 

I've got 5 different trending reports each with 2 or more runs in them.  2 of them have 7 runs.  1 of these is my problematic one.  It has got 5 trended runs and 2 'publishing'.  I add a run to this trend report about every other week.

 

All are on the same patch level of

HP LoadRunner Software 11.51 Version 11.51.0.0

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Trend report hanging in 'Publishing' state

Jump to solution

Check if you can delete the data processing tasks from the database and see if you can publish the results for the run that is stuck in publishing.

 

Regards,

Mario M

HP LR/PC Support

If you are customer you can try posting on our internal forums for more personalized support.

LoadRunner:
http://h30499.www3.hp.com/t5/LoadRunner-Support-Customer/bd-p/loadrunner-support-customer-forum

Performance Center:
http://h30499.www3.hp.com/t5/Performance-Center-Support/bd-p/performance-center-support-customer

How to:
http://www.youtube.com/watch?v=4ChlysWupWM

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.

View solution in original post

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Trend report hanging in 'Publishing' state

Jump to solution

Sounds like a decent solution, but I don't have admin access to the DB, plus even if I did, I am not sure where to look.  Any additional instructions I could get? (Table name for starters..)

 

I have the admin's ear, if I could get some basic instructions as to what I am looking for, I can probably get this done.

Thanks.

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Trend report hanging in 'Publishing' state

Jump to solution

Let me find out, I will update you soon.

 

Regards,

Mario M.

HP LR/PC Support

If you are customer you can try posting on our internal forums for more personalized support.

LoadRunner:
http://h30499.www3.hp.com/t5/LoadRunner-Support-Customer/bd-p/loadrunner-support-customer-forum

Performance Center:
http://h30499.www3.hp.com/t5/Performance-Center-Support/bd-p/performance-center-support-customer

How to:
http://www.youtube.com/watch?v=4ChlysWupWM

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Trend report hanging in 'Publishing' state

Jump to solution

There could be a DP_TASKS table under lab DB. Clearing this table could allow the DP to be used again.

 

Regards,

Mario M.

HP LR/PC Support

If you are customer you can try posting on our internal forums for more personalized support.

LoadRunner:
http://h30499.www3.hp.com/t5/LoadRunner-Support-Customer/bd-p/loadrunner-support-customer-forum

Performance Center:
http://h30499.www3.hp.com/t5/Performance-Center-Support/bd-p/performance-center-support-customer

How to:
http://www.youtube.com/watch?v=4ChlysWupWM

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Trend report hanging in 'Publishing' state

Jump to solution

In the project, there is a table:

PC_TREND_RUNS

 

it uses this:

SELECT * FROM PC_TREND_RUNS

I see 2 runs that are not 100% complete

Not sure what to do from here.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.