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 ZeroNum FROM [IMZeroNum].[ZeroNum].[ZeroNum] where EmployeeID = 106804; on data source: java:jboss/datasources/jdbc/zeronum. Exception: Failed to get connection java:jboss/datasources/jdbc/zeronum. Exception: datasources/jdbc/zeronum -- service jboss.naming.context.java.jboss.datasources.jdbc.zeronum; Failed to get connection java:jboss/datasources/jdbc/zeronum. Exception: datasources/jdbc/zeronum -- service jboss.naming.context.java.jboss.datasources.jdbc.zeronum; datasources/jdbc/zeronum -- service jboss.naming.context.java.jboss.datasources.jdbc.zeronum

Cause

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

Environment

Release :  Vapp 14.4

Component : Identity Manager

Resolution

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