The following API call
https://apisandbox.dev.clover.com/v3/apps/{appId}/merchants/{businessId}/billing_info
is giving a TooManyRowsException. The response body is given below.
{"requestId":"a07fbf9c-a14d-4ca0-ce27-bbb0feccbbab","debug":{"stacktrace":"com.clover.dbconnectors.exception.TooManyRowsException: An error occurred while attempting to access the database.\n\tat com.clover.dbconnectors.db.Databases$8.execute(Databases.java:357)\n\tat com.clover.dbconnectors.db.ExecuteQuery.process(ExecuteQuery.java:18)\n\tat com.clover.dbconnectors.db.DatabaseExecute.run(DatabaseExecute.java:42)\n\tat com.clover.dbconnectors.db.Databases.doSelect(Databases.java:381)\n\tat com.clover.dbconnectors.db.Databases.selectSingle(Databases.java:351)\n\tat com.clover.dbconnectors.db.Databases.selectLong(Databases.java:72)\n\tat com.clover.dbconnectors.transactor.DatabaseTransactor$6.transact(DatabaseTransactor.java:213)\n\tat com.clover.dbconnectors.transactor.DatabaseTransactor$6.transact(DatabaseTransactor.java:210)\n\tat com.clover.dbconnectors.db.DatabaseBase.autocommit(DatabaseBase.java:137)\n\tat com.clover.dbconnectors.transactor.DatabaseTransactor.autocommit(DatabaseTransactor.java:66)\n\tat com.clover.dbconnectors.transactor.DatabaseTransactor.selectLong(DatabaseTransactor.java:210)\n\tat com.clover.server.service.cache.AppCache$18.load(AppCache.java:321)\n\tat com.clover.server.service.cache.AppCache$18.load(AppCache.java:319)\n\tat com.github.benmanes.caffeine.cache.BoundedLocalCache$BoundedLocalLoadingCache.lambda$new$0(BoundedLocalCache.java:3125)\n\tat com.github.benmanes.caffeine.cache.BoundedLocalCache$BoundedLocalLoadingCache$$Lambda$72/942259739.apply(Unknown Source)\n\tat com.github.benmanes.caffeine.cache.LocalCache.lambda$statsAware$0(LocalCache.java:144)\n\tat com.github.benmanes.caffeine.cache.LocalCache$$Lambda$123/703031414.apply(Unknown Source)\n\tat com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$16(BoundedLocalCache.java:1973)\n\tat com.github.benmanes.caffeine.cache.BoundedLocalCache$$Lambda$124/1377645517.apply(Unknown Source)\n\tat java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1853)\n\tat com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:1971)\n\tat com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:1954)\n\tat com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:113)\n\tat com.github.benmanes.caffeine.cache.LocalLoadingCache.get(LocalLoadingCache.java:67)\n\tat com.clover.server.service.cache.CacheService$69.getFromLocalCache(CacheService.java:2225)\n\tat com.clover.server.service.cache.CacheService$69.getFromLocalCache(CacheService.java:2222)\n\tat com.clover.serverkit.cache.base.LocalCacheOrDefaultSupplier.get(LocalCacheOrDefaultSupplier.java:37)\n\tat com.clover.server.service.cache.CacheService.getAppSubscriptionIdForMerchantApp(CacheService.java:2231)\n\tat com.clover.server.controller.AppController.getCurrentSubscription(AppController.java:1274)\n\tat com.clover.server.controller.AppController.expandApp(AppController.java:1124)\n\tat com.clover.server.controller.AppController.getApps(AppController.java:930)\n\tat com.clover.server.controller.AppController.getAvailableMerchantApps(AppController.java:756)\n\tat com.clover.server.controller.AppController.getAvailableMerchantApp(AppController.java:379)\n\tat com.clover.server.controller.AppController.getMerchantBillingInfo(AppController.java:1378)\n\tat com.clover.server.controller.AppController.access$100(AppController.java:100)\n\tat com.clover.server.controller.AppController$9.transact(AppController.java:1368)\n\tat com.clover.server.controller.AppController$9.transact(AppController.java:1365)\n\tat com.clover.dbconnectors.db.DatabaseBase.autocommit(DatabaseBase.java:137)\n\tat com.clover.dbconnectors.transactor.DatabaseTransactor.autocommitRO(DatabaseTransactor.java:73)\n\tat com.clover.server.controller.AppController.getMerchantBillingInfo(AppController.java:1365)\n\tat com.clover.server.handlers.api.v3.apps.GetMerchantBillingInfo.serve(GetMerchantBillingInfo.java:46)\n\tat com.clover.server.handlers.api.v3.apps.GetMerchantBillingInfo.serve(GetMerchantBillingInfo.java:17)\n\tat com.clover.server.http.UnifiedCosRequestHandler.serveAsync(UnifiedCosRequestHandler.java:47)\n\tat com.clover.server.http.AsynchronousCosRequestHandler.serveAsync(AsynchronousCosRequestHandler.java:175)\n\tat com.clover.server.http.AsynchronousCosRequestHandler.serveAsync(AsynchronousCosRequestHandler.java:159)\n\tat com.clover.server.http.handler.DefaultHttpHandler.handleRequest(DefaultHttpHandler.java:86)\n\tat com.clover.serverkit.handlers.BaseDefaultHttpHandler.handleRequestPreProcessing(BaseDefaultHttpHandler.java:330)\n\tat com.clover.serverkit.handlers.BaseDefaultHttpHandler$1.doRun(BaseDefaultHttpHandler.java:135)\n\tat com.clover.serverkit.threadpools.CloverRunnable.run(CloverRunnable.java:35)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\n\tat java.lang.Thread.run(Thread.java:745)\n"}}
