Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
control_support [2019/06/13 17:30]
dsummers
control_support [2019/06/13 18:23] (current)
dsummers
Line 19: Line 19:
 |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|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]]||
Line 32: Line 32:
 |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]]||
Line 50: Line 50:
 |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)]]|| | | | | | |
Line 56: Line 56:
 |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]]|| | | | | | |
Line 71: Line 71:
 |* 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||   || | | | | | |
Line 78: Line 78:
 |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||   || | | | | | |
Line 107: Line 107:
 - 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)]]||
Line 117: Line 117:
  
   * [[: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]]