Tridion Custom Pages URL is getting reset, where does Custom Page information stored in SDL Tridion?

Question

It has to point to the PROD URL of the custom page application, but resets to DEV URL of the same custom page. If they change it, that resets back to DEV. We have changed it 3 times and within few minutes during the process of using that application to upload with some Content, the URL got changed back to the DEV URL.

where does Custom page information stored in SDL Tridion? Like it has some information under info tab Created by , Created time, Modified by & Modified time. In one of the forums link we have seen below comment: Custom pages are stored in CustomPages.xml from below path %TRIDION_HOME%web\WebUI\Editors\CME\Preferences\ But we don't have specified file in CME server mentioned Path.

It would be great if you suggest any resolution.

Answer 1

Indeed. Anand already answered how to see the custom pages details using Coreservice API.

As @Anand/Peter already mentioned in his comment to clarify how to get the custom page XML using API, because in database it's store as Encoded XML Fragment.

It looks like you are still looking at the database level to see that data not using Coreservice API.

SDL highly recommends that you use the APIs to read. Accessing the database directly carries a high risk. The risk is that you corrupt the database or incur data loss. Only Engineering knows database design and business logic about the database data how it's stored.

Anyway, let me give you two examples one with full Coreservice example another one with database read.

Coreservice Example:

using System;
using System.ServiceModel;
using System.Xml;
using Tridion.ContentManager.CoreService.Client;

namespace SDL.FindAndReadCustomPagesURL
{
    class Program
    {
        private const string ServiceUrl = "{0}webservices/CoreService201603.svc/basicHttp";
        private const int MaxMessageSize = 10485760;
        static void Main(string[] args)
        {

            try
            {
                    var client = GetClient("localhost:7086");

                    client.ChannelFactory.Credentials.Windows.ClientCredential = new System.Net.NetworkCredential("username", "password");

                    var appData = client.ReadApplicationData(null, "CustomPages");
                    if (appData != null)
                    {
                        var ada = new ApplicationDataAdapter(appData);

                        XmlElement appDataXml = ada.GetAs<XmlElement>();
                        Console.WriteLine(appDataXml.OuterXml);
                    }  
            }
            catch (Exception ex)
            {
                Console.Write($"Failed to process {0}", ex.Message);
            }
        }

        static CoreServiceClient GetClient(string hostname)
        {
            var basicHttpBinding = new BasicHttpBinding
            {
                MaxReceivedMessageSize = MaxMessageSize,
                ReaderQuotas = new XmlDictionaryReaderQuotas
                {
                    MaxStringContentLength = MaxMessageSize,
                    MaxArrayLength = MaxMessageSize
                },
                Security = new BasicHttpSecurity
                {
                    Mode = BasicHttpSecurityMode.TransportCredentialOnly,
                    Transport = new HttpTransportSecurity
                    {
                        ClientCredentialType = HttpClientCredentialType.Windows
                    }
                }
            };

            hostname = string.Format("{0}{1}{2}", hostname.StartsWith("http") ? "" : "http://", hostname, hostname.EndsWith("/") ? "" : "/");

            var remoteAddress = new EndpointAddress(string.Format(ServiceUrl, hostname));
            return new CoreServiceClient(basicHttpBinding, remoteAddress);
        }
    }
}

Database Level Read:

Use Tridion_cm
SELECT [APP_ID],CONVERT(varchar(max),CONVERT(varbinary(max),[DATA_CONTENT])) as XMLDATA  
  FROM [Tridion_cm].[dbo].[APP_DATA] WHERE APP_ID='CustomPages'

I hope it's helps

Answer 2

it does get stored on DB from SDL 8.6. you can find the details [APP_DATA] table CM Database.

You can use the following code to read the value using core service:

var client = CMSession.GetInstance().CoreServiceClient;
var appData = client.ReadApplicationData(null, APPDATA_CUSTOMPAGES_ID);
if (appData != null)
{
    var ada = new ApplicationDataAdapter(appData);
    var appDataXml = ada.GetAs<XmlElement>();
    return appDataXml.OuterXml;
}