When I launch Web Screen Painter, I get a message "There are Schema Changes that have been partially published."

Document ID : KB000025521
Last Modified Date : 14/02/2018
Show Technical Document Details

 

Question: 

What does the error message "There are Schema Changes that have been partially published" mean when I logon into the Web Screen Painter?

 

Environment:  

CA Service Desk Manager 14.1, 12.9

 

Answer: 

 

This can happen for a couple of different reasons:

  1. There really are schema changes which have been made, which haven't been published. If multiple people are making schema changes, this is quite common.

  2. The schema changes have been published, but the %NX_ROOT%\site\wsp.altercol and %NX_ROOT%\site\wsp.altertbl files were not successfully deleted after the last pdm_publish command was executed.

If this message appears, you should stop Service Desk and run the "pdm_publish" command. This will either run successfully, in which case you can then go ahead and fire up Web Screen Painter and use it, or the "pdm_publish" command will give errors:

D:\CA\Service Desk\bin>pdm_publish.cmd 
PDM_PUBLISH - Implement DBMS schema changes from Web Screen Painter
   
Verifying files output from Web Screen Painter... 
Verifying Unicenter Service Desk server is not running... 
   
Merging schema files... 
Schema merge successful 
   
Building data dictionary... 
Data dictionary build successful 
   
Adding new columns to existing tables... 
Creating column Call_Req.zExtRef 
   
ERROR 2705 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=2705 SQL State =42S21] Column names in each table must be unique. Column name 
'zExtRef' in table 'call_req' is specified more than once.
   
ERROR 2705 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=2705 SQL State =42S21] Column names in each table must be unique. Column name 
'zExtRef' in table 'call_req' is specified more than once. 
   
Can't spawn "cmd.exe": Bad file descriptor at .\pdm_publish.pl line 156, <ALTERCOL> line 2. 
AHD04744: sqlbuild was unable to create column Call_Req.zExtRef 0 column(s) added successfully; 1 errors 
   
Building data dictionary... 
Data dictionary build successful 
   
Normal end of pdm_publish; 1 error(s) encountered

This would indicate that previously, the "pdm_publish" command was run, but the %NX_ROOT%\site\wsp.altercol and %NX_ROOT%\site\wsp.altertbl files were left. These files contain the changes which will be added when pdm_publish is run. If they contain changes which have already been made, then you'll see the errors above.

Move these files from this directory and put them in a safe place somewhere. You can examine them at your leisure to see if all of the changes in them have already been made to the schema. Please check also the wspcol and wsptbl tables for duplicate definitions of tables or columns, whose entries should be removed.

After doing this, you can then re-run Web Screen Painter without any problems.