You’re offline. This is a read only version of the page.
1,652
I am using Analytical accounting and Grant Management and when I Save my Analytical transaction entry, I keep getting the following error message:
SQL Cal Failed
Dexterity Error 41
SQL Error 27
ODBC Error: S0022
What is causing this and what do I need to do to not get this error?
*This post is locked for comments
I wish I could help you more, but I really can't think of anything else besides running SQL traces or logging the SQL files from the dex.ini file. Unless someone else checks this and knows about Analytical Accounting, you might have to refer to Microsoft for a support case.
Last suggestion I would try might be to uninstall and drop all the tables, then try again. Here is the list of tables that I have as a reference (may or may not be 100%)
DYNAMICS
| AAG00100 |
| AAG00101 |
| AAG00102 |
| AAG00103 |
| AAG00104 |
| AAG00105 |
COMPANY
| AAG00200 |
| AAG00200FL |
| AAG00200L |
| AAG00200V |
| AAG00201 |
| AAG00202 |
| AAG00300 |
| AAG00300 |
| AAG00301 |
| AAG00301 |
| AAG00302 |
| AAG00302 |
| AAG00303 |
| AAG00304 |
| AAG00310 |
| AAG00311 |
| AAG00312 |
| AAG00313 |
| AAG00314 |
| AAG00315 |
| AAG00316 |
| AAG00317 |
| AAG00400 |
| AAG00401 |
| AAG00401V |
| AAG00401V1 |
| AAG00402 |
| AAG00403 |
| AAG00404 |
| AAG00405 |
| AAG00406 |
| AAG00407 |
| AAG00500 |
| AAG00600 |
| AAG00601 |
| AAG00602 |
| AAG00603 |
| AAG00605 |
| AAG00700 |
| AAG00800V |
| AAG00900 |
| AAG00900V |
| AAG00901 |
| AAG00902 |
| AAG00903 |
| AAG00903V |
| AAG00904 |
| AAG00905 |
| AAG00906 |
| AAG01000 |
| AAG01001 |
| AAG01002 |
| AAG02000 |
| AAG02001 |
| AAG10000 |
| AAG10001 |
| AAG10002 |
| AAG10003 |
| AAG10407 |
| AAG20000 |
| AAG20001 |
| AAG20002 |
| AAG20003 |
| AAG2000E |
| AAG2000T |
| AAG20011 |
| AAG2001T |
| AAG30000 |
| AAG30001 |
| AAG30002 |
| AAG30003 |
| AAG3000E |
| AAG40000 |
| AAG40001 |
| AAG40002 |
| AAG40003 |
| AAG50000 |
| AAG50001 |
| AAG50002 |
| AAG60000 |
| AAG60001 |
| AAG60002 |
| AAG70000 |
| AAG70001 |
| AAG70002 |
| aagError |
I ran checklinks - no errors and I checked and I have AA tables in both the Dynamics and the company databases.
I will try what you have suggested and let you know. I have searched all over and the only thing I could find is that the error means a column is not found, but I could not find any solutions
Darn, I just typed up a whole post and it disappeared. My initial reaction woudl be that your 10 AA tables that got created with the install might have skipped over ones that already existed in 9 if they were still sitting in the company or Dynamics database. It is possible that they have different formats ot columns. Even though you unilstalled AA, I don't believe that it actually drops the tables, probably just the client files.
Try running checklinks on Analytical accounting. Also, make sure that you have some tables in both DYNAMICS and the company database that look like AA tables. Maybe filter the table names to AAG or just AA.
Did you search customersource for this error?
What I am working with is a copy of the databases of a company that we recently updated to GP10 from GP9. When I first tried to activate AA, I was getting error messages (I was not able to activitate it at all) so what I did was completely removed AA and re-installed it. I am trying to save in Financial. I also get the error in Purchasing.
ODBC Error: S0022 is "Column Not Found" Which means that it is probably calling on a table that doesn't exist or at least the column doesn not exist in that table. Does anything work in AA? Or is it limited to just this particular transaction? I think that you shoudl try to figure out if you did the install of AA properly and the etup is all complete? What module are you trying to save in? Payables? Financial? Sales? Did you upgrade from a prior version or is it a fresh install? What version of GP are you running?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (