Sunday 15 April 2012

Unexpected end of file while parsing Name has occurred. Line 1, position 2048.

This SQL 2008 error occured when I tried to read XML using the executeXmlReader() method.

Turned out that it reads in chunks of 2KB or 2048 bytes. So if you close the database connection before using the resulting reader then you will only get those first 2KB.

Resolution:
Leave your SQL database connection open while using the reader and only close it after this.

Wednesday 7 March 2012

Business Objects - Utility for removing unwanted crystal reports instances

Once I had about 3 million instances created by a rogue BOBJ server.
I needed to remove these instances but could not swallow the idea of clicking "delete" on each one.

I created this program in under two hours to do the work for me. Its not perfect by a long shot, its a quick and dirty utility like many others that i make. As long as it does the job, i'm ok with the ugly design.

You will need Microsoft Visual Studio 2010 and have the BOBJ .NET SDK library installed.

Download from BOBJ instance delete utility