CA Service Management

Expand all | Collapse all

What is the procedure to Manual create the schema changes with out using the Web Screen painter

  • 1.  What is the procedure to Manual create the schema changes with out using the Web Screen painter

    Posted 12-09-2016 05:59 AM

    What is the procedure to manually create the sample schema customisation without using web screen painter?

    Environment : Advance availability



  • 2.  Re: What is the procedure to Manual create the schema changes with out using the Web Screen painter

    Posted 12-09-2016 08:07 AM

    Hi venkateswarlu,

     

    Why do you want to bypass the schema? Is there a business case or limitation of some sort in your environment that you need to address without using WSP?

     

    Kind Regards,

    Brian



  • 3.  Re: What is the procedure to Manual create the schema changes with out using the Web Screen painter

    Posted 12-09-2016 08:13 AM

    It's something bothering us in our AA environment , most of the time the schema changes are not propagated successfully to Application and Standby Servers. So, I am checking here to know the procedure to create manually.



  • 4.  Re: What is the procedure to Manual create the schema changes with out using the Web Screen painter



  • 5.  Re: What is the procedure to Manual create the schema changes with out using the Web Screen painter

    Posted 12-09-2016 11:49 AM

    Thanks cdtj , these links are useful , informative and we've tried these, Here especially, I am looking for a procedure to  create schema changes manually.



  • 6.  Re: What is the procedure to Manual create the schema changes with out using the Web Screen painter

    Posted 12-22-2016 08:51 AM

    Strongly not recommended and on your own risk!. Do backup! Version control is supposed t take care of this

    (your underline reading here must be don't do that  if you don't know exactly what you do or you will be screwed)

     

    to create everything from scratch:

    1. Create your custom table/column in the MDB itself using your preferred database tool
    2. Insert new row(s) in in the wsptbl and wspcol tables with the corresponding value(s). Make sure that the status is set to  3 (Look also in the table itself to have a better understanding from pre-existing records)
    3.  Create a mods file with your object/factory definition
    4.  Add your new tables/columns to the wsp_schema.sch
    5.  Add  corresponding new lines in wsp_schema.log (take example of the existing one inside the file)
    6.  Modify the ddict.sch in the site folder to reflect your change
    7. Cross finger and recycle SDM
    8. Watch for error in std.log  and correct or not as needed

     

    May you just want to deploy your change to others servers, you will just need to copy the mentioned files below from your primary/bg server to the respective remote servers

    • All contents from your site/mods majic and www folders. the files below from/to the respective folders
    • wsp_index.sch
    • wsp_schema.log
    • wsp_schema.sch
    • ddict.sch

     

    But again, not a good idea and you must be well experienced with the object layer of SDM to do such... better to rely on WSP for it and at less get a minimum of support from CA.

     

    My 2 cents

     

    /J

    P.S.: you have be warned



  • 7.  Re: What is the procedure to Manual create the schema changes with out using the Web Screen painter

    Posted 12-28-2016 12:16 PM

    Thank you!,

    Don't we need to create the same table and column reference in wspcol and wsptbl tables in mdb?



  • 8.  Re: What is the procedure to Manual create the schema changes with out using the Web Screen painter

    Posted 01-03-2017 04:38 AM

    yes that was point 2 

    seems the layout was a little ***** up.

    I have rearrange for better visibility

    /J