none
SCCM data related issue RRS feed

  • Question

  • Hi Team,

    We are trying to import data from SCCM database using a connector SCCMto SDP connector. 

    Some of the information is importing correctly and few of the information is missing.

    for example User Site, Department etc..(User account related)

    In logs below is the exception :

    Nov 30, 2018 12:04:26 AM com.assetexplorer.sccmconnector.SCCMScanner getUserAccountInfo
    INFO: User Account Info processing.....
    Nov 30, 2018 12:04:26 AM com.assetexplorer.sccmconnector.SCCMScanner getUserAccountInfo
    WARNING: Problem while UserAccount Info process and adding to failedinfo list
    java.sql.SQLException: Invalid object name 'User_Account_Data'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
    at com.assetexplorer.sccmconnector.SCCMScanner.getUserAccountInfo(SCCMScanner.java:1952)
    at com.assetexplorer.sccmconnector.SCCMScanner.getHardwareInfo(SCCMScanner.java:284)
    at com.assetexplorer.sccmconnector.SCCMScanner.startSCCMScan(SCCMScanner.java:187)
    at com.assetexplorer.sccmconnector.SCCMScanner.startSchedule(SCCMScanner.java:163)
    at com.assetexplorer.sccmconnector.SCCMScanner.main(SCCMScanner.java:2258)

    Please suggest how to resolve it, 

    Also please let me know which kind of user account is needed on SCCM Database side to access this user information 

    Friday, December 7, 2018 7:15 AM

All replies