Lobethal Lights 2020 - Lobethal - South Australia - Australia

Wish you all a Merry Christmas and a Happy New Year 2021. 

With the interruptions from bush fires in 2019 and cancellation of many events due to the Covid 19 pandemic, I needed to see how the Lobethal Christmas decorations are done.

Lobethal is a city famous for its Christmas lighting for over sixty years and is located 35 KiloMeters from Adelaide city and will take about 45 mins to drive there. Lobethal is up in the Adelaide hills so you should expect to drive in winding roads and to encounter wildlife on road so take care when driving and better drive little bit slower than the allowed maximum speed.

In the true spirit of Christmas this lighting festival has become a tradition and now it has evolved into becoming the largest community Christmas lighting display in the Southern Hemisphere.

Lights will be displayed from 20^th December to 31^st each year, I encourage all of you to visit Lobethal and support this community event.

			Score out of 5
1	Parking Availability	When all events are happening it will bit hard to find parking.	3
2	Wheelchair Access	Easy	5
3	Accessibility	Most of the decorations can be enjoyed being inside the car.	4
4	Facilities	Lobethal city facilities will be available. Toilets – Yes Barbecue – Yes	4
5	Scenery	Nothing much when dark.	2

Below is a video I made from the visit.

Map

Bogoda Falls - Bogoda - Sri Lanka

This is Bogoda falls in Bogoda, Ketawala in Uva province Sri Lanka. When you drive for about 3 kilometres in the Bogoda bridge road from Ketawala town, you will see this waterfall on the road itself, with its water flowing across the road. Since it is a road used by vehicles be mindful when you are enjoying the waterfall. Even though this is not a famous waterfall, you will see plenty of water in the wet season, also since this is on the way to the famous Bogoda Wooden bridge, you will see both of these in the same trip.

			Score out of 5
1	Parking Availability	By the side of road	2
2	Wheelchair Access	Main Viewpoint – No Secondary Viewpoint – No Picnic Areas – No	0
3	Accessibility	Can see from the road	5
4	Facilities	Covered Sitting Areas – No Toilets – No Barbecue – No Garbage Bins – No	0
5	Scenery	Waterfall Stream	2

Map

Sister - Supahan Sitha (සහෝදරී - සුපහන් සිත)

This is the Sinhala short teledrama "Sister" in the "Supahan Sitha" teledrama series by Ajith Kumarathanthri.
Actors and Actresses
- Hashinika Karaliyadda
- Manjula Moragaha
- Rebecca Godawatte
- Rihanna Kandabadagae
- Herman Jerald Perera

Sihala Kala Ranga 2019 (සිහල කළා රංග 2019)

These are some performances done in the 2019 concert by students of Sihala Kala Rangayathanaya in Adelaide Australia.

Swarna Swara 2019 Adelaide Australia (ස්චර්ණ ස්චර 2019 ඇඩිලේඩ් ඔස්ටේලියාව)

These are some of the performances in Swarna Swara 2019 concert held in Adelaide Australia on 2019-10-06.

Famous Sri Lankan artists Kasun Kalhara, Amarasiri Peris and Nirosha Virajini performed for the music of Suresh Maliyadde.

Denuwara Manike Train - Sri Lanka (දෙනුවර මැණිකේ දුම්රිය - ශ්‍රී ලංකාව)

This video is about Denuwara Manike train, which is the newest addition to Sri Lanka railways on late 2019 and was put to service on 1st of November 2019. Currently it is the fastest way to go to Badulla by train. This intercity express train known by train number 1001 will depart Colombo Fort railway station every other day at 6:45 AM and reach Badulla station at 3:30 PM after stopping at 11 stations on the main line. On the next day it will be train number 1002 and will return at 7:20 AM from Badulla station and reach Colombo Fort station at 4:30 PM, after stopping at 12 stations, making a journey of 294.3 kilometres in about 9 hours. Train will stop at Polgahawela, Peradeneya Junction, Gampola, Nawalapitiya, Hatton, Thalawakaelae, Nanuoya, Haputalae, Diyathalawa, Bandarawela, Ella. On the way back it will stop at Maradhana additionally.

