- UNIFYBroker Forum
-
Questions
IDB 5.0.4 Connector import does not reflect in adapter
At DET I have run import all on 4 connectors, bringing in 993 k users, 963 k users, 13 k users and 150 organisations. Part of the check to see that everything had worked is to check LDAP endpoint. One of my containers is missing - the connector import was successful but in the log I see error messages about failing to reflect:
Request to reflect change entities of the adapter.
Request to reflect change entities of the CAMSGeneric (30914957-d066-4f84-97e7-5c29d652d120) adapter errored with message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. Duration: 00:16:40.1628000
Error details:
System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) ...
Any ideas on how to get the connector entities to flow through to the adapter?
I tried clearing the connector to see if an import all might give it the necessary kick, but the clear connector option gives me the warning but does nothing if I select OK - i.e. my connector is unclearable.
Answer
Hi Eddie,
Database health in Identity Broker v5.0 is as important as it was in v4.1. Please ensure that indexes are maintained and statistics are kept up to date. This is especially true if there are a large number of changes to the database.
Thanks.
I will be talking to the DBA about getting indexes rebuilt. Would that be preventing the clear connector option from working?
Yes, same with that as well, as it needs the partition id indexes to perform that operation.
Ran the suggested commands for updating statistics and for rebuilding indexes. Adapter still showed 0 entities. Ran Import all (very quick - 20 seconds for 13k users) - still no entities in Adapter. Tried to clear connector and it still did nothing but present a warning screen.
I had tried that (Adapter, Operations, Generate Changes), but I thought it had hung. Now I have waited for 15 minutes, the tab in IE still has a spinning circle and the message Waiting for localhost, while the cursor occasionally becomes an eggtimer, but finally the processed entity count has gone to 1000 and the pending changes to 8500, so I guess I just need a lot more patience.
Partial success with that process: At completion connector shows 13462 entities, adapter shows 26924 pending changes and 6000 processed entities. Had to run another couple of Import All on the connector to get the adapter to show more entities, but it will not go above 11500.
Hi Eddie, please contact us to discuss how we can help test/fix this issue.
Customer support service by UserEcho
Hi Eddie,
Database health in Identity Broker v5.0 is as important as it was in v4.1. Please ensure that indexes are maintained and statistics are kept up to date. This is especially true if there are a large number of changes to the database.
Thanks.