DevOps, CI/CD and Automation

Hi all,

I am using the barcodes example which is on otn.

I am getting the result on the development side which is my local set-up. (windows-2000) and i am using Report Builder 9.0.4.0.21.

I am able to see the barcode.

If i try the same thing on my deployment side which on my AS(Application server) which on UNIX platform .

I am getting the below error....

REP-1401: 'CF_1FORMULA0031': Fatal PL/SQL error occurred.
ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA


I had gone thru metalinks and i found few docks saying change of width of file_name

I am enclosing the details

the below is the change i did in rep_<server>.conf

<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000" classPath="$ORACLE_HOME/reports/jlib/oraclebarcode.jar">

and i had made an entry in reports.sh as mentioned in one of the docs in metalinks.

and i had changed the width of
myfilename varchar2(20);
to
myfilename varchar2(256);

and CF_1 width to same

The code in
---
function CF_1FORMULA0031 return Char is
myfilename varchar2(256);
result varchar2(20);
barcodeData VarChar2(50) := :order_ID;
begin
myFileName := srw.create_temporary_filename;
barcodemaker.setBarWidthInch(globals.bcobj, 0.005);
barcodemaker.setBaseCodeData(globals.bcobj,barcodeData);
barcodemaker.setBarCodeType(globals.bcobj,globals.barcode_to_use);
myfilename := barcodeData;
barcodemaker.setFullPath(globals.bcobj, myFileName);
barcodemaker.renderBarCode(globals.bcobj);
return(myfilename);
end;


and i had opened the trace on and my trace says the below....

-----------------------------------------------------
[2004/4/9 8:10:50:171] Debug 50103 (EngineManager:spawnEngine): Start engine command line = $ORACLE_HOME/bin/rwengine.sh -server -cp $ORACLE_HOME/reports/jlib/oraclebarcode.jar:$ORACLE_HOME/j2ee/home/lib/ojsp.jar:$ORACLE_HOME/reports/jlib/rwrun.jar:$ORACLE_HOME/jlib/zrclient.jar -Xbootclasspath/p:$ORACLE_HOME/vbroker4/lib/vbjboot.jar -Duser.language=en -Duser.region=US -Xmx256M oracle.reports.engine.RWEngine name=rwEng-0 server=rep ORACLE_HOME=/ora10g engineimplclass=oracle.reports.engine.EngineImpl traceopts=trace_all tracefile=$ORACLE_HOME/reports/logs/rep/rwEng-0.trc tracemode=trace_replace cacheDir=$ORACLE_HOME/reports/cache

------------------------

which means the server is picking the jar files....


can any one tell me what can be the issue......


Advise me at the earliest................


cheers,
ALI