SCA Import Failure

Shahban · March 25, 2019, 5:33pm

Hi,

Seems SCA import failure in my environment last 10 days with below error code,

SCA version is 1. 10 and I run below SQL query with below result.

Please assist me if any one have this issue before.

Thanks,

Regards,
Shaban

Manish · March 25, 2019, 6:29pm

Correct even I am facing same issue and when ran the database command to find out the duplicate entry… it says table name is incorrect.
We also cross check the table and bes_obj_de does not exist.
Please suggest how we can resolve the issue.

Regards,
Manish Singh

JasonWalker · March 25, 2019, 6:41pm

I had a bit of Session Relevance that I have used in the past to detect duplicate x-fixlet-scm-id values. I seem to have lost it over the years but I’ve tried to reproduce it now. Try running this in the Console’s Presentation Debugger, or in the Web Reports QNA page and see whether it gets a result. This should show any duplicate x-fixlet-scm-id values, along with the names and sites of the fixlet(s) that have duplicate values.
(Ideally you should get no results from this. If you don’t get results and still want to validate that the queries work, change the ‘multiplicity’ clause below to multiplicity of it = 1 )

(item 0 of it, item 1 of it, name of item 1 of item 2 of it, name of item 2 of item 2 of it) of (multiplicity of item 0 of it, item 0 of it, (item 0 of it, fixlets of item 1 of it, item 1 of it) whose (mime field "x-fixlet-scm-id" of item 1 of it = item 0 of it)) of (unique values whose (multiplicity of it > 1) of mime fields "x-fixlet-scm-id" of fixlets of it, it) of all bes sites

Manish · March 25, 2019, 6:44pm

Thanks a lot Jason ,we will give a try and get back to you in- case of any issue.

In sca this seems to long pending issue were duplicate fixlet create import failure, can’t we on permanent basis bypass the duplicate entries ?

Regards,
Manish Singh

JasonWalker · March 25, 2019, 6:53pm

The duplicate entries are likely appearing due to using “Create Custom Copy” of fixlets into one of your custom sites. If this is appearing in an External Site, then it would need to be resolved by the content team. Using the SCM Wizards for “Create Custom Checklist” and “Create Custom Checks” should also prevent the duplicate IDs from being created.

If I understand, you’re requesting the behavior change so that duplicate IDs are skipped over and the rest of the checks continue importing into SCA. Is that correct? I could see value in that, if you’d like to file an RFE. I’m concerned though that might hide a problem affecting compliance results, and wouldn’t want to get a false impression that the system is OK when it is not importing all of the results.

Manish · March 25, 2019, 7:00pm

Yes correct I was looking for workaround or permanent soln so, that duplicate I’d can be skipped.
Will raise RFE to see if their is any valid point to get this addressed.
But ur point is correct and we can get false impression that system is in ok status.

Regards,
Manish Singh

JasonWalker · March 25, 2019, 7:10pm

I see there’s also a potential for duplicates in another field, “x-fixlet-scm-sentinel-id”. Here’s a Session Relevance to check for duplicates in that one as well.

(item 0 of it, item 1 of it, name of item 1 of item 2 of it, name of item 2 of item 2 of it) of (multiplicity of item 0 of it, item 0 of it, (item 0 of it, fixlets of item 1 of it, item 1 of it) whose (mime field "x-fixlet-scm-sentinel-id" of item 1 of it = item 0 of it)) of (unique values whose (multiplicity of it > 1) of mime fields "x-fixlet-scm-sentinel-id" of fixlets of it, it) of all bes sites

Shahban · March 25, 2019, 7:20pm

Might be I am missing something that’s why not getting result, plz assist,

running QNA our root server

Regards,
Shaban

JasonWalker · March 25, 2019, 7:54pm

It’ Session Relevance, it won’t run in QNA.

Console Debugger should be able to evaluate it, but…it looks like it’s giving the literal query as a result. Something weird with your quotes perhaps?

Aram · March 25, 2019, 8:01pm

In the Console’s Presentation Debugger, change the ‘Evaluate As’ radio button to string.

Shahban · March 25, 2019, 8:08pm

Also cross check with Session relevance getting the same result.

JasonWalker · March 25, 2019, 9:49pm

Ok, having no results is supposed to be good. I had two separate queries posted, one for “x-fixlet-scm-id” and the other for “x-fixlet-sentinel-scm-id”. Are you getting zero results for both?

Shahban · March 25, 2019, 9:55pm

