#4420 - Install error
I am trying to install the 1. Sugar Connector for LinkedIn Navigator, 2. Dashboard / Filter Plugin and the 3. Activity Stream Notification Plugin The installs error out and it says to check the SugarCRM.log. I will pasted the verbiage below. Hopefully you can tell me how to fix this issue. I am by no means a database guy and the error is pointing towards a database issue? Could you please review the log as soon as possible and let me know if there is a fix to get these installed? Thanks! Stephen
Mon Sep 14 11:49:45 2020 [12720][5b756b6e-f74f-11e9-a89a-0050569d47f3][ALERT] Error adding index: Query Failed:ALTER TABLE accounts_cstm ADD CONSTRAINT accounts_cstm_pk PRIMARY KEY (id_c)::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot define PRIMARY KEY constraint on nullable column in table 'accounts_cstm'.\n[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Could not create constraint or index. See previous errors. Tue Sep 15 05:00:20 2020 [12844][1][FATAL] Job e0e599da-f731-11ea-8931-0050569d3861 (Sugar Heartbeat) failed in CRON run Tue Sep 15 07:30:52 2020 [3496][5b756b6e-f74f-11e9-a89a-0050569d47f3][ALERT] Error adding index: Query Failed:ALTER TABLE accounts_cstm ADD CONSTRAINT accounts_cstm_pk PRIMARY KEY (id_c)::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot define PRIMARY KEY constraint on nullable column in table 'accounts_cstm'.\n[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Could not create constraint or index. See previous errors. Tue Sep 15 07:50:20 2020 [3496][5b756b6e-f74f-11e9-a89a-0050569d47f3][ALERT] Error adding index: Query Failed:ALTER TABLE accounts_cstm ADD CONSTRAINT accounts_cstm_pk PRIMARY KEY (id_c)::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot define PRIMARY KEY constraint on nullable column in table 'accounts_cstm'.\n[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Could not create constraint or index. See previous errors.
a year ago
Hi Bluesfolk
We have not tried our plugin with all varieties of other plugins. I recommend that you first successfully install the Sugar Connector for LinkedIn on your test instance (server). Get that to work. Then move on to install the Dashboard / Filter Plugin. Get both these to work. Then try installing the Visual Notification plugin.
HTH, KGM