Login
Enter your username and password to login. If you do not have a username you can register one.

Username: 
Password: 
Remember Me



Forgotten Password?

Online
1 member and 28 guests have been online with in the last 10 minutes.

Hot Topic
No posts have caught fire as of yet.

JD Edwards® Enterprise One / One World Discussions >> JD Edwards® EnterpriseOne Developers

Pages: 1 | 2 | 3 | (show all)
mramcn
member


Reged: 05/10/01
Last on: 09/26/11
Posts: 30
Re: Problem with Table Conversion
new       #86246 - 02/16/05 05:57 AM

Dear Hemanth,

I havent seen TC working on Demo.

Please try the same stuff in any live Env preferably in DV.

Thanks
Ram.M

Hemant wrote:
Hello all,
Thanks for the response, I'm very impressed.
I tried everything you have said. But it is still not working. I am beginning to think that this has something to do with the environment. But I really don't know.
I have created a user defined format, mapped all the fields, Checked the 'Issue a write for this event' checkbox, checked in the objects, etc.
But it is still not working.
Please find attached a document of one of the examples I tried; its a data conversion from a text file to a table.
Thanks for the help,
Best Regards,
Hemant
Hemant Jugernauth Accenture Mauritius Ltd Senior Programmer Peoplesoft EnterpriseOne & JD Edwards DEMO. Only 3 month experience in JDE & PSE1



Post Extras: Print Post   Remind Me!   Notify Moderator  
Zoltan_Gyimesi
member


Reged: 10/27/00
Last on: 03/21/14
Posts: 4256
Loc: Budapest, Hungary
Re: Problem with Table Conversion
new [Re: Hemant]       #86247 - 02/16/05 06:42 AM

Hi Hemant,

I had developed a TC UBE with text fil input many-many years ago, on B7321 release. The capability of TC changed much since this release.

I didn't find in your attachment, where do you define file.txt as the input. On B7321 it was a bitcomplicated:
- define an ODBC data source based on text driver, pointing to the file
- create a data source in OneWorld based on the ODBC
- create a new environment (per Path Code), where TBLE DEFAULT OCM entry points to the data source
- in TC select this environment as input

What about jde.log and logging options?
What about the value of F9860.SIOMIT?

Just an other idea?
Is it possible, that this is a UNICODE issue?
Try to open the file.txt with Notepad and Save As Unicode!

Good luck and keep us informed,

Zoltán

--------------------
- XE UPDATE 2 SP22, Intel NT4, SQL 2000
- B9 (8.93B1)
- was/is working with B7321, B7331, B7332 too


Post Extras: Print Post   Remind Me!   Notify Moderator  
peterbruce
member


Reged: 01/11/04
Last on: 04/16/14
Posts: 1812
Loc: NSW Australia
Re: Problem with Table Conversion
new [Re: Hemant]       #86282 - 02/16/05 05:37 PM

Hemant,

I have been watching this thread with interest as I, like yourself, have just started to "play" with table conversion. However I have had a few years experience with JD Edwards EnterpriseOne. I am also using an older version of the software - Xe. I assume that the TC process has not changed much between Xe and 8.0.

I also noticed that in your initial post you mention that you are using DEMO. Please confirm if you are using the Stand Alone version, as that may also be a possible cause of your problems.

Anyway here is my experience.

I had similar problems to yourself at first - no data being output. My first problem was that proof mode was checked in the Properties on the version. The version properties appear to have priority over or override the template properties as the template properties proof mode was left checked and the version properties proof mode was unchecked and the TC produced output. To change the version properties you need to have the version checked out on your fat client.

However, that was not my only problem. As Zoltán has mentioned, to get my TC to work I had to look in the log. I did not find anything useful in the jde.log, but the TC log in the PrintQueue directory was most enlightening. By default, logging is set to record all errors. You can also override the jde.ini debug settings. I ran my TC locally, and looked at the TC log in the PrintQueue directory on my fat client.

I therefore encourage you to look at the log that your TC produced, which it will, regardless of whether or not your TC produced output, and regardless of whether or not there are any errors encounted. The TC log will be in your PrintQueue directory. It's name will follow the normal UBE naming covention of UBEName_VerionName_DateStamp_TimeStamp.log. Please post your TC log.

I hope this has been helpful.

--------------------
Thanks, Peter

"Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
Create!form 7


Post Extras: Print Post   Remind Me!   Notify Moderator  
DBohner-(db)
member


Reged: 01/17/01
Last on: 04/15/14
Posts: 2562
Loc: Meridian, ID
Re: Problem with Table Conversion
new [Re: Hemant]       #86326 - 02/17/05 01:44 PM

Howdy,

Just to confirm - you do have the 'Insert' record check-box, checked - for at least one of the events? If not - then the ER will not insert any records to your output file. The Insert for the output file can be manual (within the ER) or through the use of the check-box (bottom left of the form)...

If you missed it - checking the box will create and insert event rule in that sections ER.

Also - don't forget that you need to set the output 'record' equal to 'something'...

(db)

--------------------
Daniel Bohner
Independent E1 Developer/Techno-Functional Consultant
Member - iConsortium
www.JDERESEARCH.COM
drbohner@JDEResearch.com | 208.495.4JDE
www.linkedin.com/in/drbohner
Worked on Everything


Post Extras: Print Post   Remind Me!   Notify Moderator  
Hemant
member


Reged: 02/14/05
Last on: 11/20/13
Posts: 31
Re: Problem with Table Conversion
new [Re: DBohner-(db)]       #86359 - 02/18/05 04:00 AM Attachment (186 downloads)

Hello to all of you,
Thanks for all the suggestions.
Table conversion is finally working in JDE Local. The trick was to use all capital letters password "DEMO". I used to login with blank password, then I tried the 'demo', but only the DEMO' works. For a moment I was very excited, then I tried the exact same thing on the PSE1 live system. But it never worked.
There is one thing I saw that was different though. In JDE Local, right after submitting for execution of the applications in BV, TC pops up and the conversion is carried out properly. But in PSE1, I did not see that, TC never appeared. I tried with some listing reports, and there TC is executed.
I have also found out that no log was created in the PrintQueue dir. in the PSE1 live system for these Table conversions.
So I checked out the JDE.ini, I saw that the 'Load Library' is equal to blank. I looked for the odbc driver, and found one for jde, named 'JDEOWODA.DLL'. I put it in the JDE.ini, and tried again, but in vain.
So I am now struggling with the PSE1 live system.
Thanks to all of you guys.
Best Regards,
Hemant

--------------------
Hemant


Post Extras: Print Post   Remind Me!   Notify Moderator  
Hemant
member


Reged: 02/14/05
Last on: 11/20/13
Posts: 31
Re: Problem with Table Conversion
new [Re: Hemant]       #86363 - 02/18/05 06:50 AM Attachment (308 downloads)

Hello again,
Please find attached my JDE.ini on the live system. The 'Load Library' is blank. Backend in Oracle.
Thanks,
Hemant

--------------------
Hemant


Post Extras: Print Post   Remind Me!   Notify Moderator  
Hemant
member


Reged: 02/14/05
Last on: 11/20/13
Posts: 31
Re: Problem with Table Conversion
new [Re: Zoltan_Gyimesi]       #86432 - 02/21/05 04:24 AM Attachment (507 downloads)

Hello Zoltan_Gyimesi,
I have looked for the F9860.SIOMIT value, and it is zero.
Actually, I was trying to make a Data conversion from F0101 to F590101(a custom table).
In the jdedebug.log, I have not found any Select from F0101, and no insert into F590101. I guess that there must be a problem with my PSE1 8.0 live system.
Thanks for the help.

--------------------
Hemant


Post Extras: Print Post   Remind Me!   Notify Moderator  
Its not on sale
member


Reged: 07/31/01
Last on: 10/04/12
Posts: 254
Re: Problem with Table Conversion
new [Re: Hemant]       #86467 - 02/22/05 08:57 AM

Hemant,

Many have asked you that after you run your TC you get the JDE.LOG and paste it here. Why cant you do that.

I believe JDE.LOG will tell all the tales. Please post your jde log here.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Bally_BK
member


Reged: 09/20/04
Last on: 07/31/13
Posts: 111
Re: Problem with Table Conversion
new [Re: mramcn]       #86516 - 02/23/05 02:25 AM

Hi

TC will run on DEMO and u have to give login password 'DEMO" then run ur TC it will upload all data's into respective tables.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Hemant
member


Reged: 02/14/05
Last on: 11/20/13
Posts: 31
Re: Problem with Table Conversion
new [Re: Its not on sale]       #86519 - 02/23/05 04:43 AM Attachment (141 downloads)

Hello,
Please find attached a copy of my jde.log.
Regards,
Hemant

--------------------
Hemant


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1 | 2 | 3 | (show all)


Extra information
0 registered and 11 anonymous users are browsing this forum.

Moderator:  Sef, ekempter, Christian Audet, jdecnc 

Print Thread

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating: ****
Thread views: 9100

Rate this thread

Jump to

JDELIST Support | Privacy statement JDELIST.com

*
UBB.threads™ 6.4.1

 .: IIP 5.4.5 by David Lozier ©2003 :. 
Distributed by ThreadsDev.com

The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither
endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.

This page best viewed with Netscape 4 or Microsoft Explorer 4 or above in 800 x 600 resolution.