We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [big-object]

The tag has no usage guidance, but it has a tag wiki.

Filter by
Sorted by
Tagged with
2
votes
2answers
33 views

How to use order by in Big Object Query?

I am trying to query records from big object in a list, using the following query Select Edit_Date__c ,CreatedDate,Field__c ,Loan_ID__c ,New_Value__c ,Old_Value__c ,User__c, System_Updates__c, ...
0
votes
2answers
26 views

How to retrieve total number / count of records stored in Big Object?

Even this seemingly easy task is impossible to do. For some reason, even when I loaded millions of data into Big Object, it somehow isn't reflected in Setup > Storage Usage Given sometimes it ...
2
votes
0answers
16 views

How to map static date field in Async SOQL query job?

I'm trying to use Aggregate Async SOQL to Query Big Objects to a custom Object like below (https://developer.salesforce.com/docs/atlas.en-us.chatterapi.meta/chatterapi/...
1
vote
1answer
51 views

Treatment of large data sets (>1M) in standard objects

Question: At what point Salesforce tags a standard object as big object? We are planning to load about 10+ million (one time) records in Asset and Order object and there would be incremental records ...
2
votes
0answers
57 views

Is there a way to delete >1 Million records from a custom Big Object?

First thing that came to my mind was writing a Batch Apex to do this but I get this error. System.UnexpectedException: The requested operation is not supported by this SObject Deleting via Bulk API ...
1
vote
0answers
27 views

How long does an Async SOQL query against big objects take?

Is there a ballpark for how long async SOQL queries on big objects take? I know i depends on the size of the data, but are we talking minutes vs hours vs days?
1
vote
1answer
36 views

Can you change set a Big Object?

I am trying to change set a big object from my developer sandbox to a full sandbox. I have seen here in the dev notes that it can be done via the metadata api. But nothing about changesets. So I ...
0
votes
1answer
60 views

Archive master-detail relationship Custom Objects with Attachments into Big Objects

We are running into a problem when querying and reporting performance is degrading due to having huge number of records on org of some specific custom objects. Basically in our use case, we are not ...
2
votes
0answers
32 views

How to test big object creation in unit test

I have an apex trigger which fires a platform event. And in the platform event trigger, it creates a big object. My unit test code is pretty simple and looks like below: Account acc = ...
2
votes
0answers
36 views

Intermittent, inconsistent issue deleting BigObjects

