What does the error message "There are Schema Changes that have been partially published" mean when I logon into the Web Screen Painter?
CA Service Desk Manager 14.1, 12.9
This can happen for a couple of different reasons:
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.