Discussion:
Analytical Accounting AAG10000 file problem
(too old to reply)
KJ
2007-05-18 14:51:32 UTC
Permalink
For some reason, there are records in our AAG10000 work file for
journal entries that have been posted. As a result, if we try and go
into adjust the AA information (transactions >> financial >>
Analytical Accounting >> edit analysis) and put in one of these
journal entries, we are given an error:
[Microsoft][ODBC Sql Server Driver][SQL Server]Cannot insert duplicate
key row in object 'AAG10000' with unique index 'AK2AAG10000'.

My questions are 1) Why did this happen in the first place, and 2) is
there any type of quick reconciliation to remove these records, or how
do I remove them?

If anyone has any knowledge on this, it is greatly appreciated.

Thanks,
KJ
Gerald
2007-05-18 15:17:02 UTC
Permalink
KJ,
Is this a restored backup from a working Company? If it is, if you just
restored the company database and you did not update your AAG tables in
Dynamics Database, the sequence of numbers will cause this problem.

G
Post by KJ
For some reason, there are records in our AAG10000 work file for
journal entries that have been posted. As a result, if we try and go
into adjust the AA information (transactions >> financial >>
Analytical Accounting >> edit analysis) and put in one of these
[Microsoft][ODBC Sql Server Driver][SQL Server]Cannot insert duplicate
key row in object 'AAG10000' with unique index 'AK2AAG10000'.
My questions are 1) Why did this happen in the first place, and 2) is
there any type of quick reconciliation to remove these records, or how
do I remove them?
If anyone has any knowledge on this, it is greatly appreciated.
Thanks,
KJ
KJ
2007-05-18 15:30:15 UTC
Permalink
Post by Gerald
KJ,
Is this a restored backup from a working Company? If it is, if you just
restored the company database and you did not update your AAG tables in
Dynamics Database, the sequence of numbers will cause this problem.
G
Post by KJ
For some reason, there are records in our AAG10000 work file for
journal entries that have been posted. As a result, if we try and go
into adjust the AA information (transactions >> financial >>
Analytical Accounting >> edit analysis) and put in one of these
[Microsoft][ODBC Sql Server Driver][SQL Server]Cannot insert duplicate
key row in object 'AAG10000' with unique index 'AK2AAG10000'.
My questions are 1) Why did this happen in the first place, and 2) is
there any type of quick reconciliation to remove these records, or how
do I remove them?
If anyone has any knowledge on this, it is greatly appreciated.
Thanks,
KJ- Hide quoted text -
- Show quoted text -
This first took place in the working company, which might have been
restored at some point. I then did backup the company and restore it
into a "test" company to test it. What needs to be done to update the
AAG tables in the Dynamics Database?

KJ
Gerald
2007-05-18 16:55:03 UTC
Permalink
KJ,
AAG00102 holds the GLHDR numbering in AA. Try modifying the field AARowID
for each table for the company you are having problems with. the first field
AATableID is the table suffix. You can do a a query on your transaction
tables, and get the MAX of the GLHDRID and just plus one and update this
table.

Hope this helps!

Gerald
Post by KJ
Post by Gerald
KJ,
Is this a restored backup from a working Company? If it is, if you just
restored the company database and you did not update your AAG tables in
Dynamics Database, the sequence of numbers will cause this problem.
G
Post by KJ
For some reason, there are records in our AAG10000 work file for
journal entries that have been posted. As a result, if we try and go
into adjust the AA information (transactions >> financial >>
Analytical Accounting >> edit analysis) and put in one of these
[Microsoft][ODBC Sql Server Driver][SQL Server]Cannot insert duplicate
key row in object 'AAG10000' with unique index 'AK2AAG10000'.
My questions are 1) Why did this happen in the first place, and 2) is
there any type of quick reconciliation to remove these records, or how
do I remove them?
If anyone has any knowledge on this, it is greatly appreciated.
Thanks,
KJ- Hide quoted text -
- Show quoted text -
This first took place in the working company, which might have been
restored at some point. I then did backup the company and restore it
into a "test" company to test it. What needs to be done to update the
AAG tables in the Dynamics Database?
KJ
Rockfield
2007-05-20 20:33:01 UTC
Permalink
KJ,

Gerald is correct, the table AAg00102 in the Dynamics DB is causing the
problem. Usually from restored TEST instance companies.

I have a script that rectifies the problem with the out of synch sequence
numbers.

Post your email addy and I'll send it to you.

Cheers.

