by kgm

DonĀ“t miss an Activity Stream mention! Get visual notifications in Sugar and on the browser tab when you are mentioned on records or in Activity Stream.

#4420 - Install error

Open Installation created by bluesfolk 2 years ago

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.

  1. kgm member avatar

    kgm Provider

    2 years 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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...