Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 5 replies
  • Subscribers 3 subscribers
  • Views 852 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

ASG 7.306: No longer generating executive reports etc.

James Bourne
I've had this problem several times during the upgrade process to 7.306. The symptoms are:

HTTP Proxy reporting reports: undefined
Dashboard stats never update

Can anyone advise me how to fix this? It's my home installation so it's not under support. I presume I need to rebuild or populate certain tables in PGSQL?

TIA,

j.


This thread was automatically locked due to age.
Parents Reply Children
  • 0 in reply to BarryG
    If you're not afraid of dropping and re-creating manually, the thread linked to by Barry is the way to go. Since this is a home installation you could also just try to run the up2dates to 7.401; there's a database conversion in 7.400 during which broken tables will be automatically dropped and re-created. This should get things into a working state again.
    Cheers,
     andreas
  • 0 in reply to andreas
    I tried following the instructions in the referred post today. This is what I got:

    fw1:/opt/tmpfs # psql -U reporting reporting
    psql: FATAL:  "pg_tblspc/16519/16520" is not a valid data directory
    DETAIL:  File "pg_tblspc/16519/16520/PG_VERSION" is missing.

    How can I fix / workaround that?