# R repositories not browsable with a H2 database backend

**URL:** <https://community.sonatype.com/t/r-repositories-not-browsable-with-a-h2-database-backend/14567>\
**Category:** Sonatype Nexus Repository\
**Created:** [March 10, 2025, 3:06pm UTC](https://community.sonatype.com/t/r-repositories-not-browsable-with-a-h2-database-backend/14567 "2025-03-10T15:06:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dj674](https://avatars.discourse-cdn.com/v4/letter/d/f6c823/32.png) [@dj674](https://community.sonatype.com/u/dj674)\
**Post date:** [March 10, 2025, 3:06pm UTC](https://community.sonatype.com/t/r-repositories-not-browsable-with-a-h2-database-backend/14567/1 "2025-03-10T15:06:46Z")

</div>

We successfully migrated from OrientDB to H2 database on version 3.70.3 and upgraded all the say up to 3.76.0 without seeing this issue.

Then we upgraded to version 3.77-0 and was unable to see our R repositories in the Nexus interface. It would simply read “A Database Error occured”.

We have upgraded to 3.77-1 and the issue still remains.

Could only see the below in the logs.

2025-02-17 17:26:41,846+0000 ERROR [qtp919751032-534] \*UNKNOWN org.sonatype.nexus.extdirect.internal.ExtDirectExceptionHandler - Failed to invoke action method: coreui\_Browse.read, java-method: org.sonatype.nexus.coreui.BrowseComponent.read  
org.sonatype.nexus.datastore.api.DataAccessException:

### Error querying database. Cause: java.lang.NumberFormatException: For input string: “conan”

### Cause: java.lang.NumberFormatException: For input string: “conan”

at org.sonatype.nexus.datastore.mybatis.DataAccessSqlSession.unwrapMyBatisException(DataAccessSqlSession.java:125)  
at org.sonatype.nexus.datastore.mybatis.DataAccessSqlSession.selectList(DataAccessSqlSession.java:76)  
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)  
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)  
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)  
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141)  
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)  
at jdk.proxy67/jdk.proxy67.$Proxy284.getByDisplayPath(Unknown Source)  
at org.sonatype.nexus.repository.content.browse.store.BrowseNodeStore.getByDisplayPath(BrowseNodeStore.java:64)  
at org.sonatype.nexus.transaction.TransactionalWrapper.proceedWithTransaction(TransactionalWrapper.java:58)  
at org.sonatype.nexus.transaction.TransactionInterceptor.proceedWithTransaction(TransactionInterceptor.java:66)  
at org.sonatype.nexus.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:55)  
at org.sonatype.nexus.repository.content.browse.store.BrowseNodeManager.getByDisplayPath(BrowseNodeManager.java:67)  
at org.sonatype.nexus.repository.content.browse.BrowseFacetImpl.getByDisplayPath(BrowseFacetImpl.java:125)  
at org.sonatype.nexus.common.stateguard.MethodInvocationAction.run(MethodInvocationAction.java:39)  
at org.sonatype.nexus.common.stateguard.StateGuard$GuardImpl.run(StateGuard.java:298)  
at org.sonatype.nexus.common.stateguard.GuardedInterceptor.invoke(GuardedInterceptor.java:54)  
at org.sonatype.nexus.repository.content.browse.store.BrowseNodeQueryServiceImpl.lambda$selectByPath$3(BrowseNodeQueryServiceImpl.java:184)  
at java.base/java.util.Optional.map(Optional.java:260)  
at org.sonatype.nexus.repository.content.browse.store.BrowseNodeQueryServiceImpl.selectByPath(BrowseNodeQueryServiceImpl.java:184)  
at org.sonatype.nexus.repository.content.browse.store.BrowseNodeQueryServiceImpl.lambda$getByPath$1(BrowseNodeQueryServiceImpl.java:154)  
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)  
at java.base/java.util.ArrayList$ArrayListSpliterator.tryAdvance(ArrayList.java:1602)  
at java.base/java.util.stream.ReferencePipeline.forEachWithCancel(ReferencePipeline.java:129)  
at java.base/java.util.stream.AbstractPipeline.copyIntoWithCancel(AbstractPipeline.java:527)  
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:513)

Has anybody else seen this issue?

I saw a post saying someone had the same issue with a postgresql backend but not a H2.

---

<div class="post-metadata">

**Author:** ![mpiggott](https://avatars.discourse-cdn.com/v4/letter/m/f0a364/32.png) [@mpiggott](https://community.sonatype.com/u/mpiggott)\
**Post date:** [March 11, 2025, 2:17pm UTC](https://community.sonatype.com/t/r-repositories-not-browsable-with-a-h2-database-backend/14567/2 "2025-03-11T14:17:48Z")

</div>

This should be fixed in 3.79

---

<div class="post-metadata">

**Author:** ![dj674](https://avatars.discourse-cdn.com/v4/letter/d/f6c823/32.png) [@dj674](https://community.sonatype.com/u/dj674)\
**Post date:** [March 11, 2025, 8:50pm UTC](https://community.sonatype.com/t/r-repositories-not-browsable-with-a-h2-database-backend/14567/3 "2025-03-11T20:50:55Z")

</div>

Great - thankyou for the update. Here’s to version 3.79!