RE: Unhandled Script Exception error in smartlist after new laptop install of GP 2013
This type of error is commonly caused, but not always, when running the ‘old’ ClearCompanies script, which can remove records from the ADH00100 table, thus causing this error. This error doesn’t require us to re-initialize SmartList, so we should be ok there.
We normally would need to see the results of these scripts to verify what is missing between these tables:
Select * from ASIEXP81 where ASI_Favorite_Type > 499 and ASI_Favorite_Type < 2000 order by ASI_Favorite_Dict_ID, ASI_Favorite_Type
Select * from ADH00100 order by ASI_Favorite_Dict_ID, ASI_Favorite_Type
Select * from ADH00101 order by ASI_Favorite_Dict_ID, ASI_Favorite_Type
If the records missing are for custom SmartList reports, I can tell you which ones are missing, then sometimes I can write scripts that will help resolve the issue, especially if it is the ADH00100 table, or we'll need to use a backup of the DYNAMICS/system database from before the error was being seen, to DTS the missing records over as needed.
I would recommend a support case, as that will expedite a resolution to this, as we'd need to go through the script results.
Thanks
Share
Report
50
All responses (
Answers (
