forcedotcom / SFDX-Data-Move-Utility

SFDMU is a cutting-edge Salesforce data migration tool for seamless org population from other orgs or CSV files. It handles all CRUD operations on multiple related objects in one go.
BSD 3-Clause "New" or "Revised" License
451 stars 76 forks source link

[QUESTION]-Issue with Node while trying to run the command on Windows 10 #615

Closed fedegiust closed 1 year ago

fedegiust commented 1 year ago

Describe the bug When trying to run the command from the command line I'm getting this error

sfdx sfdmu:run --sourceusername SOURCEORG --targetusername SANDBOX --path C:\Users\Usuario\Documents\SFDMU_APP\data\username\Accounts\ --verbose

'"C:\Program Files\Salesforce CLI\bin\node.exe"' is not recognized as an internal or external command,
operable program or batch file.
Command in progress... done

[13:37:46.37] [ERROR] Execution of the command has aborted due to unexpected error: Command failed: sfdx force:org:display --json --targetusername emarsysProd
'"C:\Program Files\Salesforce CLI\bin\node.exe"' is not recognized as an internal or external command,
operable program or batch file.
.
[13:37:46.45] [ERROR] [STACK TRACE] Error: Command failed: sfdx force:org:display --json --targetusername emarsysProd
'"C:\Program Files\Salesforce CLI\bin\node.exe"' is not recognized as an internal or external command,
operable program or batch file.

    at checkExecSyncError (node:child_process:885:11)
    at execSync (node:child_process:957:15)
    at Common.execSfdx (C:\Users\Usuario\AppData\Local\sfdx\node_modules\sfdmu\lib\modules\components\common_components\common.js:196:49)
    at ScriptOrg._setupConnection (C:\Users\Usuario\AppData\Local\sfdx\node_modules\sfdmu\lib\modules\models\script_models\scriptOrg.js:118:53)
    at ScriptOrg.setupAsync (C:\Users\Usuario\AppData\Local\sfdx\node_modules\sfdmu\lib\modules\models\script_models\scriptOrg.js:52:20)
    at Script.setupAsync (C:\Users\Usuario\AppData\Local\sfdx\node_modules\sfdmu\lib\modules\models\script_models\script.js:209:30)
    at async RunCommand.setupObjectSetAsync (C:\Users\Usuario\AppData\Local\sfdx\node_modules\sfdmu\lib\modules\commands_processors\runCommand.js:69:9)
    at async RunCommandExecutor.execute (C:\Users\Usuario\AppData\Local\sfdx\node_modules\sfdmu\lib\modules\commands_processors\runCommandExecutor.js:39:17)
    at async Run.run (C:\Users\Usuario\AppData\Local\sfdx\node_modules\sfdmu\lib\commands\sfdmu\run.js:20:9)
[13:37:46.53] [ERROR] Execution of the command sfdmu:run has been completed. Exit code 1 (COMMAND_UNEXPECTED_ERROR).

Node v18.17.0 sfdx-cli/7.190.2 win32-x64 node-v18.14.1

To Reproduce Not sure, recently I've uptaded SFDX to the latest version and Node 18, I haven't used the plugin for a long time, and I've updated it today.

Expected behavior Expected to run the migration

export.json contents of my export.json

