I have a simple where clause written in Swift that looks like this:
let whereClause = "currentBidAmount = 148"
let dataQuery = BackendlessDataQuery()
dataQuery.whereClause = whereClause
var error: Fault?
let bc = Backendless.sharedInstance().data.of(Bid.ofClass()).find(dataQuery, fault: &error)
if error == nil {
print("Entry has been found: \(bc.data)")
}
else {
print("Server reported an error: \(error)")
}
My app id is: 5F3B25A0-9BAA-AE5B-FF7E-88AE2D82A500
Thanks, Christian. Could you please check one more thing for me?:
Open Backendless console, select your app and navigate to the Data screen. Select the Bid table and enter your where clause in the “Search data…” bar. Make sure to set the SQL Search toggle to ON. Do you get any data back for the search?
And the specific error outputed is:
“2016-06-30 10:08:45.478 TBRB Project[1507:41142] failed to search db with error: Server.Processing java.lang.RuntimeException: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘6DF4654A-5CF0-D813-FF3B-E00B964B1100.413EBBE7-5F42-B664-FF19-407323196800.acl’ doesn’t exist”
Hey just a quick update. I managed to fix the problem! I deleted the table on the backendless dashboard, then readded the table via code in my app and its all good now. If you need any info let me know.
I have a similar problem. The simple query that I’m using was working fine until today.
I’m using the IOS sdk and I just updated it to 4.0.20
My appId: C3805DA9-152F-BCD7-FF16-9EE2A64A7100
FAULT = 'Server.Processing' [None of the handlers were able to invoke the target service. The service may not be found:com.backendless.services.persistence.PersistenceServiceForClients. Make sure exceptions are logged - check server log for details] <None of the handlers were able to invoke the target service. The service may not be found:com.backendless.services.persistence.PersistenceServiceForClients.
I tried calling the API through PostMan and it seems that everything is alright.
Here is the query I’m using:
let backendless = Backendless.sharedInstance()!
let dataStore = backendless.data.of(Venue.ofClass())
let dataQuery = DataQueryBuilder()
_ = dataQuery?.setPageSize(50)
_ = dataQuery?.addRelated("beacons")
_ = dataQuery?.addRelated("geopointCoordinate")
_ = dataQuery?.addRelated("venueImgs")
dataStore?.find(dataQuery,response: { ( result: [Any]?) -> Void in
},
error: { (fault: Fault!) -> Void in
print("Backendless reported an error: \(fault.message)")
})
error: Optional(FAULT = 'Server.Processing' [java.lang.RuntimeException: Unable to adapt array to data type: class weborb.v3types.BodyHolder] <java.lang.RuntimeException: Unable to adapt array to data type: class weborb.v3types.BodyHolder
at weborb.reader.ArrayType.adaptToClass(ArrayType.java:335)
at weborb.reader.ArrayType.adapt(ArrayType.java:229)
at weborb.reader.AnonymousObject.getPropertyValue(AnonymousObject.java:528)
at weborb.reader.AnonymousObject.setFieldsDirect(AnonymousObject.java:433)
at weborb.reader.AnonymousObject.adaptToClass(AnonymousObject.java:291)
at weborb.reader.AnonymousObject.adapt(AnonymousObject.java:140)
at weborb.reader.NamedObject.defaultAdapt(NamedObject.java:86)
at weborb.reader.NamedObject.defaultAdapt(NamedObject.java:74)
at weborb.dispatch.V3Dispatcher.dispatch(V3Dispatcher.java:41)
at controllers.WebORB.handleAMFRequest(WebORB.java:105)
at router.Routes$$anonfun$routes$1$$anonfun$applyOrElse$432$$anonfun$apply$432.apply(Routes.scala:11986)
at router.Routes$$anonfun$routes$1$$anonfun$applyOrElse$432$$anonfun$apply$432.apply(Routes.scala:11986)
at play.core.routing.HandlerInvokerFactory$$anon$4.resultCall(HandlerInvoker.scala:157)
at play.core.routing.HandlerInvokerFactory$$anon$4.resultCall(HandlerInvoker.scala:156)
at play.core.routing.HandlerInvokerFactory$JavaActionInvokerFactory$$anon$14$$anon$3$$anon$1.invocation(HandlerInvoker.scala:136)
at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:73)
at play.http.HttpRequestHandler$1.call(HttpRequestHandler.java:54)
at com.backendless.old.security.ValidateApplication.call(ValidateApplication.java:57)
at com.backendless.old.security.ApplicationExistenceAction.call(ApplicationExistenceAction.java:30)
at com.backendless.old.security.ConsiderApiCallAction.call(ConsiderApiCallAction.java:29)
at com.backendless.TimeOutAction.call(TimeOutAction.java:26)
at com.backendless.SimultaneousApiCallLimitAction.call(SimultaneousApiCallLimitAction.java:22)
at com.backendless.CloseEntityManagerAction.call(CloseEntityManagerAction.java:29)
at play.core.j.JavaAction$$anonfun$7.apply(JavaAction.scala:108)
at play.core.j.JavaAction$$anonfun$7.apply(JavaAction.scala:108)
at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24)
at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24)
at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:56)
at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:70)
at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:48)
at scala.concurrent.impl.Future$.apply(Future.scala:31)
at scala.concurrent.Future$.apply(Future.scala:494)
at play.core.j.JavaAction.apply(JavaAction.scala:108)
at play.api.mvc.Action$$anonfun$apply$2$$anonfun$apply$5$$anonfun$apply$6.apply(Action.scala:112)
at play.api.mvc.Action$$anonfun$apply$2$$anonfun$apply$5$$anonfun$apply$6.apply(Action.scala:112)
at play.utils.Threads$.withContextClassLoader(Threads.scala:21)
at play.api.mvc.Action$$anonfun$apply$2$$anonfun$apply$5.apply(Action.scala:111)
at play.api.mvc.Action$$anonfun$apply$2$$anonfun$apply$5.apply(Action.scala:110)
at scala.Option.map(Option.scala:146)
at play.api.mvc.Action$$anonfun$apply$2.apply(Action.scala:110)
at play.api.mvc.Action$$anonfun$apply$2.apply(Action.scala:103)
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:253)
at scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:251)
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:36)
at akka.dispatch.BatchingExecutor$AbstractBatch.processBatch(BatchingExecutor.scala:55)
at akka.dispatch.BatchingExecutor$BlockableBatch$$anonfun$run$1.apply$mcV$sp(BatchingExecutor.scala:91)
at akka.dispatch.BatchingExecutor$BlockableBatch$$anonfun$run$1.apply(BatchingExecutor.scala:91)
at akka.dispatch.BatchingExecutor$BlockableBatch$$anonfun$run$1.apply(BatchingExecutor.scala:91)
at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:72)
at akka.dispatch.BatchingExecutor$BlockableBatch.run(BatchingExecutor.scala:90)
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:39)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
> )