subject:"\[dspace\-tech\] Indexing Solr index\-lucene\-init \-\- Error table view does not exists"

Re: [dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

2016-02-23 Thread 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=:ip_addr=192.168.163.1:view_item:handle=123456789/117*


Regards,



Faiyaz Ahmed

On Tue, Feb 23, 2016 at 10:49 PM, helix84  wrote:

> 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
>
> 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?
>
>
> 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+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

2016-02-23 Thread 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

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?


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+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

2016-02-22 Thread 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

On 2/22/2016 12:04 PM, Faiyaz Ahmed wrote:

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

--
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+unsubscr...@googlegroups.com 
.
To post to this group, send email to dspace-tech@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

--
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+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

2016-02-22 Thread 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

On Monday, February 22, 2016 at 11:17:55 PM UTC+5, Faiyaz Ahmed wrote:
>
> 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
>
> On Monday, February 22, 2016 at 11:10:43 PM UTC+5, helix84 wrote:
>>
>> 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
>>
>>
>> On Mon, Feb 22, 2016 at 7:04 PM, Faiyaz Ahmed  
>> wrote:
>>
>>> 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
>>>
>>> -- 
>>> 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

Re: [dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

2016-02-22 Thread 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

On Monday, February 22, 2016 at 11:10:43 PM UTC+5, helix84 wrote:
>
> 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
>
>
> On Mon, Feb 22, 2016 at 7:04 PM, Faiyaz Ahmed  > wrote:
>
>> 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
>>
>> -- 
>> 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.
>>
>
>

-- 
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+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.


dspace.log.2016-02-22
Description: Binary data

Re: [dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

2016-02-22 Thread 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


On Mon, Feb 22, 2016 at 7:04 PM, Faiyaz Ahmed 
wrote:

> 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
>
> --
> 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+unsubscr...@googlegroups.com.
> To post to this group, send email to dspace-tech@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

[dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

2016-02-22 Thread 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

-- 
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+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

Re: [dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

Re: [dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

Re: [dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

Re: [dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

Re: [dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

[dspace-tech] Indexing Solr index-lucene-init -- Error table view does not exists

7 matches

Site Navigation

Mail list logo

Footer information