Laptop Computer Repair Welcome Guest | Login or Register

How to delete the user? This is the first problem you encounter - when user shuts down the computer - Great Plains doesn’t have the command to log off the user and when user tries to login the next day - she gets error message that user is already logged on. The fix:

• Microsoft SQL Server - open SQL Query Analyzer, switch to DYNAMICS database and run the following script: DELETE ACTIVITY WHERE USERID=’KATHY’.
• Pervasive SQL/Ctree - if you have more than one user registered you can delete the user from GP: System->User Activity->Delete User. If you like to work on the file level - ask all the users to log off. On the server, where you have your Great Plains files structure - DYNAMICS is the root, in SYSTEM folder delete ACTIVITY.* files

How to unlock the batch? This happens when user posts the batch and has her computer crashed (via surfing the internet - smile - or things like this)

• General tip - Great Plains recommends to logoff and then login back with the same user id. Then Great Plains will prompt the user to recover posting batch. Unfortunately it doesn’t work in 70% of the cases
• MS SQL Server - the batch record is stored in Batch Header table: SY00500 in the company database. The fields to clear are: BCHSTTUS and MKDTOPST. In some cases you have to delete the record from SY00800 from DYNAMICS db.
• Pervasive/ctree - you have to install ODBC driver for Pervasive or Ctree and hook the tables: SY00500, SY00800 with Microsoft Access - use linked tables technique

Now we would like to stress you the need to move away from Pervasive SQL 2000/Ctree platforms - you are in trouble - Microsoft Business Solutions cuts technical support for Microsoft Great Plains 7.5 and prior on these platforms. This means not only the support, but also tax updates (especially Payroll and Federal Magnetic Media).

What is migration from Ctree/Pervasive.SQL 2000 to MS SQL/MSDE? MBS has migration tool. You need first to install Great Plains on SQL Server with exactly the same account/segments structure and then install migration tool (it is Dexterity chunk) on your ctree/Pervasive workstation - then, when you integrate the chunk - you will map it to target SQL-based Great Plains Company, select all system and company tables, click the button and it will move all your tables one-by-one. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data

Do I need consultant? It is probably good idea to have consultant to do the upgrade. We strongly recommend you to use consultant in the following cases

• You have Dexterity customization
• You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools
• You have a lot or ReportWriter Modified Great Plains Reports
• You have old version of Great Plains: Dynamics or eEnteroprise 6.0 or prior - in this case you can not appeal to Microsoft Technical Support - it is discontinued
• Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems
• You don’t have support - in this case you have to select your Microsoft Business Solutions Partner and pay for the annual support/enhancement plan - you will get new registration key and will be ready for the upgrade

Good luck in fixing and if you have issues or concerns - we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia, Colorado, Oregon, Washington, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

You can contact Andrew: andrewk@albaspectrum.com

Tags: Great Plains Dexterity, Microsoft Great PlainsGreat Plains Dexterity, Microsoft Great Plains

Share This

It is extremely important not to make or write any changes to data on the hard drive without first verifying the hard drive configuration. Therefore, the first priority when unable to access information on a hard drive is to verify all of the configuration information dealing with the suspect hard drive.

Partition Parameter

Value or Equation

Partition Status

Bootable

Starting Head

1

Starting Sector

1

Starting Cylinder

0

Partition Type

Bigdos (drives greater than 30 MB), otherwise DOS 12

Ending Head

Total Number of Heads -1

Ending Sector

Sectors per Track displayed in Volume Boot Sector

Ending Cylinder

Number of Cylinders set in CMOS - 2

Total # of Sectors

Number of Sectors displayed in Volume Boot Sector

Start Absolute Sector

Number of Sectors per Track in Volume Boot Sector

Boot Signature

55AA

Step One: Make sure that Micro-Scope detects the hard drive

In Micro-Scope, System Configuration, Compare Settings - check to make sure that there is not an asterisk beside the number of hard drives detected value. If there is an asterisk, either the CMOS is set incorrectly, or there is an electronic problem (controller, cable, drive).