Train consists of 2 Air Conditioned first class compartments with adjustable seats, adjustable arm rests, individual tables, television screens, audio jack ports, foot rests, cup holders, seat back pockets, 240 volts power outlets for some seats. 2 second class compartments with adjustable seats, adjustable arm rests, individual tables, foot rests, cup holders, seat back pockets, openable windows, 3 third class compartments, a restaurant car with disabled toilet facilities and 2 identical engines in the front and back with fully air conditioned driver and guard rooms. All compartments are having train information display screens, music, fans, luggage holders and toilets with sinks.
Denuwara Manike has a spacious disabled toilet in the restaurant compartment. Normally the door of this is locked and the restaurant staff got a key for this. It is having automatic door and hand rails for easy access. Good size sink and a mirror is also available. There is a small cubicle with a mirror and a sink near the disabled toilet for public use.

These types of trains are called DMUs which stands for Diesel Multiple Units. This S14 type powerset was manufactured by China Railway Rollingstock Corporation and was purchased for 1845 million rupees. Each of the two 11-cylinder engines can supply 1500 kilowatts to the train through AC – DC power transmission system and they are connected using the train’s electricity system. They are numbered as engine 971 and engine 972 by Sri Lanka railways department. In an engine failure, the train can reach its destination with one operating engine.

For the first time in Sri Lanka this train has a camera system and a Blackbox similar to aircraft Blackbox and records and stores all the operational data with the front camera view. The train information display screen, on this train is made out of LED panel which will display train running information in all 3 languages Sinhala, Tamil and English. It will display information such as train name, number, start and end station names, speed, next stopping station. Engines also got fuel tanks capable of storing 3500 litres of Diesel. Maximum possible speed of the train is 120 kilometres per hour. In the daily run between Colombo and Badulla it reaches 90 kilometres per hour in some sections of the route. To make the ride extra smooth, these carriages are fitted with air suspension system rather than the conventional suspension systems.

Train’s braking system is made by a German company named Knorr-Bremse, who are renowned for manufacturing reliable braking systems especially suited for hill country trains.

Since the train got 2 engines in the front and back, it doesn’t have an observation compartment.

Full route fair for first class is 1700 Sri Lankan rupees, second class is 1000 rupees and 700 rupees for third class. This train will only accept passengers who have booked tickets prior, so you cannot just buy a ticket from a railway station and get in. Tickets can be booked from most of the major railway stations like Colombo Fort, Maradhana, Badulla, Ella, Kandy, Hatton, Mathara, Galle, Anuradhapura, Jaffna. For more information visit Sri Lanka Railways website www.railway.gov.lk.

In the video you can see,

• Denuwara Manike train passing Uduwara reservoir.
• Train parked at Badulla station.
• Denuwara Manike going to Badulla yard to rest for the night.
• Train passing the famous nine arches bridge.
• Denuwara Manike passing the highest point in Sri Lanka railway line. This place is about 1898 metres or 6227 feet above mean sea level.
• Train passing iron bridges and tunnels.

Kids Ride on Toy Car

Recently I bought a Toy Ride on Car for my kids. These videos are how I fixed the car and how kids enjoy it.

Little Crystal Creek Falls, Crystal Creek, Queensland, Australia

Another interesting waterfall in Queensland is the Little Crystal Creek falls in Crystal Creek. This is made out of 2 to 3 small cascades of water and a pool of water.

This waterfall is located about 75 kilometres North West of Townsville and is reachable in a hour of driving. The road is bit winding after turning from Bruce highway. But it is sealed all the way so a two wheel drive small car would take you there without any problems. When driving from Townsville there is a big car park about 200 metres before the bridge to the left. It can easily accommodate 15 cars so you do not have to worry about finding parking.

At the park there will be 2 boards with maps and details about the area. To reach the waterfall, you need to walk about 150 metres towards the arch bridge from the car park. The bridge is a 18.3 metre long bridge constructed in 1932. There is no separate path but can walk on the left side of the road so be careful if you are travelling with children. You can reach the bridge with a pram or a wheelchair and have a look at the waterfall. But to go anywhere near the water you need to walk down the stairs and some walking on the rocks depending on the side you start walking down. I would say it is an easy 15 minutes walk from the car park. Also you can reach the waterfall starting from any side of the bridge giving you different views of the nature, so you can start from one side and come up from another.

