Server processing error

I’m trying to get an object from Backendless using a simple where clause, but I get the following error:

FAULT = ‘Server.Processing’ [java.lang.RuntimeException: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘5F3B25A0-9BAA-AE5B-FF7E-88AE2D82A500.F66C0FDB-A280-4E8F-FFD9-0EC35A17C600.acl’ doesn’t exist] <java.lang.RuntimeException: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘5F3B25A0-9BAA-AE5B-FF7E-88AE2D82A500.F66C0FDB-A280-4E8F-FFD9-0EC35A17C600.acl’ doesn’t exist>

Can someone please explain to me what is the problem?

Hi Christian,

Could you please let us know your application id? (from the Manage > App Settings screen).

Also, please show the code that makes the request (including the where clause you use).

Regards,
Mark

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!

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?

Regards,

Mark

Ok, if I enter the clause there, it works fine. The toggle was off, I switched it to on, but in the app I get the same message.

Ok, for some reason, it seems to be working now, without changing a line of code or altering the respective class. Thank you for the support!

We got into the app on the server-side and made a few changes in there so the error does not occur.

Regards,
Mark

Hey Mark, I think I have a similar problem. Do you mind telling me what you did to fix it.

Thanks

Hi Luke,

Does the error occur for a specific API operation? Could you please provide more details (including your application id)?

Regards,
Mark

Hey Mark, it happens with the data querying API operation. Heres a function in my app with throws the error:

-(IBAction)confirmEntry {

// get currentuser data row from entries table

BackendlessDataQuery *userEntriesQuery = [BackendlessDataQuery query];

userEntriesQuery.whereClause = [NSString stringWithFormat:@"emailAddress = \'%@\'", _currentUser.email];

// vvv throws error on this line vvv

[[backendless.persistenceService of:[Entries class]] find:userEntriesQuery response:^(BackendlessCollection *userEntries) {

    

    NSArray *currentPage = [userEntries getCurrentPage];

    Entries *userEntry = [currentPage objectAtIndex:0];

    

} error:^(Fault *error) {

    

    NSLog(@"failed to search db with error: %@ %@", error.faultCode, error.message);

    

}];

}

App ID is: 6DF4654A-5CF0-D813-FF3B-E00B964B1100

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”

Thanks -Luke

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.

Thanks

Thanks for letting me know, Luke.

Hi Mark

I think I have a similar problem.It was done yesterday.

 NSMutableString * strQuery = [NSMutableString string];
 [StrQuery appendFormat: @ "userRelation.objectId = \ '% @ \' and notice is not null AND readFlg = false", userId];
 [StrQuery appendFormat: @ "and notice.statusKbn = 2"];


 BackendlessDataQuery * query = [BackendlessDataQuery query];
 query.whereClause = strQuery;
 QueryOptions * queryOptions = [QueryOptions new];
 queryOptions.pageSize = [NSNumber numberWithInteger: 1];
 query.queryOptions = queryOptions;
 [Self findAllWithQuery: query response: responseCallback error: errorCallback];

APP_ID: C0092ECD-5773-9D13-FFFF-5D5E928C3200

Thanks

Hello kunito,

which table causes a problem? and what error you get?

Hi Swrgey

There is a problem table is ‘NoticeUser’.

error:

fault:java.lang.RuntimeException: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0&lt;FAULT = 'Server.Processing' [java.lang.RuntimeException: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0] &lt;java.lang.RuntimeException: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0&gt; >

Thanks.

Hi Mark,

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)")
})

Thanks,
Sami

A quick update. The error has changed to this:

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000}
span.s1 {font-variant-ligatures: no-common-ligatures}
span.Apple-tab-span {white-space:pre}

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)
> )

Hello Sami,

we have fixed this issue.

Thanks Sergey! It’s working fine.