Yes, Both queries results is 0

JasonWalker · March 25, 2019, 10:22pm

Ok let me check a couple of things. I know x-fixlet-scm-id needs to be unique within a site, maybe x-fixlet-sentinel-scm-id needs to be unique across all of the sites.

JasonWalker · March 25, 2019, 10:28pm

The third line of your screen capture contains the error message we need to look up, but it looks like the screen capture is truncating the right edge. That should list the specific ID that is duplicate (and it appears to be an x-fixlet-sentinel-scm-id value)

I didn’t see anything to indicate the x-fixlet-sentinel-scm-id needs to be unique across all sites; but there is a reference that the PCI (Payment Card Industry) checks need to be unique across all sites. Do you have PCI content enabled? If so, I can refactor the query to look for duplicates across all sites.

Shahban · March 26, 2019, 11:34am

No Jason we don’t have PCI enable on our environment.

Regards,
Shaban

JasonWalker · March 26, 2019, 11:52am

@MichalPaluch may have more ideas, I’m also asking that you folks post the Sentinel ID of the item that’s failing to import, as it was truncated off of the earlier screenshot.
@Shahban and @Manish , are you working on the same BES deployment or are these two separate problems?

Shahban · March 26, 2019, 12:58pm

Below is latest failed log and me and manish working on same issue :-

Logfile created on 2019-03-26 09:27:04 +0000 by logger.rb/v1.2.7

