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
  • Hello Dave,

    I'm thinking and thinking ...

    The scripts are looking correctly.

    Sorry for the dumb question:

    Are you sure that nothing was imported in the db?

    You should look via SQL or the ObjectBrowser to see all objects without a filter.

    You told us that neither UNSAccountB's nor UNSGroupB's were created.

    What about the containers?

    Same issue?

    In the end of every import you should get in the log file the output of the counters:

    dfImport.Log(#LD("{0} lines imported", counter(LineType.Total))#)

    dfImport.Log(#LD("{0} header lines", counter(LineType.Header))#)

    dfImport.Log(#LD("{0} inserted", counter(LineType.Inserted))#)

    dfImport.Log(#LD("{0} changed", counter(LineType.Updated))#)

    dfImport.Log(#LD("{0} deleted", counter(LineType.Deleted))#)

    dfImport.Log(#LD("{0} not changed", counter(LineType.Unchanged))#)

    dfImport.Log(#LD("{0} not found", counter(LineType.NotFound))#)

    dfImport.Log(#LD("{0} empty lines", counter(LineType.Empty))#)

    dfImport.Log(#LD("{0} errors", counter(LineType.Error))#)

    What's the content?

    If all these tests/questions will not bring the light in the darkness I suggest to activate the SQL log and the Object log for the import to see what happens on the object layer and the SQL layer during the import.

    Steffen

Reply
  • Hello Dave,

    I'm thinking and thinking ...

    The scripts are looking correctly.

    Sorry for the dumb question:

    Are you sure that nothing was imported in the db?

    You should look via SQL or the ObjectBrowser to see all objects without a filter.

    You told us that neither UNSAccountB's nor UNSGroupB's were created.

    What about the containers?

    Same issue?

    In the end of every import you should get in the log file the output of the counters:

    dfImport.Log(#LD("{0} lines imported", counter(LineType.Total))#)

    dfImport.Log(#LD("{0} header lines", counter(LineType.Header))#)

    dfImport.Log(#LD("{0} inserted", counter(LineType.Inserted))#)

    dfImport.Log(#LD("{0} changed", counter(LineType.Updated))#)

    dfImport.Log(#LD("{0} deleted", counter(LineType.Deleted))#)

    dfImport.Log(#LD("{0} not changed", counter(LineType.Unchanged))#)

    dfImport.Log(#LD("{0} not found", counter(LineType.NotFound))#)

    dfImport.Log(#LD("{0} empty lines", counter(LineType.Empty))#)

    dfImport.Log(#LD("{0} errors", counter(LineType.Error))#)

    What's the content?

    If all these tests/questions will not bring the light in the darkness I suggest to activate the SQL log and the Object log for the import to see what happens on the object layer and the SQL layer during the import.

    Steffen

Children
No Data