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