Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can not add attribute to attribute set #454

Closed
metasnw opened this issue Jun 12, 2017 · 3 comments
Closed

Can not add attribute to attribute set #454

metasnw opened this issue Jun 12, 2017 · 3 comments

Comments

@metasnw
Copy link
Member

metasnw commented Jun 12, 2017

Is this a bug or feature request?

bug

What is the current behavior?

can not add a line which is saved

Which are the steps to reproduce?

try to add via add new in:
https://w101.metasfresh.com:8443/window/256/1000012

image

What is the expected or desired behavior?

line should be saved

@teosarca
Copy link
Member

update: basically it's because M_AttributeUse does not have a single PK.

@teosarca
Copy link
Member

stack trace

2017-06-13 12:17:56.128 ERROR 4327 [                ][          ] --- [http-nio-8080-exec-10] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.adempiere.exceptions.AdempiereException: Failed building where clause because there is no Key Column defined in SqlDocumentEntityDataBindingDescriptor{sqlTableName=M_AttributeUse, sqlTableAlias=d1}] with root cause

org.adempiere.exceptions.AdempiereException: Failed building where clause because there is no Key Column defined in SqlDocumentEntityDataBindingDescriptor{sqlTableName=M_AttributeUse, sqlTableAlias=d1}
        at de.metas.ui.web.window.model.sql.SqlDocumentQueryBuilder.buildSqlWhereClause(SqlDocumentQueryBuilder.java:395)
        at de.metas.ui.web.window.model.sql.SqlDocumentQueryBuilder.getSqlWhereAndParams(SqlDocumentQueryBuilder.java:361)
        at de.metas.ui.web.window.model.sql.SqlDocumentQueryBuilder.buildSql(SqlDocumentQueryBuilder.java:298)
        at de.metas.ui.web.window.model.sql.SqlDocumentQueryBuilder.getSqlAndParams(SqlDocumentQueryBuilder.java:278)
        at de.metas.ui.web.window.model.sql.SqlDocumentQueryBuilder.getSql(SqlDocumentQueryBuilder.java:265)
        at de.metas.ui.web.window.model.sql.SqlDocumentsRepository.retriveDocuments(SqlDocumentsRepository.java:165)
        at de.metas.ui.web.window.model.sql.SqlDocumentsRepository.retrieveDocument(SqlDocumentsRepository.java:250)
        at de.metas.ui.web.window.model.DocumentQuery$Builder.retriveDocumentOrNull(DocumentQuery.java:196)
        at de.metas.ui.web.window.model.HighVolumeReadWriteIncludedDocumentsCollection.getDocumentById(HighVolumeReadWriteIncludedDocumentsCollection.java:199)
        at de.metas.ui.web.window.model.Document.getIncludedDocument(Document.java:1499)
        at de.metas.ui.web.window.model.DocumentCollection.lambda$forDocumentReadonly$0(DocumentCollection.java:117)
        at de.metas.ui.web.window.model.DocumentCollection.forRootDocumentReadonly(DocumentCollection.java:150)
        at de.metas.ui.web.window.model.DocumentCollection.forDocumentReadonly(DocumentCollection.java:110)
        at de.metas.ui.web.window.controller.WindowRestController.getDocumentFieldDropdown(WindowRestController.java:473)
        at de.metas.ui.web.window.controller.WindowRestController.getDocumentFieldDropdown(WindowRestController.java:465)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)

@metas-rc
Copy link
Member

Results of IT

Tested on webui

  • I was able to both " add new" and delete attributes in Attribute set.

@metas-rc metas-rc self-assigned this Jun 19, 2017
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Jun 19, 2017
[#458](metasfresh/metasfresh-webui-api-legacy#458) Debug endpoint to track websocket outbound events
[#1855](#1855) error with order that has just packaging lines
[#898](metasfresh/metasfresh-webui-frontend-legacy#898) Lookup Field Dropdowns automatism
[#861](metasfresh/metasfresh-webui-frontend-legacy#861) Make remaining UI components translatable
[#454](metasfresh/metasfresh-webui-api-legacy#454) Can not add attribute to attribute set
[#1843](#1843) Error Table M_Product does not have a simple primary key
[#1852](#1852) intern: discover interceptors which were annotated with @component
[#895](metasfresh/metasfresh-webui-frontend-legacy#895) Modal view: when user presses Done the server shall be notified
[#907](metasfresh/metasfresh-webui-frontend-legacy#907) Margin missing in Advanced Edit when Scrollbar visible
[#904](metasfresh/metasfresh-webui-frontend-legacy#904) Navigation Menu vs. Sitemap entries w/ linebreak
[#900](metasfresh/metasfresh-webui-frontend-legacy#900) Handling Unit Window does not open in some cases
[#462](metasfresh/metasfresh-webui-api-legacy#462) Dashboard editing API prototype
[#1840](#1840) internal: refactor and improve PO translation code
[#897](metasfresh/metasfresh-webui-frontend-legacy#897) Clicking the search icon should open partner list
[#893](metasfresh/metasfresh-webui-frontend-legacy#893) Navigation Menu keyboard usage broken
[#1808](#1808) Sometimes i get empty window when i zoom to related sales invoices of a given sales order
[#443](metasfresh/metasfresh-webui-api-legacy#443) Make remaining UI components translatable

me-45
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants