Table Conversion Disappears

[jfoster02]

Hello all, I am running a table conversion program and as soon as I run the program it disappears. Im using a foreign Access table as my input and writing to the Z-files. This program did work at one point. Sometimes I can get it to break in the debugger in the initializations section and most of the times I cant. It never makes it to the DO section. The ODBC settings appear to be correct. The errors I get are as follows:

9184/7540 Fri Aug 04 17:33:44 2006 JDBODBC.C2148
ODB0000183 - SQLExecute failed

9184/7540 Fri Aug 04 17:33:44 2006 JDBODBC.C2148
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. - SQLSTATE: 07001

9184/7540 Fri Aug 04 17:33:44 2006 jdb_drvm.c938
JDB9900401 - Failed to execute db request

9184/7540 Fri Aug 04 17:33:44 2006 tcrun.c203
TCE009140 - JDB_SelectKeyed failed.

9184/7540 Fri Aug 04 17:33:45 2006 ODBC_U1.C930
ODB0000171 - SQLNumResultsCols failed in Table F9200
Column FRDTAI
Database Item Conversion Data

9184/7540 Fri Aug 04 17:33:45 2006 ODBC_U1.C933
SQLNumResultsCols failed, See Log

9184/7540 Fri Aug 04 17:33:45 2006 ODBC_U1.C934
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'F9200'. Make sure it exists and that its name is spelled correctly. - SQLSTATE: S0002

9184/7540 Fri Aug 04 17:33:45 2006 JDBODBC.C1515
ODB0000055 - Describe table failed for table F9200.

9184/7540 Fri Aug 04 17:33:45 2006 jdb_drvm.c839
JDB9900168 - Failed to initialize db request

9184/7540 Fri Aug 04 17:33:45 2006 JTP_CM.C1090
JDB9909007 - Unable to obtain driver request handle

9184/7540 Fri Aug 04 17:33:45 2006 jdeddapi.c1608
DDT0000015 - UpdateTamDD unsuccessful for item EXR1

9184/7540 Fri Aug 04 17:33:45 2006 jdb_rsd.c98
JDB9900290 - Failed to read a valid dictionary struct

9184/7540 Fri Aug 04 17:33:45 2006 jdb_rsd.c512
JDB9900293 - Failed to read specifications

9184/7540 Fri Aug 04 17:33:45 2006 ODBC_U1.C930
ODB0000171 - SQLNumResultsCols failed in Table F9200
Column FRDTAI
Database Item Conversion Data

9184/7540 Fri Aug 04 17:33:45 2006 ODBC_U1.C933
SQLNumResultsCols failed, See Log

9184/7540 Fri Aug 04 17:33:45 2006 ODBC_U1.C934
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'F9200'. Make sure it exists and that its name is spelled correctly. - SQLSTATE: S0002

9184/7540 Fri Aug 04 17:33:45 2006 JDBODBC.C1515
ODB0000055 - Describe table failed for table F9200.

9184/7540 Fri Aug 04 17:33:45 2006 jdb_drvm.c839
JDB9900168 - Failed to initialize db request

9184/7540 Fri Aug 04 17:33:45 2006 JTP_CM.C1090
JDB9909007 - Unable to obtain driver request handle

9184/7540 Fri Aug 04 17:33:45 2006 jdeddapi.c1608
DDT0000015 - UpdateTamDD unsuccessful for item EXR1

9184/7540 Fri Aug 04 17:33:45 2006 ODBC_U1.C930
ODB0000171 - SQLNumResultsCols failed in Table F9200
Column FRDTAI
Database Item Conversion Data

9184/7540 Fri Aug 04 17:33:45 2006 ODBC_U1.C933
SQLNumResultsCols failed, See Log

9184/7540 Fri Aug 04 17:33:45 2006 ODBC_U1.C934
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'F9200'. Make sure it exists and that its name is spelled correctly. - SQLSTATE: S0002

9184/7540 Fri Aug 04 17:33:45 2006 JDBODBC.C1515
ODB0000055 - Describe table failed for table F9200.

9184/7540 Fri Aug 04 17:33:45 2006 jdb_drvm.c839
JDB9900168 - Failed to initialize db request

9184/7540 Fri Aug 04 17:33:45 2006 JTP_CM.C1090
JDB9909007 - Unable to obtain driver request handle

9184/7540 Fri Aug 04 17:33:45 2006 jdeddapi.c1608
DDT0000015 - UpdateTamDD unsuccessful for item TXA1

9184/7540 Fri Aug 04 17:33:45 2006 jdb_rsd.c98
JDB9900290 - Failed to read a valid dictionary struct

9184/7540 Fri Aug 04 17:33:45 2006 jdb_rsd.c512
JDB9900293 - Failed to read specifications

9184/7540 Fri Aug 04 17:33:45 2006 ODBC_U1.C930
ODB0000171 - SQLNumResultsCols failed in Table F9200
Column FRDTAI
Database Item Conversion Data

Any help would be greatly appreciated.

 

[Suj]

Hi,

As per the errors i understood that there is some probelm with the foreign table. Have you mapped the foreign table correctly to the Data Source?

Thanks,
Anjali

 

[jfoster02]

Anjali,
I ended up recreating the Access database table and the table conversion UBE and got it to run. The foreign table muct have been changed by someone. Thanks for your response.