CA Service Management

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

Environment : Advance availability

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

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.

Hi,

could you check this article: create a table in schema designer and publish it, but it is not showing in attribute field 

therea re 2 techdoc mentoined:

Web Screen Painter schema modification - How it works and what to check if it goes wrong. 

How to Perform Schema Changes using Web Screen Painter on Advanced Availability Configuration

Hope this helps

Regards,

cdtj

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.

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

Thank you!,

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

yes that was point 2 

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

I have rearrange for better visibility

/J