Problem Note 68464: Elasticsearch indexing in SAS® Visual Investigator fails with an IllegalTransactionStateException error
 |  |  |  |  |
While indexing an entity, the Jobs tab reports that the indexing job for the entity has failed. There are a number of indications that help you determine whether you have this issue.
When you select the job on the Jobs tab, you can see a list of records that have been read. But the number of records written is 0.
In the svi-indexer log, you see an exception that is similar to the following:
2020-09-23 16:25:18.834 ERROR 95968 --- [ctTypeExecutor2] o.s.batch.core.step.AbstractStep : service@@__default__ [ee46199ee49ca3f1] Encountered an error executing step objectTypeSlaveStep in job indexerJob
org.springframework.batch.core.UnexpectedJobExecutionException: Step failure: the delegate Job failed in JobStep.
at org.springframework.batch.core.step.job.JobStep.doExecute(JobStep.java:125)
...
In the datahub log, you might see an exception like the following:
at com.sas.fcs.datahub.cache.TenantAwareCache.getValuesAndCommit(TenantAwareCache.java:308)
...
Caused by: org.springframework.transaction.IllegalTransactionStateException: Pre-bound JDBC Connection found! JpaTransactionManager does not support running within DataSourceTransactionManager if told to manage the DataSource itself. It is recommended to use a single JpaTransactionManager for all transactions on a single DataSource, no matter whether JPA or JDBC access.
In the datahub log, there also might be a number of messages similar to the following that fill up the log:
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator | Linux for x64 | 10.7 | Viya | ||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesAn update for this issue is available for SAS Visual Investigator 10.7. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_VI_10_7_home.html#68464| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-10-29 13:20:17 |
| Date Created: | 2021-10-01 15:18:50 |