R.
Post by KJ
Post by Gerald
KJ,
Is this a restored backup from a working Company? If it is, if you just
restored the company database and you did not update your AAG tables in
Dynamics Database, the sequence of numbers will cause this problem.
G
Post by KJ
For some reason, there are records in our AAG10000 work file for
journal entries that have been posted. As a result, if we try and go
into adjust the AA information (transactions >> financial >>
Analytical Accounting >> edit analysis) and put in one of these
[Microsoft][ODBC Sql Server Driver][SQL Server]Cannot insert duplicate
key row in object 'AAG10000' with unique index 'AK2AAG10000'.
My questions are 1) Why did this happen in the first place, and 2) is
there any type of quick reconciliation to remove these records, or how
do I remove them?
If anyone has any knowledge on this, it is greatly appreciated.
Thanks,
KJ- Hide quoted text -
- Show quoted text -
This first took place in the working company, which might have been
restored at some point. I then did backup the company and restore it
into a "test" company to test it. What needs to be done to update the
AAG tables in the Dynamics Database?
KJ
HFLo
2007-05-21 02:46:00 UTC
Permalink
Would appreciate if you can also send to:
***@pcs.com.my

many thks...
Post by Rockfield
KJ,
Gerald is correct, the table AAg00102 in the Dynamics DB is causing the
problem. Usually from restored TEST instance companies.
I have a script that rectifies the problem with the out of synch sequence
numbers.
Post your email addy and I'll send it to you.
Cheers.
R.
Post by KJ
Post by Gerald
KJ,
Is this a restored backup from a working Company? If it is, if you just
restored the company database and you did not update your AAG tables in
Dynamics Database, the sequence of numbers will cause this problem.
G
Post by KJ
For some reason, there are records in our AAG10000 work file for
journal entries that have been posted. As a result, if we try and go
into adjust the AA information (transactions >> financial >>
Analytical Accounting >> edit analysis) and put in one of these
[Microsoft][ODBC Sql Server Driver][SQL Server]Cannot insert duplicate
key row in object 'AAG10000' with unique index 'AK2AAG10000'.
My questions are 1) Why did this happen in the first place, and 2) is
there any type of quick reconciliation to remove these records, or how
do I remove them?
If anyone has any knowledge on this, it is greatly appreciated.
Thanks,
KJ- Hide quoted text -
- Show quoted text -
This first took place in the working company, which might have been
restored at some point. I then did backup the company and restore it
into a "test" company to test it. What needs to be done to update the
AAG tables in the Dynamics Database?
KJ
james
2007-05-21 07:08:01 UTC
Permalink
Can you send it at james-***@hotmail.com
-James
Post by Rockfield
KJ,
Gerald is correct, the table AAg00102 in the Dynamics DB is causing the
problem. Usually from restored TEST instance companies.
I have a script that rectifies the problem with the out of synch sequence
numbers.
Post your email addy and I'll send it to you.
Cheers.
R.
Post by KJ
Post by Gerald
KJ,
Is this a restored backup from a working Company? If it is, if you just
restored the company database and you did not update your AAG tables in
Dynamics Database, the sequence of numbers will cause this problem.
G
Post by KJ
For some reason, there are records in our AAG10000 work file for
journal entries that have been posted. As a result, if we try and go
into adjust the AA information (transactions >> financial >>
Analytical Accounting >> edit analysis) and put in one of these
[Microsoft][ODBC Sql Server Driver][SQL Server]Cannot insert duplicate
key row in object 'AAG10000' with unique index 'AK2AAG10000'.
My questions are 1) Why did this happen in the first place, and 2) is
there any type of quick reconciliation to remove these records, or how
do I remove them?
If anyone has any knowledge on this, it is greatly appreciated.
Thanks,
KJ- Hide quoted text -
- Show quoted text -
This first took place in the working company, which might have been
restored at some point. I then did backup the company and restore it
into a "test" company to test it. What needs to be done to update the
AAG tables in the Dynamics Database?
KJ
unknown
2008-11-24 06:44:49 UTC
Permalink
Hi,

Can i have the script to sync AAG00102 table as well.

thanks in advance.

Email: ***@yahoo.com
Kristie McNulty
2011-01-24 17:11:31 UTC
Permalink
Rockfield - does your script resolve what I'm after for our AAG10000 error?

"Cannot insert the value NULL into column 'GLPSTDT', table '#####.dbo.AAG10000'; column does not allow nulls. INSERT fails."

If it does, would you please share your script with me? email: ***@WoltersKluwer.com.

