Replies to This Forum

Permalink Reply by Balakrishnan Sivakumaran on April 9, 2015 at 22:09

Skip to content
Using Gmail with screen readers

Click here to enable desktop notifications for Gmail.   Learn more  Hide

Move to Inbox

 

More

 

2 of 908

 

Help in Dspace

Respected sir,

First of all I would like to thank you for guiding me then and there for our DSpace data migration queries. As I am new to the migration, few things are little difficult for me to go with. I have the following set up at my end.

Old System:

OS: Windows xp
Dspace Version: 1.8.2


New System:

OS: Windows 7
Dspace Version: 4.2

Steps followed for migration till now:

1. Installed newer version of DSpace on the windows machine
2. Took backup of the postgres dspace database on the old machine by right clicking on the DB and using the backup tool
    (which seems to backup only the structure of DSpace DB)
3. Deleted the default DB which gets created at the time of installation in new machine and restored the old DB backup, used the properties also from old DB.
4. Copied complete DSpace folder from old machine to the new machine but copying of the entire DSpace folder makes the DSpace application to break down, it doesn't come up.
5. So copied assert store & upload folders alone in the new system's DSpace folder
6. DSpace comes up in the browser with http://localhost:8080/jspui. Though it brings up all the links, the uploaded files are not coming up. It says file not found.
7. While checking the DSpace log file, it complained about missing GeoCity file, which I copied from old system to new system. Though the error message disappeared, it dint help me in resolving the problem.
8. I am unable to log into DSpace with my credentials as well. Log file shows authentication error.

It would be helpful if you could shed your views on how to proceed further on this. I am not very sure if I am close to the solution. I have been working on this for some time now. I would be really thankful to you if you could guide me on this.

Thanks a lot for all your support.

Note:
Exerts from the Log:

2015-03-17 11:02:27,883 ERROR org.dspace.app.util.AbstractDSpaceWebapp @ Failed to record startup in Webapp table.
org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
  Position: 22
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1754)
        at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:671)
        at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:447)
        at org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebapp.java:80)
        at org.dspace.app.util.DSpaceContextListener.contextInitialized(DSpaceContextListener.java:128)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1114)
        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1673)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
2015-03-17 11:02:37,462 ERROR org.dspace.app.util.AbstractDSpaceWebapp @ Failed to record startup in Webapp table.
org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
  Position: 22
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1754)
        at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:671)
        at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:447)
        at org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebapp.java:80)
        at org.dspace.app.util.DSpaceContextListener.contextInitialized(DSpaceContextListener.java:128)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1114)
        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1673)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
2015-03-17 11:02:37,680 ERROR org.dspace.core.Context @ An I/O error occured while sending to the backend.
org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:685)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:738)
        at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
        at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
        at org.dspace.core.Context.abort(Context.java:474)
        at org.dspace.core.Context.finalize(Context.java:655)
        at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
        at java.lang.ref.Finalizer.runFinalizer(Unknown Source)
        at java.lang.ref.Finalizer.access$100(Unknown Source)
        at java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source)
Caused by: java.net.SocketException: Socket closed
        at java.net.SocketOutputStream.socketWrite(Unknown Source)
        at java.net.SocketOutputStream.write(Unknown Source)
        at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
        at java.io.BufferedOutputStream.flush(Unknown Source)
        at org.postgresql.core.PGStream.flush(PGStream.java:523)
        at org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1143)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:256)
        ... 11 more
