Re: [dspace-tech] Index fail message after upgrading from Dspace 6.2 to 7.3
On Wed, Oct 12, 2022 at 12:58:05AM -0700, Lewatle Johannes Phaladi wrote: > Thanks Tim, the script completed without any error. Then it appears that we are missing a rule: CONSTRAINT has_subject CHECK (eperson_id IS NOT NULL OR epersongroup_id IS NOT NULL) > On Wednesday, 12 October 2022 at 08:26:46 UTC+2 Lewatle Johannes Phaladi > wrote: > > > > > Hello Tim, > > > > Thanks a lot I am trying it now. > > > > Regards, > > Lewatle > > On Tuesday, 11 October 2022 at 19:46:22 UTC+2 Tim Donohue wrote: > > > >> Hi Lewatle, > >> > >> Based on the error stack, it looks like the problem may be that you > >> somehow have a Resource Policy in your "resourcepolicy" database table > >> that > >> has both *no* "eperson_id" AND *no* "epersongroup_id". > >> > >> That shouldn't be possible, because every Resource Policy is supposed to > >> be related to either an EPerson or a Group. However, somehow you must > >> have > >> managed to create a resource policy that is not related to anything. > >> > >> You may need to find that resource policy and delete it. I *think* you > >> could use this query to locate it: > >> > >> SELECT * from resourcepolicy where eperson_id is null and epersongroup_id > >> is null; > >> > >> Then you likely could do a similar delete: > >> > >> DELETE FROM resourcepolicy where eperson_id is null and epersongroup_id > >> is null; > >> > >> *Make sure to test this out on a test/development copy of your database.* > >> I doubt it will have side effects, but you should always verify things > >> first before trying it in production. > >> > >> Tim > >> -- > >> *From:* dspac...@googlegroups.com on behalf > >> of Lewatle Johannes Phaladi > >> *Sent:* Tuesday, October 11, 2022 1:13 AM > >> *To:* DSpace Technical Support > >> *Subject:* [dspace-tech] Index fail message after upgrading from Dspace > >> 6.2 to 7.3 > >> > >> Dear DSpace Team, > >> > >> dspace@wiredspace:~/install/dspace7.3backend/bin$ ./dspace > >> index-discovery -b > >> > >> The script has started > >> > >> (Re)building index from scratch. > >> > >> java.lang.NullPointerException > >> > >> at > >> org.dspace.discovery.SolrServiceResourceRestrictionPlugin.additionalIndex(SolrServiceResourceRestrictionPlugin.java:95) > >> > >> at > >> org.dspace.discovery.indexobject.IndexFactoryImpl.buildDocument(IndexFactoryImpl.java:67) > >> > >> at > >> org.dspace.discovery.indexobject.InprogressSubmissionIndexFactoryImpl.buildDocument(InprogressSubmissionIndexFactoryImpl.java:46) > >> > >> at > >> org.dspace.discovery.indexobject.WorkspaceItemIndexFactoryImpl.buildDocument(WorkspaceItemIndexFactoryImpl.java:63) > >> > >> at > >> org.dspace.discovery.indexobject.WorkspaceItemIndexFactoryImpl.buildDocument(WorkspaceItemIndexFactoryImpl.java:30) > >> > >> at > >> org.dspace.discovery.SolrServiceImpl.update(SolrServiceImpl.java:165) > >> > >> at > >> org.dspace.discovery.SolrServiceImpl.indexContent(SolrServiceImpl.java:155) > >> > >> at > >> org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:340) > >> > >> at > >> org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:327) > >> > >> at > >> org.dspace.discovery.SolrServiceImpl.createIndex(SolrServiceImpl.java:295) > >> > >> at org.dspace.discovery.IndexClient.internalRun(IndexClient.java:72) > >> > >> at org.dspace.scripts.DSpaceRunnable.run(DSpaceRunnable.java:104) > >> > >> at > >> org.dspace.app.launcher.ScriptLauncher.executeScript(ScriptLauncher.java:149) > >> > >> at > >> org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:131) > >> > >> at > >> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) > >> > >> dspace@wiredspace:~/install/dspace7.3backend/bin$ > >> > >> Regards, > >> > >> Lewatle > >> > >> -- > >> All messages to this mailing list should adhere to the Code of Conduct: > >> https:/
Re: [dspace-tech] Index fail message after upgrading from Dspace 6.2 to 7.3
Thanks Tim, the script completed without any error. On Wednesday, 12 October 2022 at 08:26:46 UTC+2 Lewatle Johannes Phaladi wrote: > > Hello Tim, > > Thanks a lot I am trying it now. > > Regards, > Lewatle > On Tuesday, 11 October 2022 at 19:46:22 UTC+2 Tim Donohue wrote: > >> Hi Lewatle, >> >> Based on the error stack, it looks like the problem may be that you >> somehow have a Resource Policy in your "resourcepolicy" database table that >> has both *no* "eperson_id" AND *no* "epersongroup_id". >> >> That shouldn't be possible, because every Resource Policy is supposed to >> be related to either an EPerson or a Group. However, somehow you must have >> managed to create a resource policy that is not related to anything. >> >> You may need to find that resource policy and delete it. I *think* you >> could use this query to locate it: >> >> SELECT * from resourcepolicy where eperson_id is null and epersongroup_id >> is null; >> >> Then you likely could do a similar delete: >> >> DELETE FROM resourcepolicy where eperson_id is null and epersongroup_id >> is null; >> >> *Make sure to test this out on a test/development copy of your database.* >> I doubt it will have side effects, but you should always verify things >> first before trying it in production. >> >> Tim >> ---------- >> *From:* dspac...@googlegroups.com on behalf >> of Lewatle Johannes Phaladi >> *Sent:* Tuesday, October 11, 2022 1:13 AM >> *To:* DSpace Technical Support >> *Subject:* [dspace-tech] Index fail message after upgrading from Dspace >> 6.2 to 7.3 >> >> Dear DSpace Team, >> >> dspace@wiredspace:~/install/dspace7.3backend/bin$ ./dspace >> index-discovery -b >> >> The script has started >> >> (Re)building index from scratch. >> >> java.lang.NullPointerException >> >> at >> org.dspace.discovery.SolrServiceResourceRestrictionPlugin.additionalIndex(SolrServiceResourceRestrictionPlugin.java:95) >> >> at >> org.dspace.discovery.indexobject.IndexFactoryImpl.buildDocument(IndexFactoryImpl.java:67) >> >> at >> org.dspace.discovery.indexobject.InprogressSubmissionIndexFactoryImpl.buildDocument(InprogressSubmissionIndexFactoryImpl.java:46) >> >> at >> org.dspace.discovery.indexobject.WorkspaceItemIndexFactoryImpl.buildDocument(WorkspaceItemIndexFactoryImpl.java:63) >> >> at >> org.dspace.discovery.indexobject.WorkspaceItemIndexFactoryImpl.buildDocument(WorkspaceItemIndexFactoryImpl.java:30) >> >> at >> org.dspace.discovery.SolrServiceImpl.update(SolrServiceImpl.java:165) >> >> at >> org.dspace.discovery.SolrServiceImpl.indexContent(SolrServiceImpl.java:155) >> >> at >> org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:340) >> >> at >> org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:327) >> >> at >> org.dspace.discovery.SolrServiceImpl.createIndex(SolrServiceImpl.java:295) >> >> at org.dspace.discovery.IndexClient.internalRun(IndexClient.java:72) >> >> at org.dspace.scripts.DSpaceRunnable.run(DSpaceRunnable.java:104) >> >> at >> org.dspace.app.launcher.ScriptLauncher.executeScript(ScriptLauncher.java:149) >> >> at >> org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:131) >> >> at >> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) >> >> dspace@wiredspace:~/install/dspace7.3backend/bin$ >> >> Regards, >> >> Lewatle >> >> -- >> All messages to this mailing list should adhere to the Code of Conduct: >> https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx >> --- >> 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 view this discussion on the web visit >> https://groups.google.com/d/msgid/dspace-tech/e34f93ed-6923-4643-85e1-1d741c75eeffn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/dspace-tech/e34f93ed-6923-4643-85e1-1d741c75eeffn%40googlegroups.com?utm_medium=email_source=footer> >> . >> > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- 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 view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/5dc28b99-0037-459a-8b1c-b1a15c5f1477n%40googlegroups.com.
Re: [dspace-tech] Index fail message after upgrading from Dspace 6.2 to 7.3
Hello Tim, Thanks a lot I am trying it now. Regards, Lewatle On Tuesday, 11 October 2022 at 19:46:22 UTC+2 Tim Donohue wrote: > Hi Lewatle, > > Based on the error stack, it looks like the problem may be that you > somehow have a Resource Policy in your "resourcepolicy" database table that > has both *no* "eperson_id" AND *no* "epersongroup_id". > > That shouldn't be possible, because every Resource Policy is supposed to > be related to either an EPerson or a Group. However, somehow you must have > managed to create a resource policy that is not related to anything. > > You may need to find that resource policy and delete it. I *think* you > could use this query to locate it: > > SELECT * from resourcepolicy where eperson_id is null and epersongroup_id > is null; > > Then you likely could do a similar delete: > > DELETE FROM resourcepolicy where eperson_id is null and epersongroup_id > is null; > > *Make sure to test this out on a test/development copy of your database.* > I doubt it will have side effects, but you should always verify things > first before trying it in production. > > Tim > -- > *From:* dspac...@googlegroups.com on behalf > of Lewatle Johannes Phaladi > *Sent:* Tuesday, October 11, 2022 1:13 AM > *To:* DSpace Technical Support > *Subject:* [dspace-tech] Index fail message after upgrading from Dspace > 6.2 to 7.3 > > Dear DSpace Team, > > dspace@wiredspace:~/install/dspace7.3backend/bin$ ./dspace > index-discovery -b > > The script has started > > (Re)building index from scratch. > > java.lang.NullPointerException > > at > org.dspace.discovery.SolrServiceResourceRestrictionPlugin.additionalIndex(SolrServiceResourceRestrictionPlugin.java:95) > > at > org.dspace.discovery.indexobject.IndexFactoryImpl.buildDocument(IndexFactoryImpl.java:67) > > at > org.dspace.discovery.indexobject.InprogressSubmissionIndexFactoryImpl.buildDocument(InprogressSubmissionIndexFactoryImpl.java:46) > > at > org.dspace.discovery.indexobject.WorkspaceItemIndexFactoryImpl.buildDocument(WorkspaceItemIndexFactoryImpl.java:63) > > at > org.dspace.discovery.indexobject.WorkspaceItemIndexFactoryImpl.buildDocument(WorkspaceItemIndexFactoryImpl.java:30) > > at > org.dspace.discovery.SolrServiceImpl.update(SolrServiceImpl.java:165) > > at > org.dspace.discovery.SolrServiceImpl.indexContent(SolrServiceImpl.java:155) > > at > org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:340) > > at > org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:327) > > at > org.dspace.discovery.SolrServiceImpl.createIndex(SolrServiceImpl.java:295) > > at org.dspace.discovery.IndexClient.internalRun(IndexClient.java:72) > > at org.dspace.scripts.DSpaceRunnable.run(DSpaceRunnable.java:104) > > at > org.dspace.app.launcher.ScriptLauncher.executeScript(ScriptLauncher.java:149) > > at > org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:131) > > at > org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) > > dspace@wiredspace:~/install/dspace7.3backend/bin$ > > Regards, > > Lewatle > > -- > All messages to this mailing list should adhere to the Code of Conduct: > https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx > --- > 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 view this discussion on the web visit > https://groups.google.com/d/msgid/dspace-tech/e34f93ed-6923-4643-85e1-1d741c75eeffn%40googlegroups.com > > <https://groups.google.com/d/msgid/dspace-tech/e34f93ed-6923-4643-85e1-1d741c75eeffn%40googlegroups.com?utm_medium=email_source=footer> > . > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- 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 view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/720e377a-f067-4633-953f-8a32ee9b2cbfn%40googlegroups.com.
Re: [dspace-tech] Index fail message after upgrading from Dspace 6.2 to 7.3
Hi Lewatle, Based on the error stack, it looks like the problem may be that you somehow have a Resource Policy in your "resourcepolicy" database table that has both no "eperson_id" AND no "epersongroup_id". That shouldn't be possible, because every Resource Policy is supposed to be related to either an EPerson or a Group. However, somehow you must have managed to create a resource policy that is not related to anything. You may need to find that resource policy and delete it. I think you could use this query to locate it: SELECT * from resourcepolicy where eperson_id is null and epersongroup_id is null; Then you likely could do a similar delete: DELETE FROM resourcepolicy where eperson_id is null and epersongroup_id is null; Make sure to test this out on a test/development copy of your database. I doubt it will have side effects, but you should always verify things first before trying it in production. Tim From: dspace-tech@googlegroups.com on behalf of Lewatle Johannes Phaladi Sent: Tuesday, October 11, 2022 1:13 AM To: DSpace Technical Support Subject: [dspace-tech] Index fail message after upgrading from Dspace 6.2 to 7.3 Dear DSpace Team, dspace@wiredspace:~/install/dspace7.3backend/bin$<mailto:dspace@wiredspace:~/install/dspace7.3backend/bin$> ./dspace index-discovery -b The script has started (Re)building index from scratch. java.lang.NullPointerException at org.dspace.discovery.SolrServiceResourceRestrictionPlugin.additionalIndex(SolrServiceResourceRestrictionPlugin.java:95) at org.dspace.discovery.indexobject.IndexFactoryImpl.buildDocument(IndexFactoryImpl.java:67) at org.dspace.discovery.indexobject.InprogressSubmissionIndexFactoryImpl.buildDocument(InprogressSubmissionIndexFactoryImpl.java:46) at org.dspace.discovery.indexobject.WorkspaceItemIndexFactoryImpl.buildDocument(WorkspaceItemIndexFactoryImpl.java:63) at org.dspace.discovery.indexobject.WorkspaceItemIndexFactoryImpl.buildDocument(WorkspaceItemIndexFactoryImpl.java:30) at org.dspace.discovery.SolrServiceImpl.update(SolrServiceImpl.java:165) at org.dspace.discovery.SolrServiceImpl.indexContent(SolrServiceImpl.java:155) at org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:340) at org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:327) at org.dspace.discovery.SolrServiceImpl.createIndex(SolrServiceImpl.java:295) at org.dspace.discovery.IndexClient.internalRun(IndexClient.java:72) at org.dspace.scripts.DSpaceRunnable.run(DSpaceRunnable.java:104) at org.dspace.app.launcher.ScriptLauncher.executeScript(ScriptLauncher.java:149) at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:131) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) dspace@wiredspace:~/install/dspace7.3backend/bin$<mailto:dspace@wiredspace:~/install/dspace7.3backend/bin$> Regards, Lewatle -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- 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<mailto:dspace-tech+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/e34f93ed-6923-4643-85e1-1d741c75eeffn%40googlegroups.com<https://groups.google.com/d/msgid/dspace-tech/e34f93ed-6923-4643-85e1-1d741c75eeffn%40googlegroups.com?utm_medium=email_source=footer>. -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- 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 view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/PH0PR22MB327484A78F9D87F7B0FB9118ED239%40PH0PR22MB3274.namprd22.prod.outlook.com.
[dspace-tech] Index fail message after upgrading from Dspace 6.2 to 7.3
Dear DSpace Team, dspace@wiredspace:~/install/dspace7.3backend/bin$ ./dspace index-discovery -b The script has started (Re)building index from scratch. java.lang.NullPointerException at org.dspace.discovery.SolrServiceResourceRestrictionPlugin.additionalIndex(SolrServiceResourceRestrictionPlugin.java:95) at org.dspace.discovery.indexobject.IndexFactoryImpl.buildDocument(IndexFactoryImpl.java:67) at org.dspace.discovery.indexobject.InprogressSubmissionIndexFactoryImpl.buildDocument(InprogressSubmissionIndexFactoryImpl.java:46) at org.dspace.discovery.indexobject.WorkspaceItemIndexFactoryImpl.buildDocument(WorkspaceItemIndexFactoryImpl.java:63) at org.dspace.discovery.indexobject.WorkspaceItemIndexFactoryImpl.buildDocument(WorkspaceItemIndexFactoryImpl.java:30) at org.dspace.discovery.SolrServiceImpl.update(SolrServiceImpl.java:165) at org.dspace.discovery.SolrServiceImpl.indexContent(SolrServiceImpl.java:155) at org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:340) at org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:327) at org.dspace.discovery.SolrServiceImpl.createIndex(SolrServiceImpl.java:295) at org.dspace.discovery.IndexClient.internalRun(IndexClient.java:72) at org.dspace.scripts.DSpaceRunnable.run(DSpaceRunnable.java:104) at org.dspace.app.launcher.ScriptLauncher.executeScript(ScriptLauncher.java:149) at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:131) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) dspace@wiredspace:~/install/dspace7.3backend/bin$ Regards, Lewatle -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- 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 view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/e34f93ed-6923-4643-85e1-1d741c75eeffn%40googlegroups.com.
