Foxhound 5.0 FAQ
search engine by freefind advanced
Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad           Breck.Carter@gmail.com     


Message: Modifications not permitted for read-only database SQLCODE=-757
Message: -757 Modifications not permitted for read-only database
Message: Could not execute statement. Modifications not permitted for read-only database SQLCODE=-757
Message: OFSS Modifications not permitted for read-only database SQLCODE=-757
Message: SQLCODE = -757 Modifications not permitted for read-only database

Explanation: The Offline Foxhound Sampling Service (OFSS) doesn't work on read-only subject databases because the OFSS scripts can't modify the database.

This limitation affects High Availability secondary (mirror) and read-only scale-out databases in particular.

C:\HASETUP2-V17>"C:\Program Files\SQL Anywhere 17\bin64\dbisql.com"
  -c "SERVER=secondary_server; UID=dba; PWD=sql; HOST=localhost:55502,localhost:55503; CON=Secondary;"
  READ ENCODING Cp1252 "C:\ProgramData\RisingRoad\Foxhound5\scripts\OFSS_1_setup.sql" [OFSS]
You have connected to a read-only database.
Some Interactive SQL functionality will be disabled.
10 row(s) affected

Could not execute statement.
  Modifications not permitted for read-only database
  SQLCODE=-757, ODBC 3 State="42000"

C:\ProgramData\RisingRoad\Foxhound5\scripts\OFSS_1_setup.sql:83
  CREATE TABLE "OFSS".OFSS_settings (

You can continue executing or stop.
1. Stop
2. Continue
Select an option:

Administrative Tip: When using OFSS on a High Availability setup, run the OFSS setup and start_OFSS_monitor() on the primary, not the underlying partner. After a failover, you can then rerun the CALL start_OFSS_monitor() on the primary because it will be updatable.

You can also run OFSS on the arbiter server if it has a database.


This page was last updated on August 4, 2019.      Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com