How to truncate a BI file useing proutil - Forum - OpenEdge General - Progress Community

How to truncate a BI file useing proutil

 Forum

How to truncate a BI file useing proutil

  • HI, total newb here.  I am a user of an ERP system (Vantage, by Epicor) that is built upon Progress OpenEdge 4GL.  I signed up for the Progress Learning Community to strengthen my 4GL skills, and i downloaded OpenEdge 10.2B trial software to follow along with the training.

    I am trying to access the SPORTS2000.db, but i get en error saying:

    This codebase cannot open a  32-bit DBKEY database is the BI File is not truncated.  Use the 10.1A proutil utility to truncate the BI File.

    How do i do this?  where do i go to run proutil (seems like a command, per help, but i cannot the syntax correct)

    Any help would be greatly appreciated!

    -Keith

  • %DLC%/bin/proutil.bat %dbName% -C truncate bi

  • Is this to be ran from a command-line, or from a .p/.r program?

    What is %DLC%, full path? Do I use a full path to the dbname as well, or do I have to declare this 1st?

    Thanks for your help, Kristof.

    Yours Sincerely,

    Keith

    NORGREN: ENGINEERING ADVANTAGE

  • %DLC%/bin/proutil.bat %dbName% -C truncate bi

    To truncate the BI of a 10.1A database on OpenEdge 10.2B you gotta use

    %DLC%\bin\101dbutils\101a_dbutil.exe -C truncate bi

    %DLC% represents the OpenEdge installation directory.

  • What is %DLC%, full path?  Do I use a full path to the dbname as well, or do I have to declare this 1st?

    %DLC% represents the OpenEdge installation directory.

    The path to the db can be relative or absolute. DB needs to be shut down (no problem in your case I guess, because you weren't able to start a server anyhow).

  • Thanks Mike.

    I am getting closer, but still having issues.

    1st I tried:

    C:\OpenEdge\WRK\4GLE>%DLC%\bin\proutil.bat Sports2000.db -C truncate bi

    And I got this error:

    This codebase cannot open a 32-bit DBKey if the BI File is not truncated.

    Event Logger error: Could not find: 'PROMSGS.dll'.

    Use the 10.1A proutil utility to truncate the BI file.

    Then I tried the following commands, and I get the errors listed below each:

    C:\OpenEdge\WRK\4GLE>%DLC%\bin\101dbutils\101a_dbutil.exe Sports2000.db -C truncate bi

    The system cannot find the path specified.

    C:\OpenEdge\WRK\4GLE>c:\progress\openedge\bin\101dbutils\101a_dbutil.exe Sports2000 -C truncate bi

    msgOpen: unable to open message file: PROMSGS

    C:\OpenEdge\WRK\4GLE>c:\progress\openedge\bin\101dbutils\101a_dbutil.exe C:\Openedge\WRK\4GLE\Sports2000.db -C truncate bi

    msgOpen: unable to open message file: PROMSGS

    C:\OpenEdge\WRK\4GLE>c:\progress\openedge\bin\101dbutils\101a_dbutil.exe C:\Openedge\WRK\4GLE\Sports2000 -C truncate bi

    msgOpen: unable to open message file: PROMSGS

    C:\OpenEdge\WRK\4GLE>%DLC%\bin\101dbutils\101a_dbutil.exe -C truncate bi

    The system cannot find the path specified.

    What am I missing... the PROMSGS file?

    Yours Sincerely,

    Keith

  • What am I missing... the PROMSGS file?

     

    Setting the env-var

    PROMSGS=%DLC%\bin\101dbutils\promsgs

    might solve that.

  • Mike, how do i set the env-var?

    thanks,

    keith

  • Mike, how do i set the env-var?

     

    On Windows, on the command prompt

    SET PROMSGS=c:\Progress\OpenEdge102B\bin\101dbutils\promsgs

    Just before running the dbutil command from there.

  • I got a new error.  After trying this:

    c:\OpenEdge\WRK\4GLE>c:\progress\openedge\bin\101dbutils\101a_dbutil.exe Sports2000.db -C truncate bi

    I get this:
    PROGRESS.INI file not found. (5643)

    Any Ideas?

    Thanks,

    Keith

  • Did you start your command prompt from proenv or just the dos prompt ?

    Gerd

  • Dos. What is proenv? Newbie here... I know

  • Proenv is the dos prompt from windows but started with certain  environment variables set to the correct progress directory, eg. DLC

    You can start this from :

    * dos prompt from windows --> call c:\<install dir progress>\bin\proenv.bat psc

    or

    * Start --> <directory openedge installation> --> proenv  (see attached file)

    Following :

    - type prompt + ENTER to get the dos prompt

    - go to the path of your database

    - type the command Mike gave you + ENTER