Thank you in advance.
Post by KJ
For some reason, there are records in our AAG10000 work file for
journal entries that have been posted. As a result, if we try and go
into adjust the AA information (transactions >> financial >>
Analytical Accounting >> edit analysis) and put in one of these
[Microsoft][ODBC Sql Server Driver][SQL Server]Cannot insert duplicate
key row in object 'AAG10000' with unique index 'AK2AAG10000'.
My questions are 1) Why did this happen in the first place, and 2) is
there any type of quick reconciliation to remove these records, or how
do I remove them?
If anyone has any knowledge on this, it is greatly appreciated.
Thanks,
KJ
Post by Gerald
KJ,
Is this a restored backup from a working Company? If it is, if you just
restored the company database and you did not update your AAG tables in
Dynamics Database, the sequence of numbers will cause this problem.
G
Post by KJ
This first took place in the working company, which might have been
restored at some point. I then did backup the company and restore it
into a "test" company to test it. What needs to be done to update the
AAG tables in the Dynamics Database?
KJ
Post by Gerald
KJ,
AAG00102 holds the GLHDR numbering in AA. Try modifying the field AARowID
for each table for the company you are having problems with. the first field
AATableID is the table suffix. You can do a a query on your transaction
tables, and get the MAX of the GLHDRID and just plus one and update this
table.
Hope this helps!
Gerald
Post by Rockfield
KJ,
Gerald is correct, the table AAg00102 in the Dynamics DB is causing the
problem. Usually from restored TEST instance companies.
I have a script that rectifies the problem with the out of synch sequence
numbers.
Post your email addy and I'll send it to you.
Cheers.
R.
Post by HFLo
many thks...
Post by james
-James
Post by unknown
Hi,
Can i have the script to sync AAG00102 table as well.
thanks in advance.
Submitted via EggHeadCafe
Stock Quotes via jQuery-enabled WCF Service, JSON, and jQuery Templates
http://www.eggheadcafe.com/tutorials/aspnet/9c157185-9ded-4352-8311-73153d9d1297/stock-quotes-via-jqueryenabled-wcf-service-json-and-jquery-templates.aspx
Grant Hodgson
2011-06-21 22:40:49 UTC
Permalink
Hi There
Could you send this script as well?
***@g2systemsgroup.com
Thank you very much
G
Post by KJ
For some reason, there are records in our AAG10000 work file for
journal entries that have been posted. As a result, if we try and go
into adjust the AA information (transactions >> financial >>
Analytical Accounting >> edit analysis) and put in one of these
[Microsoft][ODBC Sql Server Driver][SQL Server]Cannot insert duplicate
key row in object 'AAG10000' with unique index 'AK2AAG10000'.
My questions are 1) Why did this happen in the first place, and 2) is
there any type of quick reconciliation to remove these records, or how
do I remove them?
If anyone has any knowledge on this, it is greatly appreciated.
Thanks,
KJ
Post by Gerald
KJ,
Is this a restored backup from a working Company? If it is, if you just
restored the company database and you did not update your AAG tables in
Dynamics Database, the sequence of numbers will cause this problem.
G
Post by KJ
This first took place in the working company, which might have been
restored at some point. I then did backup the company and restore it
into a "test" company to test it. What needs to be done to update the
AAG tables in the Dynamics Database?
KJ
Post by Gerald
KJ,
AAG00102 holds the GLHDR numbering in AA. Try modifying the field AARowID
for each table for the company you are having problems with. the first field
AATableID is the table suffix. You can do a a query on your transaction
tables, and get the MAX of the GLHDRID and just plus one and update this
table.
Hope this helps!
Gerald
Post by Rockfield
KJ,
Gerald is correct, the table AAg00102 in the Dynamics DB is causing the
problem. Usually from restored TEST instance companies.
I have a script that rectifies the problem with the out of synch sequence
numbers.
Post your email addy and I'll send it to you.
Cheers.
R.
Post by HFLo
many thks...
Post by james
-James
Post by unknown
Hi,
Can i have the script to sync AAG00102 table as well.
thanks in advance.
Post by Kristie McNulty
Rockfield - does your script resolve what I'm after for our AAG10000 error?
"Cannot insert the value NULL into column 'GLPSTDT', table '#####.dbo.AAG10000'; column does not allow nulls. INSERT fails."
Thank you in advance.
Hi,
Is there a way to disable analytical accounting module for a specific company or database.
we have multiple companies and we use analytical accounting only on one company but for some reason, I have this module enabled on all companies and I need to disable it permanently because it's causing other issues since it's not fully setup and I don't intend to use it for specific companies.
Thanks.
m***@gmail.com
2013-12-03 02:07:22 UTC
Permalink
Would appreciate if you can also send to:

***@gmail.com

Loading...