Broken DSC Reporting, RequestEntityTooLarge and some LCM internals


Broken DSC Reporting, RequestEntityTooLarge and some LCM internals
  1. Broken DSC Reporting, RequestEntityTooLarge and some LCM internals
    blogs.technet.com
    Abtract After migrating partial configurations to composite resources, DSC reporting as described in Using SQL Server 2016 for a DSC Pull Server did not work any longer or was no longer reliable. This is about troubleshooting this and learning something about Event ID 4260. Recently I have learned that the way to split large…
    Technology

Abtract

After migrating partial configurations to composite resources, DSC reporting as described in Using SQL Server 2016 for a DSC Pull Server did not work any longer or was no longer reliable. This is about troubleshooting this and learning something about Event ID 4260.

Recently I have learned that the way to split large DSC configurations is not using partial configurations but composite resources. The conversion was actually much easier than expected and the result is the same. But one important part was missing: Reporting.

 

The effect on the database

When the LCM starts applying a configuration (Start-DscConfiguration), it writes an entry of type ‘Initial’ into the reporting database. This record has a StartTime but not yet a valid EndTime. Also, StatusData only contains some basic information about the node.

Invoke-Sqlcmd -Database DSC -Query 'SELECT TOP 1 * FROM StatusReport' JobId : d7352efe-3ce2-11e7-836e-0017fa00000a Id : 77baf262-3ca1-11e7-8365-0017fa00000a OperationType : Initial RefreshMode : Status : LCMVersion : 2.0 ReportFormatVersion : 2.0 ConfigurationVersion : NodeName : XDC11 IPAddress : 192.168.88.129;127.0.0.1;fe80::99e2:71d5:6f53:7fe0%5;::2000:0:0:0;::1;::2000:0:0:0 StartTime : 5/20/2017 12:31:03 AM EndTime : 12/30/1899 12:00:00 AM Errors : [] StatusData : ["{\"IPV4Addresses\":[\"192.168.88.129\",\"127.0.0.1\"],\"CurrentChecksum\":\"0926E211C6D8617558 55CED942CB734CC94BF620EC6E4F8D1B9889F5B57ED6C7\",\"MACAddresses\":[\"00-17-FA-00-00-0A\",\"00-00 -00-00-00-00-00-E0\"],\"Type\":\"Initial\",\"HostName\":\"XDC11\",\"Locale\":\"en-US\",\"StartDa te\":\"2017-05-20T09:31:03.9100000+11:00\",\"JobID\":\"{D7352EFE-3CE2-11E7-836E-0017FA00000A}\", \"LCMVersion\":\"2.0\",\"IPV6Addresses\":[\"fe80::99e2:71d5:6f53:7fe0%5\",\"::2000:0:0:0\",\"::1 \",\"::2000:0:0:0\"]}"] RebootRequested : False AdditionalData : [{"Key":"OSVersion","Value":"{\"VersionString\":\"Microsoft Windows NT 10.0.14393.0\",\"ServiceP ack\":\"\",\"Platform\":\"Win32NT\"}"},{"Key":"PSVersion","Value":"{\"CLRVersion\":\"4.0.30319.4 2000\",\"PSVersion\":\"5.1.14393.0\",\"BuildVersion\":\"10.0.14393.0\"}"}]

 

After the LCM has finished the job, it sends an update statement with the same JobId to the pull server. The pull server then forwards this update query to the database server. In my case, this did not happen and the database was filling up with records, all without an EndTime and all did have the OperationType ‘Initial’ or ‘Consistency’. Additionally, all my nice report queries and PowerBI did not work anymore.

sqlstatusreportonlyinitial

 

 

 

One takeaway is that if something does not work with reporting, first take look at the DSC nodes operational log. I found an error with the ID 4260 there that was telling something about “RequestEntityTooLarge”.

eventviewer4260

 

Of course, you can also use PowerShell to find these event log entries using Get-WinEvent.

Get-WinEvent -FilterHashTable @{ LogName = 'Microsoft-Windows-Dsc/Operational'; ID = 4260 } | Select-Object -Fir st 1 | Format-List TimeCreated  : 5/20/2017 9:43:19 AM ProviderName : Microsoft-Windows-DSC Id           : 4260 Message      : Job {87B3A128-3CE4-11E7-836E-0017FA00000A} :                Http Client 77BAF262-3CA1-11E7-8365-0017FA00000A failed for WebReportManager for configuration The                attempt to send status report to the server https://xpull1:8080/PSDSCPullServer.svc/Nodes(AgentId='77BAF                262-3CA1-11E7-8365-0017FA00000A')/SendReport returned unexpected response code RequestEntityTooLarge..

 

