Re: [Dspace-tech] Ant fresh_install fails

[helix84]

On Fri, Dec 14, 2012 at 12:33 PM, mErRYo <merry...@yahoo.com> wrote:
> [java] 2012-12-14 16:23:17,461 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries:
> [java] java.lang.NullPointerException
> [java] at org.dspace.storage.rdbms.ColumnInfo.canonicalize(ColumnInfo.java:154)

That's strange, there's nothing on this line that would cause a NPE:

https://github.com/DSpace/DSpace/blob/dspace-3_x/dspace-api/src/main/java/org/dspace/storage/rdbms/ColumnInfo.java#L154

What do you see there in your sources?


Regards,
~~helix84

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

[qamar syed]

I have checked it thoroughly with Oracle, it's somehow not working at all with Oracle.

I personally think that dspace developers didn't check it before releasing it will Oracle.

Sent via GNex

On Dec 14, 2012 6:25 PM, "mErRYo" <merry...@yahoo.com> wrote:

Well the code is right and according to github (weblink that helix provided). I think the problem is with oracle db scripts. I don't understand why its not working with oracle when it is working fine with postgre. I mean i have dspace3.0 release with postgre also and it worked fine. Postgre DB schema is created and values inserted fine.

Please help. Its very urgent as my production installation got broke and i have timelines to meet.

--- On Fri, 12/14/12, helix84 <hel...@centrum.sk> wrote:

------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
DSpace-tech mailing list
DSpac...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

[helix84]

I looked at your stacktrace again and I was wrong that there's nothing
that would cause a NPE to be raised (I was looking at a wrong line).
The immediate problem must be that a column is null. This column name
should be the primary key of the bitstreamformatregistry table. As far
as I know, there have been no changes to this table between 1.8 and
3.0, as also evidenced by the postgres upgrade script. That would
indicate that some generic change, probably in the DatabaseManager or
TableRow class, broke Oracle.

To resolve the problem, check whether you have the
BitstreamFormatRegistry table created and bitstream_format_id is its
primary key.

My hunch is that this is some kind of character case problem with the
table name in DSpace code.

[helix84]

The strange thing is there have been no changes between 1.8.2 and 3.0
in the classes listed in your stracktrace (apart from one insignificat
string change). And as I said, there were no changes to the table in
question.

[kamarsyed]

Ok, but why it is happening ??? If you haven't changed anything in the code
????

Let me give you the details of oracle tables and columns :

Oracle DB Results :
===============

SQL> desc BitstreamFormatRegistry
Name Null? Type
----------------------------------------- --------
----------------------------
BITSTREAM_FORMAT_ID NOT NULL NUMBER(38)
MIMETYPE VARCHAR2(256)
SHORT_DESCRIPTION VARCHAR2(128)
DESCRIPTION VARCHAR2(2000)
SUPPORT_LEVEL NUMBER(38)
INTERNAL NUMBER(1)


SQL> select TABLE_NAME, CONSTRAINT_NAME,CONSTRAINT_TYPE from
user_constraints
2 where table_name ='BITSTREAMFORMATREGISTRY';

TABLE_NAME CONSTRAINT_NAME C
------------------------------ ------------------------------ -
BITSTREAMFORMATREGISTRY SYS_C009441 P
BITSTREAMFORMATREGISTRY SYS_C009442 U


Yes this is a primary key column .

Regards


Abbas







-----
Regards

Qamar Abbas

http://qamarsyed.blogspot.com
--
View this message in context: http://dspace.2283337.n4.nabble.com/Ant-fresh-install-fails-tp4660499p4660524.html
Sent from the DSpace - Tech mailing list archive at Nabble.com.

[helix84]

I didn't say that nothing changed in the code, but I looked at the
classes where the immediate problem surfaced and those have not been
changed.

[qamar syed]

Ok, but apart from the classes,  have you installed this new release with oracle ??? If not then please try to install it and then tell me  .

Regards

Abbas

[helix84]

On Mon, Dec 17, 2012 at 12:40 PM, qamar syed <kama...@gmail.com> wrote:
> Ok, but apart from the classes, have you installed this new release with
> oracle ??? If not then please try to install it and then tell me .

No, sorry, I'm not using Oracle. I was just trying to find the problem for you.

[qamar syed]

ok, no problem and thank you for your cooperation.

[helix84]

How did you set the amount of memory for Tomcat, in which variable and
which file? Even if the amounts are sufficient, maybe Tomcat isn't
picking them up. The correct variables are described here, along with
some guidelines about the values for individual memory pools:

https://wiki.duraspace.org/display/DSDOC3x/Performance+Tuning+DSpace

[mErRYo]

I am using dspace3 release with oracle 11g XE db,maven 3.x and ant 1.8x. Initially my maven failed which we resolved by our self and now after successfull build by mvn, ant is failing when i run fresh install command. exception trace is: The ' characters around the executable and arguments are not part of the command.      [java] 2012-12-14 16:23:13,898 INFO  org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg      [java] 2012-12-14 16:23:13,916 INFO  org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if unintended, check your dspace.cfg for (log.init.config)

[java] 2012-12-14 16:23:17,461 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries:      [java] java.lang.NullPointerException      [java]     at org.dspace.storage.rdbms.ColumnInfo.canonicalize(ColumnInfo.java:154)

