Dear
Earlier I have installed AA on FRx successfully , and i ran the AA wizard.
At Step 1 of 5 - it asks for the credential. When i select one of the companies(specifically) in the list it gives me the following error : An error occurred while attempting to access the database. For more information, view the Application event log.
(I can select any other company from the list and it will accept it just fine and move to Step 2 of 5, the error is for this company specifically that i am selecting, there is even another company that has special characters in it , even that company i can select, all except this one specifically)
Then if i goto the Application Event Log I get the below details
General Information *********************************************Additional Info:ExceptionManager.MachineName: SHAREPOINTExceptionManager.TimeStamp: 7/12/2012 10:59:15 AMExceptionManager.FullName: FRxSoftware.Common.ExceptionManagement, Version=7.0.310.0, Culture=neutral, PublicKeyToken=23fc7028b989ba8eExceptionManager.AppDomainName: AAWizard.exeExceptionManager.ThreadIdentity: ExceptionManager.WindowsIdentity: SHAREPOINT\AdministratorExceptionManager.ThreadHashCode: 11) Exception Information*********************************************Exception Type: FRxSoftware.Common.ExceptionManagement.FRxSoftwareExceptionMessage: An error occurred while attempting to access the database. For more information, view the Application event log.Data: System.Collections.ListDictionaryInternalTargetSite: Boolean CheckInvalidCharacter()HelpLink: NULLSource: AAWizardStackTrace Information********************************************* at FRxSoftware.Integrations.Tools.AAWizard.ComplianceErrorUserControl.CheckInvalidCharacter() at FRxSoftware.Integrations.Tools.AAWizard.ComplianceErrorUserControl.ErrorControlType(ErrorForm controlType) at FRxSoftware.Integrations.Tools.AAWizard.MainWizard.SwitchPanel(WizardNavigationDirection navDirection)2) Exception Information*********************************************Exception Type: System.Data.Odbc.OdbcExceptionErrors: System.Data.Odbc.OdbcErrorCollectionSource: SQLSRV32.DLLErrorCode: -2146232009Message: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'udf_tblInvalidCharErrors'.Data: System.Collections.ListDictionaryInternalTargetSite: Void HandleError(System.Data.Odbc.OdbcHandle, RetCode)HelpLink: NULLStackTrace Information********************************************* at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at FRxSoftware.Integrations.Tools.AAWizard.ComplianceErrorUserControl.CheckInvalidCharacter()
Your Help is greatly appreciated
Regards
After running the scripts over Dynamics, the result is actually another script that you will need to use for your companies.
Regards,
Mohammad R. Daoud MVP-MCT
Have you seen the GP Excel Paste yet? http://di.jo/GPExcelPaste.aspx
I have further investigated this issue above and it turns out there are missing stored procedures, functions and tables that should be there. For some reason they are missing. I tried to copy them manually from a working database but i am convinced that i am going to miss others.
Is there anyway we can regenerate all stored procedure and tables for the AA in FRx from the system automatically , not manually.
Your input is greatly appreciated.
Yes you can, please refer to my blog post below for more details:
mohdaoud.blogspot.com/.../integrating-frx-with-analytical_5625.html
In summary, follow the below:
Go to “C:\Program Files\FRx Software\FRx 6.7\Analytical Accounting\Scripts\SQL Server” you will find 2 scripts:
CreateTablesAA.sql and CreateProcsFunctionsAA.sql
First run CreateTablesAA against you Dynamics Database, which will generate another script to run on your companies databases, copy this script and run it on a new query window to update your database.
Then run CreateProcsFunctionsAA and perform the same steps you performed on the other script.
Reference to your response , after i run the CreateTablesAA script on Dynamics where will it generate and put those other scripts that i am supposed to run on my Company Database. Where can i locate them?
and same for CreateProcsFunctionsAA , where will it create the others scripts that i need to run on my company database.
Thank you very much , i tried it and it worked like a charm, Thanks again for your help