00145708 / 00135775
GetWSAccountQueryable / CS_Customer_System_Call_List / Cant Open Preferences or Users on SW 2.0
Occasionally, you may encounter issues accessing a customer's Preferences or User table. This often occurs because despite successful sedonaOffice upgrades prior to 6.2.0.14, a table or stored procedure may not have been properly updated during the upgrade. This means when the SedonaWeb 2.0 standardized Deployment is complete, the logs will return strange errors referencing relation IDs or constraints.Screenshot of the logs
GetWSAccountQueryable / CS_Customer_System_Call_List / Cant Open Preferences on SW 2.0
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'CS_Customer_System_Call_List' AND COLUMN_NAME = N'Relation_Id')
BEGIN
ALTER TABLE [CS_Customer_System_Call_List] ADD [Relation_Id] int not null constraint DF_Relation default 1 with values
END
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'CS_Customer_System_Call_List' AND COLUMN_NAME = N'Sequence')
BEGIN
ALTER TABLE [CS_Customer_System_Call_List] ADD [Sequence] int not null constraint DF_Sequence default 0 with values
END
