Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

Functions Catalog: Execute fails

0 votes
1 view

Dear all,

we defined our own functions in the Functions Catalog and added a dataset for testing the function. After saving and returning to the overview, we now try to execute the function with the demo data; this fails silently (i.e. there's no reaction visible). Only after checking the browser's developer console we saw an error message popping up:

Failed to load resource: the server responded with a status of 400 (Bad Request)
http://myhost:8080/knowage/restful-services/1.0/functions-catalog/execute/sample/40

Is this a usage failure or is it "just" a bug? If so, can it be circumvented in some way?

(Is there a dedicated introduction to functions I could follow to make sure that I didn't do something wrong?)

Thanks

Sebastian

Environment Knowage 6.1.1 on Debian 9; Chrome & Firefox as browsers.
in Admin and Developer Functionalities by (770 points)
Which scripting language are you using? R or Python?
by (15.2k points)
I tried Python, R and remote script - in the last case, the remote URL was never called when I clicked "Execute" ...
by (770 points)
Confirmed that the same thing is happening for me with CE 6.1.1 running on RHEL 6.8 and included Tomcat (7), Java 1.8.  I'm trying to figure out how to enable DEBUG logging for all this.
by (430 points)

Here's some DEBUG output.  Some information has been altered or removed as it may have been sensitive.  My only guess is that it has something to do with security and authorization.  Output in multiple parts:

ter:73 - Receiving request from: 10.10.10.10
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,384  INFO it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.filter:74 - Attempt to invoke method [executeSampleCatalogFunctionById] on class [class it.eng.spagobi.api.FunctionsCatalogResource]
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,385 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.getUserIdentifier:192 - IN
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,385 DEBUG it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:43 - IN
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,385 DEBUG it.eng.spagobi.commons.SingletonConfigCache.get:59 - GET :SPAGOBI_SSO.INTEGRATION_CLASS_JNDI=java://comp/env/sso_class
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,385 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:309 - IN.jndiName=java://comp/env/sso_class
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,386 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:314 - jndiName: it.eng.spagobi.services.common.FakeSsoService
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,386 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:323 - OUT.value=it.eng.spagobi.services.common.FakeSsoService
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,386 DEBUG it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:53 -  Instatiate successfully:it.eng.spagobi.services.common.FakeSsoService
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,387 DEBUG it.eng.spagobi.services.common.FakeSsoService.readUserIdentifier:46 - User in HttpRequest:null
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,387 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.getUserIdentifier:198 - OUT
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,387 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.isUserAuthenticatedInSpagoBI:135 - User is authenticated and his profile is already stored in session
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,387 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.hasUserConstraints:36 - Method hasUserConstraints: Start
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,387 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.hasUserConstraints:39 - Method hasUserConstraints: The service has user constraints
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,387 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.checkFunctionalitiesByAnnotation:49 - Method checkFunctionalitiesByAnnotation: Start
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,387 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.checkFunctionalitiesByAnnotation:70 - Method checkFunctionalitiesByAnnotation: End
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,388 DEBUG it.eng.spagobi.rest.interceptors.AuditRestPostInterceptor.filter:65 - AuditRestInterceptor:postProcess IN
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,388 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.updateAudit:78 - IN
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,388 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:230 - IN
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,388 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:232 - look if default role is selected
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,388 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:238 - default role not selected
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,388 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:243 - OUT
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,389 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.createRolesString:215 - IN
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,389 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.createRolesString:225 - OUT

==> knowage_[1]_OperatorTrace.log <==
'2018-02-03-21-22-04';'130.6.49.166';'server.com';'10.10.10.10';'';'';'';'biadmin';'dev,test,user,userb,admin,modeladmin,op_reva,an_reva,bam,demo,';'[Service:/1.0/functions-catalog/execute/sample/40 ; Class:class it.eng.spagobi.api.FunctionsCatalogResource ; Method:public java.lang.String it.eng.spagobi.api.FunctionsCatalogResource.executeSampleCatalogFunctionById(int)]';'biadmin';'/knowage/restful-services/1.0/functions-catalog/execute/sample/40';'id=[Ljava.lang.Object;@34b28022';'ERR (400)';'-1';'FIREFOX';'52.0';'WINDOWS_7';

==> knowage.log <==
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,392 DEBUG it.eng.spagobi.rest.interceptors.AuditRestPostInterceptor.filter:82 - AuditRestInterceptor:postProcess OUT
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,392 DEBUG it.eng.spagobi.rest.interceptors.NoCacheInterceptor.filter:48 - IN
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,393 DEBUG it.eng.spagobi.rest.interceptors.NoCacheInterceptor.filter:54 - OUT
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,393 DEBUG it.eng.spagobi.rest.interceptors.CallbackInterceptor.filter:52 - IN
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,393 DEBUG it.eng.spagobi.rest.interceptors.CallbackInterceptor.filter:62 - OUT
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,393 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.filter:81 - IN
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,393 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.filter:83 - OUT
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,393 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.filter:138 - IN
[http-bio-8443-exec-9] 03 Feb 2018 21:22:04,393 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.filter:140 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,615  INFO it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.filter:73 - Receiving request from: 10.10.10.10
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,615  INFO it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.filter:74 - Attempt to invoke method [getDataSets] on class [class it.eng.spagobi.api.v2.DataSetResource]
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,615 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.getUserIdentifier:192 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,615 DEBUG it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:43 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,615 DEBUG it.eng.spagobi.commons.SingletonConfigCache.get:59 - GET :SPAGOBI_SSO.INTEGRATION_CLASS_JNDI=java://comp/env/sso_class
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,616 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:309 - IN.jndiName=java://comp/env/sso_class
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,617 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:314 - jndiName: it.eng.spagobi.services.common.FakeSsoService
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,617 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:323 - OUT.value=it.eng.spagobi.services.common.FakeSsoService
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,617 DEBUG it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:53 -  Instatiate successfully:it.eng.spagobi.services.common.FakeSsoService
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,617 DEBUG it.eng.spagobi.services.common.FakeSsoService.readUserIdentifier:46 - User in HttpRequest:null
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,617 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.getUserIdentifier:198 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,617 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.isUserAuthenticatedInSpagoBI:135 - User is authenticated and his profile is already stored in session
by (430 points) 
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,618 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.hasUserConstraints:36 - Method hasUserConstraints: Start
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,618 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.hasUserConstraints:39 - Method hasUserConstraints: The service has user constraints
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,618 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.checkFunctionalitiesByAnnotation:49 - Method checkFunctionalitiesByAnnotation: Start
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,618 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.checkFunctionalitiesByAnnotation:62 - Method checkFunctionalitiesByAnnotation: Functionality found
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,618 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.checkFunctionalitiesByAnnotation:70 - Method checkFunctionalitiesByAnnotation: End
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,618 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.filter:119 - The user [Knowage Administrator] is enabled to invoke method [getDataSets] on class [class it.eng.spagobi.api.v2.DataSetResource]
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,618 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.filter:60 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,619 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.filter:65 - User profile retrieved [UserProfile [userUniqueIdentifier=biadmin, userId=biadmin, userName=Knowage Administrator, userAttributes={country=US, name=Knowage Administrator, TENANT_ID=DEFAULT_TENANT, language=en, email=user@nothing.com}, roles=[dev, test, user, userb, admin, modeladmin, op_reva, an_reva, bam, demo], defaultRole=null, organization=DEFAULT_TENANT, isSuperadmin=true]]
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,619 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.filter:68 - Tenant identifier is [DEFAULT_TENANT]
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,619 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.filter:73 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,619 DEBUG it.eng.spagobi.api.v2.DataSetResource.getDataSets:133 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,619 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.setUserProfile:66 - userID = [{0}]biadmin
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,619 DEBUG it.eng.spagobi.commons.utilities.UserUtilities.isAdministrator:262 - IN.user unique id = [biadmin]
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,620 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:90 - This DAO object instance tenant = [{0}]null
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,620 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:93 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,620 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:99 - User profile tenant = [{0}]DEFAULT_TENANT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,620 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:117 - OUT: tenant = [{0}]DEFAULT_TENANT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,632 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:273 - Parsing template [META] ...
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,632 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:285 - Row data encoding version  [1]
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,632 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.insertPropertiesInMeta:396 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,632 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.insertPropertiesInMeta:409 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,633 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:370 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,639 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:79 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,640 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:104 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,645 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:273 - Parsing template [META] ...
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,645 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:285 - Row data encoding version  [1]
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,645 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.insertPropertiesInMeta:396 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,645 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.insertPropertiesInMeta:409 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,646 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:370 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,649 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:79 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,650 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:104 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,656 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:273 - Parsing template [META] ...
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,656 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:285 - Row data encoding version  [1]
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,656 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.insertPropertiesInMeta:396 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,656 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.insertPropertiesInMeta:409 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,656 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:370 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,660 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:79 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,660 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:104 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,665 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:273 - Parsing template [META] ...
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,665 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:285 - Row data encoding version  [1]
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,665 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.insertPropertiesInMeta:396 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,665 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.insertPropertiesInMeta:409 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,666 DEBUG it.eng.spagobi.tools.dataset.utils.DatasetMetadataParser.xmlToMetadata:370 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,669 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:79 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,669 DEBUG it.eng.spagobi.tools.dataset.bo.DataSetParametersList.loadFromXML:104 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,671 DEBUG it.eng.spagobi.tools.dataset.dao.SbiDataSetDAOImpl.countSbiDataSet:317 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,671 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:90 - This DAO object instance tenant = [{0}]null
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,671 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:93 - Tenant id not find in this DAO object instance; looking for it in the user profile object ...
by (430 points) 
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,671 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:99 - User profile tenant = [{0}]DEFAULT_TENANT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,671 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.getTenant:117 - OUT: tenant = [{0}]DEFAULT_TENANT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,674 DEBUG it.eng.spagobi.tools.dataset.dao.SbiDataSetDAOImpl.countSbiDataSet:341 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,675 DEBUG it.eng.spagobi.api.v2.DataSetResource.getDatasetsAsPagedList:298 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,675 DEBUG it.eng.spagobi.rest.interceptors.AuditRestPostInterceptor.filter:65 - AuditRestInterceptor:postProcess IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,675 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.updateAudit:78 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,675 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:230 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,676 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:232 - look if default role is selected
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,676 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:238 - default role not selected
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,676 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:243 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,676 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.createRolesString:215 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,676 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.createRolesString:225 - OUT

==> knowage_[1]_OperatorTrace.log <==
'2018-02-03-21-22-07';'130.6.49.166';'server.com';'10.10.10.10';'';'';'';'biadmin';'dev,test,user,userb,admin,modeladmin,op_reva,an_reva,bam,demo,';'[Service:/2.0/datasets/ ; Class:class it.eng.spagobi.api.v2.DataSetResource ; Method:public java.lang.String it.eng.spagobi.api.v2.DataSetResource.getDataSets(java.lang.String,java.lang.String,java.lang.Boolean,java.lang.String,java.lang.String,java.lang.String,java.lang.Boolean,java.lang.String)]';'biadmin';'/knowage/restful-services/2.0/datasets/';'';'OK';'0';'FIREFOX';'52.0';'WINDOWS_7';

==> knowage.log <==
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,679 DEBUG it.eng.spagobi.rest.interceptors.AuditRestPostInterceptor.filter:82 - AuditRestInterceptor:postProcess OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,679 DEBUG it.eng.spagobi.rest.interceptors.NoCacheInterceptor.filter:48 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,679 DEBUG it.eng.spagobi.rest.interceptors.NoCacheInterceptor.filter:54 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,679 DEBUG it.eng.spagobi.rest.interceptors.CallbackInterceptor.filter:52 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,679 DEBUG it.eng.spagobi.rest.interceptors.CallbackInterceptor.filter:62 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,680 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.filter:81 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,680 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.filter:83 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,680 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.filter:138 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:07,680 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.filter:140 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,681  INFO it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.filter:73 - Receiving request from:
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,681  INFO it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.filter:74 - Attempt to invoke method [executeCatalogFunctionById] on class [class it.eng.spagobi.api.FunctionsCatalogResource]
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,681 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.getUserIdentifier:192 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,682 DEBUG it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:43 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,682 DEBUG it.eng.spagobi.commons.SingletonConfigCache.get:59 - GET :SPAGOBI_SSO.INTEGRATION_CLASS_JNDI=java://comp/env/sso_class
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,682 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:309 - IN.jndiName=java://comp/env/sso_class
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,682 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:314 - jndiName: it.eng.spagobi.services.common.FakeSsoService
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,682 DEBUG it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:323 - OUT.value=it.eng.spagobi.services.common.FakeSsoService
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,683 DEBUG it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:53 -  Instatiate successfully:it.eng.spagobi.services.common.FakeSsoService
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,683 DEBUG it.eng.spagobi.services.common.FakeSsoService.readUserIdentifier:46 - User in HttpRequest:null
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,683 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.getUserIdentifier:198 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,683 DEBUG it.eng.spagobi.rest.interceptors.SecurityServerInterceptor.isUserAuthenticatedInSpagoBI:135 - User is authenticated and his profile is already stored in session
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,683 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.hasUserConstraints:36 - Method hasUserConstraints: Start
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,683 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.hasUserConstraints:39 - Method hasUserConstraints: The service has user constraints
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,683 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.checkFunctionalitiesByAnnotation:49 - Method checkFunctionalitiesByAnnotation: Start
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,684 DEBUG it.eng.spagobi.services.rest.annotations.CheckFunctionalitiesParser.checkFunctionalitiesByAnnotation:70 - Method checkFunctionalitiesByAnnotation: End
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,684 DEBUG it.eng.spagobi.rest.interceptors.AuditRestPostInterceptor.filter:65 - AuditRestInterceptor:postProcess IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,684 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.updateAudit:78 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,684 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:230 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,685 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:232 - look if default role is selected
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,685 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:238 - default role not selected
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,685 DEBUG it.eng.spagobi.commons.bo.UserProfile.getRolesForUse:243 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,685 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.createRolesString:215 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,685 DEBUG it.eng.spagobi.commons.utilities.AuditLogUtilities.createRolesString:225 - OUT
by (430 points) 
==> knowage_[1]_OperatorTrace.log <==
'2018-02-03-21-22-09';'130.6.49.166';'server.com';'10.10.10.10';'';'';'';'biadmin';'dev,test,user,userb,admin,modeladmin,op_reva,an_reva,bam,demo,';'[Service:/1.0/functions-catalog/execute/new/40 ; Class:class it.eng.spagobi.api.FunctionsCatalogResource ; Method:public java.lang.String it.eng.spagobi.api.FunctionsCatalogResource.executeCatalogFunctionById(java.lang.String,int)]';'biadmin';'/knowage/restful-services/1.0/functions-catalog/execute/new/40';'id=[Ljava.lang.Object;@701f9f';'ERR (400)';'-1';'FIREFOX';'52.0';'WINDOWS_7';

==> knowage.log <==
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,687 DEBUG it.eng.spagobi.rest.interceptors.AuditRestPostInterceptor.filter:82 - AuditRestInterceptor:postProcess OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,687 DEBUG it.eng.spagobi.rest.interceptors.NoCacheInterceptor.filter:48 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,687 DEBUG it.eng.spagobi.rest.interceptors.NoCacheInterceptor.filter:54 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,687 DEBUG it.eng.spagobi.rest.interceptors.CallbackInterceptor.filter:52 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,687 DEBUG it.eng.spagobi.rest.interceptors.CallbackInterceptor.filter:62 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,687 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.filter:81 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,688 DEBUG it.eng.spagobi.rest.interceptors.TenantRestProcessInterceptor.filter:83 - OUT
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,688 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.filter:138 - IN
[http-bio-8443-exec-10] 03 Feb 2018 21:22:09,688 DEBUG it.eng.spagobi.services.rest.AbstractSecurityServerInterceptor.filter:140 - OUT
by (430 points)

1 Answer

0 votes
We might have resolved our issue by granting our admin user a lot more rights under "Profile Management" -> "Roles Management". Can you check if that does also resolve your issue? (We still can't run scripts, but at least we get an error message now.)
by (770 points)
Powered by Question2Answer
...