Hi @Saranga Amaraweera Thank you for the reply. But the same XML is getting executed without any error in another FSM environment (version 6.12.7886.1000). But we are using version 6.14.7977.1000 where we are getting this error :<subteam_hierarchy_select_result> <result type="Exception"> <error> <system_error> <severity>ERROR</severity> <message>The database command failed and reported the following error: The objects "request_unit" and "request_unit" in the FROM clause have the same exposed names. Use correlation names to distinguish them.</message> </system_error> </error> </result></subteam_hierarchy_select_result> I understand using an sql view is always an option but this requirement is a very simple one which can be easily achieved using multiple joins which I have seen working in the past so we want to refrain from using sql view. Thanks,Shamika Chatterjee
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.