Questions tagged [big-object]

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

Filter by
Sorted by
Tagged with
3
votes
2answers
87 views

Deleting Big Object Workaround Without Using Database.deleteImmediate

Known Issue for not being able to deletg Big Objects with database.deleteImmediate still open. This is the only method mentioned in docs to do this. Workaround to delete 1 X 1 is a joke. Any other ...
1
vote
1answer
40 views

Get data from Big Object in Marketing cloud

Due to storage limitation I need to think of a way to archive/reduce the storage for orders and order line items. I was thinking of Big Objects, but I need to be able to use the data from Orders and ...
1
vote
1answer
29 views

Clone Data of big Object into another big Object

I have roughly 10 million records in Big Object and now I need to move the data/clone the records in another big Object. The reason why I am doing this is that I need to modify/add more fields to the ...
1
vote
0answers
52 views

Testing Batch Apex with Big Objects

I have a batch apex class that uses Big Objects for processing. However, when running tests on this batch class, Salesforce throws an error not allowing Big Objects to be inserted for testing: https:/...
-2
votes
1answer
76 views

Custom Object or Big Object for dataset of 3 million records [closed]

I am sort of confused in what approach to take in storing large amounts of data in Salesforce. I have some data that is between 2 - 3 million records and I want to access that data through apex code ...
9
votes
4answers
127 views

Run more than one async jobs from Future/Quable context

We have created a process which must work asynchronously (limits and architecture reasons) and it was working fine. Some time later we have started to work with BigObject. And as long as writing to ...
0
votes
1answer
27 views

Retrieve a pre-existing big object via metadata in order to add new fields

Goal Retrieve a pre-existing big object in salesforce. Add new Fields to the metadata and deploy it back to the same org Question Can this be done via the workbenches retrieve tool? Steps Taken so ...
0
votes
1answer
52 views

What is the proper way to enable SeeAllData when working with Event Monitoring Big Objects?

I'm using Event Monitoring & would like to use @SeAllData = true in my unit tests, so that I can leverage pre-existing logs. However, when I enable it & query an Event Monitoring object, I ...
2
votes
2answers
71 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, ...
1
vote
2answers
100 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
30 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
62 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
124 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
30 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
2answers
101 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
102 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
83 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
62 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
193 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
324 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
429 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
135 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
241 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
441 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
84 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
247 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
123 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
65 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
273 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
115 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
81 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
27 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
74 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
92 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
271 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
39 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
582 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
98 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
706 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.
3
votes
1answer
621 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
191 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
179 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
578 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
170 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
444 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 ...
2
votes
2answers
463 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
83 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
81 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 ...