Reply
Occasional Visitor
Posts: 1
Registered: ‎02-14-2017

SCCM Config Manager template - dataload.ps1 throws error

When I run the dataload.ps1 it starts to populate the tables however throws the below error:

Msg 207, Level 16, State 1, Server DNKGEVELSQLT010, Line 18

Starting processing for pbist_sccm.computerprogram_staging

StartDateTime: 02/15/2017 06:46:39

EndDateTime: 02/15/2017 06:47:07

Msg 207, Level 16, State 1, Server xxxxxxxx, Line 18

Invalid column name 'NAME'.

 

We have SQL 2014 x64 bit edition.

 

Appreciate any help Smiley Happy

 

Regards,

Siddharth

 

Highlighted
Frequent Visitor
Posts: 14
Registered: ‎12-20-2016

Re: SCCM Config Manager template - dataload.ps1 throws error

This sounds like a problem with the source SCCM database (or access to it). Can you please try this:

  • using SQL Management Studio, connect to the SCCM database using the same user used during template's provisioning
  • run the query found in file "%ProgramData%\Business Platform Solution Templates\Microsoft-SCCMTemplate\ComputerProgram.sql"

Please let us know if that works!