AnsweredAssumed Answered

Is anyone using SmartEvals for course evaluations and having issues with the B2? I'm on Q4 2015 and attempts to install B2 end with error message (and B2 being listed as corrupt).

Question asked by richard.hancuff on Nov 30, 2017

Hello all,

I'm on Q4 2015 cu3 and trying to install the SmartEvals Building Block (provided by SmartEvals).

Any help more experienced users could give me would be much appreciated.

Here is the log (I bolded what I think is the core issue, but don't know where to go from there):

 

blackboard.persist.PersistenceException: Error registering Building Block %s. Please delete package and re-install.

at blackboard.platform.plugin.PackageInstaller.install(PackageInstaller.java:347)

at blackboard.platform.plugin.PackageInstaller.install(PackageInstaller.java:295)

at blackboard.platform.plugin.PackageInstaller.install(PackageInstaller.java:289)

at blackboard.platform.plugin.messagequeue.PlugInMessageQueueHandler.onMessage(PlugInMessageQueueHandler.java:104)

at blackboard.platform.messagequeue.impl.activemq.ActiveMQMessageQueueConsumer$ConsumerThread.run(ActiveMQMessageQueueConsumer.java:188)

Caused by: java.security.PrivilegedActionException: blackboard.persist.PersistenceException: Error persisting plugin: se01-smartevals-module

at java.security.AccessController.doPrivileged(Native Method)

at blackboard.platform.plugin.PackageInstaller.install(PackageInstaller.java:338)

... 4 more

Caused by: blackboard.persist.PersistenceException: Error persisting plugin: se01-smartevals-module

at blackboard.platform.plugin.PackageInstaller$InstallAction$PackageInstallTransaction.run(PackageInstaller.java:2950)

at blackboard.db.ConnectionManager.performTransaction(ConnectionManager.java:364)

at blackboard.platform.plugin.PackageInstaller$InstallAction.run(PackageInstaller.java:2743)

... 6 more

Caused by: blackboard.persist.PersistenceException: A database error occurred.

at blackboard.persist.impl.AbstractBaseDbPersister.runQuery(AbstractBaseDbPersister.java:197)

at blackboard.persist.impl.AbstractBaseDbPersister.runQuery(AbstractBaseDbPersister.java:139)

at blackboard.persist.impl.NewBaseDbPersister.doInsert(NewBaseDbPersister.java:127)

at blackboard.persist.impl.NewBaseDbPersister.doPersist(NewBaseDbPersister.java:75)

at blackboard.portal.persist.impl.ModuleTypeDbPersisterImpl.persist(ModuleTypeDbPersisterImpl.java:56)

at blackboard.platform.plugin.PackageInstaller$InstallAction$PackageInstallTransaction.updateModuleTypes(PackageInstaller.java:3411)

at blackboard.platform.plugin.PackageInstaller$InstallAction$PackageInstallTransaction.run(PackageInstaller.java:2933)

... 8 more

Caused by: java.sql.SQLIntegrityConstraintViolationException: [BBDATA]Violation of PRIMARY KEY constraint 'module_type_pk'. Cannot insert duplicate key in object 'dbo.module_type'. The duplicate key value is (smartevals-module).

Msg 2627, Level 14, State 1, Procedure module_type_cr, Line 18, Sqlstate 23000

at com.inet.tds.ab.a(Tds4Factory.java:206)

at com.inet.tds.ab.a(Tds4Factory.java:170)

at com.inet.tds.ap.b(TdsConnection.java:2573)

at com.inet.tds.ap.a(TdsConnection.java:2284)

at com.inet.tds.ba.a(TdsPrepareOnServer.java:105)

at com.inet.tds.ba.b(TdsPrepareOnServer.java:68)

at com.inet.tds.ay.h(TdsPStatement.java:699)

at com.inet.tds.ay.executeQuery(TdsPStatement.java:590)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at blackboard.db.impl.MonitoringConnectionPool$SQLRecorder.execute(MonitoringConnectionPool.java:221)

at blackboard.db.impl.MonitoringConnectionPool$MonitoringCallableStatement.executeQuery(MonitoringConnectionPool.java:640)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at blackboard.db.impl.SafetyNetCallableStatement.executeQuery(SafetyNetCallableStatement.java:44)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at blackboard.persist.impl.StoredProcedureQuery.doExecute(StoredProcedureQuery.java:314)

at blackboard.persist.impl.GenericProcedureQuery.doExecute(GenericProcedureQuery.java:213)

at blackboard.persist.impl.Query.executeQuery(Query.java:148)

at blackboard.persist.impl.Query.executeQuery(Query.java:114)

at blackboard.persist.impl.AbstractBaseDbPersister$DbConnectivityPrivilege.run(AbstractBaseDbPersister.java:276)

at java.security.AccessController.doPrivileged(Native Method)

at blackboard.persist.impl.AbstractBaseDbPersister.runQuery(AbstractBaseDbPersister.java:168)

... 14 more

 

Thanks,

Rich

Outcomes