I download the quick cube from Cube store and while is working well with Nav Demo db (when you setup one company at the time) , I have hard time with one of my clients multi company setup as follow :
“Error during execution of package for
SSIS Package: Nav_dbo_Country_Region_e69f5e8b-1680-4ba1-b037-f947aa3eeaa1
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "The metadata could not be determined because every code path results in an error; see previous errors for some of these.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Invalid object name 'dbo.Company XXX$Country_Region'.".
Unable to retrieve column information from the data source. Make sure your target table in the database is available.
OLE DB Source failed the pre-execute phase and returned error code 0xC020204A.
SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
at TimeXtender.DataManager.SSIS2016.SSISEngine2016.ExecutePackage(IPackageExecutionInput packageInput)
at TimeXtender.DataManager.Adapter_NAV.ExecuteTable(Adapter_NAV navAdapter, Table_NAV executionTable, IProviderDestination ProviderDestination, String ssisFolder)
at TimeXtender.DataManager.Adapter_NAV.ExecuteTable(IDataAdapterTable table, MultipleExecutionMessage executionMessage, List`1 failedAdapters, String ssisFolder, DataManTable dataManTable, StepSetup stepSetup)”
While I understand why is happening ( the specific table object does not exist Invalid object name 'dbo.Company XXX$Country_Region'.".
) , because Company being a multi companies environment , the main tables are setup on Nav to not be company specific (it’s a property on Nav table) , therefore the table is called 'dbo.$Country_Region' , but the script is looking to a specific combination Company+name. How we can fix that on multiple companies environment ?
This it happened for all main tables . Any Ideas ?