How to truncate a BI file useing proutil

Posted by norgrenvantage on 27-Mar-2011 19:58

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

OpenEdge General - Forum

All Replies

Posted by crydust on 28-Mar-2011 08:08

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

Posted by norgrenvantage on 28-Mar-2011 08:26

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

Posted by Admin on 28-Mar-2011 11:51

%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.

Posted by Admin on 28-Mar-2011 11:53

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).

Posted by norgrenvantage on 28-Mar-2011 18:21

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

Posted by Admin on 29-Mar-2011 01:41

What am I missing... the PROMSGS file?

 

Setting the env-var

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

might solve that.

Posted by norgrenvantage on 03-Apr-2011 00:20

Mike, how do i set the env-var?

thanks,

keith

Posted by Admin on 03-Apr-2011 03:31

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.

Posted by norgrenvantage on 04-Apr-2011 21:09

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

Posted by gdb390 on 14-Apr-2011 03:23

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

Gerd

Posted by norgrenvantage on 14-Apr-2011 06:45

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

Posted by gdb390 on 14-Apr-2011 08:35

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

This thread is closed