Open Forum

 View Only

View My Drafts

  • 1.  FRX to new app database

    BRONZE CONTRIBUTOR
    Posted Sep 07, 2021 07:05 PM
    Hi DSLUG menbers

    I have already add a seccond application data base to my existing SL, i have no multi-company, so how can i add this company to FRx?

    as always thanks for your comments, i will appreciate.
    Gracias

    ------------------------------
    Manuel Vela
    Tec
    ------------------------------


  • 2.  RE: FRX to new app database

    BRONZE CONTRIBUTOR
    Posted Mar 24, 2022 01:12 PM
    Hi,

    Does anyone has an idea how to resolve tit?
    Thanks in advance

    ------------------------------
    Manuel Vela
    Tec
    ------------------------------

    Original Message


  • 3.  RE: FRX to new app database

    BRONZE CONTRIBUTOR
    Posted Mar 24, 2022 01:51 PM
    Hello everyone,
    finally I was able to solve the problem and I leave you what was my solution in case someone else can help you,
    i just ran this script where (Second_AppDatabase) is the name of the second company database
    and the ****'ledgerId'**** is the number of ledger ID

    Best regards
    USE (Second_AppDatabase)
SET QUOTED_IDENTIFIER off
Print 'Ejecutando script para una compañía'
declare @NaturalAcctLength char(128),
@errCount as integer
--DECLARE CompanyDbList CURSOR FOR select distinct(DatabaseName), CpnyID from Gissystem..Company
USE (Second_AppDatabase)
ALTER TABLE dbo.frl_acct_code disable trigger ALL
set @NaturalAcctLength = (select rtrim(cast(max(len(Acct))as char(128))) from ACCOUNT where Acct <> '000000')
ALTER TABLE dbo.frl_acct_code enable trigger ALL
Print 'Running frx_initial_glx_build Stored Procedure against the GisApplication Application Database with Natural Length of ' + rtrim(@NaturalAcctLength)
EXEC frx_initial_glx_build @NaturalAcctLength, ****'ledgerId'****select @errCount = count(*) from frl_glx_errs where cpnyid = ****'ledgerId'****
if @errCount <> 0
Print 'FRx has rejected ' + cast(@errCount as varchar) + ' entries into the frl_acct_code table. Please review table frl_glx_errs in the GisApplication database.'/********************************************/​


    ------------------------------
    Manuel Vela
    Tec
    ------------------------------

    Original Message