We're attempting to get Dynamics Analysis Cubes up and running. We're running into a problem that we've been able to reproduce in two different test environments, each on different SQL servers.
We're running Dynamics GP 2018 R2
SQL 2016 SP2
We run through the setup wizard and everything seems fine.
There are 40 companies selected.
The only module we are selecting is Financials
We select the option to create the agent job.
After the wizard is done, we run the agent job to populate the warehouse Db. This is where the problem is. The job will fail with the following error:
Source: Calculate Retained Earnings Balances Execute SQL Task
Description: Executing the query "select 1 from SystemVersion where CompanyID = ? -..." failed with the following error: "Conversion failed when converting date and/or time from character string.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
The really odd thing is that it's not always the same step ID/company that this happens on. Maybe it happens on the first company one time, then the next time it's the 15th, then the next it's 8th, then the 30th….. etc. Even though it doesn't seem to have any pattern to the which company it errors on, it does seem to be the "DynamicsGPWarehouse_Package_Master" step associated with the relative company that's always failing.
We haven't been able to make it through the entire job once. There isn't any other activity going on in the dynamics environment during this time.
Any help would be greatly appreciated.
If you've found this thread useful, dive deeper into User Group community content by role