Transformation Extenders with Windows 2008 64 bit -

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1369
Roger French	1315
mark.cook	1244

kdcoate

Veteran Member

Posts: 44

9/14/2010 1:06 PM

Has anyone upgraded to LSF 9.0.1.6 using Windows 2008 R2 with the Transformation Extenders (Mercator/DataStage replacement)? We have not been successful in getting ProcessFlow to call TE when installed on the server (can't make the 64 bit call) and we're being told by Lawson that we need to install TE on a 32 bit PC and call it remotely. Before I go that route, I'd love to know if anyone has implemented this without a remote PC. Thanks!

Jimmy Chiu

Veteran Member

Posts: 641

9/14/2010 1:28 PM

Just finished installing WebSphereTE8.2 on my development lawson 64bit windows 2008 R2 server (local install). Spent a day to troubleshoot testgroupBCI and the fileclient smoketest issues. Finally got it working and passed both tests. What error you run into?

kdcoate

Veteran Member

Posts: 44

9/14/2010 1:32 PM

Have you been able to run a ProcessFlow that actually calls TE?

Jimmy Chiu

Veteran Member

Posts: 641

9/14/2010 1:38 PM

Can't load IA 32 bit dll (which it's calling to the TEinstalldir\dxtxjpi.dll) on a AMD 64 bit platform, does it look familiar?

kdcoate

Veteran Member

Posts: 44

9/14/2010 1:41 PM

Yes - that would be the error! Have you resolved this already?

Jimmy Chiu

Veteran Member

Posts: 641

9/14/2010 1:48 PM

Yes. Solved it on my own. Still have a case open with Lawson after they switched 3 engineers on me. They are still investigating.

Run this command and see if you come up with the following result:

pfserv test testGroupBCi

it runs couple flows to call to TE.

kdcoate

Veteran Member

Posts: 44

9/14/2010 1:57 PM

I'll have to go back and re-install TE8.2. Lawson had me install 8.1 because they had documentation saying it was the only version that was certified and that it would run on both 32 and 64 bit. I really appreciate your help with this.

Jimmy Chiu

Veteran Member

Posts: 641

9/14/2010 2:08 PM

Eventhough it's local install.

while you are setting up "pfserv config datastage", choose "Y" for remote. Then point it back to the local server name and port 2500 (default port unless you changed it). That should fix the problem with not loading 32bit dll.

kdcoate

Veteran Member

Posts: 44

9/14/2010 5:09 PM

I've un-installed TE8.1 and re-installed 8.2. Now when I execute the startRMIServer.bat file, nothing happens at all. I'm just returned to the prompt. All of my environment variables have been defined, bci_maps copied over, rmiserver.properties file confirmed. Do I need to add JAVAHOME to the startRMIServer.bat?

Jimmy Chiu

Veteran Member

Posts: 641

9/14/2010 6:10 PM

nope, when you run startRMIserver.bat, the windows appear to do nothing, it's "normal". DO NOT CLOSE the window.

leave the command prompt open. then you can run the smoketest.

kdcoate

Veteran Member

Posts: 44

9/14/2010 6:33 PM

Executing the .bat file doesn't hang - it just returns me to a command prompt but that's only if I add a JAVAHOME value. Without the JAVAHOME value, I receive the following error: "Exception in thread "main" java.lang.UnsatisfiedLinkError: dtsxjpi [Not found in java.library.path]". I'm assuming at this point that I've either left something out or I'm dealing with permission issues. Did I mention that I really appreciate your help?

Jimmy Chiu

Veteran Member

Posts: 641

9/14/2010 7:12 PM

Here is the step-by-step screenshot on how to setup WebSphere TE 8.2 on Windows 2008 R2 64 bit.

It also has the procedure on how to create custom windows service to start RMI automatically. So you don't have to login and run the stupid startRMIServer.bat and stay logged in just to run TE. (*Not supported by lawson)

http://www.mediafire.com/?p73salwranztvd8

Jimmy Chiu

Veteran Member

Posts: 641

9/14/2010 7:18 PM

You need to put the TEinstalldir in your system %PATH%

If you are reading the article from lawson. Skip all the variables they told you to put in. something like MERC_XXX_DIR or DTX_XXX_DIR etc. With lawson's infinite typo ability, half the path/files do not even exist in that article.

The only variable you need is listed in the zip file I uploaded above.

Jimmy Chiu

Veteran Member

Posts: 641

9/14/2010 7:31 PM

Might as well upload the screenshots for Setup ProcessFlow Connector on Windows 2008 R2 64 bit to finish this.

http://www.mediafire.com/?z13k7ft4m7u2870

kdcoate

Veteran Member

Posts: 44

9/14/2010 8:24 PM

Success! Thank you so much.