org.hibernate.exception.DataException

could not load collection by subselect: [com.pallasathenagroup.entities.Scope.subScopes#<1818, 2336, 2322, 2323, 2325, 2314, 2316, 2311, 2312, 765, 1779, 758, 1772, 1773, 2395, 1372, 2398, 1889, 1354, 1360, 2364, 2360, 1836, 1325, 1183, 2196, 1674, 2186, 2187, 2172, 2174, 2175, 2176, 1664, 2164, 2165, 2158, 1250, 2274, 2275, 1764, 1765, 1766, 2278, 1767, 1769, 2266, 2268, 2269, 1247, 2271, 2273, 1746, 1747, 1748, 2261, 2262, 2263, 2264, 2265, 2250, 2251, 2252, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 701, 704, 691, 2218, 1571, 1572, 36, 1056, 1538, 1539, 1540, 1542, 1543, 2042, 2045, 1536, 2560, 1, 2039, 2040, 2538, 2033, 1637, 2151, 2152, 2141, 1618, 2136, 1611, 1612, 1609, 574, 1591, 1592, 2105, 1938, 397, 1936, 1937, 1923, 1924, 1925, 1926, 1415, 1416, 1928, 1929, 1417, 1404, 1917, 1409, 1909, 2424, 2007, 2001, 2498, 2490, 2491, 2492, 1981, 2493, 2494, 2495, 2496, 2497, 1458, 2482, 1459, 2489, 2478, 2480, 1456>]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web201

  • , 2249, 701, 704, 691, 2218, 1571, 1572, 36, 1056, 1538, 1539, 1540, 1542, 1543, 2042, 2045, 1536, 2560, 1, 2039, 2040, 2538, 2033, 1637, 2151, 2152, 2141, 1618, 2136, 1611, 1612, 1609, 574, 1591, 1592, 2105, 1938, 397, 1936, 1937, 1923, 1924, 1925
  • could not initialize a collection: [com.wompower.entity.brand.Brand.brandPromoDetails#1]
  • could not initialize a collection: [com.wompower.entity.brand.Brand.brandPromoDetails#1]
  • Stack trace

    • org.hibernate.exception.DataException: could not load collection by subselect: [com.pallasathenagroup.entities.Scope.subScopes#<1818, 2336, 2322, 2323, 2325, 2314, 2316, 2311, 2312, 765, 1779, 758, 1772, 1773, 2395, 1372, 2398, 1889, 1354, 1360, 2364, 2360, 1836, 1325, 1183, 2196, 1674, 2186, 2187, 2172, 2174, 2175, 2176, 1664, 2164, 2165, 2158, 1250, 2274, 2275, 1764, 1765, 1766, 2278, 1767, 1769, 2266, 2268, 2269, 1247, 2271, 2273, 1746, 1747, 1748, 2261, 2262, 2263, 2264, 2265, 2250, 2251, 2252, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 701, 704, 691, 2218, 1571, 1572, 36, 1056, 1538, 1539, 1540, 1542, 1543, 2042, 2045, 1536, 2560, 1, 2039, 2040, 2538, 2033, 1637, 2151, 2152, 2141, 1618, 2136, 1611, 1612, 1609, 574, 1591, 1592, 2105, 1938, 397, 1936, 1937, 1923, 1924, 1925, 1926, 1415, 1416, 1928, 1929, 1417, 1404, 1917, 1409, 1909, 2424, 2007, 2001, 2498, 2490, 2491, 2492, 1981, 2493, 2494, 2495, 2496, 2497, 1458, 2482, 1459, 2489, 2478, 2480, 1456>] at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:118) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) at org.hibernate.loader.Loader.loadCollectionSubselect(Loader.java:2394) at org.hibernate.loader.collection.SubselectOneToManyLoader.initialize(SubselectOneToManyLoader.java:62) at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:682) at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:75) at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:2142) at org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollection.java:567) at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:249) at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:563) at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:132) at org.hibernate.collection.internal.PersistentBag.get(PersistentBag.java:449) at com.pallasathenagroup.portal.core.TestRun.main(TestRun.java:83) Caused by: org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0. at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:64) at org.postgresql.core.v3.SimpleParameterList.setBinaryParameter(SimpleParameterList.java:131) at org.postgresql.jdbc.PgPreparedStatement.bindBytes(PgPreparedStatement.java:1094) at org.postgresql.jdbc.PgPreparedStatement.setLong(PgPreparedStatement.java:326) at org.hibernate.type.descriptor.sql.BigIntTypeDescriptor$1.doBind(BigIntTypeDescriptor.java:46) at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:74) at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:277) at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:272) at org.hibernate.loader.Loader.bindNamedParameters(Loader.java:2096) at org.hibernate.loader.Loader.bindParameterValues(Loader.java:2016) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1950) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1903) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1881) at org.hibernate.loader.Loader.doQuery(Loader.java:926) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:343) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:313) at org.hibernate.loader.Loader.loadCollectionSubselect(Loader.java:2387) ... 10 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    3 times, 7 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago