• New Custom field not showing up in Custom Tab

    I added a custom column the Person table using the Schema Extension, and made sure the sort order was not zero.  Comitted, Compiled and then loaded The Manager.  This field is not showing up on the Custom Tab for the table, is there something else I need…

  • Already loaded DLL needs to be changed and renamed. How to remove an existing DLL?

    Running Q1IM 6.1.2: I inherited an environment that uses DLL's to allow for script libraries to code against target systems API's and such. I have coded changes to an existing loaded DLL in 1IM. It will have a new DLL name and namespace. I didn't inherit…

  • How to set UNSAccountB as Outstanding in vb script in V7 (XmarkedForDeletion)

    How to set an UNSAccountB as Outstanding by using a VB Script (XmarkedForDeletion = 2)

  • 1IM 6.1.2 Job queue Service getting the 50000 error 'Session Id for queue \nnn does not agree

    Hi,

    Working on a new Installation of 1IM v 6.1.2, getting the below error even though I only have one queue.

     

    Error excerpt:

    [821002] Error requesting queue '\FIMINFWWADV28' for database 'fiminfwwadv28\DEVD1IM_1'.
        [810023] Error during execution of…
  • AD group managed by a group not an account

    Hi,

    I am working with a customer to put their AD groups into IT Shop & have come across an issue that I had not considered before.   In AD users and groups I can see that some groups are managed by other AD groups rather than an AD user account.

    This…

  • 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…

  • Declaring the HistoryDb

    I have been looking into configuring an archiving solution for our Q1IM 6.0.2 implementation to aid in the rapidly expanding history information that is filling the database.  Currently our jobhistory table has surpassed 10 million rows and I believe it…

  • Run database compilation within script

    Hello,

    In order investiguate on issues, we need to copy production database in another environment.

    The customer want to create a task to copy the database every day and maintain the two environments with the same data.

    We are using RMAN to copy the Oracle…

  • ITShop - Approval workflow - Calculated group of approvers

    Hi,

    I try to use the "CP - Calculated group of approvers" procedure.

    First I try to select the manager of the "UID_PersonOrdered" person with the condition below:

    select *

    from Person

    where UID_Person in

    (

              select UID_PersonHead

              from Pe…