Both sides previous revision
Previous revision
Next revision
|
Previous revision
|
control_support [2019/05/23 10:05] bteekel |
control_support [2019/06/13 18:23] (current) dsummers |
| |
|**Installation Related** || || | |**Installation Related** || || |
|Need an example of a typical Control installation||* [[http://internal.cyriouswiki.com/control1_-_control_installation_overview|Control1 - Control installation overview]]|| | |Need an example of a typical Control installation||* [[http://internal.cyriouswiki.com/control1_-_control_installation_overview|Control installation overview]]|| |
|Want to put Control on a new Client||* [[:control1_-_client_install|]]|| | |Want to put Control on a new Client||* [[:control1_-_client_install|Control Client Install]]|| |
|New Control Customer \\ New Control Server Installation||* [[:control1_-_new_control_5.5_server_install|]] \\ * [[:control1_-_new_control_5.1_server_install|]] \\ * [[http://internal.cyriouswiki.com/control1_-_manual_installation_of_control_5.5|Control1 - Manual Installation of Control 5.5]]|| | |New Control Customer \\ New Control Server Installation||* [[:control1_-_new_control_5.5_server_install|Control 5.5 Server Install]] \\ * [[:control1_-_new_control_5.1_server_install|Control 5.1 Server Install]] \\ * [[http://internal.cyriouswiki.com/control1_-_manual_installation_of_control_5.5|Manual Installation of Control 5.5]]|| |
|Server Swap||* [[:control1_-_performing_a_server_swap|]]|| | |Server Swap||* [[:control1_-_performing_a_server_swap|Performing Control Server Swap]]|| |
|Wants to Upgrade the version of Control they are running.||* [[:control1_-_upgrade_5.5_to_latest_release|]] \\ * [[:control1_-_upgrade_version_4.6_to_5.5|]] \\ * [[http://@internal.cyriouswiki.com/upgrading_control_3.1_to_4.6|Control Update 3.x - 4.6]]|| | |Wants to Upgrade the version of Control they are running.||* [[:control1_-_upgrade_5.5_to_latest_release|Control 5.5 Update to Latest Release]] \\ * C[[:control1_-_upgrade_version_4.6_to_5.5|ontrol1 - Upgrade Version 4.6 to 5.5]] \\ * [[http://@internal.cyriouswiki.com/upgrading_control_3.1_to_4.6|Control Update 3.x - 4.6]]|| |
|Common client installation issue: Control requires network logon||* [[http://control.cyriouswiki.com/control_requires_network_logon|Control requires network logon]]|| | |Common client installation issue: Control requires network logon||* [[http://control.cyriouswiki.com/control_requires_network_logon|Control requires network logon]]|| |
|If a customer has a 2nd SSLIP follow this for the install process||* [[http://control.cyriouswiki.com/how_to_run_macros_on_a_separate_sslip|Control1 - Second SSLIP (Macro SSLIP)]]|| | |If a customer has a 2nd SSLIP follow this for the install process||* [[http://control.cyriouswiki.com/how_to_run_macros_on_a_separate_sslip|Control1 - Second SSLIP (Macro SSLIP)]]|| |
|Error Message when running any report: Class Not Registered||* [[:control1_-_installing_crystal_reports_xi|]]|| | |Error Message when running any report: Class Not Registered||* [[:control1_-_installing_crystal_reports_xi|Control1 - installing Crystal Reports XI]]|| |
|**Configuration Related** || | | | |**Configuration Related** || | | |
|Control Services Configuration||* [[http://internal.cyriouswiki.com/control_service_configuration|Control Service Configuration]]|| | |Control Services Configuration||* [[http://internal.cyriouswiki.com/control_service_configuration|Control Service Configuration]]|| |
|**Support Tasks** || | | | |**Support Tasks** || | | |
|Need to obtain a backup of a customer's data||* [[http://internal.cyriouswiki.com/control1_-_getting_a_copy_of_a_customers_database|Control1 - Getting a copy of a customer's database]] \\ * [[http://internal.cyriouswiki.com/control1_-_using_the_order_export_report|Control1 - Using the Order Export Report]]|| | |Need to obtain a backup of a customer's data||* [[http://internal.cyriouswiki.com/control1_-_getting_a_copy_of_a_customers_database|Control1 - Getting a copy of a customer's database]] \\ * [[http://internal.cyriouswiki.com/control1_-_using_the_order_export_report|Control1 - Using the Order Export Report]]|| |
|Basic Troubleshooting||* [[:basic_tips_for_troubleshooting_control_server_and_associated_services|]] \\ * [[http://internal.cyriouswiki.com/troubleshooting_checklist|Troubleshooting Checklist (internal)]]|| | |Basic Troubleshooting||* [[:basic_tips_for_troubleshooting_control_server_and_associated_services|Basic Tips for Troubleshooting Control Server and Associated Services]] \\ * [[http://internal.cyriouswiki.com/troubleshooting_checklist|Troubleshooting Checklist (internal)]]|| |
|**Production Terminal** || | | | |**Production Terminal** || | | |
|Need to install Production Terminal||* [[http://control.cyriouswiki.com/production_terminal|Control 1 - How to setup Production Terminal]]|| | |Need to install Production Terminal||* [[http://control.cyriouswiki.com/production_terminal|Control 1 - How to setup Production Terminal]]|| |
|SQL Service not starting||[[http://@control.cyriouswiki.com/sql_engine_service_will_not_start|SQL Service not starting]]|| | |SQL Service not starting||[[http://@control.cyriouswiki.com/sql_engine_service_will_not_start|SQL Service not starting]]|| |
|**Reports/Printing** || || | |**Reports/Printing** || || |
|Access Violation when Printing||[[:access_violation_when_printing_._._._usp10.dll|]] \\ [[http://@control.cyriouswiki.com/cant_print_-_access_violation_-_usp10.dll|usp10.dll copy 2]]|| | |Access Violation when Printing||[[:access_violation_when_printing_._._._usp10.dll|Access Violation When Printing . . . USP10.dll]] \\ [[http://@control.cyriouswiki.com/cant_print_-_access_violation_-_usp10.dll|usp10.dll copy 2]]|| |
|**Artwork Approval** || | | | |**Artwork Approval** || | | |
|Advanced Troubleshooting||[[http://control.cyriouswiki.com/artwork_approval|Artwork Approval Portal]]|| | |Advanced Troubleshooting||[[http://control.cyriouswiki.com/artwork_approval|Artwork Approval Portal]]|| |
|Inventory explanation:||[[http://control.cyriouswiki.com/inventory Overview|Inventory Overview]]|| | | | | | | | |Inventory explanation:||[[http://control.cyriouswiki.com/inventory Overview|Inventory Overview]]|| | | | | | | |
|How does Consignment Inventory Work?||[[http://internal.cyriouswiki.com/consignment_inventory|Consignment Inventory (internal)]]|| | | | | | | | |How does Consignment Inventory Work?||[[http://internal.cyriouswiki.com/consignment_inventory|Consignment Inventory (internal)]]|| | | | | | | |
|Adjusting Reserved levels (On Order)||[[:control_sql_-_adjust_reserved_inventory_levels_to_match_orders|]]|| | | | | | | | |Adjusting Reserved levels (On Order)||[[:control_sql_-_adjust_reserved_inventory_levels_to_match_orders|Control SQL - Adjust Reserved Inventory Levels to Match Orders]]|| | | | | | | |
|Merge Duplicate Inventory Items||[[http://control.cyriouswiki.com/merge_duplicate_inventory_items|Merge Duplicate Inventory Items (SQL)]]|| | | | | | | | |Merge Duplicate Inventory Items||[[http://control.cyriouswiki.com/merge_duplicate_inventory_items|Merge Duplicate Inventory Items (SQL)]]|| | | | | | | |
|Merge Duplicate Inventory Summaries||[[http://control.cyriouswiki.com/merge_duplicate_inventory_summaries|Merge Duplicate Inventory Summaries (SQL)]]|| | | | | | | | |Merge Duplicate Inventory Summaries||[[http://control.cyriouswiki.com/merge_duplicate_inventory_summaries|Merge Duplicate Inventory Summaries (SQL)]]|| | | | | | | |
|How to do a Retroactive Closeout||[[http://control.cyriouswiki.com/how_to_do_a_retroactive_closeout|Retroactive Closeout]]|| | | | | | | | |How to do a Retroactive Closeout||[[http://control.cyriouswiki.com/how_to_do_a_retroactive_closeout|Retroactive Closeout]]|| | | | | | | |
|Which entries are made for accounting actions taken?||[[http://internal.cyriouswiki.com/accounting_extries_for_orders|Accounting Reference Table (internal)]] \\ [[http://internal.cyriouswiki.com/gl_activity_by_action|GL Activity by Action (internal)]]|| | | | | | | | |Which entries are made for accounting actions taken?||[[http://internal.cyriouswiki.com/accounting_extries_for_orders|Accounting Reference Table (internal)]] \\ [[http://internal.cyriouswiki.com/gl_activity_by_action|GL Activity by Action (internal)]]|| | | | | | | |
|How do I post a payment for an order that was written off as bad debt?||[[:how_do_i_post_a_payment_for_an_order_that_was_a_write-off_to_bad_debt|]]|| | | | | | | | |How do I post a payment for an order that was written off as bad debt?||[[:how_do_i_post_a_payment_for_an_order_that_was_a_write-off_to_bad_debt|How do I Post a Payment for an Order That Was a Write-Off to Bad Debt]]|| | | | | | | |
|How to handle an NSF Check and Update Quickbooks.||[[http://control.cyriouswiki.com/how-to_handle_an_nsf_check_and_export_into_quickbooks|NSF Checks]]|| | | | | | | | |How to handle an NSF Check and Update Quickbooks.||[[http://control.cyriouswiki.com/how-to_handle_an_nsf_check_and_export_into_quickbooks|NSF Checks]]|| | | | | | | |
|How to repair Direct Cost from Bills.||[[http://control.cyriouswiki.com/direct_cost_from_bills_repair|Direct Cost from Bills Repair (billable)]]|| | | | | | | | |How to repair Direct Cost from Bills.||[[http://control.cyriouswiki.com/direct_cost_from_bills_repair|Direct Cost from Bills Repair (billable)]]|| | | | | | | |
|How to process a refund in Quickbooks.||[[http://internal.cyriouswiki.com/refund_in_quickbooks|Refund in Quickbooks (internal)]]|| | | | | | | | |How to process a refund in Quickbooks.||[[http://internal.cyriouswiki.com/refund_in_quickbooks|Refund in Quickbooks (internal)]]|| | | | | | | |
|How to check Order Tax settings.||[[:control_-_order_tax_settings_lookup|]]|| | | | | | | | |How to check Order Tax settings.||[[:control_-_order_tax_settings_lookup|Control - Order Tax Settings Lookup]]|| | | | | | | |
|How to insert a missing Journal (Activity) for Finance Charge on an Order||[[http://control.cyriouswiki.com/sql_to_insert_missing_journal_activity_entry_for_finance_charge_on_order|Insert Journal for Finance Charge (SQL)]]|| | | | | | | | |How to insert a missing Journal (Activity) for Finance Charge on an Order||[[http://control.cyriouswiki.com/sql_to_insert_missing_journal_activity_entry_for_finance_charge_on_order|Insert Journal for Finance Charge (SQL)]]|| | | | | | | |
|How to Track Donations.||[[:how_to_track_donations|]]|| | | | | | | | |How to Track Donations.||[[:how_to_track_donations|How To Track Donations]]|| | | | | | | |
|**Part Usage** || || | | | | | | | |**Part Usage** || || | | | | | | |
|What is Smart Parts?||[[http://control.cyriouswiki.com/control_-_what_is_smart_parts|Smart Parts]]|| | | | | | | | |What is Smart Parts?||[[http://control.cyriouswiki.com/control_-_what_is_smart_parts|Smart Parts]]|| | | | | | | |
|* Troubleshooting O/S or Networking||[[http://general_windows_troubleshooting|General O.cyriouswiki.com/s_and_networking_home]]|| | | | | | | | |* Troubleshooting O/S or Networking||[[http://general_windows_troubleshooting|General O.cyriouswiki.com/s_and_networking_home]]|| | | | | | | |
|* Cyrious Response to Virtualization||[[http://internal.cyriouswiki.com/virtual_machines_vm_and_sql_express|Virtual Machines (VM) and SQL Express (internal)]]|| | | | | | | | |* Cyrious Response to Virtualization||[[http://internal.cyriouswiki.com/virtual_machines_vm_and_sql_express|Virtual Machines (VM) and SQL Express (internal)]]|| | | | | | | |
|* Is the customer using virtualization?||[[:how_you_can_tell_if_the_server_is_a_virtual_machine_or_a_physical_machine|]]|| | | | | | | | |* Is the customer using virtualization?||[[:how_you_can_tell_if_the_server_is_a_virtual_machine_or_a_physical_machine|How You Can Tell if the Server is a Virtual Machine or a Physical Machine]]|| | | | | | | |
|* Is my Anti-Virus causing problems?||[[:known_issues_with_anti-virus_applications|]]|| | | | | | | | |* Is my Anti-Virus causing problems?||[[:known_issues_with_anti-virus_applications|Known Issues with Anti-virus Applications]]|| | | | | | | |
|SQL Optimization|| || | | | | | | | |SQL Optimization|| || | | | | | | |
|Riot Creative Imaging - ARC|| || | | | | | | | |Riot Creative Imaging - ARC|| || | | | | | | |
|SQL Server Related|| || | | | | | | | |SQL Server Related|| || | | | | | | |
|* Determine SQL inconsistencies||[[http://@internal.cyriouswiki.com/sql_home|SQL Master Reference - SQL HOME]]|| | | | | | | | |* Determine SQL inconsistencies||[[http://@internal.cyriouswiki.com/sql_home|SQL Master Reference - SQL HOME]]|| | | | | | | |
|* SQL Query home||[[:control_sql_-_queries_to_identify_problems|]]|| | | | | | | | |* SQL Query home||[[:control_sql_-_queries_to_identify_problems|Control SQL - Queries to Identify Problems]]|| | | | | | | |
|* Corrupted Database||[[:sql_server_-_dbcc_checkdb|]]|| | | | | | | | |* Corrupted Database||[[:sql_server_-_dbcc_checkdb|SQL Server - DBCC_CHECKDB]]|| | | | | | | |
|* Clear SQL Processes without downtime||[[:control_sql_-_odbc_process_removal_query|]]|| | | | | | | | |* Clear SQL Processes without downtime||[[:control_sql_-_odbc_process_removal_query|Control SQL - ODBC Process Removal Query]]|| | | | | | | |
|* Standard SQL Functions and Views||[[http://@control.cyriouswiki.com/control_standard_sql_functions_and_views|SQL Functions/Views (Standard with Control)]]|| | | | | | | | |* Standard SQL Functions and Views||[[http://@control.cyriouswiki.com/control_standard_sql_functions_and_views|SQL Functions/Views (Standard with Control)]]|| | | | | | | |
|* Customize SQL Queries/Triggers (such as for Macros)||[[http://@control.cyriouswiki.com/how_to_change_a_transaction_variable_based_on_an_order_condition|Modify Transaction Variable (Order Condition)]]|| | | | | | | | |* Customize SQL Queries/Triggers (such as for Macros)||[[http://@control.cyriouswiki.com/how_to_change_a_transaction_variable_based_on_an_order_condition|Modify Transaction Variable (Order Condition)]]|| | | | | | | |
|* Determine Control Version History||[[:control_sql_-_version_history|]]|| | | | | | | | |* Determine Control Version History||[[:control_sql_-_version_history|Control SQL - Version History]]|| | | | | | | |
|* Access Denied when attempting to log in||[[:access_denied_when_attempting_to_log_into_sql_management_studio|]]|| | | | | | | | |* Access Denied when attempting to log in||[[:access_denied_when_attempting_to_log_into_sql_management_studio|Access Denied When Attempting to Log Into SQL Management Studio]]|| | | | | | | |
|* Reinstall SQL Bridge||[[:control_sql_-_reinstall_sql_bridge|]]|| | | | | | | | |* Reinstall SQL Bridge||[[:control_sql_-_reinstall_sql_bridge|Control SQL -Reinstall SQL Bridge]]|| | | | | | | |
|Bug Submission|| || | | | | | | | |Bug Submission|| || | | | | | | |
|* Clearing customer info for bug testing on backup||[[http://internal.cyriouswiki.com/customer_databases_on_test_systems|Clear customer info for Testing (internal)]]|| | | | | | | | |* Clearing customer info for bug testing on backup||[[http://internal.cyriouswiki.com/customer_databases_on_test_systems|Clear customer info for Testing (internal)]]|| | | | | | | |
|* Determine Recently Modified Records (SQL)||[[:control_sql_-_recently_modified_records|]]|| | | | | | | | |* Determine Recently Modified Records (SQL)||[[:control_sql_-_recently_modified_records|Control SQL - Recently Modified Records]]|| | | | | | | |
|* SQL Query to Search All Tables (TRAINING/TESTING ONLY)||[[http://@internal.cyriouswiki.com/sql_query_to_search_all_tables|This should not be run on a customer's system ever.]]|| | | | | | | | |* SQL Query to Search All Tables (TRAINING/TESTING ONLY)||[[http://@internal.cyriouswiki.com/sql_query_to_search_all_tables|This should not be run on a customer's system ever.]]|| | | | | | | |
|Unsupported Solutions|| || | | | | | | | |Unsupported Solutions|| || | | | | | | |
- This generates 1 index on the new table based on ID; Know the implications before utilizing this.|| | - This generates 1 index on the new table based on ID; Know the implications before utilizing this.|| |
| |
|* Track SQL Activities||[[http://how_to_-_view_and_disable_sql_agent_jobs_with_tsql|View.cyriouswiki.com/kill_tasks_in_sql_tsql]]|| | |* Track SQL Activities||[[http://how_to_-_view_and_disable_sql_agent_jobs_with_tsql|Kill Tasks in SQL TSQL]]|| |
|* Statistic Collection||[[:control_-_how_to_determine_the_size_of_each_sql_database_table|]]|| | |* Statistic Collection||[[:control_-_how_to_determine_the_size_of_each_sql_database_table|Control - How to Determine the Size of Each SQL Database Table]]|| |
|* Data-Set Modification||[[http://@control.cyriouswiki.com/merge_product_dataset_using_sql|Merge Product Data-Set (SQL)]]|| | |* Data-Set Modification||[[http://@control.cyriouswiki.com/merge_product_dataset_using_sql|Merge Product Data-Set (SQL)]]|| |
|* Data Extraction||[[http://@control.cyriouswiki.com/how-to_write_sql_to_extract_an_xml_value_from_a_database_field|Extract XML (SQL)]]|| | |* Data Extraction||[[http://@control.cyriouswiki.com/how-to_write_sql_to_extract_an_xml_value_from_a_database_field|Extract XML (SQL)]]|| |
| |
* [[:control_activity_manager|Control Activity Manager]] | * [[:control_activity_manager|Control Activity Manager]] |
* [[http://control_ar_payment_entry|A.cyriouswiki.com/r_payment_entry]] | * [[http://control_ar_payment_entry|AR Payment Entry]] |
* [[:control_company_entry|Control Company Entry]] | * [[http://control.cyriouswiki.com/users_manual_ch_10-companies|Control Company Entry]] |
* [[:control_estimate_entry|Control Estimate Entry]] | * [[http://control.cyriouswiki.com/users_manual_ch_11-estimates_orders_and_service_tickets|Control Estimate Entry]] |
* [[:control_explorer|Control Explorer]] | * [[http://control.cyriouswiki.com/users_manual_ch_09-explorer|Control Explorer]] |
* [[:control_installation|]] | * [[:control_installation|Control Installation]] |
* [[:control_login|]] | * [[:control_login|Control Login]] |
* [[:control_order_entry|]] | * [[:control_order_entry|Control Order Entry]] |
* [[:passwords|]] | * [[:passwords|Passwords]] |
* [[:control_payments|]] | * [[:control_payments|Control Payments]] |
* [[:control_pricing|]] | * [[:control_pricing|Control Pricing]] |
* [[:control_printing|]] | * [[:control_printing|Control Printing]] |
* [[:product_layout|]] | * [[:product_layout|Product Layout]] |
* [[:control_production_terminal|]] | * [[:control_production_terminal|Control Production Terminal]] |
* [[:contol_reports|]] | * [[:contol_reports|Control Reports]] |
* [[:store_logo_specifications|]] | * [[:store_logo_specifications|Store Logo Specifications]] |
* [[:tax_reporting|]] | * [[:tax_reporting|Tax Reporting]] |
* [[:transaction_log_not_shrinking|]] | * [[:transaction_log_not_shrinking|Transaction Log Not Shrinking]] |
* [[:updating_control|]] | * [[:updating_control|Updating Control]] |
* [[:control_windows_issues|]] | * [[:control_windows_issues|Control Windows Issues]] |
* [[http://control.cyriouswiki.com/tcp_udp_ports|TCP and UDP Port Information]] | * [[http://control.cyriouswiki.com/tcp_udp_ports|TCP and UDP Port Information]] |
* [[:control_part_usage_cards|]] | * [[:control_part_usage_cards|Control Part Usage Cards]] |
* [[:c3s|]] | * [[:c3s|]] |
| |
By Type of Error | By Type of Error |
| |
* [[:control_access_violation|]] | * [[:control_access_violation|Control Access Violation]] |
* [[:control_invalid_floating_point_operation|]] | * [[:control_invalid_floating_point_operation|Control Invalid Floating Point Operation]] |
* [[http://unable_to_open_or_login|Unable to Open.cyriouswiki.com/login]] | * [[http://unable_to_open_or_login|Unable to Open.cyriouswiki.com/login]] |
* [[:control_printing|]] | * [[:control_printing|Control Printing]] |
* [[:control_reports_changed_after_update|]] | * [[:control_reports_changed_after_update|Control Reports Changed After Update]] |
* [[:control_reports_dont_match|]] | * [[:control_reports_dont_match|Control Reports Don't Match]] |
* [[:control_database_error|]] | * [[:control_database_error|Control Database Error]] |
* [[:control_crashes|]] | * [[:control_crashes|Control Crashes]] |
* [[:control_slow|Control Slow]] | * [[:control_slow|Control Slow]] |
* [[:ssl_provider_when_starting_sql_server|]] | * [[:ssl_provider_when_starting_sql_server|SSL Provider When Starting SQL Server]] |
* [[:control_email_errors|]] | * [[:control_email_errors|Control Email Errors]] |
* [[:control_socket_connection_error|]] | * [[:control_socket_connection_error|Control Socket Connection Error]] |
* [[:control_not_enough_storage|]] | * [[:control_not_enough_storage|Control Not Enough Storage]] |
* [[http://control.cyriouswiki.com/c3s_credit_card_issues|Credit card number partially unmasked (c3s)]] | * [[http://control.cyriouswiki.com/c3s_credit_card_issues|Credit card number partially unmasked (c3s)]] |
* [[:invalid_gl_account_error|Invalid GL Account Error]] | * [[:invalid_gl_account_error|Invalid GL Account Error]] |
* [[:row_number_error_while_updating|]] | * [[:row_number_error_while_updating|Row Number Error While Updating]] |
* [[:correcttransdetailshippingaddressid|]] | * [[:correcttransdetailshippingaddressid|Correcttransdetailshippingaddressid]] |
* [[:activity_groupids_with_multiple_orders|]] | * [[:activity_groupids_with_multiple_orders|Activity GroupIDs with Multiple Orders]] |
* [[:transaction_id_not_orig_pnref_required|]] | * [[:transaction_id_not_orig_pnref_required|Transaction ID not orig pnref Required]] |
| |
Other Useful Information | Other Useful Information |
| |
* [[:control_sql_-_queries_to_identify_problems|]] | * [[:control_sql_-_queries_to_identify_problems|Control SQL - Queries to Identify Problems]] |
* [[:control_sql_server_configuration|]] | * [[:control_sql_server_configuration|control SQL Server Configuration]] |
* [[http://@control.cyriouswiki.com/control_how-to_guides|Control How-To Guides]] | * [[http://@control.cyriouswiki.com/control_how-to_guides|Control How-To Guides]] |
| |