Posts

Showing posts from July, 2010

Dynamics GP 10 Service pack Upgrade Failure

While upgrading from Dynamics GP 10 SP1 to SP4, one of my clients have encountered the error below. “The stored procedure Synchronize TableData() of form duSQLAccountsynch : 27Pass Through SQL returned the following results: DBMS: 102, Microsoft Dynamics GP: 0.” This error was surfacing while running utilities and upgrading DYNAMICS database. I’ve not seen this error before. Taking cue from the error message, I thought initially it might be due to non-synchronization of account framework so tried resetting dex.ini file to Synchronize=TRUE, but it didn’t work at all. To understand the probable cause of this issue, I had to rely on dexsql.log file.  The log showed that there is a possible permission issue, so we tried running the GRANT.SQL and DYNSA DB owner scripts on the databases as these were databases restored from Live instance. The same issue continued. The dexsql.log showed that the database upgrade of DYNAMICS is getting interrupted with this error when it is reaching SY