SAP Knowledge Base Article - Public

3254439 - "Unable to obtain the schema for table: <Table Name>" happens when extract data via SERVICENOW Connector in Process Intelligence


The Connector to ServiceNow has been established successfully as per the user guide.

  • When extracting the data from ServiceNow, it failed with the error message as below:

    ExtractionJob failed | source-system: SERVICENOW
    | exception: java.util.concurrent.ExecutionException
    | cause: java.lang.IllegalStateException: Unable to obtain the schema for table: <XXX>

  • Or when previewing the table, it gives the error message:

    Something went wrong
    Error Id:*********
    Socket Closed


SAP Signavio Process Intelligence


The connection user for the ServiceNow Connector doesn't have enough permission to read data from the table.


Please ask the administrator of the ServiceNow to help grant the relevant permission to the connection user as per the following documentaion


Signavio, Process Intelligence, ServiceNow, Connector, Unable to obtain the schema for table,TABLE_SCHEMA_FAILED , KBA , BPI-SIG-PI-INT , Integration / Schedules / SQL Filter / Delta criteria , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Problem


SAP Signavio Process Intelligence 3.0