Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
If a build fails with the following error:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

The issue is that the connection string to the Oracle DB is expecting a SERVICE_NAME parameter instead of an SID. The difference between them is that SID is the unique name of the instance while the SERVICE_NAME is the alias to the instance.
The workaround:
1) Choose Add Data (or ElastiCube > Change connectivity >  Change source provider if you're just updating an ElastiCube that started failing).
2) In the Connect to Oracle Database window, uncheck the Use Direct Connection checkbox.
2) In the Database server location textbox, enter the following:

The variables you need to input are:
3) Connect to the server and rebuild. 
If you need to find out the SERVICE_NAME, you can do so by connecting to the Oracle DB and running the following command:
select * from global_name;
For more information about the source of the issue visit the following:
Version history
Last update:
‎03-02-2023 08:54 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: