TEMA (SCM) 1.5 Error Cannot insert the value NULL into

Usage and Config Security
1

Anyone else running into this issue, after upgrading to version 1.5 of TEMA we can no longer run any imports. We’ve also tried to re-install from scratch and the install fails when connecting to the BFEnterprise database with the “Cannot insert the value NULL into column ‘id’, table ‘tem_analytics.dbo.raw_datasource_analysis_activations’; column does not allow nulls. INSERT fails.”

I cannot figure out whether or not this is related to Java, Ruby, or the database and wanted to know if anyone else has any insights. I have a bug report open but no one has any ideas on a solution as of yet.

2

You actually are not the only one, that’s the same problem referenced here: http://bugs.sfolab.ibm.com/bugzilla/show_bug.cgi?id=65534

Have you done anything to your IEM deployment besides updating to SCA 1.5? I had assumed the problem was due to the introduction of “invalid” fixlets.

In any case, I would keep an eye on the bug for updates but I’ll try to update here as well.

3

Hmm…, thanks for the response, it doesn’t seem like I can access that website, is it accessible via the public?

4

No, it’s our internal bug tracking site. (We use bugzilla.)

5

Okay, thanks. Karlhe had mentioned introducing “invalid” fixlets as a root cause possibly, does anyone know how to identify “invalid” fixlets?

6

Issue is fixed, there was a problem with a view within the SQL database, not sure why it was changed but the problem is resovled, thanks to all who commented.