Software Information

Microsoft Great Plains - Typical Problems And Fixes - Overview For IT Administrators

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!

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 (, he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

You can contact Andrew:


Government Technology

Carnegie Mellon engineers aim to unmask anonymous surfing software
Pittsburgh Post Gazette
Carnegie Mellon University researchers have been working to remove the veil of secrecy from the Tor Project, a free software program that allows users to anonymously surf the Internet on various devices, including smartphones like above.
Carnegie Mellon University Engineers Aim to Unmask Surfing SoftwareGovernment Technology
Tor attack may have unmasked usersiT News

all 111 news articles »

Inside The Software That Shapes Your Music: Steven Slate (Part 2)
With this software guru by his side, Slate dove full force into the world of analog modeling for digital platforms—but not the kind of analogue modeling I spoke of before. Not drum samples or bass emulators, not vintage synths or guitar replicas, but ...

and more »


Inside The Software That Shapes Your Music: Steven Slate (Part 1)
In the introduction to this series, I remarked that the new Holy Grails of pop iconography (the up-side-down Stratocaster of Jimi Hendrix; the circular array of Neil Peart's drum-set) are increasingly less tangible. Rather, they have become pieces of ...

VMS Software, Inc. Named Exclusive Developer of Future Versions of OpenVMS ...
BOLTON, Mass., Jul 31, 2014 (BUSINESS WIRE) -- VMS Software, Inc. (VSI) today announced that HP has named it as the sole developer of future versions of the OpenVMS operating system and its layered product components. Under the agreement, VSI will ...
eCube Systems and VMS Software Corporation Building Future for OpenVMS

all 12 news articles »


Defining Life's Digital Software
Specifically, Walker and colleagues are researching how this aspect of information theory helps life reach a tipping point where there's top-down flow, so that its biological software gains control of the hardware. The researchers note that this shift ...

Business Today

Infosys poised for software reboot
Financial Times
Mr Sikka told the Financial Times that he would develop areas such as data analytics and cloud computing, as part of a drive to take on global technology “big guns” such IBM, as he starts work on Friday at India's second-largest software group by revenue.
Infosys Taps First-Ever Outsider CEO to Lead TurnaroundWall Street Journal

all 48 news articles »

CBS News

Work-from-home remote access software vulnerable to hackers: Report
CBS News
Newly discovered malware, dubbed "Backoff," was found to have infiltrated computer networks through commonly used remote desktop software such as Microsoft's Remote Desktop, Apple Remote Desktop and Chrome Remote Desktop, says the report.
Feds warn retailers about malwareCNBC
US government warns retailers about malicious softwareChicago Tribune

all 42 news articles »

Wall Street Journal (blog)

Bar Exam Fail: Law grads unable to submit completed tests due to software glitch
Fox News
ExamSoft, the management platform software that handles digital bar exam submissions for multiple states, experienced a severe technical meltdown on Tuesday, leaving many graduates temporarily unable to complete the exams needed to practice law.
Software Snafu Delays Bar Exam SubmissionsWall Street Journal (blog)
Bar exam software problem forces states to extend deadlines for law graduatesThe Guardian
Software delays hit Maryland bar exam takersDaily Record (subscription)
Business Insider
all 138 news articles »


Oracle Nabs Cloud Software Company TOA
The deal should be viewed against the backdrop of Oracle's tightening rivalry in cloud business software with While Salesforce is known primarily for its Customer Relationship Management software (indeed, CRM is Salesforce's stock ...
Oracle buys TOA Technologies in strike against Salesforce.comPCWorld

all 35 news articles »

Above the Law

Illinois among states extending bar exam deadlines after software havoc
Chicago Tribune
A company that makes software used to administer bar exams in dozens of states has said that delays experienced by thousands of aspiring attorneys across the country have eased, and many states have extended test deadlines. ExamSoft Worldwide Inc ...
The Horror – Bar Exam Software Server Problems NationwideJD Supra (press release)

all 8 news articles »

Google News

home | site map
© 2006