[java]     at org.dspace.storage.rdbms.TableRow.canonicalizeAndCheck(TableRow.java:579)      [java]     at org.dspace.storage.rdbms.TableRow.setColumn(TableRow.java:437)      [java]     at org.dspace.storage.rdbms.DatabaseManager.doInsertGeneric(DatabaseManager.java:1835)      [java]     at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:679)      [java]     at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:451)      [java]     at org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403)      [java]     at org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172)      [java]     at org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138)      [java]     at org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75)      [java] Error:      [java]  - null BUILD FAILED /usr/local/dspace-3.0-src-release/dspace/target/dspace-3.0-build/build.xml:849: Java returned: 1     at org.apache.tools.ant.taskdefs.Java.execute(Java.java:111)     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)     at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)     at java.lang.reflect.Method.invoke(Method.java:597)     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)     at org.apache.tools.ant.Task.perform(Task.java:348)     at org.apache.tools.ant.Target.execute(Target.java:392)     at org.apache.tools.ant.Target.performTasks(Target.java:413)     at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)     at org.apache.tools.ant.Project.executeTarget(Project.java:1368)     at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)     at org.apache.tools.ant.Project.executeTargets(Project.java:1251)     at org.apache.tools.ant.Main.runBuild(Main.java:811)     at org.apache.tools.ant.Main.startAnt(Main.java:217)     at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)     at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109) Log file is attached.

[mErRYo]

Well the code is right and according to github (weblink that helix provided). I think the problem is with oracle db scripts. I don't understand why its not working with oracle when it is working fine with postgre. I mean i have dspace3.0 release with postgre also and it worked fine. Postgre DB schema is created and values inserted fine.

Please help. Its very urgent as my production installation got broke and i have timelines to meet.

--- On Fri, 12/14/12, helix84 <hel...@centrum.sk> wrote:

> From: helix84 <hel...@centrum.sk>
> Subject: Re: Ant fresh_install fails
> To: "mErRYo" <merry...@yahoo.com>
> Cc: hilton...@gmail.com, lighto...@gmail.com, jm...@lyncode.com, dspac...@lists.sourceforge.net, mw...@iupui.edu
> Date: Friday, December 14, 2012, 5:00 PM

[mErRYo]

Thanks the article resolved our issue.

--- On Thu, 12/20/12, helix84 <hel...@centrum.sk> wrote:

> From: helix84 <hel...@centrum.sk>
> Subject: Re: PremGen Error While adding community
> To: "mErRYo" <merry...@yahoo.com>
> Cc: hilton...@gmail.com, lighto...@gmail.com, jm...@lyncode.com, dspac...@lists.sourceforge.net, mw...@iupui.edu

[mErRYo]

I am using dspace3 release with oracle 11g XE db,maven 3.x and ant 1.8x. Initially my maven failed which we resolved by our self and now after successfull build by mvn, ant is failing when i run fresh install command.

exception trace is:

The ' characters around the executable and arguments are
not part of the command.
     [java] 2012-12-14 16:23:13,898 INFO  org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg
     [java] 2012-12-14 16:23:13,916 INFO  org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if unintended, check your dspace.cfg for (log.init.config)

     [java] 2012-12-14 16:23:17,461 FATAL org.dspace.administer.RegistryLoader @
anonymous::error_loading_registries:
     [java] java.lang.NullPointerException
     [java]     at org.dspace.storage.rdbms.ColumnInfo.canonicalize(ColumnInfo.java:154)

Log file is attached.

-----Inline Attachment Follows-----

------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d

-----Inline Attachment Follows-----

[mErRYo]

I am running Dspace 3.0 jspui with postgre 9.2 and tomcat 7. When i try to add top level community or check item statistics i get premgen error. Does anyone know what is happening wrong. I don't see it a memory issue what else is wrong.



INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Dec 20, 2012 2:17:44 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 62960 ms
Dec 20, 2012 2:20:43 PM org.apache.jasper.compiler.TldLocationsCache tldScanJar
INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
Dec 20, 2012 2:23:35 PM org.apache.solr.core.SolrCore execute
INFO: [statistics] webapp=/solr path=/select params={q=type:2+AND+id:1&wt=javabin&version=2} hits=0 status=0 QTime=63
Exception in thread "http-bio-8080-exec-7" java.lang.OutOfMemoryError: PermGen space
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:2904)
at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:1173)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1681)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1559)
at org.xbill.DNS.Record.newRecord(Record.java:157)
at org.xbill.DNS.Record.newRecord(Record.java:175)
at org.dspace.statistics.util.DnsLookup.reverseDns(DnsLookup.java:33)
at org.dspace.statistics.SolrLogger.getCommonSolrDoc(SolrLogger.java:290)
at org.dspace.statistics.SolrLogger.postView(SolrLogger.java:216)
at org.dspace.statistics.SolrLoggerUsageEventListener.receiveEvent(SolrLoggerUsageEventListener.java:40)
at org.dspace.services.events.SystemEventService.fireLocalEvent(SystemEventService.java:144)
at org.dspace.services.events.SystemEventService.fireEvent(SystemEventService.java:86)
at org.dspace.app.webui.servlet.HandleServlet.communityHome(HandleServlet.java:498)
at org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:254)
at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:119)
at org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
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)