Re: [firebird-support] firebird found more than one transation isolation in tbp

2019-12-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.12.2019 15:41, SOFTDZ m_brahi...@yahoo.fr [firebird-support] wrote:
> My application is executed fine but when I try to execute an SP I get
> that message above
> the SP do some works to clean the db at app first installation
> before it worked fine for two years and did not make changes the code
> since today  and now it cannot be executed

   Didn't you upgrade server version yesterday?


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/



[firebird-support] firebird found more than one transation isolation in tbp

2019-12-19 Thread SOFTDZ m_brahi...@yahoo.fr [firebird-support]
Hi all,

My application is executed fine but when I try to execute an SP I get 
that message above
the SP do some works to clean the db at app first installation
before it worked fine for two years and did not make changes the code 
since today  and now it cannot be executed
Thanks for help

This is the code:

SET TERM ^ ;

create or alter procedure init_first_start
as
declare variable nom varchar(30);
declare variable pwd varchar(250);
declare variable login_name varchar(30);
declare variable id integer;
declare variable role_name varchar(20);
BEGIN
  /*
   SELECT SEC$USER_NAME FROM SEC$USERS WHERE 
SEC$USER_NAME='ADMINISTRATEUR' INTO :NOM;


   IF (:NOM IS NULL) THEN
   BEGIN
   SELECT PWD FROM TB_USER WHERE LOGIN_NAME='ADMINISTRATEUR' INTO :PWD;
   EXECUTE PROCEDURE 
USER_CREATE('ADMINISTRATEUR',PWD,0,0,'RDB$ADMIN','SYSDBA','','','MASTERKEY');
   END
     */


   DELETE FROM CONNECTION_LOG;
   DELETE FROM MESSAGERIE;
   DELETE FROM MESSAGERIE_ATTACHMENT;
   UPDATE PARAMETRES SET 
BACKUP_DB_PATH='',MIN_LENGTH_PASSWORD=5,EVALUATEUR_MUST_VALIDATE=0,ENABLE_INPUT_CONTROL=0;


   FOR SELECT LOGIN_NAME  FROM TB_USER INTO  :LOGIN_NAME    DO
    BEGIN
  LOGIN_NAME=COALESCE(:LOGIN_NAME,'');
  LOGIN_NAME=TRIM(:LOGIN_NAME);
  IF (:LOGIN_NAME<>'ADMINISTRATEUR')  THEN
   BEGIN
    EXECUTE STATEMENT 'DROP USER ' || LOGIN_NAME ;
    SELECT USERID FROM TB_USER WHERE LOGIN_NAME=:LOGIN_NAME INTO :ID;
    DELETE FROM  USER_PROFIL WHERE USERID=:ID;
    DELETE FROM  ALERTE WHERE USERID=:ID;
    DELETE FROM TB_USER WHERE LOGIN_NAME=:LOGIN_NAME;
   END
    END
  END^

SET TERM ; ^

/* Following GRANT statements are generated automatically */

GRANT SELECT,DELETE ON CONNECTION_LOG TO PROCEDURE INIT_FIRST_START;
GRANT SELECT,DELETE ON MESSAGERIE TO PROCEDURE INIT_FIRST_START;
GRANT SELECT,DELETE ON MESSAGERIE_ATTACHMENT TO PROCEDURE INIT_FIRST_START;
GRANT SELECT,UPDATE ON PARAMETRES TO PROCEDURE INIT_FIRST_START;
GRANT SELECT,DELETE ON TB_USER TO PROCEDURE INIT_FIRST_START;
GRANT SELECT,DELETE ON USER_PROFIL TO PROCEDURE INIT_FIRST_START;
GRANT SELECT,DELETE ON ALERTE TO PROCEDURE INIT_FIRST_START;

/* Existing privileges on this procedure */

GRANT EXECUTE ON PROCEDURE INIT_FIRST_START TO SYSDBA;
GRANT EXECUTE ON PROCEDURE INIT_FIRST_START TO GESTIONNAIRE;
GRANT EXECUTE ON PROCEDURE INIT_FIRST_START TO OPERATEUR;