0

Nav Quick Cube on multi companies database ??

Hi ,

 

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 ? 

 

Thank you

0 comments

Please sign in to leave a comment.