{
    "objects": [
        {
            "operation": "Upsert",
            "externalId": "Name",
            "query": "SELECT Name, Account_Level_Justification__c, Account_Level__c, Account_Management_Team__c, Account_Status__c, Approval_Process_Name__c, Approval_Requested__c, Approval_Status__c, Approval_System_Update__c, Approved__c, Arank__c, AvgCaseCloseTime__c, AvgCaseFirstResponseTime__c, AvgFirstResponseCloseTime__c, Avg_App_Satisfaction__c, Avg_CS_Satisfaction__c, Avg_Monthly_Mailing_Volume__c, B2B__c, B2C__c, Billing__c, COUNTCasesTS__c, CRM_Platform_Other__c, CRM_Platform__c, Challenges__c, Company_Language__c, Concept__c, Contract_Expiration__c, Countries_Languages__c, Country_Manager_Email__c, Current_Business_Focus__c, Current_Challenges__c, Current_E_Mail_Marketing_Solution__c, Current_Issues__c, Customer_Example__c, Customer_Importance__c, Customer_Insights_Bussiness_Intelligence__c, Customer_References__c, Customer_Since__c, Data_Import_Key__c, Data_source_created_by__c, Database_Size__c, Date_of_cancellation__c, Date_of_last_invoice__c, Design__c, Direct_Communications__c, Display_Retargeting__c, Dynamics__c, Ecommerce_Platform_Other__c, Ecommerce_Platform__c, Existing_Solution_Renewal_Date__c, Expected_Monthly_Recurring_Revenue_12_Mo__c, Expected_Recurring_Monthly_Revenue_NOW__c, Facebook_Likes__c, Full_Service__c, Funding_Amount__c, Gigya__c, Has_Current_Automation_Campaigns__c, History_of_Contact_Person__c, Interest_in_Integrations__c, Interest_in_Services__c, Interest_in_Software__c, Is_SAP_Pricing__c, Keywords__c, LID__LinkedIn_Company_Id__c, Last_Application_Survey__c, Last_CRM_Client_Meeting__c, Last_Call__c, Last_Lead_Source__c, Last_Recurring_Revenue_in_EUR__c, Last_Satisfaction_Survey__c, Last_Technology_Update__c, Lead_Score__c, Lead_Source__c, Logo_Use_Not_Approved__c, Logo__c, Magento__c, Manager_of_Owner_Email__c, Multi_channel_automation__c, New_Business_Team__c, Next_CRM_Client_Meeting__c, No_Employees__c, Objectives__c, Office__c, Opt_In_Strategy__c, Opt_Out_Strategy__c, Other_Current_Provider__c, Other_Platform_Other__c, Other_Platform__c, Partner_Commission__c, Performing_Email_recommendations_2__c, Performing_Email_recommendations__c, Performing_Website_recommendations_2__c, Performing_Website_recommendations__c, Potential_for_full__c, Predict__c, Production__c, Products__c, Purchasing_Time_Frame__c, Reason_for_losing_Sub_Level__c, Reason_for_losing_Top_Level__c, Reason_for_losing_customer__c, Recommendation_Personalisation__c, Recommendations_Platform_Other__c, Remarks__c, Revenue_Recovery__c, Risk_Origin__c, Risk_Status__c, Sales_Initiative__c, Salesforce__c, Set_Approver__c, Smart_Insight__c, Source_of_New_Recipients__c, Specify_E_mail_Marketing_Solution__c, Specify_Other_Industry__c, Specify_Other_Sub_Industry__c, Sub_Industry__c, Support_Team__c, System__c, Target_Group__c, Test_Account__c, Total_Opportunity_Amount__c, Type_of_marketing_campaigns__c, Web_Analytics_Platform_Other__c, Web_Extend__c, Website_Pageviews__c, Account_Overview__c, Account_Team_Last_Activity_Date__c, Advertising_Platform__c, Android_MAU__c, Authority_Notes__c, Avg_12_Month_PS_MRR_2018_Static__c, Avg_12_Month_Tech_MRR_2018_Static__c, Avg_Pro_Services_MRR_Last_12_Months__c, Avg_Tech_MRR_Last_12_M_SMS_Adjusted__c, Avg_Technology_MRR_Last_12_Months__c, BP_ID__c, BRM_Exemption__c, Became_a_customer_date_fix__c, Billing_Currency_Money_Maker__c, Billing_State_backup__c, Business_Objectives__c, Buying_Capability__c, C_Suite_Engagement_Start_Date__c, Case_Studies_Press_Releases__c, Client_Engagement_Cohort__c, Client_Relationship_Start_Date__c, Client_Relationship_Stop_Date__c, Client_VAT_No__c, Co_signed_Strategic_Roadmap__c, Cohort_Status__c, Cohort__c, Company_Twitter_Username__c, Custom_SI__c, Customer_Quotes__c, Customer_Service_Platforms__c, DPA_Type__c, DUNS_number__c, Date_First_NBS_Opp_Created__c, Date_Sales_Ownership__c, Date_of_Cancellation_before_CW__c, Date_of_Requested_Re_Engagement__c, Date_of_data_removal__c, Date_of_last_invoice_before_CW__c, Decision_Maker_Available_First_Meeting__c, Decision_Maker_Influencer_Identified__c, DevMark__c, Discovery_Purchased__c, Email_Provider__c, Email__c, Emarsys_Goals__c, Enhance_Category__c, Estimated_Number_of_Products_on_Website__c, Existing_Competitor_Partner__c, Existing_Solution_Partner__c, External_Id__c, Financial_Year_End_Date__c, First_Marketing_Channel_Date__c, Forrester_Assessment_Role__c, Forrester_Assessment_URL__c, GSAM_Suitability_Review__c, Gap_Presentation__c, Hubspot_Nurturing_Membership__c, Import_Date__c, Industry_Analysis__c, KPIs__c, Last_Completed_CRM__c, Last_Completed_Meeting_Date__c, Last_Ownership_Transfer__c, Lost_to_who__c, Lost_to_who_other__c, Marketing_in_Contract__c, Metrics__c, Mobile_Channel_Use__c, Mobile_Marketing_Automation_Other__c, Mobile_Marketing_Automation__c, Money_Maker_Billing_Country__c, Money_Notes__c, Named_Accounts__c, Nbofstores__c, Next_Roadmap_Review__c, Next_Scheduled_CRM__c, No_Marketing_Communications__c, Not_Update_Office__c, Num_B2C_Clients__c, Num_Contacts__c, Operation_Type__c, Owner_Last_Activity_Date__c, Pain_Notes__c, Partner_Tiers__c, Partnership_Type__c, Power_Paragraph__c, Primary_SIC_Code__c, Primary_SIC_Description__c, Product_Area__c, Program_Type__c, Prospecting_Rank__c, Prospecting_Tiers__c, Public_Presentations__c, Ranking_Number__c, Ranking_Type__c, Reason_for_Exemption__c, Recommendations_Provider__c, Region_covered__c, Registered_City__c, Registered_Country__c, Registered_State_Province__c, Registered_Street__c, Registered_Zip_Postal_Code__c, Retain_access_to_accounts__c, Risk_Remarks__c, Roadmap_Publish_Date__c, SDR_Brief__c, STAMP_Percentage_Helper__c, Satisfaction_Survey_Group__c, Satisfaction_Surveys__c, Skip_To__c, Solution_Notes__c, States_covered__c, Status_Before_Closed_Won__c, Strategic_Milestones__c, Strategic_Roadmaps__c, Sub_Brands__c, Support_Active_Users__c, Support_Additional_Users_Adjustment__c, Support_Additional_Users__c, Support_Package_New__c, Support_Package__c, Support_Total_Allowed_Users__c, Support_Weekend_Emergency_Add_On__c, Survey_Batch_Num__c, System_Account__c, Tech_Touch_Category__c, Testimonials_Written_and_Video__c, Timeline_Notes__c, Top_Accounts__c, Transfer_ID__c, Trigger_Notification_API_Name__c, Type_of_Agency__c, Upload_Batch__c, User_Defined_Industry__c, Value_Drivers__c, Web_Analytics_Platform__c, Win_announcements__c, X24_Month_Vision__c, analytics_techs_start__c, eDS_Email_Hosting__c, eDS_Industry__c, eDS_Monthly_Sending_Volume_Num__c, eDS_Monthly_Sending_Volume__c, eDS_Personalized_Volume_Num__c, eDS_Personalized_Volume__c, eDS_Sending_List_Size_Num__c, eDS_Sending_List_Size__c, iOS_MAU__c, isPhysical__c, Approval_for_User__c, Approver__c, Commercial_Owner__c, Current_emarsys_Contract__c, Initial_Opportunity__c, Initial_Recurring_Revenue__c, Initial_emarsys_Contract__c, Inside_Sales_Name__c, Last_Recurring_Revenue__c, Onboarding_Project__c, Partner_Contact__c, Cross_Sell_Owner__c, Current_Risk__c, Global_Account__c, Initial_Smart_Insight_Recurring_Revenue__c, Internal_Sales_Name__c, Last_Opportunity__c, AccountNumber, AccountSource, AnnualRevenue, BillingCity, BillingCountry, BillingCountryCode, BillingGeocodeAccuracy, BillingLatitude, BillingLongitude, BillingPostalCode, BillingState, BillingStateCode, BillingStreet, CurrencyIsoCode, Description, Fax, Industry, Jigsaw, NumberOfEmployees, Phone, ShippingCity, ShippingCountry, ShippingCountryCode, ShippingGeocodeAccuracy, ShippingLatitude, ShippingLongitude, ShippingPostalCode, ShippingState, ShippingStateCode, ShippingStreet, SicDesc, Type, Website, OwnerId, ParentId, RecordTypeId, Id FROM Account WHERE Account_Status__c = 'Submitted Cancellation' AND Date_Of_Last_Invoice__c = LAST_YEAR LIMIT 200"
        },
        {
            "operation": "Insert",
            "externalId": "Id",
            "master": false,
            "query": "SELECT Id FROM AccountContactRole"
        },
        {
            "operation": "Insert",
            "externalId": "Id",
            "master": false,
            "query": "SELECT Id FROM AccountTeamMember"
        },
        {
            "operation": "Upsert",
            "externalId": "Name",
            "master": false,
            "query": "SELECT Auto_Renewal__c, Consent_Type__c, Consent__c, End_Date__c, Justification__c, Start_Date__c, Status__c, Term__c, Account__c, CurrencyIsoCode, Id FROM Consent__c"
        },
        {
            "operation": "Upsert",
            "externalId": "Name",
            "master": false,
            "query": "SELECT Application_Survey__c, Became_a_Lead_Date__c, Became_a_MQL_Date__c, Became_a_SAL_Date__c, Became_a_SQL_Date__c, Became_an_SRL_date__c, Behaviour_Score__c, Billing_Country__c, Block_Listed_Cause__c, Block_Listed__c, CSM_External_Communication__c, Case_Studies__c, Channel_Feedback__c, Clearbit_Company_Description__c, Client_IP__c, Company_Grade__c, Completed_Application_Surveys__c, Completed_Satisfaction_Surveys__c, Contact_Us_Category__c, Contact_Us_Comments__c, Converted_By_Domain_Match__c, Created_from_Lead__c, Demo_Request_Activity_Date__c, Demo_Request_Submission_Date__c, Demographic_Score__c, Double_Opt_In_Date__c, Double_Opt_In_Source__c, Double_Opt_In__c, Duplicate_type__c, Email_Invalid_Cause__c, Email_Invalid__c, Email_Suspended_At__c, Email_Suspended_Cause__c, Email_Suspended__c, Enhance_Communications_Opt_In__c, Enhance_Submission_History__c, Enhance_inquiry_for__c, Enquiry_Type__c, Environments__c, Exclude_from_Satisfaction_Survey__c, External_Id__c, Facebook_Profile__c, First_Marketing_Channel_Date__c, Follow_up_date__c, Forrester_Assessment_Role__c, Forrester_Assessment_URL__c, GA_CID__c, General_Opportunity_Count__c, General_Opportunity_Latest_Date__c, HS_Tradeshow_Meeting_Date__c, HS_Tradeshow_Meeting_Time__c, Hubspot_Evolution_SDR__c, Hubspot_First_Conversion_Date__c, Hubspot_First_Conversion__c, Hubspot_Lead_Score__c, Include_in_Satisfaction_Survey__c, Inquiry_Campaign__c, Inquiry_Count__c, Inquiry_Latest_Date__c, Invalid_Data__c, Invalid_E_Mail__c, Is_this_Contact_a_duplicate__c, Job_Function__c, Job_Level__c, Job_Title__c, LID__LinkedIn_Company_Id__c, LID__LinkedIn_Member_Token__c, Language__c, Last_Campaign_Responded_To_Date__c, Last_Campaign_Responded_To_Member_ID__c, Last_Campaign_Responded_To_Membership__c, Last_Campaign_Responded_To__c, Last_Lead_Source_Date__c, Last_Lead_Source__c, Latest_Person_Source__c, Latest_Recycle_Date__c, Lead_Created_Date__c, Lead_Nurturing_Mailings_Clicked__c, Lead_Nurturing_Programme__c, Lead_Nurturing_Programme_old__c, Lead_Priority__c, Lead_Return_Reason__c, Lead_Score_Feedback__c, Lead_Score__c, Lead_Status__c, Left_Company__c, Level_of_Knowledge__c, Lifecycle_Stage__c, LinkedIn_Profile__c, MQL_Campaign__c, MQL_Count__c, MQL_Latest_Date__c, Mailing_State_backup__c, Marketing_Collected_Information__c, Marketing_Lifecycle_Stage__c, Marketing_Suspended_Cause__c, Marketing_Suspended__c, Member_Status_Update_Date__c, NPS_Survey_Hash__c, NPS_Survey_Phone_Call_Follow_up_Notes__c, NPS_Survey_Recipient__c, Onboarding_Completed_Questionnaire__c, Onboarding_Suite_From_Email_Address__c, Opt_In_Date_Time__c, Opt_In_Date__c, Opt_In_IP__c, Opt_In_Implied_Date__c, Opt_In_Implied_Expiration_Date__c, Opt_In_Implied__c, Opt_In_Referrer__c, Opt_In_Source_Detail__c, Opt_In_Source__c, Opt_In__c, Opt_Out_Date__c, Opt_Out_Retargeting__c, Original_General_Opportunity_Date__c, Original_Inquiry_Date__c, Original_MQL_Date__c, Original_Person_Source__c, Original_Pre_Sales_Opportunity_Date__c, Original_SAL_Date__c, Original_Source_Drill_down_1__c, Original_Source_Drill_down_2__c, Original_Source__c, Other__c, Outreach_Last_engaged_date__c, Outreach_opt_in__c, Outreach_status__c, Partner_Company__c, Partner_Email__c, Partner_Interest__c, Person_Class__c, Person_Family__c, Person_Score_Mirrored__c, Person_Source_History__c, Person_Source__c, Post_Implementation_Survey__c, Pre_Sales_Opportunity_Count__c, Pre_Sales_Opportunity_Latest_Date__c, Prefix_to_Lastname__c, Privacy_Law__c, Recycle_Count__c, Role_in_E_Mail_Marketing__c, SAL_Count__c, SAL_Latest_Date__c, SAP_Rep_Employee_ID__c, SAP_Rep_First_Name__c, SAP_Rep_Job_Title__c, SAP_Rep_Last_Name__c, SAP_Rep_Work_Email__c, SAP_Territory__c, Sales_DNC__c, Satisfaction_Survey_Group__c, Satisfaction_Surveys__c, Social_Last_Source__c, Software_Update_Newsletter_Opt_In__c, Solution_Notes__c, Suffix_to_Lastname__c, Suite_Environments__c, Suite_No_Open_Indication_Last_12m__c, TAM__c, TeamWhoCreated__c, Test_Record__c, Top_250__c, Trade_Show_Comments__c, Trained__c, Twitter_Profile__c, Unsubscribed_Cause__c, Unsubscribed_Reason__c, Whitepapers__c, Zendesk_Active__c, Zendesk_Status__c, Zendesk_User_Account_Type__c, Zendesk_User_ID__c, emarsys_Newsletter_Opt__c, g2_category_pageviews__c, g2_company_name__c, g2_comparison_pageviews__c, g2_domain__c, g2_market_score__c, g2_pages_viewed__c, g2_product_profile_pageviews__c, g2_sponsored_content_pageviews__c, g2_total_pageviews__c, mkto_si__Last_Interesting_Moment_Type__c, Global_Account__c, Last_Survey_Sent__c, Partner_Account__c, AssistantName, AssistantPhone, Birthdate, CurrencyIsoCode, Department, Description, Email, EmailBouncedDate, EmailBouncedReason, Fax, FirstName, HomePhone, Jigsaw, LastName, LeadSource, MailingCity, MailingCountry, MailingCountryCode, MailingGeocodeAccuracy, MailingLatitude, MailingLongitude, MailingPostalCode, MailingState, MailingStateCode, MailingStreet, MobilePhone, OtherCity, OtherCountry, OtherCountryCode, OtherGeocodeAccuracy, OtherLatitude, OtherLongitude, OtherPhone, OtherPostalCode, OtherState, OtherStateCode, OtherStreet, Phone, Salutation, Title, AccountId, IndividualId, OwnerId, ReportsToId, Id FROM Contact"
        },
        {
            "operation": "Upsert",
            "externalId": "Name",
            "master": false,
            "query": "SELECT Activation_Date__c, Auto_Renewal_Opportunity_Created__c, Billing_Date__c, Contacts_in_Database__c, DPA_Type__c, Deactivation_Date__c, Discovery_Page_Views_Overage_Rate__c, Discovery_Page_Views_Total__c, Emails_Overage_Rate__c, Emails_Total__c, End_date__c, Expiration_Notice__c, Helper__c, LayoutView__c, Max_Monthly_Active_Users__c, Minimum_Monthly_Fullservices_Revenue__c, Minimum_Monthly_Revenue__c, Minimum_Monthly_Software_Revenue__c, Monkey_Contract_ID__c, Monthly_Pro_Services_Recurring_Revenue__c, Page_Views_Overage_Rate__c, Page_Views_Total__c, Professional_Services_One_Time__c, Renewal_Time__c, Renewed__c, SMS_Commitment__c, Start_date__c, Status__c, Term__c, Trial__c, Renewed_Contract__c, Account__c, CurrencyIsoCode, Id FROM emarsys_Contract__c"
        },
        {
            "operation": "Upsert",
            "externalId": "Name",
            "master": false,
            "query": "SELECT Name, Closed_Date__c, Completed_Date__c, Contract_Due_Date__c, Create_Tasks__c, Created_By_Salesforce__c, Custom_Dev_Team__c, Deliverability_Team__c, Escalated__c, Implementation_Team__c, Invoicing_Status__c, Last_Update_Date__c, Last_Update__c, Opportunity_Record_Type__c, Prioritized__c, Production_Manager__c, Production_Team__c, Project_Group__c, Project_Nature__c, Project_at_Risk__c, Strategic_Services_Team__c, Training_Team__c, mavenlink__Access_Level__c, mavenlink__Archived__c, mavenlink__Auto_Expense_Approval__c, mavenlink__Auto_Time_Approval__c, mavenlink__Automatically_Archived__c, mavenlink__Automatically_Created__c, mavenlink__Budget_Used__c, mavenlink__Budgeted__c, mavenlink__Can_Create_Line_Items__c, mavenlink__Can_Invite__c, mavenlink__Change_Orders_Enabled__c, mavenlink__Child_Object_Last_Updated_At__c, mavenlink__Creator_Id__c, mavenlink__Currency__c, mavenlink__Custom_Field_Source_Update_JSON__c, mavenlink__Default_Rate__c, mavenlink__DescriptionArea__c, mavenlink__Description__c, mavenlink__Effective_Due_Date__c, mavenlink__Expense_Last_Updated_At__c, mavenlink__Fixed_Fee_By_Default__c, mavenlink__GL_Account_Id__c, mavenlink__GL_Project_Create_Date__c, mavenlink__Has_Budget_Access__c, mavenlink__Mavenlink_Id__c, mavenlink__Mavenlink_Url__c, mavenlink__Next_Milestone__c, mavenlink__Non_Billable_By_Default__c, mavenlink__Object_Type__c, mavenlink__Organizations_Done__c, mavenlink__Over_Budget__c, mavenlink__Parent_Opp_Stage__c, mavenlink__Participant_Ids__c, mavenlink__Percentage_Complete__c, mavenlink__Posts_Require_Privacy_Decision__c, mavenlink__Price_In_Cents__c, mavenlink__Price__c, mavenlink__Project_Account_Group__c, mavenlink__Project_Department__c, mavenlink__Project_Geography__c, mavenlink__Project_Manager__c, mavenlink__Project_Rate_Card__c, mavenlink__Project_Title__c, mavenlink__Project_Type__c, mavenlink__Rate_Card_Name__c, mavenlink__Related_OLI__c, mavenlink__Role__c, mavenlink__Start_Date__c, mavenlink__StatusColor__c, mavenlink__StatusKey__c, mavenlink__Status__c, mavenlink__Stories_Complete__c, mavenlink__Stories_Total__c, mavenlink__Time_Entry_Last_Updated_At__c, mavenlink__Account__c, mavenlink__Opportunity__c, CurrencyIsoCode, OwnerId, Id FROM mavenlink__Mavenlink_Project__c"
        },
        {
            "operation": "Upsert",
            "externalId": "Name",
            "master": false,
            "query": "SELECT Name, Discount__c, List_Price__c, Quantity__c, Unit_Price__c, mavenlink__GL_Task_Id__c, mavenlink__Product_Code__c, mavenlink__Related_OLI__c, mavenlink__Task_Bill_Type__c, mavenlink__Task_Budget_Amount__c, mavenlink__Task_Budget_Used_Amount__c, mavenlink__Task_Budget_Used__c, mavenlink__Task_Budget__c, mavenlink__Task_Complete__c, mavenlink__Task_Description__c, mavenlink__Task_Hours__c, mavenlink__Task_Mavenlink_Id__c, mavenlink__Task_Parent_Project_Name__c, mavenlink__Task_Parent_Project__c, mavenlink__Task_Rate__c, mavenlink__Task_Role__c, mavenlink__Task_Status__c, mavenlink__Task_Target_Date__c, mavenlink__Task_Type_Selection__c, mavenlink__Task_Type__c, mavenlink__Task_Weight__c, SKU__c, mavenlink__Mavenlink_Project__c, CurrencyIsoCode, Id FROM mavenlink__Mavenlink_Task__c"
        },
        {
            "operation": "Upsert",
            "externalId": "Name",
            "master": false,
            "query": "SELECT Name, Actual_Close_Date__c, Additional_discovery_views_annually__c, Additional_emails_annually__c, Additional_page_views_annually__c, Apply_Multi_year_pricing__c, Approval_Date__c, Approval_Process_Escalated__c, Approval_Status__c, Approved_by_Deal_Desk1__c, Approved_by_Deal_Desk__c, Auto_Renew_Type__c, Auto_Renew__c, Avg_12_Month_PS_MRR_2018_S_fixed__c, Avg_12_Month_Tech_MRR_2018_S_fixed__c, Avg_MRR_Last_12_Months_fixed__c, Avg_MRR_Last_3_Months_fixed__c, Avg_ProServices_MRR_Last_12_Months_fixed__c, Avg_Technology_MRR_Last_12_Months_fixed__c, Billing_Format__c, Billing_Method__c, Billing_in_Advance_Upgrade__c, Bus_Issue_Still_need_to_uncover__c, Bus_Value_Still_need_to_uncover__c, Business_Issue__c, Business_Value__c, CRM_Platform_Other__c, CRM_Platform__c, Campaigns_Per_Month__c, Client_Success_Notes__c, Commercial_Agreement_Additional_Terms__c, Competitors__c, Contacts_in_Database__c, Contract_Duration_in_Months__c, Contract_Value_Change__c, Converted_From_Trial__c, Create_External_Sales_Opportunity__c, Created_from_Lead__c, Created_with_Stage__c, Cross_sell_Professional_Services_MRR__c, Cross_sell_Technology_MRR__c, Current_Contract_MRR_Incl_FS_fixed__c, Current_Contract_MRR_fixed__c, Current_Contract_Pro_Services_MRR_fixed__c, Current_Contract_Technology_MRR_fixed__c, Custom_Development_SOW_Text__c, DVM2__c, Decision_expected__c, Ecommerce_Platform_Other__c, Ecommerce_Platform__c, Email_Volume__c, End_date__c, Executive_Sponsor_Notes__c, Executive_Sponsor_Status_fixed__c, FlowRollupCustomSolution2__c, FlowrollupPSTechMRR2__c, FlowrollupPSTechMRRConstant2__c, FlowrollupPSTechMRRY22__c, FlowrollupPSTechMRRY32__c, FlowrollupPSTechMRRY42__c, FlowrollupPSTechMRRY52__c, FlowrollupTechMRRConstant2__c, FlowrollupTechMRRY22__c, FlowrollupTechMRRY32__c, FlowrollupTechMRRY42__c, FlowrollupTechMRRY52__c, Forecast_Category__c, Forecast_Full_Services_MRR__c, Forecast_MRR__c, Forecast_Notes__c, Forecast_Professional_Services_One_time__c, Functionality__c, Handover_Date__c, Has_Executive_Sponsor__c, Has_Solution_Consultant__c, Hide_Negative_Uplift__c, Highest_Stage__c, Implementation_Billing_Terms__c, Implementation_Notes__c, Incumbent_Solution_Other__c, Incumbent_Solution__c, Influenced_Steps__c, Initiative_Source__c, IsLocked__c, Item__c, LID__Is_Influenced__c, LID__LinkedIn_Company_Id__c, Link_to_Handover__c, List_Size__c, Lost_To_Which_Competitor_List__c, Lost_To_Which_Competitor__c, MRR_EUR__c, MRR_Incl_FS__c, MRR__c, MYCOLIisChanged__c, Manager_Email__c, Minimum_Commitment_Value__c, Monthly_Recurring_Fullservice_Revenue__c, Monthly_Recurring_Services_Revenue__c, Monthly_Recurring_Software_Revenue__c, Multi_year_contract_type__c, New_Pricing_used__c, Next_Steps__c, Not_Blank_DVM2__c, Not_Blank_Value2__c, Nurture_Notes__c, Office__c, One_Time_Services_Revenue__c, Opportunity_Billing_Mode__c, Other_Current_Provider__c, Other_Platform_Other__c, Other_Platform__c, Owner_Manager__c, Package_Additionals_Discount_Max__c, Package_Additionals_Discount__c, Package_Discount_Max__c, Package_Discount__c, Package_Growth_Database_Size__c, Package_Growth_Fee__c, Package_Professional_Services_Discount__c, Package__c, Page_Views__c, Partner_Involvement__c, Partner_Opportunity_Type__c, Payment_Terms_Net_Days__c, Period__c, Pers_Value_Still_need_to_uncover__c, Personal_Value__c, Plan_Still_need_to_uncover__c, Plan__c, Power_Still_need_to_uncover__c, Power__c, Predicted_MRR__c, Presales_Ownership__c, Pricing_Model__c, Pricing_Notes__c, Problem_Still_need_to_uncover__c, Problem__c, Product_Type__c, Professional_Services_Discount__c, Quantifiable__c, Quote_Id__c, Quote_Link__c, Quote_Status__c, Quote_Submit_Approval__c, RFP_Attached__c, RFP_Opportunity__c, Reason_For_Losing__c, Reason_For_Negative_Uplift__c, Reason_for_losing_category__c, Reason_for_losing_child__c, Reason_for_losing_parent__c, Reasons_For_Losing__c, Recurring_One_Time__c, Remarks__c, Rollup_Other_Revenue__c, Rollup_Professional_Services_MRR__c, Rollup_Professional_Services__c, Rollup_Technology_MRR__c, Send_Frequency__c, Service_provided__c, Services_Billing_Terms__c, Services_billing_terms_other__c, Slack_Sent__c, SolCon_Components_Completed__c, SolCon_Estimated_Close_Date__c, SolCon_Handover_Document_attached__c, SolCon_Notes__c, Sol_Still_need_to_uncover__c, Solution__c, Source__c, Specify_Other_Competitors__c, Stage_Before_Closed_Lost__c, Stage_Before_Closed_Won__c, Stage_changed_from_Planned__c, Suite_Text__c, SystemFieldOR__c, SystemFieldPM__c, SystemFieldPO__c, SystemFieldTM__c, SystemField_PUS__c, SystemField_TUS__c, Technology_MRRFlowrollup12__c, Technology_MRR_fixed__c, TestIsRunning__c, Time_bound__c, Time_of_Send__c, Total_Commissionable_Revenue__c, Total_Trial_Technology_MRR__c, Total_Value_Of_Committed_Contract__c, Total_Value_of_Full_Service__c, Type__c, Uplift_EUR__c, Uplift_Professional_Services_fixed__c, Uplift_Technology_fixed__c, Uplift_fixed__c, Upsales_Professional_Services_MRR__c, Upsales_Technology_MRR__c, Valid_until__c, Value3__c, Web_Analytics_Platform_Other__c, Web_Analytics_Platform__c, Zeiterfassung__c, Zendesk_Ticket_Id__c, isLeadSourceAutoPopulated__c, is_Accepted__c, mavenlink__Mavenlink_Create_Projects_No__c, mavenlink__Project_BD_Created__c, mavenlink__Project_Created__c, Account_Cross_Sell_Owner__c, Contact__c, Country_Manager__c, Initial_Emarsys_Contract__c, Initial_Opportunity__c, Internal_Sales_Name__c, Partner_Account__c, Presales_Opportunity__c, Product_Bundle__c, Product_Plan__c, emarsys_Login_Account__c, Amount, CloseDate, CurrencyIsoCode, Description, ForecastCategoryName, IsExcludedFromTerritory2Filter, LeadSource, NextStep, StageName, Type, AccountId, CampaignId, ContractId, OwnerId, Pricebook2Id, RecordTypeId, Territory2Id, ContactId, Id FROM Opportunity"
        },
        {
            "operation": "Upsert",
            "externalId": "Name",
            "master": false,
            "query": "SELECT Category__c, Commissionable_Revenue__c, Contract_Duration__c, Cross_sell__c, Discount_Approved__c, Discount__c, Family__c, Finance_Technology_MRR__c, First_Invoice__c, Flag_Code__c, Migrated_Data__c, Multi_Year_Contract__c, Multi_year_contract_type__c, Non_committed_MRR__c, Of_Multi_Year__c, Opportunity_Stage__c, Package_Name__c, Pricing_Parameters__c, Product_Code__c, Revenue_Nature__c, Sales_Price_Annually__c, Sales_Price_Annually_original__c, Sort_Order__c, Sub_Category__c, System__c, Trial__c, mavenlink__ML_Sent_to_Mavenlink__c, Actual_First_Invoice__c, Asset__c, Description, Discount, Quantity, ServiceDate, SortOrder, UnitPrice, OpportunityId, PricebookEntryId, Product2Id, Id FROM OpportunityLineItem"
        }
    ],
    "promptOnMissingParentObjects": false,
    "promptOnIssuesInCSVFiles": false
}

