-
1. Re: TEIID40011 Processing exception 'TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid
iginsk Jun 23, 2015 6:49 AM (in response to iginsk)I updated the C:\DV-6.1.0\jboss-eap-6.3\standalone\configuration\application-users.properties and C:\DV-6.1.0\jboss-eap-6.3\standalone\configuration\application-roles.properties, then i circumvented the teiid connection issues.
I deployed the VDB and tried to select the values, it was OK. But, I tried to insert, obviously it is not possible to insert the values into the view. Because the VDB had only view models.
insert into PreFinalVDB.PreFinalViewModel.test.insert_test values (1,'kumar',98863)
org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryValidatorException: Remote TEIID30492 Metadata does not allow updates on the group: PreFinalViewModel.test.insert_test
Now, My query is, how do I make it to insert the data into the physical table using the VDB. Should I add the source model , while I create the VDB and try? (i have added only the view models into the VDB earlier.
-
2. Re: TEIID40011 Processing exception 'TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid
rareddy Jun 23, 2015 8:34 AM (in response to iginsk)Kiran,
View can be updatable in Teiid unlike in other databases, granted the underlying sources support the update too. You need to set "updatable" property to "true" on your view. Depending upon complexity of the transformation, you may have to also define the insert/update/delete transformation tabs. Look "INSTEAD OF TRIGGERS" in the documentation to write these transformations. Once that is ready, you can issue INSERT/UPDATE and DELETE calls on View.
Ramesh.. -
3. Re: TEIID40011 Processing exception 'TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid
iginsk Jun 23, 2015 9:03 AM (in response to rareddy)Hi Ramesh,
Thanks. Can you please point me to the documentation that takes me to teh steps and places of this attribute changes.
Also, I posted another query on Teiid development where I face an issue of not being able to access http://localhost:8080 and...
Can you please help me resolve this. I am just right on top of it.
Thanks for your help on this
Regards,
Kiran
-
4. Re: TEIID40011 Processing exception 'TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid
iginsk Jun 23, 2015 9:35 AM (in response to iginsk)I did this and recreated the new VDB (Included with both source and view models) and started executing this VDB. It is able to retrieve the values, but not insert.
insert into PreFinal1VDB.PreFinalViewModel.test.insert_test values (1,'kumar',98863)
org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryValidatorException: Remote TEIID30492 Metadata does not allow updates on the group: PreFinalViewModel.test.insert_test
Please help.
-
5. Re: TEIID40011 Processing exception 'TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid
iginsk Jun 23, 2015 9:37 AM (in response to rareddy)I did this and recreated the new VDB (Included with both source and view models) and started executing this VDB. It is able to retrieve the values, but not insert.
insert into PreFinal1VDB.PreFinalViewModel.test.insert_test values (1,'kumar',98863)
org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryValidatorException: Remote TEIID30492 Metadata does not allow updates on the group: PreFinalViewModel.test.insert_test
Please help.
- See more at: https://developer.jboss.org/inbox#sthash.fKQPkJdj.dpuf
-
6. Re: TEIID40011 Processing exception 'TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid
van.halbert Jun 23, 2015 9:40 AM (in response to iginsk)Kiran,
If you look in the properties panel, the table info for "Update" is set to false. That needs to be changed to "true" to enable updates to the table.
Van
-
7. Re: TEIID40011 Processing exception 'TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid
iginsk Jun 23, 2015 9:51 AM (in response to van.halbert)Van,
I took that image before saving. But when I see it now, it is saved and it is updated to 'updateable'.
Still the same error. Is there anything else I should take care, please.
Regards,
Kiran
-
8. Re: TEIID40011 Processing exception 'TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid
iginsk Jun 23, 2015 9:55 AM (in response to van.halbert)On the server side, i get this exception
org.eclipse.datatools.sqltools.parsers.sql.SQLParserException: Unable to parse the input: "insert into PreFinal1VDB.PreFinalViewModel.test.insert_test values (1,'kumar',98863);".
-
9. Re: TEIID40011 Processing exception 'TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid
van.halbert Jun 23, 2015 9:55 AM (in response to iginsk)Kiran,
Did you rebuild the VDB and redeploy?
Van
-
10. Re: TEIID40011 Processing exception 'TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid
van.halbert Jun 23, 2015 9:59 AM (in response to iginsk)Kiran,
org.eclipse.datatools.sqltools.parsers.sql.SQLParserException isn't a server side exception. Can you paste the full stack trace?
Van
-
11. Re: TEIID40011 Processing exception 'TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid
iginsk Jun 23, 2015 10:21 AM (in response to van.halbert)Van ...Alright...a bit more...thanks for being with me all this while...
I edited the transformation and amended the supports update check box and redeployed the VDB...and got the result what I wanted...
Thank you...
Now, can you help me on the other issue, I am on JBOSS EAP 6.3. and I am not able to login the console...I will comment in that thread too