Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

force:data:export:tree --plan only exports 1000 rows of 1400-row object #1663

Closed
tggagne opened this issue Aug 10, 2022 · 3 comments
Closed
Labels
bug Issue or pull request that identifies or fixes a bug

Comments

@tggagne
Copy link

tggagne commented Aug 10, 2022

Summary

Object with 1400 rows (1000 > x < 2000) only exports 1000 rows even with --plan

Steps To Reproduce:

Here's the command:

sfdx force:data:tree:export -u uat -q 'select a-bunch-of-fields from aCustomObject__c limit 2000' -d ./data/ --plan
Wrote 1000 records to data/HWKForm__cs.json
Wrote 0 records to data/HWKForm__c-plan.json

Expected result

Wrote 1456 records to data/aCustomObject.json ??? (not sure what this should be)
Wrote 0 records to data/HWKForm__c-plan.json ??? ( not sure what this should be)

% grep aCustomField data/aCustomObject.json | wc -l
1456

Actual result

Wrote 1000 records to data/HWKForm__cs.json
Wrote 0 records to data/HWKForm__c-plan.json

% grep aCustomField data/aCustomObject.json | wc -l
1000 2000 36463

System Information

Using zsh on mac osx

tgagne@HWKMAC-C02DN69QMD6M dx-mga % sfdx version --verbose --json
{
"cliVersion": "sfdx-cli/7.159.0",
"architecture": "darwin-x64",
"nodeVersion": "node-v16.15.0",
"pluginVersions": [
"@copado/copado-cli 1.1.15",
"@oclif/plugin-autocomplete 0.3.0 (core)",
"@oclif/plugin-commands 1.3.0 (core)",
"@oclif/plugin-help 3.3.1 (core)",
"@oclif/plugin-not-found 1.2.6 (core)",
"@oclif/plugin-plugins 1.10.11 (core)",
"@oclif/plugin-update 1.5.0 (core)",
"@oclif/plugin-warn-if-update-available 1.7.3 (core)",
"@oclif/plugin-which 1.0.4 (core)",
"@salesforce/sfdx-plugin-lwc-test 1.0.0 (core)",
"alias 2.1.0 (core)",
"apex 1.1.0 (core)",
"auth 2.2.2 (core)",
"community 2.0.0 (core)",
"config 1.4.14 (core)",
"custom-metadata 2.0.0 (core)",
"data 2.0.4 (core)",
"generator 2.0.2 (core)",
"info 2.0.1 (core)",
"limits 2.0.1 (core)",
"org 2.0.2 (core)",
"salesforce-alm 54.6.2 (core)",
"schema 2.1.1 (core)",
"sfdx-cli 7.159.0 (core)",
"signups 1.2.0 (core)",
"source 2.0.7 (core)",
"telemetry 2.0.0 (core)",
"templates 55.0.0 (core)",
"trust 2.0.1 (core)",
"user 2.1.0 (core)",
"vlocityestools 0.22.14"
],
"osVersion": "Darwin 21.5.0"
}

Additional information

None.

@tggagne tggagne added the investigating We're actively investigating this issue label Aug 10, 2022
@github-actions
Copy link

Thank you for filing this issue. We appreciate your feedback and will review the issue as soon as possible. Remember, however, that GitHub isn't a mechanism for receiving support under any agreement or SLA. If you require immediate assistance, contact Salesforce Customer Support.

@mdonnalley mdonnalley added bug Issue or pull request that identifies or fixes a bug and removed investigating We're actively investigating this issue labels Aug 11, 2022
@git2gus
Copy link

git2gus bot commented Aug 11, 2022

This issue has been linked to a new work item: W-11585530

@mshanemc
Copy link
Contributor

mshanemc commented Aug 3, 2023

I don't know when this was fixed, but it works now.

sf data export tree -o gus -q 'select id from ADM_Work__c limit 1500' -d data --plan
Wrote 1500 records to data/ADM_Work__cs.json

If you can still repro, please open a new issue with your reproduction.

@mshanemc mshanemc closed this as completed Aug 3, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Issue or pull request that identifies or fixes a bug
Projects
None yet
Development

No branches or pull requests

3 participants