Sor statistics were working in the past, then at some stage it just stopped. We think this happened after data entries were made by a person using a chinese keyboard. After some problems there were attempts to delete those items using that keyboard - we don't know for sure. It doesn't matter we need, I think to correct the problem of items with missing handles by deleting all reference to that item in the database. There are other posts on this forum suggesting the cause is missing handles.
http://dspace.2283337.n4.nabble.com/Problem-attempting-to-migrate-from-DSpace-1-8-directly-to-4-1-td4673622.html http://dspace.2283337.n4.nabble.com/problems-with-OAI-td4671531.html that problem is not just missing handles but also dangling pointers from one table to another. We have items with missing handles and you can't delete them because entries in some tables are missing and standard DSpace delete doesn't work. On Mon, 2014-10-13 at 09:12 +0300, Edward Safari wrote: > did it uses to display the solr statistics before or wat happened? > > > > On Mon, Oct 13, 2014 at 4:34 AM, Keir Vaughan-Taylor > <[email protected]> wrote: > I believe the error is related to items in the repository that > have some items have been corrupted and don't have a handle. > Some items have entries in some tables and not in others. > > The GUI either fails to delete these items so I need to erase > all entries related to a specific item_id using SQL. > > The SQL code below should erase everything in the database > related to an item code. > I am not sure what to do about the physical files . > Is it best to leave them in place or should they be removed? > What happens about the sequence id in the bitstream table - is > it a problem to just leave a hole? > > I would appreciate it if anyone can see a problem with the > code and make any comments or suggestions > > > -------------------------------------------------------------------------------- > > > > # Clean DSpace based on itemId > # Give IRMA id returns handle for that publication > # Run as id dspace > > [ $# -eq 0 ] && { echo "Usage: $0 <item_id>"; exit 1; } > > itemId=$1 > echo "Erasing all records referencing item: $itemId" > echo -n "Do you wish to continue y/n " > read ans > if [ "$ans" != "y" ] > then > exit 1 > fi > > # Delete bundles associated with item_id > # Delete bitstreams associated with item_id > > # Get list of bundle ids associated with item > bundleList=$(psql -A -t -c "select bundle_id from item2bundle > where item_id='$itemId';") > > # For each bundle id delete the bitstream and delete the > bundle to bitstream entry > for bundle in $bundleList > do > btStmIdList=$(psql -A -t -c "select bitstream_id from > bundle2bitstream where bundle_id=(select bundle_id from > item2bundle where item_id='$itemId');") > for bstrmId in $btStmIdList > do > # Do something with files > filenames=$( psql -A -t -c "select name,internal_id > from bitstream where bitstream_id =$bstrmId;") > for fn in filenames > do > # do something with files maybe > done > psql -A -t -c "select * from bitstream where > bitstream_id =$bstrmId;" > > done > psql -A -t -c "select * from bundle2bitstream where > bundle_id='$bundle';" > psql -A -t -c "select * from bundle where > bundle_id='$bundle';" > psql -A -t -c "select * from bundle2bitstream where > bundle_id='$bundle';" > psql -A -t -c "select * from bundle where > bundle_id='$bundle';" > done > > > for tableName in collection2item metadatavalue item > item2bundle community2item collection2item workflowitem > do > psql -A -t -c "delete from $tableName where > item_id='$itemId';" > done > > > > On Fri, 2014-10-10 at 11:42 +1100, Keir Vaughan-Taylor wrote: > > I have two Dspace 4.0 instances installed both using Solr > Statistics and > > all appears to be working. > > In both cases the generic statistics appears okay. > > > > The academics love it when they see how many accesses there have > been by > > going to the item in the repository and clicking on the nearby > > statistics button. > > > > An upgrade from 1.8.2 to 4.0 recently took place on one of the > machines. > > With the 1.8.2 version all the statistics features were working. Now > > however, on the upgraded machine although the overall statistics > still > > appear, the button associated with a publication item no longer > renders > > statistics information. > > The statistic page appears okay but there is no data presented. > > > > The other separate instance of DSpace 4.0 for a different database > does > > work. So i know its not a Dspace 4.0 bug. > > I cannot find what is different about the two. > > DSpace.cfg are the same, solr.cfg is the same. > > The logs don't reveal anything I can identify as a problem. > > The running of nightly Discovery indexing is the same. > > > > Please can anyone suggest a list of places I should be looking at > to get > > this going. > > > > > > > > -- > Keir Vaughan-Taylor > ERA DSpace Administrator > Rm:123 Fisher Library University of Sydney > [email protected] > ph:+61 2 9351 7408 > mb:+61 434 606 885 > > > ------------------------------------------------------------------------------ > Meet PCI DSS 3.0 Compliance Requirements with EventLog > Analyzer > Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI > DSS Reports > Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White > paper > Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog > Analyzer > http://p.sf.net/sfu/Zoho > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List > +Etiquette > > -- Keir Vaughan-Taylor ERA DSpace Administrator Rm:123 Fisher Library University of Sydney [email protected] ph:+61 2 9351 7408 mb:+61 434 606 885 ------------------------------------------------------------------------------ Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://p.sf.net/sfu/Zoho _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
