Hi vamsikrishna,

look like sql query problem.

Are you using SQL query on this page.

this sql query should be {Role}.[Name] 

Regards

Rahul Sahu

Hi Rahul,

This is the error we noticed, while accessing lifetimeidp client configuration. 

Regards, 

Vamsi

Hi Rahul Sahu,

I am working with Vamsi and we were able to fix the SQL problem. The issue was that the plugin had a wrong SQL query, the format looked like MySQL syntax, once we changed to Oracle it worked fine. 

Now we have another issue on the configuration form, more specifically the second tab called "SP Connector settings and Claims". It never saves the configuration and reset to the default values as follows.

All the other tabs are working fine but this one.  We debugged using the Service Studio and it looks like it is a problem with the Form validation.  For some reason it always returns "false".

We went through all the fields on the form and we are filling all the fields that is mandatory but the validation is always false.  Any ideia what is going on?

Thanks!

Andre

Andre, it would be really helpful if you could post the fix for that query. This way other people don't have to go through the same pain and can easily fix the same problem. Thanks !

To give a bit more info on this. If you are using Oracle as database, you need to remove the "top 1" from all the queries in order for this component to work. In my opinion, this should be fixed in the component.