The problem are some limitations on the pull server’s web configuration. After some research and testing I was confused by contradictory statements and resolutions. After trying without success for quite some time, I finally got it working by adding this into the web.config in ‘C:\inetpub\PSDSCPullServer’.

<bindings> <webHttpBinding> <binding maxBufferPoolSize="2147483647" maxReceivedMessageSize="2147483647" maxBufferSize="2147483647" transferMode="Streamed"> </binding> </webHttpBinding> </bindings>

 

Unfortunately the xWebConfigKeyValue does not yet support doing these settings when setting up the DSC pull server using DSC. As I do not want to make…

  1. T-Mobile will cover your iPhone if you bring it from Verizon - CNET

    CNET - News
    05.24 / 13:32 cnet.com
    The limited promotional offer will give you a payment in the form of a digital prepaid…
  2. My first lightsaber combat lesson as a new Padawan - CNET

    CNET - News
    05.24 / 13:32 cnet.com
    As Star Wars turns 40, CNET's Christine Cain decides it's time to apply her martial arts training to Jedi academy. Will her lightsaber…
  3. Serena Williams accepts a new challenge - in Silicon Valley

    SFgate.com-Tech
    05.24 / 13:32 sfgate.com
    SAN FRANCISCO (AP) — Tennis star Serena Williams has 39 Grand Slam titles, four Olympic medals, major endorsement deals and her own line of clothing and accessories. Williams didn't offer specifics about her goals as a corporate director, implying that her very presence can help push the company — and, by extension, the industry as a whole — in a more diverse direction. Silicon Valley's lack of diversity has become a recurring source of embarrassment in a region that has long sought to po…
  4. Serena Williams accepts a new challenge - in Silicon Valley

    WashingtonTimes-Technology
    05.24 / 13:31 washingtontimes.com
    SAN FRANCISCO (AP) - Tennis star Serena Williams has 39 Grand Slam titles, four Olympic medals, major endorsement deals and her own line of clothing and accessories. Now she is embarking on a new mission: She says wants to help tech companies diversify their workforces and solve one of the…
  5. Technology elevates new theme park experiences in Orlando

    WashingtonTimes-Technology
    05.24 / 13:31 washingtontimes.com
    ORLANDO, Fla. (AP) - Florida's theme parks are taking advantage of new simulated technology with attractions they are introducing this year. But as good as they all are, the Flight of Passage ride at Disney World's new Pandora-World of Avatar does the best job by far. It's designed to make…
  6. Serena Williams accepts a new challenge - in Silicon Valley

    KansasCityStar-Tech
    05.24 / 13:30 kansascity.com
    Tennis star Serena Williams has 39 Grand Slam titles, four Olympic medals, major endorsement deals and her own line of clothing and accessories. Now she is embarking on a new … Click to Continue…
  7. Technology elevates new theme park experiences in Orlando

    KansasCityStar-Tech
    05.24 / 13:30 kansascity.com
    For more than a moment, you feel the way "Avatar" hero Jake Sully felt plunging down the side of a floating mountain and coming just close enough to a giant … Click to Continue…
  8. Sleep Safe On Cloud 9 With OpusDivine Hypoallergenic Waterproof Mattress Protector

    Thefirstdispatch.com - Technology
    05.24 / 13:26 thefirstdispatch.com
    OpusDivine assures a peaceful and healthy good night sleep with its state of the art Hypoallergenic Waterproof Vinyl Free Mattress Protector that comes with a 10 year warranty. New…
  9. Marine Propulsion Engine Market to exceed $13bn by 2024

    Thefirstdispatch.com - Technology
    05.24 / 13:26 thefirstdispatch.com
    “Key industry players contributing to marine propulsion engine market share include MAN Diesel & Turbo, Wärtsilä, Mitsubishi and Caterpillar. “ “Marine Propulsion Engine Market Size By Product (Diesel, Wind &…
  10. Secure VPN Services With Lifetime Subscription (Save up to 95%) - Limited Time Deal

    Thehackernews.com - Technology
    05.24 / 13:25 thehackernews.com
    PRIVACY – a bit of an Internet buzzword nowadays, because the business model of the Internet has now shifted towards data collection. Today, most users surf the web unaware of the fact that websites and online services collect their personal information, including search histories, location, and buying habits and make millions by sharing your data with advertisers and marketers. If this i…
  11. Накопительные пакеты обновлений для System Center 2012 R2 и System Center 2016

    Blogs.technet.com - Technology
    05.24 / 13:24 blogs.technet.com
    Компания Microsoft в рамках сопровождения семейства продуктов System Center выпустила очередные пакеты накопительных исправлений. KB4020917 Тринадцатый накопительный пакет обновлений для System Center 2012 R2 (Update Rollup 12 for System Center 2012 R2) содержит исправление для Data Protection Manager, Operations Manager и Virtual Machine Manager. . KB4020906 Третий накопительный пакет для System Center 2016 (Update Rollup 3 for System Center 2016) …
  12. Excerpt from Analytics: The Agile Way

    Philsimon.com - Technology
    05.24 / 13:24 philsimon.com
    Read the Preface and Introduction from my new book. The post Excerpt from Analytics: The Agile Way appeared first on Phil…
  13. Graham Hancock Apologizes for His Temper But Still Sees Everyone As Out to Get Him

    Jasoncolavito.com - Technology
    05.24 / 13:23 jasoncolavito.com
    ​Last week, Graham Hancock and Michael Shermer debated the existence of a lost Ice Age civilization on the Joe Rogan Experience, and as I noted at the time, it did not make either man look good. Shermer was at times unprepared and often uninspiring, while Hancock was emotional instead of logical and far too quick to anger over every moment of disagreement. Similar anger issues emerged when Hancock attacked skeptic Marc Defant, the author of a harsh forthcoming review of Hancock’s Magicians …
  14. Amazon's One-Day Logitech Sale Is Perfect For Gamers and Office Dwellers Alike

    Toyland.gizmodo.com - Technology
    05.24 / 13:22 toyland.gizmodo.com
    Amazon’s back at it again with a ton of great deals on Logitech PC peripherals, today only.Read m…
  15. Lecture at Los Alamos in 1992: 'The End of the Soviet Union is the End of Who We Thought We Were'

    Toyland.gizmodo.com - Technology
    05.24 / 13:22 toyland.gizmodo.com
    “Do not buy maps, buy stock in companies that print maps,” Dr. Paul Goble told a group at Los Alamos National Laboratory in November of 1992.Read mor…
  16. The Next X-Men Movie Could Take the Franchise to Space

    Toyland.gizmodo.com - Technology
    05.24 / 13:22 toyland.gizmodo.com
    John Boyega discusses Finn’s new place in the Resistance in The Last Jedi. The stars of Game of Thrones say there’ll be a quicker pace to the next season. Plus, early rumors for the next Justice League Dark director, and new Wonder Woman posters. To me, my Spoilers!Read mor…
  17. The Most Mysterious TRAPPIST-1 Planet Finally Reveals Some Secrets

    Toyland.gizmodo.com - Technology
    05.24 / 13:22 toyland.gizmodo.com
    Now that TRAPPIST-1 is the trendiest star system in the galaxy, astronomers and nerds alike are clamoring to learn more about it. We know that the seven-planet system contains three planets in the habitable zone, which means they could hypothetically support liquid water, and even life. We also know that the…Read m…
  18. The Moment That Inspired A Global Movement To Destroy Workplace Burnout [VIDEO]

    Digitalistmag.com - Technology
    05.24 / 13:21 digitalistmag.com
    As workplace burnout reaches epidemic proportions, more companies are starting to actively address the problem as they realize its effect on the bottom…
  19. New STORServer offering delivers FedRAMP, FIPS-compliant cloud backup for government agencies

    Wwpi.com - Technology
    05.24 / 13:21 wwpi.com
    STORServer, enterprise data backup solutions company, announced Tuesday that it is now offering FIPS-compliant cloud backup for the government market. This cloud backup solution also meets security controls for FedRAMP. With IBM Spectrum Protect, formerly known as Tivoli Storage Manager or TSM, government agencies can now simply and securely embrace the advantages of the cloud for their data backup needs. With STORServer’s cloud backup, government agencies can eliminate their reliance on [&…
  20. IBM boosts open database-as-a-service on Power Systems to deliver integration and support

    Wwpi.com - Technology
    05.24 / 13:21 wwpi.com
    IBM announced Wednesday a new Database-as-a-Service (DBaaS) toolkit on Power Systems optimized for open source databases, including MongoDB, EDB PostgreSQL, MySQL, MariaDB, Redis, Neo4j, and Apache Cassandra to help deliver more speed, control, and efficiency for enterprise developers and IT departments. The new turnkey open source DBaaS toolkit available, called Open Platform for DBaaS on IBM Power Systems, runs on IBM’s OpenPOWER LC servers designed specifically for big data and de…