Bulk Load not working as intended with datasource error
search cancel

Bulk Load not working as intended with datasource error

book

Article ID: 239147

calendar_today

Updated On:

Products

CA Identity Manager

Issue/Introduction

Getting the following message when using BulkLoad user create task

ERROR MESSAGE: Failed running query ; Failed to execute prepared statement: SELECT <datasource name> FROM [IM<datasource name>].[<datasource name>].[<datasource name>] where EmployeeID = <employee number>; on data source: java:jboss/datasources/jdbc/<datasource name>. Exception: Failed to get connection java:jboss/datasources/jdbc/<datasource name>. Exception: datasources/jdbc/<datasource name> -- service jboss.naming.context.java.jboss.datasources.jdbc.<datasource name>; Failed to get connection java:jboss/datasources/jdbc/<datasource name>. Exception: datasources/jdbc/<datasource name> -- service jboss.naming.context.java.jboss.datasources.jdbc.<datasource name>; datasources/jdbc/<datasource name> -- service jboss.naming.context.java.jboss.datasources.jdbc.<datasource name>

Environment

Release :  Vapp 14.4

Component : Identity Manager

Cause

This is due to undepoly central server log that causes the configuration issue 

Resolution

Run "removeJBossDatasource"  to remove the corrupted datasoure and then  Run "addJBossDatasource" to re-add it