02-14-2017 10:35 PM
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
02-21-2017 05:38 PM
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!