How To Spot Subsidence (and It's Potential Causes)

Bit of a departure this blog post but it's quite rate to be able to spot some textbook subsidence for a building and have the most likely cause visible in the same picture.As you can see in the image to the left the tree (bush?) is growing right next to the brick wall, judging by the tilt it's quite easy to imaging the roots of the plant going under the foundations of the building.If you zoom in to the corner of the building you'll see that the brick...

Read More

Noetix: Disabling Material Category (XXK_MTL_CAT) caching

This is slightly more complicated than the other "removal of caching" blog posts I've done earlier as there are multiple views (one for each structure) which all need to be updated and replaced at the same time. I've adopted a fairly simple approach;Remove any backup (_BK) viewsCreate a new view to replace the root XXK_MTL_CAT viewGo through the ALL_VIEWS system view looking for the structure-specific views and then individually replace each of them with a view based on the new XXK_MTL_CAT view created aboveRebuild all the objects that have been...

Read More

Switching to Google Public DNS (on an Apple Mac OS X Lion)

If you are interested in learning why you should be using a DNS other than that provided by your Service Provider then you might like to see Google Article on the subject;http://code.google.com/speed/public-dns/docs/intro.htmlA couple of things it doesn't mention but are also definite benefits (for me anyway) are;Automatically opting out of any Service Provider "search" services (such as those offered by Virgin Media) when you miss-type a URLAvoiding...

Read More

Noetix: New view template INV_Material_Status_History

INVG0_Material_Status_HistoryUsing Oracle's Process Manufacturing (OPM) module was part of Oracle e-Business Suite is never easy; there are so few users of process manufacturing - as opposed to it's much more commonly used bigger brother discrete manufacturing - that we often get left out.(What's the difference between Process and Discrete manufacturing? Discrete manufacturing makes individual items (Cars, TV sets, iPads, etc) these are either complete...

Read More

SQL Server: Installing Microsoft SQL Server 2012 On a Development Windows 2008r2 (SP1) System

This is a simple step-by-step guide to installing Microsoft's newest version of SQL Server with Reporting Services in stand-alone mode (the alternative is SharePoint Integrated, I'll deal with all the steps necessary to do that installation separately in a few days/weeks time).I'm using the developer edition as downloaded from Microsoft MSDN, the ISO name is;en_sql_server_2012_developer_edition_x86_x64_dvd_813280.isoI've highlighted the build version....

Read More

Windows 2008R2: Installing .NET Framework (Enabling the Feature)

2008R2 includes the .NET Framework as a feature that needs to be turned on when required. Numerous installation programs (for example SQL Server 2012) require it and will mostly just error and tell you to turn the feature on.The blog post is intended as a step-by-step guide to switching the feature on.Go to the start menu and type "Feature" into the search box, choose the option "Turn Windows Features on or off". The Server Manager will then be displayed;Windows...

Read More

iTunes: How to Download 1080p Content By Default (If Available)

By default iTunes is set to download HD content (TV Shows and Movies) in 720p and while this is the maximum supported resolution for the AppleTV 2 the new Apple TV supports up to 1080p and, if you've paid for the HD content, you might as well see it full size!*.Start with opening iTunes and bring up "Preferences" and select the green "Store" icon;iTunes Store Preferences > Store TabIn the second section at the bottom there is a drop down, showing...

Read More

SSRS: Duplicating the "Dataset1" Error Message

This is a fairly simple blog post (requested by Microsoft) showing how to create the "Dataset1" error message when you are using a report which contains no dataset called "Dataset1". Just as a quick recap the error message is along the lines of;Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)Now to make this as simple as possible I'm going to create a dataset using the (Oracle) SQL;SELECT SYSDATEFROM DUALWHERE TO_NUMBER(:TEST)...

Read More

Noetix: Comparing NOETIX_SYS Schemas

As I'm currently working on upgrading our Noetix installation from 6.0.2 to 6.1 I've been writing some SQL to do a comparison between our new 6.1 build (on a test server) and our current production 6.1 environment. At the moment the only things I'm comparing are the views (looking for new and removed), and columns looking for new and removed and where the source code has changed.In order to use this script you need to have created a database link in your test environment called NOETIX_TEST that points to your production environment.The SQL is;declare ...

Read More