14 Replies Latest reply on Jul 28, 2017 1:50 AM by tmathew RSS
    tmathew Newbie

    CreateDashboard fails in Thingworx 7.2 (PostgreSQL)

    We have integrated PostgreSQL (version 9.4/9.5)  with Thingworx7.2 . We are getting below error when calling CreateDashboard

     

    Resources["DashboardFunctions"].CreateDashboard(params);


    NOTE: Please note that this works fine with Thingworx 7.2 WITHOUT PostgreSQL

     

    Error =>

    : Wrapped java.lang.Exception: Import Failed: Not authorized for Create Cause: Import Failed: Not authorized for

      • Re: CreateDashboard fails in Thingworx 7.2 (PostgreSQL)
        polinao Collaborator

        Are you logged in as  Administrator?

        • Re: CreateDashboard fails in Thingworx 7.2 (PostgreSQL)
          supandey Collaborator

          Hi Thomas, could you please clarify what you meant with integrated PostgreSQL version 9.4 & 9.5? Which version is used as the persistence provider for ThingWorx 7.2?

           

          What sort of user did you use to create the dashboard?

            • Re: CreateDashboard fails in Thingworx 7.2 (PostgreSQL)
              tmathew Newbie

              We are using  PostgresSQL 9.5 as thingsworx storage.

               

              We are using  ThingworxPersistenceProvider (Persistence provider package :).

               

               

              CreateDashboard is being executed by user .

               

              Please note that it works fine with Thingworx 7.2 with Neo4j as ThingworxPersistenceProvider .

                • Re: CreateDashboard fails in Thingworx 7.2 (PostgreSQL)
                  polinao Collaborator

                  PostgreSQL 9.5 is currently not supported. Please install the latest minor version of 9.4 (9.4.12)

                    • Re: CreateDashboard fails in Thingworx 7.2 (PostgreSQL)
                      tmathew Newbie

                      We have different instance, which is configured to 9.4 and getting same below error

                       

                      Wrapped java.lang.Exception: Import Failed: Not authorized for Create Cause: Import Failed: Not authorized for Create]

                        • Re: CreateDashboard fails in Thingworx 7.2 (PostgreSQL)
                          polinao Collaborator

                          Is the User an Administrator? Because otherwise this is just a permission issue.

                            • Re: CreateDashboard fails in Thingworx 7.2 (PostgreSQL)
                              tmathew Newbie

                               

                               

                              User has permission to execute "CreateDashboard", user is not Administrator

                               

                               

                              Please note that it works fine with Thingworx 7.2 with Neo4j as ThingworxPersistenceProvider .

                                • Re: CreateDashboard fails in Thingworx 7.2 (PostgreSQL)
                                  polinao Collaborator

                                  Please check if it works with Administrator user, then we will look into permissions layer by layer

                                    • Re: CreateDashboard fails in Thingworx 7.2 (PostgreSQL)
                                      tmathew Newbie

                                      It works fine with Administrator user.

                                       

                                      Below is the stack trace of normal user.

                                       

                                      Error= 

                                              at java.lang.Thread.run(Thread.java:745)

                                       

                                      1. com.thingworx.common.exceptions.InvalidRequestException: Not authorized for Create

                                       

                                              at com.thingworx.system.managers.BaseManager.generateSecurityException(BaseManager.java:499)

                                       

                                              at com.thingworx.system.managers.BaseManager.checkDesignTimePermission(BaseManager.java:458)

                                       

                                              at com.thingworx.system.managers.BaseManager.checkCreatePermission(BaseManager.java:503)

                                       

                                              at com.thingworx.system.managers.BaseManager.createEntity(BaseManager.java:224)

                                       

                                              at com.thingworx.contentmanagement.ImportProcessor.processImport(ImportProcessor.java:471)

                                       

                                              at com.thingworx.resources.dashboards.DashboardFunctions.CreateDashboard(DashboardFunctions.java:96)

                                       

                                             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:483)

                                       

                                              at com.thingworx.common.processors.ReflectionProcessor.processService(ReflectionProcessor.java:261)

                                       

                                              at com.thingworx.handlers.ReflectionServiceHandler.processService(ReflectionServiceHandler.java:48)

                                       

                                              at com.thingworx.entities.helpers.InternalServiceHelper.processServiceRequestDirect(InternalServiceHelper.java:115)

                                       

                                              at com.thingworx.entities.helpers.InternalServiceHelper.processServiceRequest(InternalServiceHelper.java:71)

                                       

                                              at com.thingworx.entities.ServiceProviderEntity.processServiceRequest(ServiceProviderEntity.java:53)

                                       

                                              at com.thingworx.dsl.engine.adapters.VirtualFunction.call(VirtualFunction.java:145)

                                       

                                              at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:32)

                                       

                                              at org.mozilla.javascript.gen.PopulateDashboardByDefault_543._c_script_0(PopulateDashboardByDefault:7)

                                       

                                              at org.mozilla.javascript.gen.PopulateDashboardByDefault_543.call(PopulateDashboardByDefault)

                                       

                                              at org.mozilla.javascript.gen.PopulateDashboardByDefault_543.exec(PopulateDashboardByDefault)

                                       

                                              at com.thingworx.dsl.engine.DSLProcessor.executeService(DSLProcessor.java:167)

                                       

                                              at com.thingworx.dsl.DSLServiceHandler.processService(DSLServiceHandler.java:37)

                                       

                                              at com.thingworx.things.Thing.processServiceRequestDirect(Thing.java:6657)

                                       

                                              at com.thingworx.things.Thing.processServiceRequest(Thing.java:6575)

                                       

                                              at com.thingworx.dsl.engine.adapters.VirtualFunction.call(VirtualFunction.java:145)

                                       

                                              at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:85)

                                       

                                              at org.mozilla.javascript.gen.SetCurrentMainDashboard_498._c_script_0(SetCurrentMainDashboard:2)

                                       

                                              at org.mozilla.javascript.gen.SetCurrentMainDashboard_498.call(SetCurrentMainDashboard)

                                       

                                              at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:394)

                                       

                                              at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3090)

                                       

                                              at org.mozilla.javascript.gen.SetCurrentMainDashboard_498.call(SetCurrentMainDashboard)

                                       

                                              at org.mozilla.javascript.gen.SetCurrentMainDashboard_498.exec(SetCurrentMainDashboard)

                                       

                                              at com.thingworx.dsl.engine.DSLProcessor.executeService(DSLProcessor.java:167)

                                       

                                              at com.thingworx.dsl.DSLServiceHandler.processService(DSLServiceHandler.java:37)

                                       

                                              at com.thingworx.things.Thing.processServiceRequestDirect(Thing.java:6657)

                                       

                                              at com.thingworx.things.Thing.processAPIServiceRequest(Thing.java:6595)

                                       

                                              at com.thingworx.webservices.BaseService.handleInvoke(BaseService.java:2931)

                                       

                                              at com.thingworx.webservices.BaseService.service(BaseService.java:327)

                                       

                                              at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

                                       

                                              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

                                       

                                              at com.thingworx.security.contenttype.ContentTypeFilter.doFilter(ContentTypeFilter.java:111)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

                                       

                                              at com.thingworx.security.filter.ValidationFilter.doFilter(ValidationFilter.java:22)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

                                       

                                              at com.thingworx.security.authentication.AuthenticationFilter.propagateRequest(AuthenticationFilter.java:370)

                                       

                                              at com.thingworx.security.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:150)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

                                       

                                              at com.thingworx.security.filter.ClickjackFilter.doFilter(ClickjackFilter.java:32)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

                                       

                                              at com.thingworx.security.filter.ProhibitIfNotLeaderFilter.doFilter(ProhibitIfNotLeaderFilter.java:119)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

                                       

                                              at com.thingworx.security.filter.HttpResponseHeadersFilter.doFilter(HttpResponseHeadersFilter.java:52)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

                                       

                                              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

                                       

                                              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)

                                       

                                              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

                                       

                                              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

                                       

                                              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)

                                       

                                              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

                                       

                                              at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)

                                       

                                              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

                                       

                                              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)

                                       

                                              at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)

                                       

                                              at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)

                                       

                                              at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502)

                                       

                                              at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458)

                                       

                                              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

                                       

                                              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

                                       

                                              at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

                                       

                                              at java.lang.Thread.run(Thread.java:745)

                                       

                                       

                                       

                                       

                                       

                        • Re: CreateDashboard fails in Thingworx 7.2 (PostgreSQL)
                          tmathew Newbie

                          Thanks a lot for the help. We got the resolution.

                          • Re: CreateDashboard fails in Thingworx 7.2 (PostgreSQL)
                            tmathew Newbie

                            there were permissions defined in data table.
                            The data table was not imported correctly.

                            After importing the issue is resolved.