Table name not found in Server jdedebug.log

[bsush]

Hi All

I am working on a issue in the P43060 app in E1 9.1. In local web (of FAT client) it is working correctly and the quantity is getting reduced (in Form A the entry point) after clicking on the "Generate Order" Form exit. The purchase order is also getting created in F4301 and F4311. However when I run P43060 on the server in DV910 the quantity is not getting reduced in Form A but the PO is getting created in F4301 and F4311. The server jdedebug.log shows the below:

**********************************************************************************
Jul 18 04:13:02.531000 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering jdeCloseDictionary
Jul 18 04:13:02.531001 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exited jdeCloseDictionary with DDType 0
Jul 18 04:13:02.531002 - 5236/3656 WRK:E191643_0950B1B8_P43060 Return value is 0 for UpdateF41021PrimaryLocationQty. BSFNLevel = 3)
Jul 18 04:13:02.531003 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering AddObjectCache
Jul 18 04:13:02.531004 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_OpenTable(Table = )
Jul 18 04:13:02.531005 - 5236/3656 WRK:E191643_0950B1B8_P43060 JDB9900307 - Failed to find table specifications
Jul 18 04:13:02.532000 - 5236/3656 WRK:E191643_0950B1B8_P43060 JDB3100007 - Failed to get valid table specifications
Jul 18 04:13:02.533000 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_OpenTable(Table = ) with Failure
Jul 18 04:13:02.533001 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_GetEnv
Jul 18 04:13:02.533002 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_GetEnv with Success
Jul 18 04:13:02.533003 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_InitUser with (AUTO commit mode)
Jul 18 04:13:02.533004 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_BeginTransaction (UserHandle 0699FDC8)
Jul 18 04:13:02.533005 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_BeginTransaction with Success (UserHandle 0699FDC8)
Jul 18 04:13:02.533006 - 5236/3656 WRK:E191643_0950B1B8_P43060 Incremented huser count to 5
Jul 18 04:13:02.533007 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_InitUser with Success (UserHandle 0699FDC8)
Jul 18 04:13:02.533008 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering jdeCloseDictionary
Jul 18 04:13:02.533009 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_FreeUser (UserHandle 0699FDC8)
Jul 18 04:13:02.533010 - 5236/3656 WRK:E191643_0950B1B8_P43060 Decremented huser count to 4
Jul 18 04:13:02.533011 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_FreeUser with Success(UserHandle 0699FDC8)
Jul 18 04:13:02.533012 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exited jdeCloseDictionary with DDType 0
Jul 18 04:13:02.533013 - 5236/3656 WRK:E191643_0950B1B8_P43060 ERROR INFO JDEERR - ID= 0, Error= 3143 - b4300360.c, Line= 431
Jul 18 04:13:02.534000 - 5236/3656 WRK:E191643_0950B1B8_P43060 Entering JDB_FreeBhvr (UserHandle 0699B090)
Jul 18 04:13:02.534001 - 5236/3656 WRK:E191643_0950B1B8_P43060 Exiting JDB_FreeBhvr with Success(UserHandle 0699B090)
Jul 18 04:13:02.534002 - 5236/3656 WRK:E191643_0950B1B8_P43060

**********************************************************************************

In the above log patch the table for which the specs are not found is not appearing in the log.

Please help me figure out how to identify the missing table.

Thanks a Lot in advance.

 

[johndanter]

That must be a custom object somewhere in the flow that you don't have the specs for on your machine.
Maybe someone has modified the code to use such an object

Does it work on the thin client server?

 

[bsush]

Hi John

No it doesn't work on JDV local either.

Thanks
Sushant

 

[jdelisths]

Based on this log, the error is coming from business function B4300360. I looked at the code and the table that it it trying to update is F4311. Try deleting the global table specs on the server (for DV).

 

[bsush]

Hi Hari

Thanks for your reply. You are right and the error is coming from BSFN B4300360 (Update Purchase Blanket Order) where there is code for Open Table F4311 thru the API. However at the same time insert in F4311 is working as the PO number is shown after Generating the order.

So I am confused as how the insert in to F4311 is working but not the update.

 

[bsush]

Hi Hari

Thanks for your reply. You are right and the error is coming from BSFN B4300360 (Update Purchase Blanket Order) where there is code for Open Table F4311 thru the API. However at the same time insert in F4311 is working as the PO number is shown after Generating the order.

So I am confused as how the insert in to F4311 is working but not the update.

 

[jdelisths]

Take a look at the index ID that is referenced in the JDB_OpenTable API. Open F4311.h and look at the fields in the index. Verify that the index is in the F4311 table specifications (using table design aid) and the physical table on the database server.

You can run R9698711 with F4311 in the data selection to see if there are any differences between the E1 specs and the physical table.

If there are any discrepancies (of even there are no discrepancies), build/deploy an update package for F4311. That might just fix it.