This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Designer - SQL Database Import not Updating UNSAccountB

Gurus,

I eluded to this question in a previous post and despite my best efforts, I can't find a solution yet. So here is the situation, one of the applications we are attesting to runs off an MS SQL Database and our DBAs have basically given the Quest account rights to run a few stored processes so that it can synch the users/groups from the SQL application to Quest. The script basically opens a connection string to the database, runs the stored procs and uses the data to populate users (one script) and populate data base roles (other script) into UNSAccountB and UNSGroupB respectively while tagging XProxyContext to be the application name... lets call it DBApp1 for privacy.

In the Production environment, the sccripts work just fine... they pull the data in and populate accordingly. I used the Database Transport tool to import all Change Labels into the Test lab. After verifying that AD synch was working Dev and then making sure that Manager > Unified Namespace has an entry for DBApp1, I ran the import. I watched the job logs intently - refreshing every few seconds, just to make sure everything worked. Yay! The script completed and I got NO errors. I even have the script writing a log file to show me what it does. The log file shows several new inserts into the database. Yay!

THEN... I checked UNSAccountB and UNSGroupB. NOTHING is there... There are no records at all...

I tried the same process again with DBApp2. Again, all things look great! Imports run and NOTHING in UNSAccountB or UNSGroupB. What the heck happened? Where did this stuff go? If the logs think everything is fine and the database is sending data (I verified this). Why doesn't it populate into Quest? Can anyone provide me some insight?

Thanks in advance!

Parents
  • I just wanted to show you that this can't work. The UID_UNSContainerB attribute in UNSAccountB and UNSGroupB is the foreign key to the UNSContainerB table, so it should carry the UID (the primary key) of the UNSContainerB instead of its canonical name. But you can use the canonical name to determine the correct UID by doing a connection.getsingleproperty.

    You know what i mean?

Reply
  • I just wanted to show you that this can't work. The UID_UNSContainerB attribute in UNSAccountB and UNSGroupB is the foreign key to the UNSContainerB table, so it should carry the UID (the primary key) of the UNSContainerB instead of its canonical name. But you can use the canonical name to determine the correct UID by doing a connection.getsingleproperty.

    You know what i mean?

Children
No Data