Log file Attach your full .log file.

_target.csv file. When you have an issue with failed rows, attach the dump of the _target.csv file containing the error messages (at least 1-2 relevant full rows).

hknokh2 commented 1 year ago

Hello,

Thank you for reaching out to me.

It appears that the nodejs/sfdx-cli installation might not have been successful. There are two potential reasons for this issue:

While I cannot determine the exact reason for the issue from my end, I recommend investigating the installation and access permissions on your side. Rest assured, this issue does not seem to be directly related to SFDMU.

As a further check, I tested the latest versions of node/sfdx in my environment, and everything is working smoothly. Here are some screenshots for reference:

image image

Please review your setup and ensure that nodejs and sfdx are correctly installed and have the necessary permissions. If you need any further assistance, feel free to reach out.

Cheers,

fedegiust commented 1 year ago

But why is it looking for node.exe under the salesforce cli folder and not the env path?

C:\Program Files\Salesforce CLI\bin\node.exe

image

image

I don't have a node.exe neither in Salesforce CLI or sf folder

fedegiust commented 1 year ago

I just found out the issue!

There were two versions of SFDX on this work laptop, I recently installed the latest .exe downloaded from the Salesfoce tools site but the old was still there.

I uninstalled the old one, reinstalled the plugins and it's working fine now!

hknokh2 commented 1 year ago

I don't know why this exception is thrown internally by SFDX. I never call node.exe in my code. Try reinstalling Node.js / SFDX. It looks like an issue related to your specific environment. Unfortunately, I can't help you with this. Regards

hknokh2 commented 1 year ago

Happy to hear that it's working now!