Table Conversion fails

Adrian_Chimirel

Legendary Poster
Help,
I am trying to populate the Invoicing Batch/Z files with a TC; the input tables reside on a local Access Database.
When I run, locally, the Table Convertor, I get some nasty errors such as:
<<316/264 Mon Nov 27 14:29:04 2000 ODBC_U1720
ODB0000171 - SQLNumResultsCols failed in Table F98613
Column OMUGRP
Database F03B11Z1_In
316/264 Mon Nov 27 14:29:04 2000 ODBC_U1723
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'F98613'. Make sure it exists and that its name is spelled correctly. - SQLSTATE: S0002>>
The 'good point' is the last section saying ... conversion done SUSCCESSFULLY:
<<316/264 Mon Nov 27 14:29:10 2000 tcrun592
Conversion R5503BPXG1 ADC0001 done successfully. Elapsed time - 1.626000 Seconds.
316/264 Mon Nov 27 14:29:10 2000 tcrun600
Fetched 48 rows from F5503B11Z1_in
316/264 Mon Nov 27 14:29:10 2000 tcrun608
Inserted 0 rows, failed to insert 0 rows into F03B11Z1>>
Am I missing something? Thank you.

B732.1 SP12.2, Oracle 805 on RS/6000, Citrix, Win95&NT
 

Zoltan_Gyimesi

Legendary Poster
Hi Adrian,
Is your input table a "foreign" table or is it defined and created with OW?

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

Zoltan_Gyimesi

Legendary Poster
Hi again,
How do you access F03B11Z1 in your TC? Do you access it as a Table or via an original OW Business View or via a custom Business View?

Do you run your TC on a fat or on a thin client? I amn't experienced with CITRIX and thin clients but I suppose, it could cause problems.

What do you mean "local Access Databse"? is the original Local data source of OneWorld or is it created with Access?

What does it mean "run locally" if you use thin client?

Zoltán

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

Zoltan_Gyimesi

Legendary Poster
Hi Again,
Excuse me that I split my questions and coins into more posts but I hit always some newer after I hav sent the previous. Let'see.

Do you generate the unique key fields for F03b11Z1 (User ID, Batch Number, Transaction Number, Line Number)?
If you do so then is it come from your input table or do you generate in the ER of TC?

How do you issue a write for F03B11Z1? Is it on the appropriate Event (e.g. Row Fetched vs Format Fetched)?

Do you have "Advanced ER" in your TC? Is it on the appropriate Event (e.g. Row Fetched vs Format Fetched)? It could depend on how your input table defined.

Have you setup any security on F03B11Z1?

Do you issue any Table I/O on F98613?
I do not know the roll of the mentioned table but it seems to me that it have to be accessible for your TC. Do you have an explicit and active map in the OCM for this table in the running environment (and for the user)?

Anyway, what is your input and output environments? Are they one of the standard OW environments or a custom one for this task?

(... unfortunately, I can not access any B732 installation currently9

Please, answer my questions and let me/us know when you could resolve the problem (...and the solution too).
Godd luck,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Discover how to build no-code data integrations and business process automations.

Adrian_Chimirel

Legendary Poster
Hi Zoltán,
These are my answers to your most important questions:
0-I am running OW Dev on a standard Development workstation, not on Citrix!
1-I tried generating key fields in both manners; at my input table level and at the ER-Row Fetched Table Conversion level. The same result ocurred.
2-The only used ER is the Row Fetched
3-F03B11Z1 is not secured.
4-I don't ... touch any of the F98613, F0092 or F00950 tables. There are active OCMs for them, but not in the input environment
5-which is a custom one, of course - the input tables are foreign - Access, and they reside on a local Access Database, on my Development workstation
6-the output environment is a standard DEVB732
I'm ready to go, anytime between 10:00AM to 10:00PM EST, today.
Thanks,
Oh I almost forgot; I am running the TC locally.
B732.1 SP12.2, Oracle 805 on RS/6000, Citrix, Win95&NT
 

Zoltan_Gyimesi

Legendary Poster
Hi Adrian,

I suppose:
* Your running and output environment is the same, the standard OW DEVB732
* Your input environment is a custom one, created for your task
Am I right?

I suppose:
* You have cretaed your OneWorld Data Source pointing to your local access
* You have an active map DEFAULT for TBLE pointing to your local data source (mentioned previously) in your input environment
* The Path Code of your input environment is the same as your running and output environment, namely DEVB732
Am I right?

Please, confirm or correct my suppositions.
Now, let's see some (maybe silly) tip:

1.) If the only OCM entry is the DEFAULT for TBLE (or there is very few entry) in your input environment then try to copy your running environment into your input environment EXCEPT DEFAULT for TABLE, restart OW and try again.

2.) Have you ever tried to put your logic onto the Format Fetched event instead of Row fetched? I know, it sounds silly but maybe could work, you can never know. Try it.

3.) If you access F03B11Z1 through a Business View in your TC then try to change it to access as table.

Could any of them make sense for you?