Step Two: Compare the BIOS parameters against the drive partition information.

In Micro-Scope, System Configuration, System Information - note the information displayed for the hard drive, specifically the parameters for the drive in question. Compare these parameters to the parameters in the MBR display under Micro-Scope, System Configuration, Partition Display using the following formula:

System Information

Master Boot Record

Cylinders

Ending Cylinder + 2

Heads

Ending Head + 1

Sectors

Sectors Per Track

If the information does not match, either the partition information is corrupt, or the CMOS setup or controller BIOS setup (if one exists) is incorrect, or there is a problem communicating with the drive.

Step Three: Check the drive functionality

In Micro-Scope, Diagnostics, Fixed Disk Tests - check the information in the Fixed Disk Selected window. Make sure that the proper drive type, model, and native parameters are showing in this window. If any of the information is incorrect, there is an electronic problem. Check the cable, controller and drive, re-seating all connections, and repeat the above procedure. After correcting the electronic problem, perform a read test on the first 10 cylinders of the drive. If any errors occur, then this is the most likely cause of the drive failure. Perform a read of the entire drive to determine if the errors are electronic in nature, or physical in nature. Electronic problems will result in the errors displayed not always being the same type or in the same location on the drive. If the problem is electronic, replace the cable, controller, and finally drive electronics and repeat the read test until no errors occur. If the error is physical, use an INT 13 type editor (such as Norton Advanced Editor), to block the entire drive and write the information to a daisy chained drive set to the same parameters as the faulty drive.

The next step, after the drive passes the read test on the first 10 cylinders, is to check the original partition setup of the drive.

Step Four: Check for the physical location of the master boot sector and the volume boot sector.

In Micro-Scope, Utilities, Fixed Disk Editor - use the FIND feature to search the last two bytes of each cylinder for a boot signature (55 AA). The first location where a boot signature should be found would be at cylinder 0, head 0, sector 1 (the master boot sector). The second location where a boot signature should be found is at cylinder 0, head 1, sector 1 (the volume boot sector). It is also possible to use the FIND feature to locate the volume boot sector by searching for MSDOS (in DOS based systems) or MSWIN (in Windows95 systems).

If there is a duplicate copy of the master boot sector found before the location of the volume boot sector, then it is possible that a boot virus has infected the hard drive in the system. The Rebuild Master Boot feature of Micro-Scope will eliminate any boot sector virus. Be sure to boot the system to the Micro-Scope diskette and immediately do a cold reboot of the system after using the Rebuild Master Boot feature.

If the volume boot sector is found in a location other than cylinder 0, head 1, sector 1, count the actual number of sectors before the volume boot sector, and compare that value to the value for the sectors per track displayed in the partition table described in step 2. If the values match, the most likely cause of the system failure is an incorrect CMOS setup. In this case the CMOS needs to be reset to the values indicated by the partition table described in step 2, remembering to use the formula described in step 2 when doing so. If the values do not match, set the CMOS Sectors Per track to the number of sectors counted before the volume boot sector and continue to the next step.

Step Five: Check the partition tables to make sure they are correct

Reboot the system to Micro-Scope and go to System Configuration, Partition Tables. Check the information displayed in the master boot record to see if there is any obvious corruption (that is, excessively large numbers, all partitions non-bootable, etc.) If there is no obvious corruption in the master boot record, then perform step 2 again. If the information matches at this point, go to step 6. If the information does not match, then set the sectors per track in the Master Boot Record to the number of sectors per track currently set in CMOS, set the starting head to 1, starting sector to 1, and starting cylinder to 0, and write the information to the drive.

Step Six: Verify the Master Boot Sector information

Display the Volume Boot Sector and use the values for heads and sectors per track (on the right half of the screen) to perform step 2 again.

If the values match, then the volume boot sector is probably okay. If any values in the Master Boot Record do not match the table to the right, reset the values to match the values in the table, and write to the drive.

