Error when trying to populate the datasource.

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Track-It!


    COMPONENT:

    Track-It! 2019 R3


    APPLIES TO:

    Track-It! 20.19.03



    QUESTION:

    "Error when trying to populate the datasource"

     11696 |2019-10-16 12:59:03.1126 | MATTAMYHELPDESK | ERROR | ServiceDesk | TrackIt.Core.BLL.Reporting.ReportLoggingService.LogException | Reporting error occurs: StartBuild error
     EXCEPTION: System.Exception: Error when trying to populate the datasource. The following exception was thrown:
     The schema does not contain the following column: "SYSTEM ADMINISTRATION.Technician"."LoginInfo". ---> DevExpress.XtraReports.DataRetrievalException: Error when trying to populate the datasource. The following exception was thrown:
     The schema does not contain the following column: "SYSTEM ADMINISTRATION.Technician"."LoginInfo". ---> DevExpress.DataAccess.Sql.ColumnNotInSchemaValidationException: The schema does not contain the following column: "SYSTEM ADMINISTRATION.Technician"."LoginInfo".



     


    ANSWER:

    n order to resolve the issue please verify whether or not "SYSTEM ADMINISTRATION.Technician"."LoginInfo" column in the View are visible?
     

       
    1. To obtain Technician details      
           
      •   Select [LoginInfo]
          FROM [TrackitDATABASENAME].[SYSTEM ADMINISTRATION].[Technician]
      •   
    2.  
    3. To obtain Requestor Details (just in case)      
           
      •   Select [LoginInfo]
          FROM [TrackitDATABASENAME].[SYSTEM ADMINISTRATION].[Requestors]
      •   
       Once above is confirmed, How to Resolved?  
       
    1. Do a backup of the DB, do not proceed until you create the backup
    2.  
    3. Locate the [SYSTEM ADMINISTRATION].[Technician]
    4.  
    5. Right click and select Design     
           
      1. User-added image
      2.    
      3. Scroll down until you see LoginInfo        
               
        1. User-added image
        2.     
      4.    
      5. Enable LoginInfo
      6.    
      7. User-added image
      8.    
      9. Click Save
      10.   
    6.  
    7. Run the query     
           
      1. Select [LoginInfo]
      2.    
      3. FROM [TrackitDATABASENAME].[SYSTEM ADMINISTRATION].[Technician]
      4.   
    8.  
    9. Test the results
      

      

     


    Article Number:

    000174741


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles