TC - What'd i forget?

[DBohner-(db)]

TC - What\'d i forget?

I am creating this TC...

I have my input... I have my output (foreign, AS400...)

I have four formats that get loaded to this very wide (400 char) record...

All of my ER logic seems to check out...

I go to Batch Versions - attempt to run... it acts like it is starting ...
then it just goes away...

I don't get any logs... it just goes away...

Suggestions?




Daniel Bohner
[email protected]
www.existinglight.net
JDE - XE & AS/400
JDE - B7331 & MS SQL 7x

 

[WhippingBoy]

Re: TC - What\'d i forget?

Do you have any dates in there? I've seen this when writing an invalid date into a julien date field with TC.

JDEDEBUG.LOG should show you something though, even if it's just the UBE-starting messages.

Darren Ricciardi - OneWorld Whipping Boy

Looking for work WEST of DENVER

 

[DBohner-(db)]

RE: TC - What\'d i forget?

Thanks Darren... I know I didn't give a great deal to go on...

I did have one of our consultants spy over my shoulder...

Resolution, sorda...
Though I have the outbound table created and pointed to an AS/400
library/file - the TC was trying to write to the local B7\environment\export
folder... I found the issue when turning on the TC logs - and seeing that
it couldn't get to the folder (I hadn't created the export folder). I
created the export folder - and it ran ...

Thus a new question arrives...

If one creates a TC that points to a local folder - how do you modify the TC
to point to, say, a file within an AS/400 library... without loosing all the
specs...

Learning more about TCs, than I may ever want to know...



Daniel Bohner
[email protected]
www.existinglight.net
JDE - XE & AS/400
JDE - B7331 & MS SQL 7x

 

[pcaenaro]

Re: TC - What\'d i forget?

Hi Daniel,

No JDE.Log at all ? ... interesting
Could you debug the TC, insert a breakpoint in Process
Begins
If yuo don't even reach there that might indicate that the
system can't open your input (although I would expect that
to be logged in jde.log)

Hope this helps

Cheers

Philippe



One World B7333 SP16 AS400

 

[jeremey_garcia]

Re: RE: TC - What\'d i forget?

if you create a EXPORT folder on the '400 in the directory where your trying to create the file then it should appear. i.e. I want to create a auto deposit file in CRP, so I create an EXPORT folder through the IFS in the PY7333 directory.

Now comes the kicker, unless you are on SP 16.1 or higher, it will not work. There is a problem with the passing of the password through the BLOB. It was fixed in 16.1, with no SAR or ESU. (Which is stupid but that is from JDE support.) I've run into this problem because we are on SP 14.

Good luck.

Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix

 

[Zoltan_Gyimesi]

Re: RE: TC - What\'d i forget?

Hi Daniel,

To your sub-issue.


Before changes:
===============
1.) Print out the ER into a text file.
2.) Copy all Event Rules of effected events onto the ClipBoard and save them into separate .CLP files.

After changes:
==============
1.) Re-Define your formats if it is required
2.) Re-create your ER variables in the same order as they had been created originally and with the same ER names. Use your ER text output to determine the order and Copy/Paste the same ER names.
3.) Open the ER .CLP files and Paste them back to their original events.
4.) Check all pasted ER lines again.

I know, this is not a real solution but I don't know better.

On the other hand, are your foreign tables text files?
If yes then then have you considered already using Flat File Operation BSFNs in a normal UBE instead of using TC?

Not too far in the past I have used this method in my last 3 interface application with satisfaction. I have written about it about 3-4 posts/replies under different threads. If you are interested in it then you can find them in the Archives of the Forum.

Regards,

Zoltán


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)