Indexing Solr index-lucene-init -- Error table view does not exists

[Faiyaz Ahmed]

Dear All,

I have installed the Dspace 5.4 and put too much data but....

When I run below command, I'm getting follow error:

Command:

/usr/local/dspace/bin/dspace index-lucene-init

Error: 

2016-02-22 21:01:21,159 INFO  org.dspace.core.ConfigurationManager @ Loading from classloader: file:/usr/local/dspace/config/dspace.cfg

2016-02-22 21:01:21,173 INFO  org.dspace.core.ConfigurationManager @ Using dspace provided log configuration (log.init.config)

2016-02-22 21:01:21,173 INFO  org.dspace.core.ConfigurationManager @ Loading: /usr/local/dspace/config/log4j.properties

2016-02-22 21:01:25,199 INFO  org.dspace.storage.rdbms.DatabaseManager @ DBMS is 'Oracle'

2016-02-22 21:01:25,200 INFO  org.dspace.storage.rdbms.DatabaseManager @ DBMS driver version is 'Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production'

2016-02-22 21:01:25,243 INFO  org.dspace.storage.rdbms.DatabaseUtils @ Loading Flyway DB migrations from: filesystem:/usr/local/dspace/etc/oracle, classpath:org.dspace.storage.rdbms.sqlmigration.oracle, classpath:org.dspace.storage.rdbms.migration

2016-02-22 21:01:25,329 INFO  org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: jdbc:oracle:thin:@//libdb:1521/xe (Oracle 11.2)

2016-02-22 21:01:25,414 INFO  org.dspace.storage.rdbms.DatabaseUtils @ DSpace database schema is up to date

2016-02-22 21:01:25,434 ERROR org.dspace.storage.rdbms.DatabaseManager @ SQL query exec Error -

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)

Does any one have idea which table or view is missing?

Regards,

Faiyaz Ahmed

[helix84]

The stacktrace you posted is cut off. Include all lines up to and including any "Caused by:" lines.

Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

--
You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech...@googlegroups.com.
To post to this group, send email to dspac...@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

[Faiyaz Ahmed]

Thank you for the reply and I have now attached the complete logs after executing above command:

G:\Faiyaz-Data\SBP-Dspace\Backup-22-Feb-2016

[Faiyaz Ahmed]

I have also enabled the debug mode and found below query : 

sspath:org.dspace.storage.rdbms.sqlmigration.oracle, classpath:org.dspace.storage.rdbms.migration

2016-02-22 21:30:16,423 INFO  org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: jdbc:oracle:thin:@//libdb:1521/xe (Oracle 11.2)

2016-02-22 21:30:16,656 INFO  org.dspace.storage.rdbms.DatabaseUtils @ DSpace database schema is up to date

2016-02-22 21:30:16,682 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "SELECT * FROM bi_1 WHERE ROWNUM=1"  with parameters:

2016-02-22 21:30:16,682 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "SELECT * FROM bi_1 WHERE ROWNUM=1"  with parameters:

2016-02-22 21:30:16,717 ERROR org.dspace.storage.rdbms.DatabaseManager @ SQL query exec Error -

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStat

[Tim Donohue]

Hello Faiyaz,

Just a quick note. If you are trying to reindex DSpace in *Solr*, then you are running the wrong command.

Assuming you mean to be using Discovery / Solr:
https://wiki.duraspace.org/display/DSDOC5x/Discovery

Then the correct reindex command is:
[dspace]/bin/dspace index-discovery -b

The old "index-lucene-init" command is ONLY used if you are using the legacy, deprecated Lucene Search & DBMS Browse systems. If you are not using those systems (which it sounds like you are not), then the command will likely throw errors.

- Tim

--
You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech...@googlegroups.com.
To post to this group, send email to dspac...@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

-- 
Tim Donohue
Technical Lead for DSpace & DSpaceDirect
DuraSpace.org | DSpace.org | DSpaceDirect.org

[Faiyaz Ahmed]

Thanks Tim for Reply.. However, I have done the same but the data is not showing, however at advance search it is showing but when I click on view item then only blank page appears.

Regards,

Faiyaz Ahmed

Faiyaz Ahmed

--
You received this message because you are subscribed to a topic in the Google Groups "DSpace Technical Support" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/dspace-tech/yhmMsFJ-KhU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to dspace-tech...@googlegroups.com.

[helix84]

The "bi_1", "bi_2" etc tables missing are meant to be used with legacy
DB-based browse. They don't exist because DSpace 5 doesn't create them
anymore.

> 2016-02-22 21:01:28,816 INFO org.dspace.search.DSIndexer @ Writing Community: 123456789/99 to Index

From these log lines, I see that index-init (Lucene-based search)
completed successfully. The question is whether you changed your
configuration to use the legacy Lucene search and DB-based browse or
you did no changes and are using the Discovery (Solr) based
search&browse.

If you click on any Browse index (by author, by title, by issue date),
do you see any items?
Which URL did you use for search?

If you make a search query from the /discovery URL, do you see results?

To debug the problem with an item page not showing any content, watch
the log file:
tail -f [dspace]/log/dspace.log.2016-xx-xx

and then load any item page. Do you see any message added to the log?

[Faiyaz Ahmed]

Thanks Helix for reply ...

I updated my answer below after your questions..

If you make a search query from the /discovery URL, do you see results?  

Can you please let me know how to do that ...

If you click on any Browse index (by author, by title, by issue date),
do you see any items?

I can see author name but no data I can see ...

Which URL did you use for search?

I clicked on advance search and it is showing data : 

To debug the problem with an item page not showing any content, watch
the log file:
tail -f [dspace]/log/dspace.log.2016-xx-xx
and then load any item page. Do you see any message added to the log?

Only info logs printed : 

2016-02-23 21:28:35,714 INFO  org.dspace.usage.LoggerUsageEventListener @ anonymous:session_id=XXXXXXXXXXXXXXXXXXXX:ip_addr=192.168.163.1:view_item:handle=123456789/117

Regards,

Faiyaz Ahmed