Once you walk down you will be able to see the creek. In the dry season there will be not much water so it will be safe to walk besides the water. Near the bridge there is a table and a bench to sit and relax and have a picnic near the water. Near the car park there are barbecue, toilet and waste disposal facilities as well as a park for children to run around so I would recommend enjoying some food over there.

			Score out of 5
1	Parking Availability	Adequate	5
2	Wheelchair Access	Main Viewpoint – No        Secondary Viewpoint – No Picnic Areas – Yes	1
3	Accessibility	Easy walk till the bridge and then stairs, total walk for about 15 minutes from car park.	3
4	Facilities	Covered Sitting Areas – No Toilets – Yes Barbecue – Yes Garbage Bins – Yes	4
5	Scenery	Waterfall          Stream Bridge	3

Hope you will enjoy the video.

Map

CRM Exception message: Principal user (Id=GUID, type=8) is missing prvReadComplexControl privilege (Id=GUID)

Recently one of my customers started getting insufficient permissions messages and having issues accessing files on the CRM.

Exception detail was as below.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3s344d364e35]]: System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #CBE39829Detail:

<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">

  <ActivityId>f6dfec3a-6114-4eef-9544-a9396f5d1572</ActivityId>

  <ErrorCode>-2147220970</ErrorCode> 

<ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />

  <Message>System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #CBE39829</Message>

  <Timestamp>:44:42.8709171Z</Timestamp>

  <ExceptionRetriable>false</ExceptionRetriable>

  <ExceptionSource i:nil="true" />

  <InnerFault>

    <ActivityId>GUID</ActivityId>

    <ErrorCode>-2147220960</ErrorCode>   

<ErrorDetails xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />

    <Message>Principal user (Id=GUID, type=8) is missing prvReadComplexControl privilege (Id=GUID)</Message>

    <Timestamp>2019-07-04T07:44:42.8709171Z</Timestamp>

    <ExceptionRetriable>false</ExceptionRetriable>

    <ExceptionSource i:nil="true" />

    <InnerFault i:nil="true" />

    <OriginalException i:nil="true" />

    <TraceText i:nil="true" />

  </InnerFault>

  <OriginalException i:nil="true" />

  <TraceText i:nil="true" />

</OrganizationServiceFault>

The actual error is given in the inner fault section, the same error is logged in the event log of the CRM server as below.

Exception information:

Exception type: CrmException

