Focal Point
[SOLVED] ReportCaster rcExport2XML.bat errors??:

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3797077776

August 11, 2015, 05:21 PM
CoolGuy
[SOLVED] ReportCaster rcExport2XML.bat errors??:
Hey everyone,

So, we have attempted to run the rcExport2XML.bat file that the Migration manual tells us to use to export ReportCaster content from 7.x to 8.x. I did first copy the rc directory over from the utilities directory of our 8.x install to the 7.x ...\ReportCaster76\rc directory like we are supposed to do.

When we run it we get to the "Do you want to export all ReportCaster content, or only Library content?" question and select an option. But then we get a stack trace chain of errors displaying for a java.lang.NoClassDefFoundError: javax/resource/ResourceException being thrown saying "Could not find the main class: ibi.broker.Export2XML. Program will exit. Press any key to continue..."

Has anyone here ever ran into this error before and know how to fix it? Where would I find this class file if I did want to find it?

Any help and expertise is greatly appreciated!

Thanks so much in advance!

This message has been edited. Last edited by: CoolGuy,


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
August 12, 2015, 07:30 AM
CLH
Edit the bad file and look for line that starts with the following

call %~dpo\..\..\Reportcaster

Make sure this matches your path to Report caster


Webfocus 8.0.7 on Windows
August 12, 2015, 07:47 AM
Wep5622
quote:
Originally posted by CoolGuy:
I did first copy the rc directory over from the utilities directory of our 8.x install to the 7.x ...\ReportCaster76\rc directory like we are supposed to do.


Your copying didn't accidentally create a directory ...\ReportCaster76\rc\rc?

The error you're seeing looks familiar from when we had that utility copied to the wrong location; in our case the utility's files were copied directly into the ReportCaster directory instead of to an rc\ subdirectory.

It's also possible that the utility has trouble with the appended version number on the ReportCaster directory. I think your safest bet in that case would be to create a symbolic link (UNIX/Linux) or junction (Windows NTFS) named ReportCaster to the ReportCaster76 directory.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
August 12, 2015, 10:25 AM
CoolGuy
CLH,

So, I went into the rcExport2XML.bat file and found this section of code:

if exist %~dp0\..\..\ReportCaster (
  call %~dp0\..\..\ReportCaster\bin\classpath.bat
) else (
  if exist %~dp0\..\..\ReportCaster76 (
    call %~dp0\..\..\ReportCaster76\bin\classpath.bat
  )
)
set CLASSPATH=%~dp0\rcExport2XML.jar;%CLASSPATH%

set EXPDIRLOC=.\

java %JAVA_OPTS% -Dfile.encoding=%ENCODING% -cp "%CLASSPATH%" ibi.broker.Export2XML ^
cfgDir="%DSINSTALL%/cfg" ^
user=%USERNAME% ^
password=%PASSWORD% ^
location=%EXPDIRLOC% ^
isLibFile=%EXPLIB% ^
isPartial=%MIGMR% ^
IncNonDomainSchedLib=%INCNONDOMAIN% ^
isLibOnly=%LIBONLY%


I also went into the classpath.bat file and found this code:

set CMD_LINE_ARGS=
rem set CMD_LINE_ARGS=MASTER -f
rem set CMD_LINE_ARGS=FAILOVER
set DSINSTALL=D:\ibi\ReportCaster76
set DSINSTALL_PROD=D:\ibi\ReportCaster76
set DSHOST=<the name of our server>
set DSPORT=<port number>
set CLASSPATH=C:\Microsoft_SQL_Server_2005\sqljdbc_1.2\enu\sqljdbc.jar;;;%DSINSTALL_PROD%\lib\reportcaster.jar;


Do you see anything that looks off?
Where would I check to see what our path to ReportCaster is? Sorry, I'm new to this. Thanks for your help though!

Wep5622,

I took the rc directory from the \\..\..\ibi\WebFOCUS81\utilities directory and copied it into the
\\..\ibi\ReportCaster76 directory making the path \\..\ibi\ReportCaster76\rc without any sign of copying it into an additional rc subdirectory of rc, and I did not take the files from the rc directory and copy them all directly into the ReportCaster76 directory either. So things are as they should be...I think.

I'm not sure the appended version number on the ReportCaster76 directory is an issue due to the check made in the batch file (seen above). If I were wanting to create a junction (Windows) as you call it, how & where would I go to do such? Again, I'm sorry I'm so new at this stuff. Trying to learn as fast as I can. Appreciate your help a lot though.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
August 12, 2015, 11:20 AM
Wep5622
Looks like you did things correctly then.

I once created a junction on a Windows 7 NTFS file system, but I have since forgotten how to do that. I don't normally care for Windows admin tasks, that's the very last operating system I would ever want to manage on any scale beyond home use. Don't even remember how I know about junctions, I must have picked that up somewhere...

What I do recall is that we opened a case for the migration tool with some urgency and that we got help from IBI support fairly quickly.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
August 12, 2015, 12:19 PM
CoolGuy
Oh no worries man. Thanks though. Sounds pretty intense. I agree Windows can be a pain. Hoping after the initial bugs get ironed out that Windows 10 will be a lot better. Just upgraded my home laptop to Windows 10 Home. Haven't had time to play with it yet, but looks pretty slick.

I have opened/updated a case with IBI on getting help with our migration issues. I haven't heard back yet, but hope to here soon.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
August 27, 2015, 10:43 AM
CoolGuy
I eventually figured out that I was mistakenly not running the .bat script on the server/box we were exporting from. After running it on the needed server/box we were able to run it without issue. Never knew we had to do that until now. Figured it out though. That's the main thing.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.