Messages

1

MP Server / Re: Delete AG with no data, when OD thinks it has data

« on: October 13, 2010, 07:54:21 AM »

pankaj.puranik

Deleting rows from Db2 would be the last thing you should do

It's no problem to delete anything until you know what you are doing. (:

Justin

If or rather when I get enough time for this type of data mining I will definitely do this, as for this moment I already found 3 such Application Groups. They all were imported from another system, so hopefully problem is inherited from there, but I want to be shure.

As to deletion, it is actually a problem too. When I confirm I get this message: "Server failed while accessing application Group Data. Contact your system administrator."
Thus I feel I need to get to the root cause and manually clean out the mess.

2

MP Server / Delete AG with no data, when OD thinks it has data

« on: October 13, 2010, 02:23:55 AM »

Hi,

I found out an interesting problem when tried to delete one of old Application Groups, which was migrated to our system from another several years ago.

Problem is following.
1. When trying to delete AG from admin client, in deletion confirmation msgbox it shows that AG still has documents in it.
2. When comparing lists of loaded files load_id's to unloaded, it shows that all loaded files were unloaded.
3. Looking at AG table (the one named by AGID_NAME) I see that table exists and it is empty.
4. ARSSEG table shows that for table above number of inserted rows is greater than number of deleted rows. Difference matches number in point 1.

My question is if anybody already encountered same problem and if there are recommendations on how to get it solved.
I'm thinking of trying to update DEL_ROWS value in ARSSEG so it matches INS_ROWS value, then delete AG table, then try to delete AG from admin client again.
But before trying it I'd like to check if somebody already got and solved same issue.

OD version 8.4.1.2, DB2 v9.5.400.xxx

Thanks in advance!

3

MP Server / Re: statistics report

« on: June 07, 2010, 03:24:42 AM »

Hi,

I tried to submit form with my email address at http://www.raptor4.com, but got this error: "You don't have permission to access /contact.cgi on this server."

Is site still supported and tool available?
Few years ago I've done for our company "home-made" statistics based on System Log for docs retrievals, user activity, cache-tsm timings, etc. (coded logic to work with SL dump), and really interested in this type of product.

4

MP Server / Re: loadid row count

« on: June 07, 2010, 12:14:44 AM »

Hi,

Another alternative for Justin's suggestion, if you don't want to search for the right table, is to use "arsdoc query" or "arsdoc get" with [-i "WHERE DOC_NAME LIKE 'xxxFAA'"]. Then you'll get either txt list of respective DB rows which you can count, or the report file itself, where you can count number of reports.

The way you do it depends on the means you have and personal preferences.

5

MP Server / Re: Can't view historical reports

« on: May 27, 2010, 12:32:23 AM »

To view old reports you also need to restore those reports to test machine (from the message you got I assume you use "cache only").
Think that if you create OD cache directories on the drives with same letters as in production machine, you can simply copy their contents from production to test machine with reliable bulk copy tool.