sf data query resume: cannot find resource for bulk query results in cli #2968
Comments
|
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. |
github-actions
bot
added
the
validated
|
@deployment-ian thanks for the issue
|
mdonnalley
added
the
more information required
|
I don't believe this is to be the case. When I adjust my query so that it only returns 1.8m records (down from 21m), the command |
|
Also, when I utilize workbench with the same query as I use and the resource doesn't appear, workbench is able to extract al of the data |
|
Got it. Can you set |
|
sure! I set the flag, received lots of additional information, but no extra detail when executing the |
|
|
|
duh! |
|
Here's the data as JSON: {
"name": "NOT_FOUND",
"message": "The requested resource does not exist",
"exitCode": 1,
"context": "BulkQueryReport",
"stack": "NOT_FOUND: The requested resource does not exist\n at SfCommandError.from (file:///C:/Users/Ian-Bates/AppData/Local/sf/client/2.50.6-6e9d7f7/node_modules/@salesforce/sf-plugins-core/lib/SfCommandError.js:39:16)\n at BulkQueryReport.catch (file:///C:/Users/Ian-Bates/AppData/Local/sf/client/2.50.6-6e9d7f7/node_modules/@salesforce/sf-plugins-core/lib/sfCommand.js:315:47)\n at BulkQueryReport._run (C:\\Users\\Ian-Bates\\AppData\\Local\\sf\\client\\2.50.6-6e9d7f7\\node_modules\\@oclif\\core\\lib\\command.js:306:29)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async Config.runCommand (C:\\Users\\Ian-Bates\\AppData\\Local\\sf\\client\\2.50.6-6e9d7f7\\node_modules\\@oclif\\core\\lib\\config\\config.js:424:25)\n at async run (C:\\Users\\Ian-Bates\\AppData\\Local\\sf\\client\\2.50.6-6e9d7f7\\node_modules\\@oclif\\core\\lib\\main.js:95:16)\n at async file:///C:/Users/Ian-Bates/AppData/Local/sf/client/2.50.6-6e9d7f7/bin/run.js:15:1",
"cause": "NOT_FOUND: The requested resource does not exist\n at BulkApiV2.getError (C:\\Users\\Ian-Bates\\AppData\\Local\\sf\\client\\2.50.6-6e9d7f7\\node_modules\\@jsforce\\jsforce-node\\lib\\http-api.js:279:16)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async C:\\Users\\Ian-Bates\\AppData\\Local\\sf\\client\\2.50.6-6e9d7f7\\node_modules\\@jsforce\\jsforce-node\\lib\\http-api.js:127:33\n at async QueryJobV2.result (C:\\Users\\Ian-Bates\\AppData\\Local\\sf\\client\\2.50.6-6e9d7f7\\node_modules\\@jsforce\\jsforce-node\\lib\\api\\bulk2.js:359:13)\n at async BulkQueryReport.run (file:///C:/Users/Ian-Bates/AppData/Local/sf/client/2.50.6-6e9d7f7/node_modules/@salesforce/plugin-data/lib/commands/data/query/resume.js:50:25)\n at async BulkQueryReport._run (C:\\Users\\Ian-Bates\\AppData\\Local\\sf\\client\\2.50.6-6e9d7f7\\node_modules\\@oclif\\core\\lib\\command.js:302:22)\n at async Config.runCommand (C:\\Users\\Ian-Bates\\AppData\\Local\\sf\\client\\2.50.6-6e9d7f7\\node_modules\\@oclif\\core\\lib\\config\\config.js:424:25)\n at async run (C:\\Users\\Ian-Bates\\AppData\\Local\\sf\\client\\2.50.6-6e9d7f7\\node_modules\\@oclif\\core\\lib\\main.js:95:16)\n at async file:///C:/Users/Ian-Bates/AppData/Local/sf/client/2.50.6-6e9d7f7/bin/run.js:15:1 {\n errorCode: 'NOT_FOUND',\n content: undefined\n}",
"warnings": [],
"code": "1",
"status": 1,
"commandName": "BulkQueryReport"
} |
|
@deployment-ian Thanks for the logs! Based on these logs, It looks like jsforce is creating a url with a I'll mark this as a |
mdonnalley
added
bug
|
This issue has been linked to a new work item: W-16325607 |
|
Thank you so much @mdonnalley! I really appreciate it. And since we have this conversation going, is there any way batch-download the CSV? or will this work-flow always return all this data within 1 csv? I don't see much documentation utilizing the bulk api 2.0 commands within the cli... I appreciate you helping me out with this! |
There's no support for batch downloading the csv - it's always going to go into a single csv file. If you needed to do that, you could adjust your soql query to return a subset of the data and then run multiple |
hi 👋🏼 @deployment-ian FWIW, the Bulk 2.0 API doesn't let clients to batch data when uploading, so for a feature like this the CLI would need to implement some extra logic, see: |
|
Hi @cristiand391, I don't know right now if it's actually better for me to have a multiple-file result from the bulk query at this time. Once the issue above it resolved, I can then figure out if it would be beneficial to request this feature. I will post my thoughts on the pages you provided here. Thanks! |
Summary
I am using
@salesforce/cli/2.50.6 win32-x64 node-v20.15.0I am trying to extract data using a bulk query. This is a significant amount of data in this query request:
I then checked the status of the job:
Great! It ran successfully. But when I try to extract the data, I receive this information that the resource does not exist:
Where did the resource go? How do I extract these batch results into a csv?
System Information
{ "architecture": "win32-x64", "cliVersion": "@salesforce/cli/2.50.6", "nodeVersion": "node-v20.15.0", "osVersion": "Windows_NT 10.0.19045", "rootPath": "C:\\Users\\{user}\\AppData\\Local\\sf\\client\\2.50.6-6e9d7f7", "shell": "cmd.exe", "pluginVersions": [ "@oclif/plugin-autocomplete 3.1.6 (core)", "@oclif/plugin-commands 4.0.6 (core)", "@oclif/plugin-help 6.2.5 (core)", "@oclif/plugin-not-found 3.2.10 (core)", "@oclif/plugin-plugins 5.3.4 (core)", "@oclif/plugin-search 1.2.2 (core)", "@oclif/plugin-update 4.4.7 (core)", "@oclif/plugin-version 2.2.6 (core)", "@oclif/plugin-warn-if-update-available 3.1.8 (core)", "@oclif/plugin-which 3.2.6 (core)", "@salesforce/cli 2.50.6 (core)", "apex 3.2.4 (core)", "auth 3.6.33 (core)", "data 3.5.5 (core)", "deploy-retrieve 3.9.13 (core)", "env 3.0.32 (user) published 41 days ago (Wed Jun 12 2024)", "info 3.3.17 (core)", "limits 3.3.17 (core)", "marketplace 1.2.17 (core)", "org 4.3.4 (core)", "packaging 2.7.0 (core)", "schema 3.3.19 (core)", "settings 2.3.8 (core)", "sobject 1.4.19 (core)", "source 3.5.3 (core)", "telemetry 3.6.1 (core)", "templates 56.3.2 (core)", "trust 3.7.13 (core)", "user 3.5.17 (core)" ] }The text was updated successfully, but these errors were encountered: