Custom table generation error

[rnelson4]

I am trying to generate a custom table and get the following error:

3020/1576 Mon Jan 29 09:45:45.544 Jdb_rst.c2344
JDB9900318 - Failed to find table information in TAM using RDB

3020/1576 Mon Jan 29 09:45:45.544 Jdb_rst.c341
JDB9900913 - Failed to create global table specs for F9500001

3020/1576 Mon Jan 29 09:45:45.554 Jdb_rst.c1129
JDB9900307 - Failed to find table specifications

3020/1576 Mon Jan 29 09:45:45.554 Jdb_rq1.c1563
JDB3100007 - Failed to get valid table specifications

3020/1576 Mon Jan 29 09:45:45.554 Jdb_rst.c2344
JDB9900318 - Failed to find table information in TAM using RDB

3020/1576 Mon Jan 29 09:45:45.564 Jdb_rst.c341
JDB9900913 - Failed to create global table specs for F9500001

3020/1576 Mon Jan 29 09:45:45.564 Jdb_rst.c1129
JDB9900307 - Failed to find table specifications

3020/1576 Mon Jan 29 09:45:45.564 Jdb_rq1.c1563
JDB3100007 - Failed to get valid table specifications

3020/1576 Mon Jan 29 09:45:45.575 Odbc_p3.c852
ODB0000137 - SQLExecDirect failed. Table F55ARI3.

3020/1576 Mon Jan 29 09:45:45.585 Jdbodbc.c4566
ODB0000049 - Unable to get table spec. numbers.

3020/1576 Mon Jan 29 09:45:45.585 Jdb_drvm.c1402
JDB9900184 - Failed to get table specs from db

3020/1576 Mon Jan 29 09:45:45.585 Jdb_rq1.c7517
JDB9900275 - Failed to get foreign table specs

3020/1576 Mon Jan 29 09:45:45.595 Jdb_rq1.c7181
JDB3100050 - Failed to load table information

1756/3460 Mon Jan 29 09:45:51.953 dbsql_a.c1569
SQL0000003 - Create table failed

1756/3460 Mon Jan 29 09:45:51.953 Odbc_p3.c529
ODB0000080 - BuildString failed.

1756/3460 Mon Jan 29 09:45:51.953 Jdbodbc.c2883
ODB0000033 - JDBODBC_DBA failed.

1756/3460 Mon Jan 29 09:45:51.964 Jdb_drvm.c882
JDB9900168 - Failed to initialize db request

1756/3460 Mon Jan 29 09:45:51.964 Jtp_cm.c1013
JDB9909007 - Unable to obtain driver request handle

1756/3460 Mon Jan 29 09:45:51.964 Jdb_exem.c418
JDB21000091 - Failed to create table F55ARI3 in data source Business Data - DV

We are currently on version 8.9.4

Any ideas would be greatly appreciated.

Thanks,
Ronnie

 

[smss]

Are you trying to generate the table from the same machine where the specs
were created? If not you may want to do a get before doing the generation.

Madhu.




--
Thanks,
Madhu

 

[DSauve]

Even if you're on the machine on which you created the table, I've found that I have better luck if I check in the table, and then check it back out (same goes for business views).

 

[rnelson4]

Yes, i am on the same machine.

 

[rnelson4]

I checked it in and back out and still get the following errors:

1756/3460 Mon Jan 29 14:45:18.995 dbsql_a.c1569
SQL0000003 - Create table failed

1756/3460 Mon Jan 29 14:45:18.995 Odbc_p3.c529
ODB0000080 - BuildString failed.

1756/3460 Mon Jan 29 14:45:19.005 Jdbodbc.c2883
ODB0000033 - JDBODBC_DBA failed.

1756/3460 Mon Jan 29 14:45:19.005 Jdb_drvm.c882
JDB9900168 - Failed to initialize db request

1756/3460 Mon Jan 29 14:45:19.005 Jtp_cm.c1013
JDB9909007 - Unable to obtain driver request handle

1756/3460 Mon Jan 29 14:45:19.015 Jdb_exem.c418
JDB21000091 - Failed to create table F55ARI3 in data source Business Data - DV

 

[smss]

It appears that necessary data sources are not installed or incorrect on
your machine. Can you test the data sources to see if you could connect to
the database?



--
Thanks,
Madhu

 

[max_xx]

Hi,

It seems to be that the table has a new DD item with type c which is world's standard.Change this type to 1 and the table will generate successfully.


Regards,
Irfan

 

[alphaq]

As seen from the discusson and the errors i think u need to check the database connectivity and do the same .

Thanks

 

[rnelson4]

Thanks for all the help. I had the DD as a type "S" and changed it to "2" and everythign worked fine.