+ Start a Discussion
GlennCoppensGlennCoppens 

SOQL on Big Object [REQUEST_RUNNING_TOO_LONG]

Hi,

Since last week we started having problems running SOQL queries on a custom Big Object.
Executing the SOQL in our sandboxes gives no problem at all.
So querying/exporting data from Dataloader, Workbench and Execute Anonymous session all give the same error, immediately after the request is fired: "UNKNOWN ERROR: [REQUEST_RUNNING_TOO_LONG] Your request was running for too long, and has been stopped" 

Thanks,
Glenn
Lode Blomme 2Lode Blomme 2
Developer script exception from <customer name> : '<custom written Apex class>' : org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: CUSTOM_ENTITY.z00: Didn't find expected key values for table row in metadata row at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:111) at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:551) at org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:16267) at org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:6143) at org.apache.hadoop.hbase.regionserver.HRegionServer.execServiceOnRegion(HRegionServer.java:3548) at org.apache.hadoop.hbase.regionserver.HRegionServer.execService(HRegionServer.java:3530) at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32496) at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2213)
Is a more specific error of what occurs.
 
Sandeep Adhikari RSandeep Adhikari R
Enable Bulk API on the data loader settings and give it a try.