Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

D365 upgrade LCS system diagnostics and environment discovery errors

(0) ShareShare
ReportReport
Posted on by 303
Hello everyone,
 
I am getting the below errors while I use the option Collect now using Microsoft Dynamics Lifecycle Services System Environment Discovery. I am using MS online documentation for the upgradation and after the installation of system diagnostic service in AX environment, the environment is discovered and uploaded to LCS successfully and then we click Collect now button to push the data from AX environment to LCS but I do not see any job or collector or report data on LCS and we are seeing some errors in event viewer. Can you guys guide us how to fix those or anything which we are missing the push the data to LCS? Below are the errors from event log.
 
Collection started for environment: LCS-365
 
1-  Collector FA_Setup_Parameters(SqlCollector) failed to run against target [AXR3].[MicrosoftDynamicsAX]: Invalid column name 'ASSETALLOWLOCATIONTRANSFER_JP'.
    Invalid column name 'DEPRECIATIONCATCHUPINTERVAL_JP'.
    Invalid column name 'LOWCOSTASSETTHRESHOLD_W'.
    Invalid column name 'ANALYSISDIMENSIONATTRIBUTE_RU'.
    Invalid column name 'ASSESSEDROLL_RU'.
    Invalid column name 'ASSESSEDTAXINITDATE_RU'.
    Invalid column name 'COMPANYISSUE_RU'.
    Invalid column name 'COMPANYRECEIPT_RU'.
    Invalid column name 'DISPOSAL_RU'.
    Invalid column name 'LENDING_RU'.
    Invalid column name 'LENDINGRETURN_RU'.
    Invalid column name 'OTHER_RU'.
    Invalid column name 'PARTIALTAKEDOWN_RU'.
    Invalid column name 'CURRENCYWRITEDOWNADJ_RU'.
    Invalid column name 'CURRENCYWRITEUPADJ_RU'.
    Invalid column name 'MAJORREPAIRS_RU'.
    Invalid column name 'LANDTAXCODE_RU'.
    Invalid column name 'LANDTAXROLL_RU'.
    Invalid column name 'LOWCOSTASSETINVENTPROFILEID_RU'.
    Invalid column name 'TAXBOOKIDDEFAULT_RU'.
    Invalid column name 'TAXCODE_RU'.
    Invalid column name 'TRANSPORTTAXCODE_RU'.
    Invalid column name 'TRANSPORTTAXROLL_RU'. 
 
2-  Collector IWM_Setup_InventParameters(SqlCollector) failed to run against target [AXR3].[MicrosoftDynamicsAX]: Invalid column name 'PRODUCTVARIANTFEATURESREADY'.
    Invalid column name 'OWNERSHIPCHANGEJOURNALNAMEID'.
    Invalid column name 'PRODUCTVARIANTSPECIFICORDERSETTINGS'.
    Invalid column name 'MUSTCHECKINVENTUPDATEBLOCKEDITEM'. 
 
3-     Collector OA_MO_Parameters(SqlCollector) failed to run against target [AXR3].[MicrosoftDynamicsAX]: Invalid column name 'EXCHANGESERVERURL'. 
 
4-     Collector OA_Workflow_Parameters(SqlCollector) failed to run against target [AXR3].[MicrosoftDynamicsAX]: Invalid column name 'REQUIREEXPLICITUSERASSIGNMENTTOLEGALENTITIES'. 
 
5-     Data file PS_Common_POLineCount.xml has exceeded the maximum size limit of 64MB. This data file is excluded from the uploading package.
 
6-     Data file PS_Common_RequisitionsLineCount.xml has exceeded the maximum size limit of 64MB. This data file is excluded from the uploading package.
 
7-     Collector ssss(SqlCollector) failed to run against target [AXR3].[MicrosoftDynamicsAX]: Could not find stored procedure 'sss'.
 
Thanks
 
 
 
 
 
  • M.Nauman Rashid Profile Picture
    M.Nauman Rashid 303 on at
    D365 upgrade LCS system diagnostics and environment discovery errors
    Just pasting the image as reference to last reply.
     
  • M.Nauman Rashid Profile Picture
    M.Nauman Rashid 303 on at
    D365 upgrade LCS system diagnostics and environment discovery errors
    Hi Hana,
     
    Thanks for your response on this. Actually we already installed the system diagnostic component according to the MS documentation and now we are running the collector from Microsoft Dynamics Lifecycle Services System Environment Discovery tool and at that time we are getting these all error. So should we need to resolve these errors first to successfully upload the data to LCS environment? If yes, then what actions we need to take on this? 
     
    One more thing, while installing the system diagnostic component we got X509 certificate warning message but we skip and proceed that. So is this what which is actually the cause? I am pasting the error image below for the reference. But after proceeding we were able to upload the environment to LCS successfully from Environment Discovery tool and then when we run the collector, we get the issues.
     
     
    Thanks.
     
    Regards,
    Nauman
     
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    D365 upgrade LCS system diagnostics and environment discovery errors
    Hi,
    In Microsoft Dynamics Lifecycle Services, System Diagnostics includes a native component that must be installed before the service can be used to discover the Microsoft Dynamics AX environment and collect data.
    Please check the conditions for installing the system diagnostic component according to the content of the article:
    Install and run System diagnostics | Microsoft Learn
    Also, you can check the similar question below, hope it will be useful.
    Dynamics Community Forum Thread Details
    Best Regards,
    Hana

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans