1 35000015250 2017-10-04T13:32:46-05:00 35000046836 false Admin Related 5 2017-10-04T13:32:46-05:00 1 1 2017-10-04T12:39:29-05:00 0 1 Company Name Change - How do I change the official name of my company in DBA? The official company name for your DBA system is hard coded and governed by the licensing key.  To change your company name, you will need to request a new registration key from accounting@dbasoftware.com .  Provide the exact spelling and punctuation for your new company name.  You will receive an email with your new company name and registration key. Tips for Upgrading License Key The license upgrade must be performed physically at the server  We recommend that all of your users log out of DBA  Go to File - Admin - Upgrade License  Copy and Paste the company name and key information from the email provided by the DBA office.  This must be exactly as presented.  Be careful about spaces that get added on the front or back end during copy/paste. <h2 style="">Company Name Change - How do I change the official name of my company in DBA?</h2><p style=""><br></p><p style=""><font size="2">The official company name for your DBA system is hard coded and governed by the licensing key.  To change your company name, you will need to request a new registration key from </font><a data-cke-saved-href="mailto:accounting@dbasoftware.com" href="mailto:accounting@dbasoftware.com"><font size="2">accounting@dbasoftware.com</font></a><font size="2"> .  Provide the exact spelling and punctuation for your new company name.  You will receive an email with your new company name and registration key.</font></p><p style=""><br></p><p style=""><font size="2">Tips for Upgrading License Key</font></p><ul> <li><font size="2">The license upgrade must be performed physically at the server </font></li> <li><font size="2">We recommend that all of your users log out of DBA </font></li> <li><font size="2">Go to <em>File - Admin - Upgrade License</em> </font></li> <li><font size="2">Copy and Paste the company name and key information from the email provided by the DBA office.  This must be exactly as presented.  Be careful about spaces that get added on the front or back end during copy/paste.</font></li> </ul> 35000046836 134 35000004219 2017-10-04T12:39:29-05:00 35000002609 1 2 0 1 Company Name Change - How do I change the official name of my company in DBA? 2017-10-04T13:33:09-05:00 35000002609 1 2017-10-05T20:09:43-05:00 0 0 How to update the Training Company with data from Main (live) Company The Training Company installation does not allow updating.  This means: You cannot refresh the Training Company's database so that it reflects changes you've made to the Main (live) Company after you installed the Training Company. You cannot take a current installation of the Training Company, apply an update to it, and have its software reflects a newer software build. The path forward for both of these situations is to uninstall (using the Window's Control Panel) and reinstall the Training Company.  The reinstall will offer to make a copy of your current live database.  This is how you "refresh" the database to reflect any recent changes.  If you'd like to update your Training Company's software build to reflect a newer release (if one exists), just reinstall using the newer Training Company installation file.  The latest Training Company's installation file can be found in the "What's New" section in the Support Center. Download - Training Company Installation <h2 style="">How to update the Training Company with data from Main (live) Company</h2><p style=""><br></p><p style="">The Training Company installation does <strong>not</strong> allow updating.  This means:</p><p style=""><br></p><ol> <li style="">You cannot refresh the Training Company's database so that it reflects changes you've made to the Main (live) Company after you installed the Training Company.</li> <li style="">You cannot take a current installation of the Training Company, apply an update to it, and have its software reflects a newer software build.</li> </ol><p style=""><br></p><p style="">The path forward for both of these situations is to uninstall (using the Window's Control Panel) and reinstall the Training Company.  The reinstall will offer to make a copy of your current live database.  This is how you "refresh" the database to reflect any recent changes.  If you'd like to update your Training Company's software build to reflect a newer release (if one exists), just reinstall using the newer Training Company installation file.  The latest Training Company's installation file can be found in the "What's New" section in the Support Center.</p><p style=""><br></p><p style=""><a href="https://links.dbamanufacturing.com/trainingregister/" target="_blank">Download - Training Company Installation</a></p><p><br></p> 35000046836 213 35000004864 2017-10-05T20:10:36-05:00 35000002609 1 2 0 0 How to update Training Company with data from Main (live) Company 2017-10-06T09:40:08-05:00 35000002609 1 2017-10-04T13:35:12-05:00 1 0 DBA License Agreement The following document is a copy of the DBA License Agreement that is accepted during the installation and update process. Download - DBA License Agreement <h2 style=""><font size="4">DBA License Agreement</font></h2><p style=""><br></p><p style=""><font size="2">The following document is a copy of the DBA License Agreement that is accepted during the installation and update process.</font></p><p style=""><br></p><p style=""><a href="https://links.dbamanufacturing.com/dbalicenseagreement/" target="_blank">Download - DBA License Agreement </a></p><p><br></p> 35000046836 82 35000004238 2017-10-04T13:35:12-05:00 35000002609 2 2 1 0 How can I get a copy of my DBA Next Gen License Agreement? 2017-10-04T13:35:12-05:00 35000002609 1 2017-10-05T20:18:57-05:00 1 0 Can we have read-only or partial access to certain screens? Admin - User Setup - Module Security Screen access in DBA is completely modular (or "menu-level").  So, either a user has full access to a screen (such as the entire Jobs screen) or no access at all to that screen.  There is not a way to give partial access to a certain module.  You can provide menu access to screens such as our Sales Order Inquiry and Job Inquiry which provide a great deal of read only information.  Our data views are also a practical way to get read only data. <h2 style="">Can we have read-only or partial access to certain screens?</h2><p style=""><br></p><p style=""><em>Admin - User Setup - Module Security</em></p><p style=""><br></p><p style="">Screen access in DBA is completely modular (or "menu-level").  So, either a user has full access to a screen (such as the entire Jobs screen) or no access at all to that screen.  There is not a way to give partial access to a certain module.  You can provide menu access to screens such as our Sales Order Inquiry and Job Inquiry which provide a great deal of read only information.  Our data views are also a practical way to get read only data.</p><p style=""><br></p> 35000046836 95 35000004866 2017-10-05T20:18:57-05:00 35000002609 2 2 1 0 Can we have read-only or partial access to certain screens? 2017-10-06T09:40:08-05:00 35000002609 1 2017-10-04T14:06:17-05:00 0 0 What do do if you suspect you have experienced database corruption (gds software consistency check) The only course of action for a corrupted database is to restore to your most recent backup! Sources of Data Corruption    Data corruption can occur from a number of outside sources beyond the control of the software. Here is a partial listing of these outside sources:    An abrupt power loss or crash from unclean power  Hard drive corruption or malfunction  Direct editing of database tables Improper data import Third party applications that update the database Users logging in during an update or restore process Restoring a backup to a running database  Signs of Data Corruption  If you encounter any of these error messages during the course of system operation, it is an indication that some data corruption has occurred.     Internal gds software consistency check  Database file appears corrupt. Wrong page type. Page NNN is of wrong type (expected X, found Y) Decompression overran buffer Wrong record length Database file appears corrupt. Bad checksum Cannot find record back version Next transaction older than oldest active transaction Corrupted header page (at least) Conversion error from string INET/inet_error: read errno = 10054 or 10038 or 10093 Partner index description not found (175))  What to do if data corruption occurs  If you encounter data corruption, as evidenced by any of the error messages listed in the previous section, do not continue using the system. If you encounter data corruption, stop using the system immediately and do a recovery restore from the last daily backup before the corruption was first noticed.  Do not keep using the system. This can perpetuate the corruption indefinitely, making it impossible to determine how many backups you must revert to in order to find a safe restore point.       The only remedy is to restore from backup  Once a database is corrupted, your only remedy is to do a recovery restore from backup. You will lose all transactions made since your last backup and must reenter them once again. If you backup daily, you can limit the amount of reentry to one day’s transactions, which is inconvenient, but certainly achievable.  If you do not have a backup:  If you do not have a recent backup or no backup at all, you may have to reenter days, weeks, or even months of transactions or start over with a clean database. If you have allowed data corruption to perpetuate:  If you have allowed data corruption to perpetuate without restoring from backup at the time it was first noticed, your data may be hopelessly corrupted, requiring you to start over with a clean database.  Our ability to help is limited to recovery advice We are not able to repair a corrupt database, nor is it advisable to use any third party programs to repair a database.   These utilities drop corrupted data leaving your system vulnerable to failure.    Our ability to help is limited to providing support with the recovery restore from backup process or advising how to start over with a clean database.  Suggested Safeguards  1. Daily Scheduled Backups (absolutely critical) DBA Backup Manager 2. Install a power protection system (UPS) An abrupt power loss or crash from unclean power is the most common cause of data corruption. Factories are especially subject to power fluctuations. It is imperative that you protect your server with a power protection system that includes surge suppression, power conditioning, and battery backup.  3. Do not edit your database tables  Never directly edit or manipulate your database tables, even if you have a tool that enables you to do so. This is extremely dangerous and can result in severe data loss. This practice also violates section 5 of the current DBA Software License and Maintenance Agreement.  4. Do not import data with non-DBA utilities Never import data by any means other than the Data Import utility included with the system. Only use the Data Import utility for initial import and not for updating existing records. Avoid third party data import programs. The big risk you take by violating these guidelines is that you can “infect” your system with corrupt data from day one that can cause chronic problems that can never be purged from your system.  5. Do not use third party applications that update the database Custom programs or reports that exttract data from the databae are fine, but DO NOT USE any third party program that updates the database.  This is extremely dangerous and can render your system unsupportable. <h2 style="">What do do if you suspect you have experienced database corruption (gds software consistency check)</h2><p style=""><br></p><h3 style="">The only course of action for a corrupted database is to restore to your most recent backup!</h3><h3 style=""><br></h3><h3 style=""><span><span>Sources of Data Corruption </span></span></h3><h3> </h3><p>Data corruption can occur from a number of outside sources beyond the control of the software. Here is a partial listing of these outside sources:   </p><ul type="disc"> <li>An abrupt power loss or crash from unclean power </li> <li>Hard drive corruption or malfunction </li> <li>Direct editing of database tables</li> <li>Improper data import</li> <li>Third party applications that update the database</li> <li>Users logging in during an update or restore process</li> <li>Restoring a backup to a running database </li> </ul><h3 style=""><br></h3><h3 style="">Signs of Data Corruption </h3><p style=""><br></p><p>If you encounter any of these error messages during the course of system operation, it is an indication that some data corruption has occurred.    </p><ul style="" type="disc"> <li><span>Internal gds software consistency check </span></li> <li><span>Database file appears corrupt. Wrong page type. Page NNN is of wrong type (expected X, found Y)</span></li> <li><span>Decompression overran buffer</span></li> <li><span>Wrong record length</span></li> <li><span>Database file appears corrupt. Bad checksum</span></li> <li><span>Cannot find record back version</span></li> <li><span>Next transaction older than oldest active transaction</span></li> <li><span>Corrupted header page (at least)</span></li> <li><span>Conversion error from string</span></li> <li><span>INET/inet_error: read errno = 10054 or 10038 or 10093</span></li> <li><span>Partner index description not found (175)) </span></li> </ul><h3 style=""><br></h3><h3 style=""><u>What to do if data corruption occurs </u></h3><p style=""><br></p><p style="">If you encounter data corruption, as evidenced by any of the error messages listed in the previous section, do not continue using the system.</p><p style=""><br></p><p><strong>If you encounter data corruption, <u>stop using the system immediately</u> and do a recovery restore from the last daily backup before the corruption was first noticed. </strong></p><p style=""><strong>Do not keep using the system. This can perpetuate the corruption indefinitely, making it impossible to determine how many backups you must revert to in order to find a safe restore point.      </strong></p><p style=""><br></p><h2 style="">The <u>only</u> remedy is to restore from backup </h2><p style=""><br></p><p style="">Once a database is corrupted, your only remedy is to do a recovery restore from backup. You will lose all transactions made since your last backup and must reenter them once again. If you backup daily, you can limit the amount of reentry to one day’s transactions, which is inconvenient, but certainly achievable. </p><p style=""><br></p><p style=""><strong>If you do not have a backup: </strong></p><p style=""><br></p><p style="">If you do not have a recent backup or no backup at all, you may have to reenter days, weeks, or even months of transactions or start over with a clean database.</p><p style="">If you have allowed data corruption to perpetuate: </p><p style=""><br></p><p style="">If you have allowed data corruption to perpetuate without restoring from backup at the time it was first noticed, your data may be hopelessly corrupted, requiring you to start over with a clean database. </p><p style=""><br></p><p style="">Our ability to help is limited to recovery advice</p><p style=""><br></p><p style="">We are <strong>not</strong> able to repair a corrupt database, nor is it advisable to use any third party programs to repair a database.   These utilities drop corrupted data leaving your system vulnerable to failure.    Our ability to help is limited to providing support with the recovery restore from backup process or advising how to start over with a clean database. </p><h3 style=""><br></h3><h3 style=""> <u>Suggested Safeguards</u> </h3><h5 style=""><br></h5><p style=""><strong>1. Daily Scheduled Backups (absolutely critical)</strong></p><p style=""><br></p><p style=""><a href="https://links.dbamanufacturing.com/onlinebackupmanager/" target="_blank">DBA Backup Manager</a></p><p style=""><br></p><p style=""><strong>2. Install a power protection system (UPS)</strong></p><p style=""><br></p><p style="">An abrupt power loss or crash from unclean power is the most common cause of data corruption. Factories are especially subject to power fluctuations. It is imperative that you protect your server with a power protection system that includes surge suppression, power conditioning, and battery backup. </p><p style=""><br></p><p style=""><strong>3. Do not edit your database tables </strong></p><p style=""><br></p><p style=""><u>Never</u> directly edit or manipulate your database tables, even if you have a tool that enables you to do so. <u>This is extremely dangerous and can result in severe data loss</u>. This practice also violates section 5 of the current <em>DBA Software License and Maintenance Agreement</em>. </p><p style=""><br></p><p style=""><strong>4. Do not import data with non-DBA utilities</strong></p><p style=""><br></p><p style=""><u>Never</u> import data by any means other than the <em>Data Import</em> utility included with the system. Only use the <em>Data Import</em> utility for initial import and not for updating existing records. Avoid third party data import programs. The big risk you take by violating these guidelines is that you can “infect” your system with corrupt data from day one that can cause chronic problems that can never be purged from your system. </p><p style=""><br></p><p style=""><strong>5. Do not use third party applications that update the database</strong></p><p style=""><br></p><p style="">Custom programs or reports that exttract data from the databae are fine, but DO NOT USE any third party program that updates the database.  This is extremely dangerous and can render your system unsupportable.</p><p style=""><br></p><p style=""><br></p> 35000046836 129 35000004287 2017-10-04T14:15:06-05:00 35000002609 3 2 0 0 What do do if you suspect you have experienced database corruption (gds software consistency check) 2017-10-04T14:06:17-05:00 35000002609 1 2017-10-05T20:21:20-05:00 0 0 "Why can't I see an SO Type in the SO List?" or "How can I restrict non-admin users from seeing certain SO Types?" From the User Setup window, you can restrict or grant access for non-administrative users to certain SO Types.  To do this, go into the menu Admin > User Setup > SO/Job Types In the User Setup window, highlight the DBA user name you wish to change the permissions for, then go into the SO/Job Types tab.  In the SO/Job Types tab, you will need to check or un-check the SO Type you wish to grant access to or restrict access of based on the DBA user you have highlighted in the main User Setup list screen. After you have made these changes, the user should only be able to see the SO Types they have access granted to.    However users with administative access to DBA are automatically granted access to all SO Types. <h3 style="">"Why can't I see an SO Type in the SO List?" or "How can I restrict non-admin users from seeing certain SO Types?"</h3><p style=""><br></p><p style="">From the User Setup window, you can restrict or grant access for non-administrative users to certain SO Types. </p><p style=""><br></p><p style="">To do this, go into the menu <em>Admin &gt; User Setup &gt; SO/Job Types</em></p><p style=""><br></p><p>In the User Setup window, highlight the DBA user name you wish to change the permissions for, then go into the SO/Job Types tab.  In the SO/Job Types tab, you will need to check or un-check the SO Type you wish to grant access to or restrict access of based on the DBA user you have highlighted in the main User Setup list screen.</p><p style="">After you have made these changes, the user should only be able to see the SO Types they have access granted to.   </p><p style="">However users with administative access to DBA are automatically granted access to all SO Types.</p><p><br></p> 35000046836 37 35000004867 2017-10-05T20:21:20-05:00 35000002609 3 2 0 0 Changing User Setup Permissions To Access an SO Type 2017-10-06T09:40:09-05:00 35000002609 1 2017-10-05T20:29:21-05:00 1 2 Resetting DBA User Passwords  Passwords can be reset by the system Administrator at your company.   Administrator can go to File/Administrator/User Setup Screen   Highlight the appropriate user and click on the ResetPW icon on the right This will automatically reset the user's password to pass (new users and reset of passwords will always default to pass Next time the user logs in they use their assigned username and password = pass Once logged in they should go to File/Change Password.  Follow the instructions and choose a new password. Passwords are always self generated by the user via this procedure. Resetting Admin Password - If you have forgotten your Admin password and cannot sign into DBA Submit a support ticket and one of our team members can set up a remote session to clear your password and allow you to sign into DBA. <h2 style=""><span>Resetting DBA User Passwords </span></h2><p style=""><br></p><p><span><span>Passwords can be reset by the system <strong>Administrator</strong> at your company.</span>  </span></p><ul style=""> <li><span>Administrator can go to <strong>File/Administrator/User Setup Screen</strong>  </span></li> <li><span>Highlight the appropriate user and click on the <strong>ResetPW </strong>icon on the right</span></li> <li><span>This will automatically reset the user's password to <strong>pass</strong> (new users and reset of passwords will always default to pass</span></li> </ul><p style=""><br></p><p style=""><span><span data-cke-display-name="image" data-cke-filter="off" data-cke-widget-id="0" data-cke-widget-wrapper="1"><img src="https://supportcenteronline.com/dmfiles/628/647/Support%20Downloads/My%20Images/Screen%20Shots/Reset%20password.gif" alt="" class="fr-dii fr-draggable"><img src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/35000190467/original/IeNb4loYKXGXQXBxlhx0jvkUUHurAPzkew?1507253181" title="Click and drag to move" style="width: 15px; height: 15px;" class="fr-dii fr-draggable"></span></span></p><p style=""><br></p><ul> <li><span>Next time the user logs in they use their assigned username and password = <strong>pass</strong></span></li> <li><span>Once logged in they should go to <strong>File/Change Password.  </strong>Follow the instructions and choose a new password.</span></li> <li><span>Passwords are always self generated by the user via this procedure.</span></li> </ul><p style=""><br></p><h2 style="">Resetting Admin Password - If you have forgotten your Admin password and cannot sign into DBA</h2><p style=""><br></p><p style="">Submit a support ticket and one of our team members can set up a remote session to clear your password and allow you to sign into DBA.</p> 35000046836 83 35000004868 2017-10-05T20:29:21-05:00 35000002609 4 2 1 2 I forgot my DBA User password, how do I reset it? 2017-10-06T09:40:09-05:00 35000002609