Announcements
When I am generating the report it generates the error. I have already tried checking links. but always the same mistake.
Hi Beat,
That's how it is. something happened on the tables and they were corrupted. I already did what Brandon told me and everything went well.
I thank you for your attention.
Regards.
Hello Brandon,
I already made the indications you gave me in the test database. everything was a success. Now I will do the same in the production environment.
Thank you very much for your indications.
Regards.
Hi Juan,
Then it is likely a data corruption between GL20000 & GL30000 as Brandon suggested to check..
Some reports might work, some not, depending on what data is aggregated in the report..
The fact that it started to happen after the service pack apply might be a sign, but not necessarily the root cause.
Hello Brandon,
Thanks for answering. I am going to carry out the procedure that you indicate. If I have doubts, any problem or success in the solution, I will indicate it to you.
stay tuned
Hi Beat,
thanks for answering. I tell you that the error is generated in both ways, when I use the original GP report and the modified one, in both cases the same error is generated.
I tell you that this was generated after updating GP from version 2016 to version 2018 with the service pack of February 2021. Before this everything was fine.
The interesting thing is that it only happens with all the summary and detail trial balance reports. all other GP reports are fine.
Do you have another idea of what could be happening?
Hello Juan,
This error can be tricky and will likely need a support case to get addressed.
My assumption is our Identity Column is incorrect on one of GL tables and it is why it is erroring when attempting to put value into the temp table. My initial thoughts would be that it is incorrect on the GL20000 or GL30000 depending on if you are running the report for an Open or Historical year.
You can try the following to determine if this corrects the error.
I recommend testing this in a test company with a copy of live data to ensure that you receive the results you are looking for:
KB 871973 How to set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, or SQL Server 2005
NOTE: Please make sure that you have a restorable backup prior to performing any troubleshooting steps.
select count(*) from GL20000
select count(*) from GL20000
If the error still occurs, we will likely need a support case to capture logs to see what is occurring.
I hope this helps!
Thank you!
Microsoft Support Engineer | Brandon Jarrett
Hi Juan,
is this a modified version of the GP report ? this looks like a temp table used during the report generation (the ## indicates usually SQL temp tables).
The IDENTITY_INSERT seems to be related to a primary key violation that is defined, which means the process tries to insert twice the same data into the temp table, which is not allowed.
Some logic of this report seem to have been altered.
Can you check the GP Alternate Forms & Reports security to make sure it's using the original GP report ?
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156