If the values still do not match, both the Master Boot Record and the Volume Boot Record are probably corrupt. At this point, e-mail Technical Support for help in this situation. Future articles will provide more insight into the repair procedure.

Step Seven: Check the FATs

Check to see if the first FAT starts on the sector just beyond the volume boot sector. Use the find feature in the Fixed Disk Editor to search for F8 FF FF in the first three bytes of each sector. The first occurrence should be on sector two of head one. Continue to search until the second FAT is found, indicated by the second occurrence of F8 FF FF. Note the location of the cylinder, head and sector of the second FAT.

Based on the start of the second FAT, and the start of the first FAT, calculate how many sectors are in the first FAT. If necessary, read each sector starting at the first sector of the first FAT, keeping a count of the sectors that have been read until F8 FF FF is seen in the upper left of the HEX display, which would indicate the start of the second FAT. After calculating the sectors per FAT, compare this value to the value in the volume boot sector. If the values match, the drive should be accessible through DOS at this point.

Step Eight: Attempt to access the drive

Boot to a DOS-bootable floppy diskette and attempt to access the drive. If the root directory and sub-directories on the hard drive are readable at this point, then attempt to boot to the drive. If the drive boots at this point, the problem has been corrected. If the drive is still not bootable, e-mail the Micro 2000 Technical Support department for help.

Disclaimer - The Micro 2000 Tech Tip is a free service providing information only. While we use reasonable care to see that this information is correct, we do not guarantee it for accuracy, completeness or fitness for a particular purpose. Micro 2000, Inc. shall not be liable for damages of any kind in connection with the use or misuse of this information.

Micro 2000 Inc has been helping to solve the day-to-day challenges that IT departments face in order to keep their businesses operational as well as profitable for over 14 years. The company’s primary goal is to put the customer first - through feature-rich, simple-to-use IT tools that can help IT administrators manage their jobs more effectively.

For more advice and free articles be sure to visit: http://www.micro2000.co.uk

Tags: computer, diagnostics, hard drives, maintaining pcs and computers, PC, pc and computer tools, tech tipscomputer, diagnostics, hard drives, maintaining pcs and computers, PC, pc and computer tools, tech tips

Share This

The proper graphics card can help speed up almost any system by taking the responsibility of many visual functions, allowing the CPU to work more effectively in other areas. Let’s take a look at a few of the key features to look for in a graphics card.

Most all graphics cards are based on an Nvidia or ATI Radeon chip set. For the casual home or office user, any of today’s video cards are adequate. If you’re just doing Excel spreadsheets you might not need to spend $500 on a video card, but if you have a 21″ monitor and want to view that spreadsheet at 1600 x 1200 with a high refresh rate, it may be worth the investment. Where things start to change is on high end games, that’s where the Geforce and Radeon cards make the difference.

Memory Matters

As with every other facet of computing, more is always better. However, you don’t need a 256MB card if you’re just going to be using Quickbooks. For most office applications, a 32 or 64MB card is adequate. For gamers or those doing some sort of video production work, a minimum of 128MB is recommended, with a strong lean to 256. The more memory your video card has, the higher the resolution, and the larger the number of colors it can display.

Connectors and Interfaces

A standard SVGA card is going to have a single VGA connector. Higher end cards will have an S-Video and a DVI connector as well. What this means is that you have to pay attention to what type of monitor you have. DVI is all digital, like HDTV. The S-Video can be used to output to your TV for gaming on a larger screen.

Now a days, you will have either a PCI or an AGP slot for your video card. AGP stands for Advanced Graphics Port and as you might have guessed, means there are enhancements in performance when using and AGP slot. If your current video card is built into the motherboard, it is likely robbing the system of valuable memory because the system RAM is shared with it. This is another good reason to upgrade your video card.

John Gibb manages http://www.computer-and-printer-reviews.com
The site dedicated to computers and printers.

Tags: computer, computer problems, Computer Viruses, computers, software, spyware, trojans, virus, virusescomputer, computer problems, Computer Viruses, computers, software, spyware, trojans, virus, viruses

Share This