Questions tagged [big-object]
The big-object tag has no usage guidance, but it has a tag wiki.
79
questions
0
votes
0
answers
44
views
How can we write a test class for class containing the Database.insertImmediate method?
I have a class which archives sobject records as big objects. This includes the method Database.insertImmediate(). As this database method counts as a callout, it seems it cannot be covered during ...
- 1
0
votes
0
answers
26
views
Big Objects are not inserting properly but got successful message while inserting
I have inserted 50 records from email message (standard objects) to big objects by apex(database.insertimmediate). All 50 records are inserted successfully. But in big objects, i could see only 8 ...
- 1
1
vote
0
answers
44
views
What is the impact of a big object lookup to a Standard/Custom Object?
Say I have a data model where an Big Object where I want to store an Account Id. Is it better to store the 18 char Id as Text, or actually make the lookup relationship so the big object looks up to ...
- 10.5k
0
votes
0
answers
31
views
Test Class for Big Objects [duplicate]
I have a visualforce page that generates a PDF. I am querying for big object data and build the PDF based off of the data from the big object. I am trying to create a test class that covers this but I ...
- 101
1
vote
0
answers
65
views
Can we package custom Big Objects into a 2nd generation managed package?
When I try to create a package version via sfdx force:package:version:create, it gives an error:
ERROR running force:package:version:create: Unexpected file found in package directory: /my-base-path/...
- 31
1
vote
0
answers
178
views
Simple Salesforce how to create Custom Big Object?
Is there a way to create Custom Big Object with the simple salesforce metadata API?
This is my approach:
idx_field = mdapi.IndexField(
name="MY_ACCOUNT_ID__c", sortDirection=&...
- 11
1
vote
1
answer
260
views
Schedulable Class - Big Object
I've created a schedulable class that retrieves info from SetupAuditTrail everyday and creates a big object records on a daily basis. The schedulable class works fine. But when I run the test class, ...
2
votes
1
answer
328
views
Can we show a Big Object with lightning-record-form in LWC?
I want to show my custom big object in LWC lightning-record-form ?
Is it possible ?
When i do this i get this error :
Code for the form :
<lightning-record-form
record-id={selectedBigObject.Id}...
- 1,571
0
votes
2
answers
3k
views
Does Database.QueryLocator and Iterable both have same limit?
I wrote a batch class to insert dummy data into big object and have used Iterable to insert data.
I was under impression that Iterable should only be able to insert in normal limit of 50K records.
But ...
- 8,059
1
vote
0
answers
165
views
Big Objects - How to Retry a Batch?
In exploring Big Objects the docs state the below:
When working with big data and writing batches of records using APIs
or Apex, you can experience a partial batch failure while some records
are ...
- 5,325
15
votes
1
answer
1k
views
How to archive & restore Custom Objects in Big Objects
For my app I want to build a Archive and Restore functionality. For a given Custom Object MyObject__c and a Big Object ArchivedMyObject__b those requirements need to be fulfilled:
MyObject__c records ...
- 36.7k
10
votes
0
answers
364
views
Move Large Data Volume objects to Big Objects
I have built an Open-Source tool that collects App Errors in Managed Packages and creates Custom Object records for each of them in a Salesforce org. This app can produce thousands of records per day. ...
- 36.7k
1
vote
1
answer
973
views
How can we make Async SOQL queries to big objects from Apex?
I'm looking at ways to execute an Async SOQL query for a Big Object using Apex. The documentation suggests this can only be done using the Connect REST API.
https://developer.salesforce.com/docs/atlas....
- 306
1
vote
0
answers
908
views
Insert Big Object in Batch Class
I am trying to create records in a Big Object using a Batch class.
However, when executing the Database.InsertImmediate() command, the error below occurs:
Just as a note, the Database.InsertAsync() ...
0
votes
1
answer
660
views
How to delete custom fields from Big Object?
How do I delete non-indexed custom fields on a Big Object ? I do not see a 'delete' option next to 'edit' option of a field.
- 25
2
votes
1
answer
2k
views
How to parse large size csv file content into custom object in Salesforce?
I have requirements to implement the LWC file upload wizard which should handle very large size csv file( about 1 GB).. is it doable to parse such large size csv through APEX batch method?
I tried ...
- 21
3
votes
2
answers
639
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,517
1
vote
1
answer
483
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 ...
- 121
1
vote
1
answer
347
views
Clone data of big object into another big object
I have roughly 10 million records in a 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 ...
- 679
1
vote
0
answers
760
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
1
answer
626
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 ...
- 613
12
votes
4
answers
1k
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 ...
- 123
0
votes
1
answer
317
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 ...
- 351
0
votes
1
answer
207
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 ...
- 405
2
votes
2
answers
906
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, ...
2
votes
2
answers
2k
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 ...
- 1,209
2
votes
0
answers
145
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,209
1
vote
1
answer
236
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 ...
- 390
4
votes
1
answer
1k
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,209
1
vote
1
answer
139
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?
- 2,683
1
vote
3
answers
807
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 ...
- 351
0
votes
1
answer
522
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,929
3
votes
0
answers
576
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 = ...
- 12.9k
2
votes
0
answers
132
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())...
- 3,986
1
vote
2
answers
1k
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 ...
- 11
2
votes
1
answer
1k
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 ...
- 146
2
votes
1
answer
1k
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
1
answer
779
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,171
2
votes
2
answers
869
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 ...
- 21
0
votes
1
answer
31
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
- 123
5
votes
1
answer
2k
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 ...
- 1,517
2
votes
1
answer
255
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
1
answer
407
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
0
answers
26
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/...
- 179
0
votes
2
answers
715
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,438
1
vote
1
answer
267
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 "...
- 41
0
votes
1
answer
610
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 ...
- 41
1
vote
1
answer
360
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?
4
votes
0
answers
185
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 ...
- 91
1
vote
0
answers
71
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
...
- 1,089