EPrints Technical Mailing List Archive

Message: #00915

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Re: Configuration may be wrong

Hi Seb,

The problem is with the Oracle layer.

Immediately preceding the error message is the following SQL:

Database execute debug: SELECT DISTINCT D0,D1 FROM (SELECT "DISTINCTBY_188303376"."DIVISIONS" D0,"DISTINCTBY_188303376"."EPRINTID" D1 FROM "EPRINT", "EPRINT_DIVISIONS" "DISTINCTBY_188303376", "EPRINT_DIVISIONS" "EPRINT_DIVISIONS" WHERE "EPRINT"."EPRINTID"="DISTINCTBY_188303376"."EPRINTID" AND "EPRINT"."EPRINTID"="EPRINT_DIVISIONS"."EPRINTID" AND "EPRINT"."METADATA_VISIBILITY" = 'show' AND "EPRINT"."EPRINT_STATUS" = 'archive' AND ( "EPRINT_DIVISIONS"."DIVISIONS" != '')) D
Warning! No values were found for eprint.view.divisions [divisions] - configuration may be wrong

This SQL will *never* return results. This is because Oracle treats the
empty string '' as equivalent to NULL, so the statement
"EPRINT_DIVISIONS.DIVISIONS != ''" breaks it. If you try running either
of the following statements against the database,

SELECT * FROM EPRINT_DIVISIONS WHERE divisions = NULL;
SELECT * FROM EPRINT_DIVISIONS WHERE divisions = '';

or

SELECT * FROM EPRINT_DIVISIONS WHERE divisions != NULL;
SELECT * FROM EPRINT_DIVISIONS WHERE divisions != '';

An empty result set will be returned. This is very bizarre, I know, but
the layer needs to use 'IS NULL' or 'IS NOT NULL' in those scenarios.

To whom do I need to speak about fixing this?

Best wishes,
Rob


Robert Berry <robert.berry@liverpool.ac.uk> writes:

> Hi Seb,
>
> Sorry, never mind that last e-mail. The data isn't wrong - everything
> looks right. Still unsure why the script won't generate the divisions
> view, however, as I definitely have prints with those divisions set. I
> will do some more digging - thanks for your advice.
>
> Best wishes, Rob
>
> Robert Berry <robert.berry@liverpool.ac.uk> writes:
>
>> Hi Seb,
>>
>> I tried reindexing and it gave no errors. It's still not working, though.
>>
>> I looked at the SQL that was being used in the generate_views script,
>> and it is using SUBJECT__ORDER_VALUES_EN as part of its look up for the
>> subjects / divisions. The data in here is wrong though - it relates to
>> the old set of subjects. Is there a way to repopulate this table? Do you
>> know why it might not have been populated?
>>
>> Best wishes,
>> Rob
>>
>> Sebastien Francois <sf2@ecs.soton.ac.uk> writes:
>>
>>> Hi Rob,
>>>
>>> I think this means you've asked EPrints to generate a 'view' on 
>>> 'subjects', however no EPrint objects / publications have got a subject 
>>> set. In other words, your 'view' will be empty.
>>>
>>> I can't comment much about the Oracle error except that when you 
>>> imported your subjects file, EPrints must have requested to re-index the 
>>> "subjects" dataset and this is probably what this error relates to (but 
>>> I cannot tell you any implications this will have...). You may try to:
>>>
>>> /opt/eprints3/bin/epadmin reindex <archive_id> subject
>>>
>>> and see what happens.
>>>
>>> Seb.
>>>
>>> On 27/07/12 16:57, Robert Berry wrote:
>>>> Hello,
>>>>
>>>> What does it mean when I run the bin/generate_views script, and it gives
>>>> an error like --
>>>>
>>>> Wrote: /eprints/eprints3/archives/liverpool/html/en/view/year
>>>> Warning! No values were found for eprint.view.subjects [subjects] -
>>>> configuration may be wrong
>>>>
>>>> What configuration? Where?
>>>>
>>>> I've imported a new subjects file. It gave a bunch of Oracle errors-
>>>>
>>>> ORA-01722: invalid number (DBD ERROR: error possibly near<*>  indicator
>>>> at char 52 in 'INSERT INTO "EVENT_QUEUE" ("EVENTQUEUEID") VALUES
>>>> (:<*>p1)') at /eprints/eprints3/bin/../perl_lib/EPrints/DataObj.pm line
>>>> 294
>>>>
>>>> -so I guess it could be related to that. The subjects are in the
>>>>   database, table, however, and look correct.
>>>>
>>>> Best wishes, Rob
>>>> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>> *** Archive: http://www.eprints.org/tech.php/
>>>> *** EPrints community wiki: http://wiki.eprints.org/
>>>
>>> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>> *** Archive: http://www.eprints.org/tech.php/
>>> *** EPrints community wiki: http://wiki.eprints.org/
>> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>> *** Archive: http://www.eprints.org/tech.php/
>> *** EPrints community wiki: http://wiki.eprints.org/
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: http://www.eprints.org/tech.php/
> *** EPrints community wiki: http://wiki.eprints.org/