Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2013-03-24T15:22:05Z by yn2000
SystemAdmin
SystemAdmin
9855 Posts
ACCEPTED ANSWER

Pinned topic Custom ITIM Adapter giving "Database Schema name is not provided" error

‏2013-03-22T07:11:24Z |
I am facing a strange error, which I am getting from the custom connector while account provisioning.
The target database is MS Sql server.the connector is running in an env right now where feed comes and user are created automatically for all using this connector.
Here for the connection no schema name is needed, just the DBURL with DataBase name is given.
I test connection form ITIM5.1 it gives successful, then all operation ADD, MOB, DEL, SUS, RES. works fine. also added on target.
But after a while suddenly the connector starts giving this below error. for all operation, for all requests

But when I restart the dispatcher it starts working fine and create hundreds of user.
Then after 1-2 days again the error starts coming.
If dispatcher is restarted it again works fine.
This happened a couple of times now.

Now since it giving error schema name is not provided.
I have tried all possible combination putting somevalue in the schema field though no need of any schema in MS SQL Server is required.

********************************************************************************************
2013-03-22 11:36:10,760 INFO http://_tdi_timsol_ITIM_RMI.xml - CTGDIS115I Starting scripting hook of type prolog0.
2013-03-22 11:36:10,762 INFO http://_tdi_timsol_ITIM_RMI.xml - Adapter Version - 1.0
2013-03-22 11:36:10,764 INFO http://_tdi_timsol_ITIM_RMI.xml - CTGDIS116I Scripting hook of type prolog0 finished.
2013-03-22 11:36:10,764 INFO http://_tdi_timsol_ITIM_RMI.xml - CTGDIS003I *** Start dumping Entry
2013-03-22 11:36:10,764 INFO http://_tdi_timsol_ITIM_RMI.xml - Operation: generic
2013-03-22 11:36:10,764 INFO http://_tdi_timsol_ITIM_RMI.xml - Entry attributes:
2013-03-22 11:36:10,764 INFO http://_tdi_timsol_ITIM_RMI.xml - Entry properties:
2013-03-22 11:36:10,764 INFO http://_tdi_timsol_ITIM_RMI.xml - REASON_MESSAGE: 'com.ibm.di.adapter.ADD_FAILED'
2013-03-22 11:36:10,764 INFO http://_tdi_timsol_ITIM_RMI.xml - REASONCODE: '100'
2013-03-22 11:36:10,764 INFO http://_tdi_timsol_ITIM_RMI.xml - REASON_MESSAGE_ARGS: '[add Error: {
"status": "fail",
"connectorname": "Add",
"operation": "initialize",
"exception": "java.lang.Exception: CTGDIJ108E The database ''Schema'' name is not provided.",
"message": "CTGDIJ108E The database ''Schema'' name is not provided.",
"class": "java.lang.Exception"
}]'
2013-03-22 11:36:10,764 INFO http://_tdi_timsol_ITIM_RMI.xml - STATUSCODE: '2'
2013-03-22 11:36:10,764 INFO http://_tdi_timsol_ITIM_RMI.xml - CTGDIS004I *** Finished dumping Entry
2013-03-22 11:36:10,764 INFO http://_tdi_timsol_ITIM_RMI.xml - executeALRequest():2133 Request ID: 1203680821566765950, status=2, reason=100, reasonMessage=com.ibm.di.adapter.ADD_FAILED
**************************************************************************************************************
Updated on 2013-03-24T15:22:05Z at 2013-03-24T15:22:05Z by yn2000
  • yn2000
    yn2000
    1086 Posts
    ACCEPTED ANSWER

    Re: Custom ITIM Adapter giving "Database Schema name is not provided" error

    ‏2013-03-24T15:22:05Z  in response to SystemAdmin
    IMO, this has nothing to do with TIM. The issue is between TDI and MS SQL. It may be in the session control (session timeout) within the network, firewall, or the MS SQL rules.

    Try using the "Initialize and terminate every time it is used" in the MS SQL connector configuration.

    Rgds. YN.