My Oracle Support Banner

DataSync Error Out "ERROR 25502: An SQL data change is not permitted for a read-only connection" (Doc ID 2673008.1)

Last updated on MARCH 10, 2021

Applies to:

Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.
DataSync 2.6

Symptoms

DataSync throws the following errors while server start.

Error
-----------------------
Error "Windows cannot find "-server" should be resolved.

MESSAGE :::An SQL data change is not permitted for a read-only connection, user or database.
EXCEPTION CLASS::: org.apache.derby.client.am.SqlException

Caused by: ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.