Unfortunately, I can not access any B7321 system currently, further I haven't worked with TCs under B7321 since a long time but I remember something that we had also problem with TC under B7321 which was resolved with a higher version of ODBC driver.

I am waiting for your answer which will hopefully be a resolution.
Good luck,
Zoltán


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

Adrian_Chimirel

Legendary Poster
Your assumptions are 100% correct:
1-The running environment is the output one, which is DEVB732
2-The input environment is a custom one "PTMSINVGEN"
3-I did create both Data Sources:
a-the Foreign, ODBC Data Source "PTMS_In" using driver MS Access 4.00.4202.00 ODBCJT32.dll 06/04/99) and
b-the OneWorld Data Source "PTMS" pointing to my ODBC Data Source
4-The Pathcode for my input environment is the same as my running and output, namely DEVB732
5?-How can I copy my running environment into my input environment?
6-I'll try it
7-I am accessing F03B11Z1 directly - not through a BSVW
Thank you for your patience.

B732.1 SP12.2, Oracle 805 on RS/6000, Citrix, Win95&NT
 

Zoltan_Gyimesi

Legendary Poster
Hi Adrian,
You can copy environment with P0094 Environment Master appl in Menu GH9053 (It is under B7331). You have to have a "Copy Environment" selection in the Row menu on the Work With Environment Form.

My recommendation is:
1.) Copy your original input env to an other for backup.
2.) Delete all OCM entry for your input env.
3.) Delete your input env.
4.) Copy your running env to the same name as your original input env
5.) Revise all settings (including OCM) in the copied environment.
6.) :) restart OW.

Let me know if you tried something, does it work or doesn't.
Good luck,
Zoltán

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

Adrian_Chimirel

Legendary Poster
Zoltán,
I copied the running env into the input one, I replaced the DEFAULT business Data-Dev with the local one and ran it again; first I got the date not implemented error, I replaced it with the system function date_today() but TC fails with this log:
"252/267 Tue Nov 28 12:30:15 2000 JTP_TM2362
JDB9909162 - Failed to find primary index to use for timestamp registry
252/267 Tue Nov 28 12:30:15 2000 tcrun592
Conversion R5503BPXG1 ADC0001 done successfully. Elapsed time - 0.884000 Seconds.
252/267 Tue Nov 28 12:30:15 2000 tcrun600
Fetched 48 rows from F5503B11Z1_in
252/267 Tue Nov 28 12:30:15 2000 tcrun608
Inserted 0 rows, failed to insert 0 rows into F03B11Z1"
Do you know what the jtp_tm2362/jdb9909162 means? Whose primary index was not found?

B732.1 SP12.2, Oracle 805 on RS/6000, Citrix, Win95&NT
 

Zoltan_Gyimesi

Legendary Poster
Hi again :)
1.) "JDB9909162 - Failed to find primary index to use for timestamp registry" sounds like a transaction processing setup issue (see "timestamp").
Have you setup any transaction processing in your system?
If it really this type of issue then you have to revise all transaction related setting in the jde.ini on the workstation and on the server (and who knows where elsewhere?). Sorry, I can not help in this issue, mainly under B7321.

2.) An other silly idea. Isn't too long the name "F5503B11Z1_in" for your input table? The restriction for OW table names is 8 character. Is it possible that OW do not handle this extra long foreign table name corretly everywhere? Maybe you can try to use at longest 8 char name with uppercase only. Hey, Oracle is case sensitive, so I don't think that a good idea using lowercase letters in the name.

Have you tried the Format fetched?
Good luck,
Zoltán


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

Adrian_Chimirel

Legendary Poster
I am really dumb! Do you know what was happening? The "Issue a write for this event?" checkbox was ... UNchecked! It was THAT simple! Oh boy! Sorry Zoltán, I really made you lose a LOT of time.
Multiple regards! Keep your hard work going! Yo da man.



B732.1 SP12.2, Oracle 805 on RS/6000, Citrix, Win95&NT
 

Zoltan_Gyimesi

Legendary Poster
Hi Adrian,
Never mind and do not be ashmed of it
I am developer long time ago. I know very well that generally most harder to find the most obvious and most smaller mistakes and bugs. You can believe me, I have some similar event in my mind.
The final result is always the most important: The issue is resolved!
On the other hand, we have made a good overview on the potencial traps of TC that hopefully could be useful for somebody.
In any case, it could be very instructive for everybody of us.
My last question:
Could I help you to find (occasionaly?) this pretty bug forcing to try Format fetch?
Best regards,
Zoltán

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

Adrian_Chimirel

Legendary Poster
Unortunately, I tried the Format Event but all the input table fields disappeared! I went back to Row Fetch and I checked the "Issue a write ..." checkbox (don't ask me why); I ran the TC and I went directly to jde.log and I saw "... inserted 48 rows ...". It's good to have so many places to clik on, isn't it?
Thank you again for your moral support! See you soon with another ... cartoon ...

B732.1 SP12.2, Oracle 805 on RS/6000, Citrix, Win95&NT
 
Top