Subject Re: Cannot create sequence
Author Jorge Andres Brugger
Post date 2017-09-23T00:54:24Z
Solved.
I was missing to do GRANT USAGE ON SEQUENCE RDB$GEN_REPLICADOR TO [user] WITH GRANT OPTION
(Sequence seems to be considered system one and dont get listed)
Regards!

2017-09-22 21:44 GMT-03:00 Jorge Andres Brugger <jorge.brugger@...>:
Hello all.
To use a replication solution (not longer maintaned) i need to create a generator/sequence named "RDB$GEN_REPLICADOR" but when I try to do it i get (using Flamerobin):

Error: *** IBPP::SQLException ***
Context: Statement::Execute( CREATE GENERATOR RDB$GEN_REPLICADOR )
Message: isc_dsql_execute2 failed

SQL Message : -607
can't format message 13:393 -- message file C:\Windows\system32\firebird. msg not found

Engine Code    : 335544351
Engine Message :
unsuccessful metadata update
CREATE SEQUENCE RDB$GEN_REPLICADOR failed
unknown ISC error 336068862

How I can create that generator?
Thanks!