Exception message: Principal user (Id=GUID, type=8) is missing prvReadComplexControl privilege (Id=GUID)  at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()

   at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveCommand.Execute()   at Microsoft.Crm.Caching.ComplexControlLoader.LoadCacheData(Guid key, IOrganizationContext context)   at Microsoft.Crm.Caching.CrmMultiOrgCacheBase`2.CreateEntry(TKey key, IOrganizationContext context)   at Microsoft.Crm.Caching.CrmMultiOrgCacheBase`2.LookupEntry(TKey key, IOrganizationContext context)   at Microsoft.Crm.Application.Components.Sdk.InlineEditControls.Web.CompositionLinkControl.GetFlyOutDescriptor()    at Microsoft.Crm.Application.Components.Sdk.InlineEditControls.Web.LinkControl.GetRequiredColumns(Int32 entityTypeCode)   at Microsoft.Crm.Application.Forms.CompositeControlVisitor.HandleColumnProvider(Control control, FormDescriptor formDescriptor)   at Microsoft.Crm.Application.InlineEdit.Mediators.FormMediator.AddControlProperties(ICrmControl crmControl, ControlDescriptor controlDescriptor)   at Microsoft.Crm.Application.InlineEdit.Mediators.FormMediator.ProcessControlHierarchy(Action`2 controlHandler)   at Microsoft.Crm.Application.InlineEdit.Mediators.FormMediator.GetInstance(FormFactor formFactor, FormDescriptor descriptor, Guid processId, Int64 processVersionNumber, IOrganizationContext organizationContext)   at Microsoft.Crm.Application.InlineEdit.ReadFormDataBuilder..ctor(String recordId, String entityTypeCode, Guid formId, FormFactor formFactor)   at Microsoft.Crm.Application.Pages.Form.FormDataPage.Render(HtmlTextWriter writer)   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

After a while found the “Complex Control” privileges are listed as “Process Configuration” in CRM security roles. To fix the issue go to CRM Security Roles and open Customization tab. There you will find Process Configuration for which you need to provide Read permission. 

Giving permissions according to the error you see will fix the issue, for example if your error showed your were missing prvCreateComplexControl, then you need to provide Create permissions.

More details about security role UI and privilege mapping can be obtained from the Microsoft article.

Unable to Enlist in the Transaction

I recently received an error while trying to run a SSIS package in Visual Studio. The full error is seen as below.

Error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D024 "The transaction manager has disabled its support for remote/network transactions.".

This error is happening when a component with transactions try to connect and manipulate data on a remote server.

To avoid this error, two things can be done.

* Remove the transaction handling from the component. – This should be done only if the transactions are not required or as a temporary measure.

You can do this by selecting the properties of the component, also check the package properties to make sure transactions are not enabled at the package level.

For an explanation of the options please visit the URL.

* Configure the Distributed Transaction Coordinator (DTC).

For a component to work correctly with transactions, below two things are required.
1. Running Distributed Transaction Coordinator (DTC) Service

This service should be running on the database server the component connects to and on  the machine where the package is running. This will coordinate the work between two machines / servers.

This can be checked and started by going to Windows Services.

2. Properly configuring the security of DTC.

To make the DTC service work properly, it should be given permission as required. This can be done by opening the Component Services window. In the component services window, navigate to Component Services –> Computers –> My Computer –> Distributed Transaction Coordinator. Right click Local DTC and click on Properties to open properties window.

If you are intending to run any workloads with transactions via any external servers you should enable “Network DTC Access”.

Depending on the situation you should allow Inbound, Outbound or both transaction manager communication options.

For complete list of explanations on each property please refer the following URL.

Enable Disk Clean-up

It seems in Windows Server latest versions the good old disk clean up tool is not enabled by default. If you just want it back you can run the below commands in a command prompt to copy the required files.

Copy C:\Windows\winsxs\amd64_microsoft-windows-cleanmgr_31bf3856ad364e35_6.1.7600.16385_none_c9392808773cd7da\cleanmgr.exe C:\Windows\System32\

Copy C:\Windows\winsxs\amd64_microsoft-windows-cleanmgr.resources_31bf3856ad364e35_6.1.7600.16385_en-us_b9cb6194b257cc63\cleanmgr.exe.mui C:\Windows\System32\en-US\

Then create a shortcut pointing to the Disk Clean up tool found in the following path.

C:\Windows\System32\CleanMgr.exe

I did try this on Windows Server 2008 R2 and hope it works as it is or with slight changes on other versions of Windows as well.

Filtering Results of a Stored Procedure

Recently I needed to filter the results of a Stored Procedure, After some searching I found 2 options for this as below.

1. Using OpenRowSet Command

SELECT * FROM OPENROWSET ('SQLOLEDB', 'Server=ServerName;TRUSTED_CONNECTION=YES;', 'EXEC sp_Who2')

Remember in this method this feature should be enabled in the server.

2. Using Temporary Tables.

-- Creating a temporary table.
CREATE TABLE #tblSPWho2
(SPId INT, Status NVARCHAR(200), LoginName NVARCHAR(200), HostName NVARCHAR(200), BlockedBy NVARCHAR(200), DBName NVARCHAR(200),
Command NVARCHAR(200), CPUTime BIGINT, DiskIO BIGINT, LastBatch NVARCHAR(200), ProgramName NVARCHAR(200), SPId2 INT, RequestId NVARCHAR(200))

-- Inserting the results of the Stored Procedure into the temporary table.
INSERT INTO #tblSPWho2
EXEC sp_Who2

-- Doing the required filtering using the temporary table.
SELECT * FROM #tblSPWho2 WHERE LoginName = 'Domain\UserName'

-- Removing the temporary table.
DROP TABLE #tblSPWho2

SP_Who2 Stored Procedure will bring all the processes that is currently active in SQL server with the relevant information, the above query will filter the results and will only display the processes that are initiated by the given username (Domain\UserName).