2019-03-26 09:27:04 (+0:00:00.000) INFO: BFC Version: 1.10.0.42
2019-03-26 09:27:04 (+0:00:00.000) INFO: Runtime: jruby 9.2.0.0 (2.5.0) 2018-05-24 81156a8 IBM J9 VM 2.9 on 8.0.5.20 - pwa6480sr5fp20-20180802_01(SR5 FP20) +jit [mswin32-x86_64]
2019-03-26 09:27:04 (+0:00:00.000) INFO: All times in log are in UTC time zone!
2019-03-26 09:27:04 (+0:00:00.000) INFO: Import created at (UTC): 2019-03-26 09:27:04 UTC
2019-03-26 09:27:04 (+0:00:00.000) INFO: Check datasources connectivity: Start
2019-03-26 09:27:05 (+0:00:01.109) INFO: Data Source: server, Bigfix Server Version: 9.5.9.62 with schema: 9.7, DB Version: 11.0.2100.60 RTM Standard Edition (64-bit)
2019-03-26 09:27:05 (+0:00:00.000) INFO: Check datasources connectivity: Success
2019-03-26 09:27:17 (+0:00:12.031) INFO: ETL before snapshot task: Calling all Model.before_snapshot blocks: Start
2019-03-26 09:27:21 (+0:00:04.125) INFO: ETL before snapshot task: Calling all Model.before_snapshot blocks: Success
2019-03-26 09:27:21 (+0:00:00.000) INFO: ETL task: Initialize datasource server: Start
2019-03-26 09:27:21 (+0:00:00.047) INFO: ETL task: Initialize datasource server: Success
2019-03-26 09:27:21 (+0:00:00.000) INFO: ETL Datasource task: from server - RawDatasourceSite (0x00000000332894C9 - N/A): Start
2019-03-26 09:27:22 (+0:00:00.109) INFO: ETL Datasource task: from server - RawDatasourceSite (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:27:22 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceSite (0x00000000332894C9 - N/A): Start
2019-03-26 09:27:22 (+0:00:00.063) INFO: Remediating DatasourceSite…
2019-03-26 09:27:22 (+0:00:00.062) INFO: DatasourceSite items: 53
2019-03-26 09:27:22 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceSite (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:27:22 (+0:00:00.000) INFO: ETL Datasource task: from server - RawDatasourceAnalysisActivation (0x00000000332894C9 - N/A): Start
2019-03-26 09:27:26 (+0:00:04.573) INFO: ETL Datasource task: from server - RawDatasourceAnalysisActivation (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:27:26 (+0:00:00.000) INFO: ETL Datasource task: from server - RawDatasourceAnalysis (0x00000000332894C9 - N/A): Start
2019-03-26 09:27:27 (+0:00:00.422) INFO: Site file ‘excluded_sites.json’ with remote ID (73) has been copied from site ‘SCM Reporting’ to F:/Program Files/IBM/SCA/wlp/usr/servers/server1/data/metadata/1/SCM Reporting/excluded_sites.json.
2019-03-26 09:28:56 (+0:01:29.587) INFO: ETL Datasource task: from server - RawDatasourceAnalysis (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:28:56 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceAnalysis (0x00000000332894C9 - N/A): Start
2019-03-26 09:29:02 (+0:00:05.578) INFO: Remediating DatasourceAnalysis…
2019-03-26 09:29:11 (+0:00:09.094) INFO: DatasourceAnalysis items: 2179
2019-03-26 09:29:11 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceAnalysis (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:29:11 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceProperty (0x00000000332894C9 - N/A): Start
2019-03-26 09:29:26 (+0:00:14.953) INFO: DatasourceProperty items: 7818
2019-03-26 09:29:26 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceProperty (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:29:26 (+0:00:00.000) INFO: ETL Datasource task: from server - RawComputerId (0x00000000332894C9 - N/A): Start
2019-03-26 09:29:26 (+0:00:00.156) INFO: ETL Datasource task: from server - RawComputerId (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:29:26 (+0:00:00.000) INFO: ETL Datasource task: from server - Computer (0x00000000332894C9 - N/A): Start
2019-03-26 09:29:27 (+0:00:00.609) INFO: Computer items: 255
2019-03-26 09:29:27 (+0:00:00.016) INFO: ETL Datasource task: from server - Computer (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:29:27 (+0:00:00.000) INFO: ETL Datasource task: from server - ComputerPropertyValue (0x00000000332894C9 - N/A): Start
2019-03-26 09:29:27 (+0:00:00.390) INFO: ETL Datasource task: from server - ComputerPropertyValue (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:29:27 (+0:00:00.000) INFO: ETL Datasource task: from server - ComputerDimension (0x00000000332894C9 - N/A): Start
2019-03-26 09:29:27 (+0:00:00.407) INFO: ETL Datasource task: from server - ComputerDimension (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:29:27 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceSiteFile (0x00000000332894C9 - N/A): Start
2019-03-26 09:29:28 (+0:00:00.875) INFO: DatasourceSiteFile items: 1955
2019-03-26 09:29:28 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceSiteFile (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:29:28 (+0:00:00.000) INFO: ETL Datasource task: from server - RawDatasourceFixlet (0x00000000332894C9 - N/A): Start
2019-03-26 09:29:28 (+0:00:00.062) INFO: Site file ‘excluded_sites.json’ with remote ID (73) has been copied from site ‘SCM Reporting’ to F:/Program Files/IBM/SCA/wlp/usr/servers/server1/data/metadata/1/SCM Reporting/excluded_sites.json.
2019-03-26 09:32:28 (+0:02:59.821) INFO: ETL Datasource task: from server - RawDatasourceFixlet (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:32:28 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceFixlet (0x00000000332894C9 - N/A): Start
2019-03-26 09:33:36 (+0:01:07.458) INFO: Remediating DatasourceFixlet…
2019-03-26 09:33:50 (+0:00:13.906) INFO: DatasourceFixlet items: 11907
2019-03-26 09:33:50 (+0:00:00.015) INFO: ETL Datasource task: from server - DatasourceFixlet (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:33:50 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceGroupFixletResult (0x00000000332894C9 - N/A): Start
2019-03-26 09:36:07 (+0:02:17.717) INFO: DatasourceGroupFixletResult items: 1995
2019-03-26 09:36:07 (+0:00:00.016) INFO: ETL Datasource task: from server - DatasourceGroupFixletResult (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:36:07 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceGroup (0x00000000332894C9 - N/A): Start
2019-03-26 09:38:23 (+0:02:15.683) INFO: ETL Datasource task: from server - DatasourceGroup (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:38:23 (+0:00:00.000) INFO: ETL Datasource task: from server - RawDatasourceGroupMembership (0x00000000332894C9 - N/A): Start
2019-03-26 09:38:23 (+0:00:00.344) INFO: ETL Datasource task: from server - RawDatasourceGroupMembership (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:38:23 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceGroupMembership (0x00000000332894C9 - N/A): Start
2019-03-26 09:38:24 (+0:00:00.750) INFO: ETL Datasource task: from server - DatasourceGroupMembership (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:38:24 (+0:00:00.000) INFO: ETL Datasource task: from server - SCM::FixletField (0x0000000000000000 - N/A): Start
2019-03-26 09:39:12 (+0:00:48.046) INFO: SCM::FixletField items: 4833
2019-03-26 09:39:12 (+0:00:00.016) INFO: ETL Datasource task: from server - SCM::FixletField (0x0000000000000000 - 0x000000003CFDECB3): Success
2019-03-26 09:39:12 (+0:00:00.000) INFO: ETL Datasource task: from server - SCM::RawChecklistSite (0x00000000332894C9 - N/A): Start
2019-03-26 09:39:12 (+0:00:00.047) INFO: ETL Datasource task: from server - SCM::RawChecklistSite (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:39:12 (+0:00:00.000) INFO: ETL Datasource task: from server - SCM::RawMetadataFile (0x00000000332894C9 - N/A): Start
2019-03-26 09:39:12 (+0:00:00.016) INFO: ETL Datasource task: from server - SCM::RawMetadataFile (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:39:12 (+0:00:00.000) INFO: ETL Datasource task: from server - SCM::PolicyFile (0x00000000332894C9 - N/A): Start
2019-03-26 09:39:12 (+0:00:00.015) INFO: SCM::PolicyFile items: 0
2019-03-26 09:39:12 (+0:00:00.000) INFO: ETL Datasource task: from server - SCM::PolicyFile (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:39:12 (+0:00:00.000) INFO: ETL Datasource task: from server - SCM::StagingTableUpdate (0x00000000332894C9 - N/A): Start
2019-03-26 09:39:12 (+0:00:00.047) INFO: SCM::StagingTableUpdate items: 0
2019-03-26 09:39:12 (+0:00:00.000) INFO: ETL Datasource task: from server - SCM::StagingTableUpdate (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:39:12 (+0:00:00.000) INFO: ETL Datasource task: from server - SCM::CheckFixletMapping (0x00000000332894C9 - N/A): Start
2019-03-26 09:39:12 (+0:00:00.016) INFO: SCM::CheckFixletMapping items: 0
2019-03-26 09:39:12 (+0:00:00.000) INFO: ETL Datasource task: from server - SCM::CheckFixletMapping (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:39:12 (+0:00:00.000) INFO: ETL Datasource task: from server - SCM::Policy (0x00000000332894C9 - N/A): Start
2019-03-26 09:39:12 (+0:00:00.031) INFO: SCM::Policy items: 0
2019-03-26 09:39:12 (+0:00:00.016) INFO: ETL Datasource task: from server - SCM::Policy (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:39:12 (+0:00:00.000) INFO: ETL Datasource task: from server - RawDatasourceSiteSubscription (0x00000000332894C9 - N/A): Start
2019-03-26 09:39:19 (+0:00:06.140) INFO: ETL Datasource task: from server - RawDatasourceSiteSubscription (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:39:19 (+0:00:00.000) INFO: ETL Datasource task: from server - DatasourceSiteSubscription (0x00000000332894C9 - N/A): Start
2019-03-26 09:39:34 (+0:00:15.125) INFO: ETL Datasource task: from server - DatasourceSiteSubscription (0x00000000332894C9 - 0x000000003CFDECB3): Success
2019-03-26 09:39:34 (+0:00:00.000) INFO: ETL Datasource task: from server - SCM::RawSentinel (0x00000000332894C9 - N/A): Start
2019-03-26 09:39:49 (+0:00:15.503) ERROR: Duplicate Sentinel Fixlet(s) detected!
2019-03-26 09:39:49 (+0:00:00.000) INFO: ETL Datasource task: from server - SCM::RawSentinel (0x00000000332894C9 - 0x000000003CFDECB3): Failed
2019-03-26 09:48:30 (+0:08:41.104) ERROR: Sequel::UniqueConstraintViolation: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Cannot insert duplicate key row in object ‘scm.raw_sentinels’ with unique index ‘scm_raw_sentinels_datasource_site_id_remote_id_index’. The duplicate key value is (338, bd5d38201bb4474af82204f66a837d3b42157430).
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(com/microsoft/sqlserver/jdbc/SQLServerException.java:217)
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:1655)
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:885)
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:778)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(com/microsoft/sqlserver/jdbc/IOBuffer.java:7505)
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:2445)
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:191)
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:166)
com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:751)
java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:508)
org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:455)
org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:316)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.adapters.jdbc.invokeOther2:execute(F_3a_/Program_20_Files/IBM/SCA/wlp/usr/servers/server1/apps/tema_dot_war/WEB_minus_INF/gems/gems/sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/jdbc.rb:253)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.adapters.jdbc.block in execute(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/jdbc.rb:253)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:302)
java.lang.invoke.VirtualHandle.invokeExact_thunkArchetype_L(java/lang/invoke/VirtualHandle.java:128)
java.lang.invoke.BruteArgumentMoverHandle.invokeExact_thunkArchetype_X(java/lang/invoke/BruteArgumentMoverHandle.java:398)
java.lang.invoke.MutableCallSiteDynamicInvokerHandle.invokeExact_thunkArchetype_X(java/lang/invoke/MutableCallSiteDynamicInvokerHandle.java:64)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.config.initializers.sequel.log_connection_yield(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/config/initializers/sequel.rb:148)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:300)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.adapters.jdbc.invokeOther32:log_connection_yield(F_3a_/Program_20_Files/IBM/SCA/wlp/usr/servers/server1/apps/tema_dot_war/WEB_minus_INF/gems/gems/sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/jdbc.rb:253)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.adapters.jdbc.block in execute(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/jdbc.rb:253)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:300)
java.lang.invoke.VirtualHandle.invokeExact_thunkArchetype_L(java/lang/invoke/VirtualHandle.java:128)
java.lang.invoke.BruteArgumentMoverHandle.invokeExact_thunkArchetype_X(java/lang/invoke/BruteArgumentMoverHandle.java:398)
java.lang.invoke.MutableCallSiteDynamicInvokerHandle.invokeExact_thunkArchetype_X(java/lang/invoke/MutableCallSiteDynamicInvokerHandle.java:64)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.adapters.jdbc.statement(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/jdbc.rb:688)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:300)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.adapters.jdbc.invokeOther37:statement(F_3a_/Program_20_Files/IBM/SCA/wlp/usr/servers/server1/apps/tema_dot_war/WEB_minus_INF/gems/gems/sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/jdbc.rb:241)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.adapters.jdbc.block in execute(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/jdbc.rb:241)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:300)
java.lang.invoke.VirtualHandle.invokeExact_thunkArchetype_L(java/lang/invoke/VirtualHandle.java:128)
java.lang.invoke.BruteArgumentMoverHandle.invokeExact_thunkArchetype_X(java/lang/invoke/BruteArgumentMoverHandle.java:398)
java.lang.invoke.MutableCallSiteDynamicInvokerHandle.invokeExact_thunkArchetype_X(java/lang/invoke/MutableCallSiteDynamicInvokerHandle.java:64)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.connection_pool.threaded.hold(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/connection_pool/threaded.rb:98)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:300)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.database.connecting.invokeOther3:hold(F_3a_/Program_20_Files/IBM/SCA/wlp/usr/servers/server1/apps/tema_dot_war/WEB_minus_INF/gems/gems/sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/connecting.rb:270)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.database.connecting.synchronize(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/connecting.rb:270)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:300)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.adapters.jdbc.invokeOther49:synchronize(F_3a_/Program_20_Files/IBM/SCA/wlp/usr/servers/server1/apps/tema_dot_war/WEB_minus_INF/gems/gems/sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/jdbc.rb:240)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.adapters.jdbc.execute(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/jdbc.rb:240)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:300)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.adapters.jdbc.invokeOther6:execute(F_3a_/Program_20_Files/IBM/SCA/wlp/usr/servers/server1/apps/tema_dot_war/WEB_minus_INF/gems/gems/sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/jdbc.rb:269)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.adapters.jdbc.execute_ddl(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/adapters/jdbc.rb:269)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:302)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.database.query.invokeOther2:execute_ddl(F_3a_/Program_20_Files/IBM/SCA/wlp/usr/servers/server1/apps/tema_dot_war/WEB_minus_INF/gems/gems/sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/query.rb:76)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.database.query.run(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/query.rb:76)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:302)
RUBY.execute(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/strategy/stored_procedure.rb:62)
RUBY.etl_core(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/sequel/plugins/etl.rb:187)
RUBY.etl_core(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/domains/scm/app/models/scm/raw_sentinel.rb:46)
RUBY.etl(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/sequel/plugins/etl.rb:170)
RUBY.block in with_datasource_tasks(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/endpoints.rb:52)
org.jruby.RubyProc.call(org/jruby/RubyProc.java:286)
org.jruby.RubyProc.call(org/jruby/RubyProc.java:266)
org.jruby.RubyProc$INVOKER$i$0$0$call.call(org/jruby/RubyProc$INVOKER$i$0$0$call.gen)
RUBY.run(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/task.rb:70)
RUBY.run_task(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/tasks.rb:36)
RUBY.block in run_no_txn(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/tasks.rb:47)
org.jruby.RubyArray.each(org/jruby/RubyArray.java:1801)
org.jruby.RubyArray$INVOKER$i$0$0$each.call(org/jruby/RubyArray$INVOKER$i$0$0$each.gen)
RUBY.run_no_txn(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/tasks.rb:46)
RUBY.block in run_single_txn(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/tasks.rb:53)
RUBY.transaction(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/transactions.rb:204)
F_3a.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.database.transactions.invokeOther37:transaction(F_3a/Program_20_Files/IBM/SCA/wlp/usr/servers/server1/apps/tema_dot_war/WEB_minus_INF/gems/gems/sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/transactions.rb:179)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.database.transactions.block in transaction(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/transactions.rb:179)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:302)
java.lang.invoke.VirtualHandle.invokeExact_thunkArchetype_L(java/lang/invoke/VirtualHandle.java:128)
java.lang.invoke.BruteArgumentMoverHandle.invokeExact_thunkArchetype_X(java/lang/invoke/BruteArgumentMoverHandle.java:398)
java.lang.invoke.MutableCallSiteDynamicInvokerHandle.invokeExact_thunkArchetype_X(java/lang/invoke/MutableCallSiteDynamicInvokerHandle.java:64)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.connection_pool.threaded.hold(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/connection_pool/threaded.rb:98)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:300)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.database.connecting.invokeOther3:hold(F_3a_/Program_20_Files/IBM/SCA/wlp/usr/servers/server1/apps/tema_dot_war/WEB_minus_INF/gems/gems/sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/connecting.rb:270)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.database.connecting.synchronize(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/connecting.rb:270)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:300)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.database.transactions.invokeOther65:synchronize(F_3a_/Program_20_Files/IBM/SCA/wlp/usr/servers/server1/apps/tema_dot_war/WEB_minus_INF/gems/gems/sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/transactions.rb:145)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.database.transactions.transaction(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/transactions.rb:145)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:302)
RUBY.run_single_txn(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/tasks.rb:52)
RUBY.run(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/tasks.rb:25)
RUBY.block in run(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/runner.rb:59)
RUBY.block in with_isolation_level(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/sequel/extensions/isolation_level.rb:19)
java.lang.invoke.VirtualHandle.invokeExact_thunkArchetype_L(java/lang/invoke/VirtualHandle.java:128)
java.lang.invoke.BruteArgumentMoverHandle.invokeExact_thunkArchetype_X(java/lang/invoke/BruteArgumentMoverHandle.java:398)
java.lang.invoke.MutableCallSiteDynamicInvokerHandle.invokeExact_thunkArchetype_X(java/lang/invoke/MutableCallSiteDynamicInvokerHandle.java:64)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.connection_pool.threaded.hold(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/connection_pool/threaded.rb:98)
java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(java/lang/invoke/DirectHandle.java:300)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.database.connecting.invokeOther3:hold(F_3a_/Program_20_Files/IBM/SCA/wlp/usr/servers/server1/apps/tema_dot_war/WEB_minus_INF/gems/gems/sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/connecting.rb:270)
F_3a_.Program_20_Files.IBM.SCA.wlp.usr.servers.server1.apps.tema_dot_war.WEB_minus_INF.gems.gems.sequel_minus_5_dot_11_dot_0_dot_9c6f12860cd354792900a282dfa0053ed1d9f044.lib.sequel.database.connecting.synchronize(F:/Program Files/IBM/SCA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/gems/gems/sequel-5.11.0.9c6f12860cd354792900a282dfa0053ed1d9f044/lib/sequel/database/connecting.rb:270)

Shahban · March 26, 2019, 6:12pm

Any suggestions would be appreciated,

JasonWalker · March 26, 2019, 7:19pm

Ok, now you know which Sentinel ID is triggering the duplicate value. Try using this Session Relevance in the Console’s Presentation Debugger or in the Web Reports QNA page to see if you can identify the fixlets with this ID. If there is more than one result here you may have a problem. If you get more than one result from the same site then it’s definitely a problem.

(id of it, name of it, name of site of it) of fixlets whose (mime field "x-fixlet-scm-sentinel-id" of it = "bd5d38201bb4474af82204f66a837d3b42157430") of all bes sites

Also, be sure to run this as a Master Operator account, or otherwise be sure you account as read access to all of the custom sites.

(edited for code tags)