we have an intermittent issue when deleting big objects. We have a scheduled job that runs every 30 minutes, and if some conditions are met, it runs the following: try { if (!Test.isRunningTest())...
1
vote
2answers
83 views

Populating Big Objects from CSV

I need to create a client application where users can upload CSV files, which will then be used to populate Custom Big Objects. My problem is I'm not sure which API to use. The Salesforce ...
1
vote
1answer
187 views

How to query non-index field on Big Object?

I'm learning Big Object on trailhead and I have completed deploy the big object to my org. But I have a question is that: how can I query non-index field by SOQL? I know that only index fields can ...
2
votes
1answer
289 views

System.UnexpectedException: Error processing messages in Test Class for Batch Apex

Error Message System.UnexpectedException: Error processing messages Stack Trace Class.System.Test.stopTest: line 24, column 1 Class.payout.BIgObj_Test.MyMethod: line 31, column 1 Batch Class ...
0
votes
1answer
82 views

Attach Files to a Big Object record

I would like to associate Files with Big Object records. Documentation inference implies this is not technically possible... if a Big Object could be a "LinkedEntityId" I imagine it would have been ...
2
votes
1answer
178 views

Field is not writable on custom Big Object in APEX

I'm trying to read a set of records from a custom Big Object, update a long text field (not part of the object index), and then upsert back. When trying to update the value of the field I get 'Field ...
0
votes
1answer
29 views

How to get access to the 'Setup -> Create -> BigObjects' page?

How to get access to the 'Setup -> Create -> BigObjects' page? It was working fine recently and now I'm receiving Insufficient Privileges
5
votes
1answer
269 views

Creating BigObject Record in Test Class Using Test.loadData(..)

Successfully used testLoadData for a number of test classes for "regular" Sobjects. Have seen references to Stub Api Mocking Framework for one method to create test records for Big Objects in Apex but ...
2
votes
1answer
46 views

How can I setup a scheduled sync from a SQL Server database to Salesforce Big Objects?

What is the best way to have a daily scheduled insert/update of a SQL Table into Salesforce Big Objects? We currently have a C# adapter to update Salesforce standard object records with SQL database ...
0
votes
1answer
158 views

Create New Big Object Record in Marketing Cloud Journey

After sending an SMS or Email to a customer using a Marketing Cloud Journey, we would like to create a record in Service Cloud that details the content of the communication as well as the date/time ...
1
vote
0answers
25 views

What causes exception 2015936646-114094 (-407009801) in deployments?

I am trying to do a deployment of a Big Object as part of this trailhead module using Workbench API 41. I have verified that I am in the correct org. https://trailhead.salesforce.com/content/learn/...
0
votes
2answers
76 views

Big Objects visibility on page or reports

I would like to know any way where we can show data of Big objects in any page or in report format. I need archival strategy where all the previous unused data needs to be added in Big objects and ...
1
vote
1answer
51 views

Displaying related cases Email data on visualforce Page for Big Objects Data

First of all i am very new in salesforce and not have anything to do with programming however i have been trying to finish my first project by getting help online. I have created a BIG OBJECT "...
0
votes
1answer
221 views

Can not see data on VisualForce page for Big Objects data

I created a Visual force page for Big object data to be seen. However when i import data from workbench i am unable to see the full data in VF page. For some reason i can only 2 records out of 10 and ...
1
vote
1answer
101 views

Error inserting data into big object

Refer to pictures. I am trying to insert data into a big object and get the following error "variable does not exist" and it refers to the textbody Anyone have any suggestions?
3
votes
0answers
71 views

“Reached maximum number of custom objects” while creating BigObject

I am trying to create a Big Object through workbench but I keep hitting the following error message: reached maximum number of custom objects. I have only used 6% of my custom object allocation ...
1
vote
0answers
20 views

Salesforce - Restoring big objects

I'm trying to retrieve the data from certain big objects. The documentation seems to underline a different behavior on the data: Do not use the Id field in a query. Including Id in a query returns ...
0
votes
2answers
61 views

Big Object query error

I am using below query and getting the error "COMPILE ERROR: Variable does not exist: R1_ACC_TXT_Id_Golden_record__c LINE: 3 COLUMN: 47" Query: List<Account> Ac = [SELECT Id,FirstName,...
0
votes
1answer
55 views

use case of Big Objects for our Org

We are a big Airline org and we have unified solutions for call centers into Service Cloud wherein we have a custom Account objects (~47 million records), cases and Lounge Accesses, etc. How do you ...
0
votes
1answer
249 views

Define Custom Big Objects: No package.xml found

I am working on the Developer Intermediate Big Object Basics Define Custom Big Objects I am not able to finish the challenge because I can not upload the zip file successfully through workbench. ...
0
votes
0answers
34 views

Unknown exception when saving big object

We are getting following error while inserting big object: [UNKNOWN_EXCEPTION] UNKNOWN_EXCEPTION: java.lang.RuntimeException java.sql.SQLException: java.lang.RuntimeException: org....
2
votes
0answers
461 views

How to insert records in Big Object through developer console?

I am creating Big Object through workbench like Survey__b. I inserting record through developer console, in this time showing error: Variable does not exist. But i have all variables in the big ...
0
votes
1answer
88 views

How to using the Big object in visualforce page?

I created big object through workbench. I want to create record using visualforce page using input fields in the big object. How is it possible? Could you please anybody help on this.
-3
votes
1answer
559 views

what is big object .usages and limits? [closed]

What is big object. Usages and limits and diffidence between object vs big object,please anybody help on this.
2
votes
1answer
502 views

Lookups TO Big Object Workaround

Seen and tried Big Objects and seem great, except that lookups seem backward to me...I'm sure for a reason. Not looking for the reason. I want to see how I can lookup from a Custom Object record TO a ...
1
vote
2answers
164 views

Does big object increase VF page performance?

I ran into the issue, due to the huge amount of the data my VF page performance is very slow, I have already had index filer in my regular objects and still, the result is same. I read about big ...
0
votes
2answers
146 views

Error deploying standard fields in big object

I'm trying to deploy a big object to Salesforce but there are some errors with the object's fields. The big object is based on a standard object that already exists in salesforce and has some standard ...
1
vote
1answer
557 views

Big Object not deploying to Salesforce

I've been trying to deploy a big object to Salesforce via the Metadata API in Workbench but for some reason, the object isn't showing up in Salesforce. Here are the contents of the files in the ...
2
votes
1answer
145 views

How do I set a string field to null in a Big Object using Apex?

Is that something that is not allowed? Is it a bug? I just tried and it did not seem to set anything. The index of Named_Entity_Big__b is over the following, and I'd like to set Result__c to null: ...
2
votes
1answer
362 views

Does QueryLocator work with Big Objects?

I am trying to query Big Object records through Database.getQueryLocator method in a Batch class. However, it is throwing an 'Internal Salesforce Error' on the queryLocator line. I tried executing ...
1
vote
2answers
407 views

Big Object Basics - Deploying Big Objects

I have a problem while deploying a new Big Object to my developer ORG from my windows machine. I was doing the exact steps mentioned in Trailhead and deploying the big object using Workbench. I have ...
0
votes
2answers
76 views

Any work around to show TextArea under bigobject

I am able to create and hold records in big object. Here's my issue with bigobject fields, I am able to insert the data with LongTextArea/TextArea fields, but I am unable to query the field. And even ...
5
votes
1answer
76 views

Issue with re-creating a Big Object with the same API Name

As part of a POC, someone had created a big object called StatusTracking__b. After a few stuff-ups they ended up keeping StatusTracking3__b in the system. The time has come for things to get ...
0
votes
2answers
156 views

Visualforce action method to search Big Object with LIKE

I built a visualforce page on Big object to show Account name which we are querying. As the big object is not supporting Like' in SOQL command, was unable to get the desired result and getting the ...
5
votes
1answer
786 views

Unit Test Big Objects

I have an APEX controller that writes to a Big Object. How do I unit this? During an insert operation insert I get an error: Unsupported External Object Operations.
0
votes
2answers
338 views

How to filter custom Big Object fields?

Here's my question on custom big object: can we filter a record under big object?. I just want to filter and show an account record based on account name, here we are storing about 300,000 records of ...
0
votes
2answers
189 views

Deploying Object fields in Big Object

Does anyone know whether it is possible to deploy custom or standard object into big object without manually writing those entire object fields and permission set file? Thanks in Advance
3
votes
0answers
84 views

Salesforce big objects pagination

Given that SOQL for big objects doesn't support OFFSET, how should pagination be implemented for big objects?
2
votes
1answer
793 views

Explain: Big objects don’t support transactions including both big objects, standard object and custom objects

While reading the Big Object related documentation, I was curious as to what does the following statement mean? Big objects don’t support transactions including both big objects, standard object ...
0
votes
2answers
367 views

Add more fields in Custom Big Objec

Anybody there to help me out how to add more fields in custom Big Object? I had already created one Custom Big Object with some fields. Now Im trying to add more fields in the same Object. How it ...
0
votes
1answer
688 views

How to do I enable asyncquery for developer salesforce org

I get the following error when I try to run an async soql query in workbench {"message":"This feature is not currently enabled for this user type or org: [AsyncQuery]","errorCode":"...