Ok so i have a load of nodes that i need to set there umbracoURLAlias, now for various reasons i can not do this via the umbraco api so i have written code that inserts a new cmsPropertyData for the node and also recreates the nodes contentxml into the database this all works perfectly and when i view the nodes i see there umbraoURLAlias has been set however when i try to navigate to this url i get a not found error this happens even if i republish the node via umbraco in fact the only time i can get umbracoURlAlias to work is when creating a new node within umbraco. Can anyone point me in the write direction i believe there is either another database table i need to update or file that im not amending.

Many thanks.