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
  • Hi All,

    I have a doubt here related to same script. Please suggest .

    We are assigning the SQL query to lineprovider.statement here but where will exactly the statement get executed? Is it while getlines() as below?

    For Each line As Line In lineProvider.GetLines(counter)

    The issue here is, even the query is throwing error it is not throwing any execption or no error is returned here. How can we get to know if the query is throwing some error while executing?

Reply
  • Hi All,

    I have a doubt here related to same script. Please suggest .

    We are assigning the SQL query to lineprovider.statement here but where will exactly the statement get executed? Is it while getlines() as below?

    For Each line As Line In lineProvider.GetLines(counter)

    The issue here is, even the query is throwing error it is not throwing any execption or no error is returned here. How can we get to know if the query is throwing some error while executing?

Children
No Data