not able to create new scheduled issue, throwing error msg

[Raju Adluru]

JIRA v 7.1.2, i have installed later The scheduler plugin.

When i clicked on Access manager, i am getting 404 error

when i do create scheduled issue, i am getting 500 error and log attached.

[Raju Adluru]

The scheduler Version 4.1.2 • JIRA Server 7.0.0 - 7.1.2 • Released 2016-03-18

[Raju Adluru]

@radlur want to watch this issue.

[jost]

Hello Raj,

In newest version of TSP we had to remove one constraint from database. Your stack trace shows that for some reason this constraint was not removed from your database. To resolve this problem you should remove this constraint manually. Please, try this solution, and let us know whether it helped:

https://bitbucket.org/apdc/the-scheduler/issues/61/scheduler-failing-in-jira-647

[Raju Adluru]

Hi Ostrowskij i did that in db, dropped the constraint, but still i am getting error, do i need to restart my JIRA after DB change?

[Raju Adluru]

Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
    Database:
      - name:Microsoft SQL Server
      - version:11.00.3128
      - minor version:0
      - major version:11
    Driver:
      - name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
      - version:1.3.1
    
    java.sql.SQLException: The object 'U_AO_A406ED_SCHEDUL1453239299' is dependent on column 'NAME'.
  at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:47) [?:?]
  at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:77) [?:?]
  at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:72) [?:?]
  at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:25) [?:?]
  at com.atlassian.jira.DefaultHostContextAccessor.doInTransaction(DefaultHostContextAccessor.java:34) [DefaultHostContextAccessor.class:?]
  at sun.reflect.GeneratedMethodAccessor177.invoke(Unknown Source) [?:?]
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [?:1.8.0_74]
Show less
Caused by: java.sql.SQLException: The object 'U_AO_A406ED_SCHEDUL1453239299' is dependent on column 'NAME'.
  at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) [jtds-1.3.1.jar:1.3.1]
  at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) [jtds-1.3.1.jar:1.3.1]
  at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) [jtds-1.3.1.jar:1.3.1]

[jost]

Hi Raj,

This solution should work without restarting the JIRA server. Could you please check if the constraint is droped corectly? To do this you can run Microsoft SQL Management Studio, select table AO_A406ED_SCHEDULED_ISSUE, click on the right mouse button->Script Table as->CREATE To->New Query Editor Window. Please send us this script.

[jost]

Hello Raj,

Any update on this issue?