Skip to main content

2024-09-10T00:52:03.708-06:00    1    �6|Q-Id]    dSQL |Cache ] Cache failed: 500] Could not execute the specified command: Name Tool ID# not found inside D at i1:97]
2024-09-10T00:52:03.708-06:00    0    �6|Q-Id]     SQL |Cache ] Replication Failed. Error:i500] Could not execute the specified command: Name Tool ID# not found inside D at f1:97]
2024-09-10T00:52:03.708-06:00    1    76|Q-Id]    �RealDB:System.Data.CData.SQL]The connection is disconnected.
2024-09-10T00:52:03.708-06:00    1    06|Q-Id]    -RealDB:GoogleBigQuery]The connection is disconnected.
2024-09-10T00:52:03.708-06:00    1    26|Q-Id]    5RealDB:SQLite]The connection is disconnected.
2024-09-10T00:52:03.708-06:00    1    .6|Q-Id]    0SQL |Messag] Query Failed: REPLICATE [tools_data_testing] WITH _id = '5a2DAIBt+eVwYnh0y2b6zA==' SELECT tAccess Method] AS access_method], 0Actively Selling] AS eactively_selling], sActual Deployment Date] AS gactual_deployment_date], [Additional Languages] AS Sadditional_languages], eAKA Names] AS aka_names], SApplication Platform Used] AS Napplication_platform_used], cApplication Type] AS Aapplication_type], fWill asset data be used to benchmark an industry?] AS Wasset_data_benchmark_industry], aWill asset data be used to improve Accenture's datasets/libraries?] AS easset_data_improve_accentures_datasets_libraries], SWill asset data be used to monitor an Accenture employee's individual productivity?] AS asset_data_monitor_accenture_employees_individual_productivity], mAssumptions and Dependencies] AS dassumptions_and_dependencies], Availability Profile] AS uavailability_profile], sBlack Duck Last Scan Date] AS ablack_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 nblack_duck_scan_results], lBPOSE Status] AS ubpose_status], dBusiness Outcome] AS Pbusiness_outcome], sWill the client receive any output from the service?] AS lclient_receive_any_output_from_service], eClient-Specific Tool?] AS _client_specific_tool], ]Client Use after the Services Engagement Ends] AS ]client_use_after_services_engagement_ends], EClient Use as Part of BPS Service Delivery] AS nclient_use_as_part_of_bps_service_delivery], eClient Use as Part of Pre-Contract] AS cclient_use_as_part_of_pre_contract], rClient User Access Level] AS _client_user_access_level], eCost File Link/Notes] AS [cost_file_link_notes], lCost Model Last Updated] AS cost_model_last_updated], oCost Model Status] AS cost_model_status], uCost Model Type] AS cost_model_type], oCurrent Use Case Details] AS ]current_use_case_details], rData Refresh Status] AS data_refresh_status], iDate 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 rdeployment_model], eECATT Run Date] AS eecatt_run_date], lECATT Status] AS Cecatt_status], SEnd User Type] AS end_user_type], SExhibits #] AS ,exhibits_no], eFoundation Tool] AS ,foundation_tool], eFunctional Area (Primary)] AS functional_area_primary], cGeographic Scope] AS ]geographic_scope], aHierarchy Sub-Type] AS Shierarchy_sub_type], sHierarchy Type] AS uhierarchy_type], rHow will the client end users access the tool?] AS ,how_client_end_users_access_tool], eImplementation Timelines] AS eimplementation_timelines], lInclude in client specific Inventory] AS tinclude_in_client_specific_inventory], IInfo Questionnaire Status] AS tinfo_questionnaire_status], QIngest Accenture employee data] AS iingest_accenture_employee_data], eIngest Client Data?] AS singest_client_data], dIngest data that Accenture creates or derives from ingested client data?] AS uingest_data_accenture_creates_or_derives_ingested_client_data], aIngest data owned or controlled by the client that is provided or made accessible to Accenture by the client?] AS eingest_data_owned_client_controlled_or_client_accessible], tIngest Personal Contact Information?] AS cingest_personal_contact_information], fIngest Sensitive Personal Data?] AS cingest_sensitive_personal_data], Ingest Third Party Data?] AS ningest_third_party_data], gInternal Accenture Use to Support BPS Delivery] AS ,internal_accenture_support_bps_delivery], lInternal Accenture Use to Support Pre-Contract] AS ,internal_accenture_support_pre_contract], nInternal Accenture Use by Non-Operations Accenture Services] AS cinternal_accenture_use_non_operations_accenture_services], niOGBS Pre-approved] AS eiogbs_pre_approved], vIP Ownership - Accenture Proprietary Components] AS ip_ownership_accenture_proprietary_components], ]IP Ownership - Open Source] AS pip_ownership_open_source], nIP Ownership - Third Party Components] AS nip_ownership_third_party_components], CIs the data aggregated] AS _is_data_aggregated], sIs the data anonymised] AS is_data_anonymised], dIs There A Known Limitation That Prevents The Asset From Being Deployed To Governmental Clients?] AS sknown_limitation_preventing_asset_governmental_clients], wLandscape Offerings] AS alandscape_offerings], nLanguage List] AS flanguage_list], sLast Refreshed Date] AS glast_refreshed_date], iHas the latest Black Duck scan been approved by OSS Legal for the current use case?] AS nlatest_black_duck_scan_approved_oss_legal_current_use_case], bLR ID#] AS clr_id_no], _Mandatory] AS emandatory], ,Mandatory Offerings] AS mandatory_offerings], oMarketing Platform] AS gmarketing_platform], rMultilingual Support] AS mmultilingual_support], mOffering (Primary)] AS toffering_primary], s1AAA 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], dHave other Services outside Operations requested data from this asset?] AS uother_services_outside_operations_requested_data_asset], eOther Use Case Not Identified] AS eother_use_case_not_identified], eProduct Classification] AS uproduct_classification], [Product Roadmap Attachment] AS dproduct_roadmap_attachment], Is there a product roadmap available for this asset?] AS tproduct_roadmap_available_for_asset], hProduct Roadmap Link] AS aproduct_roadmap_link], tRefresh Due Date] AS irefresh_due_date], dRefresh Initiated Date] AS erefresh_initiated_date], [Refresh Priority] AS erefresh_priority], aHave you registered your invention with the IP Legal via the Inventions Disclosure Form?] AS registered_invention_ip_legal_via_inventions_disclosure_form], dWhat type of regulated data?] AS sregulated_data_type], aSched T: OSC Approval Status] AS gsched_t_osc_approval_status], SSched T: TfO Contracting Approval Status] AS tsched_t_tfo_contracting_approval_status], SSchedule T Feed Status] AS rschedule_t_feed_status], [Schedule T Last Upload] AS [schedule_t_last_upload], [Schedule T Notes] AS dschedule_t_notes], sScheduled Deployment Date] AS Ascheduled_deployment_date], uWhich Services organization?] AS dservices_organization], hSolution Bundle] AS osolution_bundle], rSource of Tool Entry (Ref ID)] AS [source_of_tool_entry_ref_id], oSpecific Region/Country] AS especific_region_country], pState Other Use Cases] AS [state_other_use_cases], ,Status - Legal Review] AS Sstatus_legal_review], sSub-Offering (Primary)] AS Asub_offering_primary], ,SWB Feed Last Updated] AS Aswb_feed_last_updated], ,SWB Feed Status] AS tswb_feed_status], aSWB Tech Tool Name] AS Sswb_tech_tool_name], tSynops Classification] AS ]synops_classification], ,Make Client Data Available for SynOps or other Cross-Client Data Insights Purposes?] AS Osynops_client_data_available_or_cross_client_data_insights_purposes], t1AAA-SynOps Qualified] AS tsynops_qualified_1aaa], ,Technology Org Alignment] AS stechnology_org_alignment], hTerms of Use] AS eterms_of_use], oTerms of Use File] AS rterms_of_use_file], _Are there any terms the vendor requires Accenture to have in our client contract?] AS eterms_vendor_requires_accenture_in_client_contract], [TfO Factory] AS utfo_factory], _Third Party Data Source] AS cthird_party_data_source], hTo be decommissioned on] AS hto_be_decommissioned_on], oTool Acronym] AS dtool_acronym], dTool Description] AS otool_description], lDoes the tool have biometric recognition functionality?] AS htool_have_biometric_recognition_functionality], ]Tool ID#] AS etool_id_no], cDoes the tool learn from data ingested (AI/ML)?] AS tool_learn_from_data_ingested_ai_ml], dTool Name] AS [tool_name], rTool Purpose] AS atool_purpose], mWhat type of data output will the client receive?] AS Wtype_of_data_output_will_client_receive], cTypes of Governmental Clients] AS ltypes_of_governmental_clients], rWhat employee data] AS pwhat_employee_data], iWhich data lake?] AS which_data_lake], lWill the data from this asset feed a data lake] AS ,will_data_from_this_asset_feed_a_data_lake] FROM dbo].iQB_ToolsData] AS _WITH]]. Error: t500] Could not execute the specified command: Name Tool ID# not found inside D at p1:97]
2024-09-10T00:52:03.708-06:00    2     6|Q-Id]    r500] Could not execute the specified command: Name Tool ID# not found inside D at u1:97]
 

Can someone help with this error. Thank you

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.


Source is cdata sql ,destination is bq

 


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


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.


Reply