Saturday, June 23, 2012

Configurator Table - CZ_SERVERS

Configurator schema has plenty of tables, but one of the important one is CZ_SERVERS. Although you will not need to look at it frequently, but when something is wrong with instance or after cloning/migration, you need to ensure that CZ_SERVERS table contains correct data.

You can get complete details of the columns from Oracle ETRM

Few useful information:
The table must contain one entry atleast for local_name="LOCAL" and server_local_id=0 value. This record identifies local host for the server. If you clone or create new instance, then please ensure that the hostname is updated with this value from that instance
select host_name from v$instance

Please ensure that all the db links are active for the servers which are you using (either for BOM Import or Publication target). The db link names should be available in FNDNAM_LINK_NAME column. Same should exists in dba_db_links table.

IMPORT_ENABLED
Should be set to 1 only for one record in the table.

SOURCE_SERVER_FLAG
This flag will be set to 1 for the server record from which the publication has been done. If Instance A is doing publication to Instance B, then B's cz_servers will contain value "1" for the row which contains entry of Instance A.
If this flag is set to 1 for any record in cz_servers, then you cannot launch Configurator Developer on the instance. The reason is - Configurator thinks that this instance is a publication target. Doing a development activity on the instance may cause data corruption.

4 comments:

  1. 2EADAF4D2777
    Sosyal medya yönetimi konusunda güvenilir ve etkili hizmetler arıyorsanız en iyi smm panel tercih edebilirsiniz. Bu panel sayesinde takipçi ve beğeni artırma işlemleriniz daha hızlı ve güvenli bir şekilde gerçekleşir. Ayrıca kullanıcı dostu arayüzü ile iş akışınızı kolaylaştırır ve zaman kazandırır. Böylece dijital varlığınızı güçlendirmek için en uygun çözümleri sunar.

    ReplyDelete
  2. DC40080441
    Many artists and designers are exploring new methods to bring their visions to life on various surfaces. One innovative technique gaining popularity is the dtf transfer, which allows for high-quality, durable prints on different materials. This method is revolutionizing the customization industry and opening up new possibilities for creative expression. For those interested in learning more, visiting the link provides detailed information about the process and applications.

    ReplyDelete