Skip to main content
Solved

Name Tool ID# not found inside D at [1:97]

  • September 11, 2024
  • 4 replies
  • 70 views

Forum|alt.badge.img

2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [SQL |Cache ] Cache failed: [500] Could not execute the specified command: Name Tool ID# not found inside D at [1:97]
2024-09-10T00:52:03.708-06:00    0    [6|Q-Id]    [SQL |Cache ] Replication Failed. Error:[500] Could not execute the specified command: Name Tool ID# not found inside D at [1:97]
2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [RealDB:System.Data.CData.SQL]The connection is disconnected.
2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [RealDB:GoogleBigQuery]The connection is disconnected.
2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [RealDB:SQLite]The connection is disconnected.
2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [SQL |Messag] Query Failed: [REPLICATE [tools_data_testing] WITH _id = '5a2DAIBt+eVwYnh0y2b6zA==' SELECT [Access Method] AS [access_method], [Actively Selling] AS [actively_selling], [Actual Deployment Date] AS [actual_deployment_date], [Additional Languages] AS [additional_languages], [AKA Names] AS [aka_names], [Application Platform Used] AS [application_platform_used], [Application Type] AS [application_type], [Will asset data be used to benchmark an industry?] AS [asset_data_benchmark_industry], [Will asset data be used to improve Accenture's datasets/libraries?] AS [asset_data_improve_accentures_datasets_libraries], [Will asset data be used to monitor an Accenture employee's individual productivity?] AS [asset_data_monitor_accenture_employees_individual_productivity], [Assumptions and Dependencies] AS [assumptions_and_dependencies], [Availability Profile] AS [availability_profile], [Black Duck Last Scan Date] AS [black_duck_last_scan_date], [Is the Black Duck scan current for the use case] AS [black_duck_scan_current_for_use_case], [Black Duck Scan Results] AS [black_duck_scan_results], [BPOSE Status] AS [bpose_status], [Business Outcome] AS [business_outcome], [Will the client receive any output from the service?] AS [client_receive_any_output_from_service], [Client-Specific Tool?] AS [client_specific_tool], [Client Use after the Services Engagement Ends] AS [client_use_after_services_engagement_ends], [Client Use as Part of BPS Service Delivery] AS [client_use_as_part_of_bps_service_delivery], [Client Use as Part of Pre-Contract] AS [client_use_as_part_of_pre_contract], [Client User Access Level] AS [client_user_access_level], [Cost File Link/Notes] AS [cost_file_link_notes], [Cost Model Last Updated] AS [cost_model_last_updated], [Cost Model Status] AS [cost_model_status], [Cost Model Type] AS [cost_model_type], [Current Use Case Details] AS [current_use_case_details], [Data Refresh Status] AS [data_refresh_status], [Date Modified] AS [date_modified], [Does the Default 'Limited Access' Provision accurately describe the access Client will receive the tool] AS [default_limited_access_provision_describe_client_will_receive_tool], [Deployment Model] AS [deployment_model], [ECATT Run Date] AS [ecatt_run_date], [ECATT Status] AS [ecatt_status], [End User Type] AS [end_user_type], [Exhibits #] AS [exhibits_no], [Foundation Tool] AS [foundation_tool], [Functional Area (Primary)] AS [functional_area_primary], [Geographic Scope] AS [geographic_scope], [Hierarchy Sub-Type] AS [hierarchy_sub_type], [Hierarchy Type] AS [hierarchy_type], [How will the client end users access the tool?] AS [how_client_end_users_access_tool], [Implementation Timelines] AS [implementation_timelines], [Include in client specific Inventory] AS [include_in_client_specific_inventory], [Info Questionnaire Status] AS [info_questionnaire_status], [Ingest Accenture employee data] AS [ingest_accenture_employee_data], [Ingest Client Data?] AS [ingest_client_data], [Ingest data that Accenture creates or derives from ingested client data?] AS [ingest_data_accenture_creates_or_derives_ingested_client_data], [Ingest data owned or controlled by the client that is provided or made accessible to Accenture by the client?] AS [ingest_data_owned_client_controlled_or_client_accessible], [Ingest Personal Contact Information?] AS [ingest_personal_contact_information], [Ingest Sensitive Personal Data?] AS [ingest_sensitive_personal_data], [Ingest Third Party Data?] AS [ingest_third_party_data], [Internal Accenture Use to Support BPS Delivery] AS [internal_accenture_support_bps_delivery], [Internal Accenture Use to Support Pre-Contract] AS [internal_accenture_support_pre_contract], [Internal Accenture Use by Non-Operations Accenture Services] AS [internal_accenture_use_non_operations_accenture_services], [iOGBS Pre-approved] AS [iogbs_pre_approved], [IP Ownership - Accenture Proprietary Components] AS [ip_ownership_accenture_proprietary_components], [IP Ownership - Open Source] AS [ip_ownership_open_source], [IP Ownership - Third Party Components] AS [ip_ownership_third_party_components], [Is the data aggregated] AS [is_data_aggregated], [Is the data anonymised] AS [is_data_anonymised], [Is There A Known Limitation That Prevents The Asset From Being Deployed To Governmental Clients?] AS [known_limitation_preventing_asset_governmental_clients], [Landscape Offerings] AS [landscape_offerings], [Language List] AS [language_list], [Last Refreshed Date] AS [last_refreshed_date], [Has the latest Black Duck scan been approved by OSS Legal for the current use case?] AS [latest_black_duck_scan_approved_oss_legal_current_use_case], [LR ID#] AS [lr_id_no], [Mandatory] AS [mandatory], [Mandatory Offerings] AS [mandatory_offerings], [Marketing Platform] AS [marketing_platform], [Multilingual Support] AS [multilingual_support], [Offering (Primary)] AS [offering_primary], [1AAA Onboarding Status] AS [onboarding_status_1aaa], [Has an OSS scan of the Bill of Materials been conducted] AS [oss_scan_of_bill_of_materials_conducted], [Have other Services outside Operations requested data from this asset?] AS [other_services_outside_operations_requested_data_asset], [Other Use Case Not Identified] AS [other_use_case_not_identified], [Product Classification] AS [product_classification], [Product Roadmap Attachment] AS [product_roadmap_attachment], [Is there a product roadmap available for this asset?] AS [product_roadmap_available_for_asset], [Product Roadmap Link] AS [product_roadmap_link], [Refresh Due Date] AS [refresh_due_date], [Refresh Initiated Date] AS [refresh_initiated_date], [Refresh Priority] AS [refresh_priority], [Have you registered your invention with the IP Legal via the Inventions Disclosure Form?] AS [registered_invention_ip_legal_via_inventions_disclosure_form], [What type of regulated data?] AS [regulated_data_type], [Sched T: OSC Approval Status] AS [sched_t_osc_approval_status], [Sched T: TfO Contracting Approval Status] AS [sched_t_tfo_contracting_approval_status], [Schedule T Feed Status] AS [schedule_t_feed_status], [Schedule T Last Upload] AS [schedule_t_last_upload], [Schedule T Notes] AS [schedule_t_notes], [Scheduled Deployment Date] AS [scheduled_deployment_date], [Which Services organization?] AS [services_organization], [Solution Bundle] AS [solution_bundle], [Source of Tool Entry (Ref ID)] AS [source_of_tool_entry_ref_id], [Specific Region/Country] AS [specific_region_country], [State Other Use Cases] AS [state_other_use_cases], [Status - Legal Review] AS [status_legal_review], [Sub-Offering (Primary)] AS [sub_offering_primary], [SWB Feed Last Updated] AS [swb_feed_last_updated], [SWB Feed Status] AS [swb_feed_status], [SWB Tech Tool Name] AS [swb_tech_tool_name], [Synops Classification] AS [synops_classification], [Make Client Data Available for SynOps or other Cross-Client Data Insights Purposes?] AS [synops_client_data_available_or_cross_client_data_insights_purposes], [1AAA-SynOps Qualified] AS [synops_qualified_1aaa], [Technology Org Alignment] AS [technology_org_alignment], [Terms of Use] AS [terms_of_use], [Terms of Use File] AS [terms_of_use_file], [Are there any terms the vendor requires Accenture to have in our client contract?] AS [terms_vendor_requires_accenture_in_client_contract], [TfO Factory] AS [tfo_factory], [Third Party Data Source] AS [third_party_data_source], [To be decommissioned on] AS [to_be_decommissioned_on], [Tool Acronym] AS [tool_acronym], [Tool Description] AS [tool_description], [Does the tool have biometric recognition functionality?] AS [tool_have_biometric_recognition_functionality], [Tool ID#] AS [tool_id_no], [Does the tool learn from data ingested (AI/ML)?] AS [tool_learn_from_data_ingested_ai_ml], [Tool Name] AS [tool_name], [Tool Purpose] AS [tool_purpose], [What type of data output will the client receive?] AS [type_of_data_output_will_client_receive], [Types of Governmental Clients] AS [types_of_governmental_clients], [What employee data] AS [what_employee_data], [Which data lake?] AS [which_data_lake], [Will the data from this asset feed a data lake] AS [will_data_from_this_asset_feed_a_data_lake] FROM [dbo].[QB_ToolsData] AS [WITH]]. Error: [500] Could not execute the specified command: Name Tool ID# not found inside D at [1:97]
2024-09-10T00:52:03.708-06:00    2    [6|Q-Id]    [500] Could not execute the specified command: Name Tool ID# not found inside D at [1:97]
 

Can someone help with this error. Thank you

Best answer by Ethem Q

Hi @loisine.ann.mendoza,

The error message would indicate an issue with the column name [Tool Id#] in the destination table most likely. In your last comment, you mentioned that it works when you run the task with History Mode disabled. There is one thing I would like to note about History Mode. This option requires that the destination table does not exist for the initial History Mode run, so please make sure you enable the Drop Table option for at least your first History Mode run. 

You can find more information about this in our documentation below: 

 https://cdn.cdata.com/help/ASJ/sync/Features.html#history-mode 

 

If you keep facing issues or are the above answer is unclear for you feel free to reach out to the support team at [email protected] and one of our Sync support team members will further assist you.

This topic has been closed for replies.

4 replies

Forum|alt.badge.img+1
  • Influencer
  • September 11, 2024

You should provide more detail as to the source database/connection and the table or file.

Although this looks like it’s some sort of survey table where the columns are the question names.  They are quite long and contain special characters.  Not a good practice.


Forum|alt.badge.img
Source is cdata sql ,destination is bq

 


Forum|alt.badge.img

When I enabled the History mode, I received that error, however this one works when it's disabled.


Ethem Q
Forum|alt.badge.img
  • Employee
  • Answer
  • September 16, 2024

Hi @loisine.ann.mendoza,

The error message would indicate an issue with the column name [Tool Id#] in the destination table most likely. In your last comment, you mentioned that it works when you run the task with History Mode disabled. There is one thing I would like to note about History Mode. This option requires that the destination table does not exist for the initial History Mode run, so please make sure you enable the Drop Table option for at least your first History Mode run. 

You can find more information about this in our documentation below: 

 https://cdn.cdata.com/help/ASJ/sync/Features.html#history-mode 

 

If you keep facing issues or are the above answer is unclear for you feel free to reach out to the support team at [email protected] and one of our Sync support team members will further assist you.