2015-03-17 11:02:38,320 INFO  org.dspace.app.xmlui.configuration.XMLUIConfiguration @ Loading XMLUI configuration from: C:/Dspace\config\xmlui.xconf
2015-03-17 11:02:38,382 INFO  org.dspace.app.xmlui.configuration.XMLUIConfiguration @ Aspect Installed: name='Displaying Artifacts', path='resource://aspects/ViewArtifacts/'.
2015-03-17 11:02:38,382 INFO  org.dspace.app.xmlui.configuration.XMLUIConfiguration @ Aspect Installed: name='Browsing Artifacts', path='resource://aspects/BrowseArtifacts/'.
2015-03-17 11:02:38,382 INFO  org.dspace.app.xmlui.configuration.XMLUIConfiguration @ Aspect Installed: name='Discovery', path='resource://aspects/Discovery/'.
2015-03-17 11:02:38,382 INFO  org.dspace.app.xmlui.configuration.XMLUIConfiguration @ Aspect Installed: name='Administration', path='resource://aspects/Administrative/'.
2015-03-17 11:02:38,382 INFO  org.dspace.app.xmlui.configuration.XMLUIConfiguration @ Aspect Installed: name='E-Person', path='resource://aspects/EPerson/'.
2015-03-17 11:02:38,382 INFO  org.dspace.app.xmlui.configuration.XMLUIConfiguration @ Aspect Installed: name='Submission and Workflow', path='resource://aspects/Submission/'.
2015-03-17 11:02:38,382 INFO  org.dspace.app.xmlui.configuration.XMLUIConfiguration @ Aspect Installed: name='Statistics', path='resource://aspects/Statistics/'.
2015-03-17 11:02:38,382 INFO  org.dspace.app.xmlui.configuration.XMLUIConfiguration @ Aspect Installed: name='Original Workflow', path='resource://aspects/Workflow/'.
2015-03-17 11:02:38,382 INFO  org.dspace.app.xmlui.configuration.XMLUIConfiguration @ Theme Installed: name='Atmire Mirage Theme', path='Mirage/', id='null', regex='.*', handle='null'.
2015-03-17 16:31:46,006 INFO  org.dspace.browse.BrowseEngine @ anonymous:session_id=87780E83CC5EE213FEB32513DAEC299F:ip_addr=0:0:0:0:0:0:0:1:browse_mini:
2015-03-17 16:31:46,341 INFO  org.dspace.app.webui.discovery.DiscoverUtility @ facets for scope, null: 3
2015-03-17 16:32:01,986 INFO  org.dspace.app.webui.servlet.HandleServlet @ anonymous:session_id=87780E83CC5EE213FEB32513DAEC299F:ip_addr=0:0:0:0:0:0:0:1:view_community:community_id=9
2015-03-17 16:32:02,031 INFO  org.dspace.browse.BrowseEngine @ anonymous:session_id=87780E83CC5EE213FEB32513DAEC299F:ip_addr=0:0:0:0:0:0:0:1:browse_mini:
2015-03-17 16:32:02,036 INFO  org.dspace.app.webui.discovery.DiscoverUtility @ facets for scope, org.dspace.content.Community@27e: 3

2015-03-17 16:32:02,091 INFO  org.dspace.statistics.SolrLogger @ useProxies=false
2015-03-17 16:51:08,736 INFO  org.dspace.browse.BrowseEngine @ anonymous:session_id=7BAE563FF80425875A52B4C2A34CDA74:ip_addr=0:0:0:0:0:0:0:1:browse_mini:
2015-03-17 16:51:08,756 INFO  org.dspace.app.webui.discovery.DiscoverUtility @ facets for scope, null: 3
2015-03-17 16:51:45,046 INFO  org.dspace.authenticate.PasswordAuthentication @ anonymous:session_id=7BAE563FF80425875A52B4C2A34CDA74:ip_addr=0:0:0:0:0:0:0:1:authenticate:attempting password auth of user=
2015-03-17 16:51:45,096 WARN  org.dspace.app.webui.servlet.InternalErrorServlet @ :session_id=7BAE563FF80425875A52B4C2A34CDA74:internal_error:-- URL Was: http://localhost:8080/jspui/password-login
-- Method: POST
-- Parameters were:
-- login_email: ""
-- login_submit: "Log In"
-- login_password: *not logged*

java.lang.IllegalArgumentException: No such column 'digest_algorithm'
        at org.dspace.storage.rdbms.TableRow.canonicalizeAndCheck(TableRow.java:585)
        at org.dspace.storage.rdbms.TableRow.getStringColumn(TableRow.java:249)
        at org.dspace.eperson.EPerson.checkPassword(EPerson.java:936)
        at org.dspace.authenticate.PasswordAuthentication.authenticate(PasswordAuthentication.java:226)
        at org.dspace.authenticate.AuthenticationManager.authenticateInternal(AuthenticationManager.java:162)
        at org.dspace.authenticate.AuthenticationManager.authenticate(AuthenticationManager.java:99)
        at org.dspace.app.webui.servlet.PasswordServlet.doDSPost(PasswordServlet.java:63)
        at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:115)
        at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:73)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

siva
	Dr.Sugumaran Pachaiyappan
	Duraiarasan Amuthan
	kalpana varatharaj
	Mr.M.Mothilal
	Saravanan S
	shanmugavel1978
	spurgeon anand samuel
	Venkatesh sundar
	Anitha naren
	ARUNKUMAR NAGALINGAM
	balakrishnan sivakumaran
	Dhakshinamurthy, A
	Dr. HARI MURALEEDHARAN
	Elumalai Murugan
	elumalai settu
	esak deen
	gopinathan narasimhan
	Kalaivani Thirumeni
	Krishnika A
	Manimohan Subbarayan
	Mr.K. Sivaswamy
	nekkalapudi srujanchowdary
	Panneer Selvam
	RAMASUBRAMANIAN GOPALAN
	Ramesh Iyer
	ravi bairam
	ravindar bairam
	REGIONAL OFFICE CHENNAI
	siva kumar
	Yatrik Patel
	வாழ்க.... வாழ்க வளமுடன்..
	a.kraman
	Aarthi  Invited
	abcplbgl
	adaikammai
	akjain
	Sify
	sivagaami
	Vinayaga Book House
	Yatrik Patel
Balakrishnan Sivakumaran /span>siva2578@gmail.com>	Apr 6 (4 days ago)
to Yatrik

• ▶ Reply

• ‹ Previous
• 1
• 2
• Next ›
• Page