Transport problems while transporting query
I am facing a problem.
Initially i transported a query to Prod from Dev.
The query was working perfect.
Afterwards my user suggested lots of changes which includes Changing dozens of variables so that they can filter out properly in query result.
I did all the changes and now transported query sucessfully to Prod without any errors.
Bt in prod. the query is not taking the new definition.
Its getting transported sucesfully but still its not picking new defined variables.
But those new variables are present in Production though.
Can i change the query and also do all required changes in Production.
Can i make changes in production or not ??????
If i try to restrict various Characterisitccs, i am able to find new variables , but the query is not picking those definitions....
Some times, even if all variables are exisiting, it will create problems.
I suggest to delete the transports from STMS and reimport again with overwrite original option, Hope this work around will solve the problem