Skip to Content
avatar image
Former Member

Variable in KF Structure removed

Hi

I have removed a variable from a reusable structure but the structure however is

still referencing the variable Although the queries are running by using the new

variable that was inserted into the structure we are not able to delete the old variable using RSZDELETE.

When i am trying to delete the variable it is showing that its being used in the

structure but i am sure that it is not being used.

Please help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • avatar image
    Former Member
    Aug 22, 2007 at 10:06 AM

    Hi,

    close the QDesigner and reopen it; perform a where used list for this variable; if it is not used anywhere you'll then be able to delete it.

    hope this helps...

    Olivier.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 11:44 AM

    Hi

    Let me re phrase my question I need to know how to regenerate a query

    structure , I am sure ther must be some function module.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      yes you can use RSRT in order to generate the query, but not the structure....

      finally what do you want to delete??

      Olivier.

  • avatar image
    Former Member
    Aug 22, 2007 at 10:04 AM

    Shashi,

    If you refer to a group of queries using this structure, you should check all the nodes in that.

    Else if you want to do that for a single query, you can remove the reference of the structure and proceed with changes.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 12:33 PM

    Hi

    I am using a structure with a variable I created .I have removed from the structure a previous variable that was being used.Now if i go into RSZDELETE and try to delete the Old redundant variable it is showing as being used in the structure.However i am very sure that it is not being used in any structure ,RKF or CKF.

    Please Help

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      where did you use your variable? in a RKF or is it a text var?

      Is your structure a Global or Local structure?

      Did you close and reopen the QDesigner and eventually logoff login? Usually this is the problem: you have to leave the querydesigner in order to release the locks. (see locks in SM12, perhaps your variable is locked.). Is there any other user having open the qdesigner?

      let us know

  • avatar image
    Former Member
    Aug 22, 2007 at 01:21 PM

    I am sorry all of these are not helping.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 23, 2007 at 10:28 AM

    Hi

    I am not able to delete the variable using any of the above methods.

    I need to see if the structure is stored in any object.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 23, 2007 at 11:01 AM

    THE STRUCTURE IS BEING USED IN AROUND TEN QUERIES.BUT I AM NO LONGER USING THE VARIABLE IN THE STRUCTURE.

    HOWEVR THE META DATA SHOWS THAT THE VARIABLE TO BE USED BY

    THE STRUCTURE WHICH IS NOT TRUE.

    AND THATS WHERE THE PROBLEM IS ARAISING.

    I AM SURE THAT I AM NOT USING THE VARIABLE IN THE STRUCTURE.

    AND WHEN I WANT TO DELETE ITS HOWVER GIVING AN ERROR SAYING THAT THE VARIABLE IS BEING USED.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2007 at 05:42 AM

    Hi

    My problem has been solved the issue was the redundant entries in tables

    RSZELTXREF

    RSZELTDIR

    RSZCOMPDIR

    Deleting these entries solves the problem.

    Thanks for all your inputs .

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2007 at 10:02 AM

    hi,

    to see the list of variables in Bex, go to table RSZGLOBV and see where it is used when i have got same problem i tried this right click on the variable and delte and save and once again right click on the variable and delte try this

    thanks

    srini

    Add comment
    10|10000 characters needed characters exceeded