DaRogue69
Member
Getting \"SQLExtendedFetch failed\" errors when running UBE over a custom view/table
All,
I'm trying to troubleshoot an error we receive while running a custom UBE that selects data from a custom view/table that resides in another database.
Here's what we setup:
1) Create a JDE Table that consists of new/custom DDict items, mostly numeric fields and some text (created as VarStrings).
2) Generated the Custom Table and Indexes.
3) Going into SQL Server Management Studio, we delete the table created from step 2.
4) We create a new SQL View that maps data from another SQL database into the custom JDE table. Fields are mapped individually. The name of the new View is F58TAPB2.
5) If you run a query against the custom table, F58TAP2, all rows are returned - approx. 275 - and appear to be populated correctly.
6) Created a JDE BSVW (V58TAPB2) to reside over the custom F58TAPB2 table.
7) Created a Custom UBE that pulls all records from the V58TAPB2.
8) JDE report runs and pulls data, but only the first 100 or so records are getting pulled.
9) Looking in the JDE.LOG file, I see the following errors:
3868/2408 MAIN_THREAD Tue May 18 15:33:38.350000 Jdb_ctl.c3946
Starting OneWorld
3868/1140 WRK:Starting jdeCallObject Tue May 18 15:34:02.284000 Jdekprnt.c1088
KNT0000119 - PRTTable_GetDefaultPrinterInfo failed to find printer: User: DAROGUE69 Host: WinClient
3868/696 UNKNOWN Tue May 18 15:34:04.302000 Jdekprnt.c1088
KNT0000119 - PRTTable_GetDefaultPrinterInfo failed to find printer: User: DAROGUE69 Host: WinClient
3868/696 UNKNOWN Tue May 18 15:34:05.151000 Odbc_p1.c1679
ODB0000092 - SQLExtendedFetch failed. Table(1st) F58TAPB2, ODBC DSN HILE1DB01.
3868/696 UNKNOWN Tue May 18 15:34:05.151001 Jdb_drvm.c1176
JDB9900172 - Failed to execute db fetch
3868/696 UNKNOWN Tue May 18 15:34:05.421000 jdepref.c208
GetRecipientPreferences :No email address found for contact, assuming workcenter email an8<167839> idln<0>
3868/696 UNKNOWN Tue May 18 15:34:05.421001 jdepref.c208
GetRecipientPreferences :No email address found for contact, assuming workcenter email an8<167839> idln<0>
We're running E1 8.12/Tools 8.98.2.4 over SQL Server 2005.
We couldn't find anything specific on the Oracle Support website except a reference that if you used STRING datatypes instead of VARSTRINGS - this could happen. We actually wrote everything first as STRINGS, then created a second table using VARSTRINGS, but the results are identical.
Does anyone have any ideas on what we could try next? Any help or suggestions would be greatly appreciated!
All,
I'm trying to troubleshoot an error we receive while running a custom UBE that selects data from a custom view/table that resides in another database.
Here's what we setup:
1) Create a JDE Table that consists of new/custom DDict items, mostly numeric fields and some text (created as VarStrings).
2) Generated the Custom Table and Indexes.
3) Going into SQL Server Management Studio, we delete the table created from step 2.
4) We create a new SQL View that maps data from another SQL database into the custom JDE table. Fields are mapped individually. The name of the new View is F58TAPB2.
5) If you run a query against the custom table, F58TAP2, all rows are returned - approx. 275 - and appear to be populated correctly.
6) Created a JDE BSVW (V58TAPB2) to reside over the custom F58TAPB2 table.
7) Created a Custom UBE that pulls all records from the V58TAPB2.
8) JDE report runs and pulls data, but only the first 100 or so records are getting pulled.
9) Looking in the JDE.LOG file, I see the following errors:
3868/2408 MAIN_THREAD Tue May 18 15:33:38.350000 Jdb_ctl.c3946
Starting OneWorld
3868/1140 WRK:Starting jdeCallObject Tue May 18 15:34:02.284000 Jdekprnt.c1088
KNT0000119 - PRTTable_GetDefaultPrinterInfo failed to find printer: User: DAROGUE69 Host: WinClient
3868/696 UNKNOWN Tue May 18 15:34:04.302000 Jdekprnt.c1088
KNT0000119 - PRTTable_GetDefaultPrinterInfo failed to find printer: User: DAROGUE69 Host: WinClient
3868/696 UNKNOWN Tue May 18 15:34:05.151000 Odbc_p1.c1679
ODB0000092 - SQLExtendedFetch failed. Table(1st) F58TAPB2, ODBC DSN HILE1DB01.
3868/696 UNKNOWN Tue May 18 15:34:05.151001 Jdb_drvm.c1176
JDB9900172 - Failed to execute db fetch
3868/696 UNKNOWN Tue May 18 15:34:05.421000 jdepref.c208
GetRecipientPreferences :No email address found for contact, assuming workcenter email an8<167839> idln<0>
3868/696 UNKNOWN Tue May 18 15:34:05.421001 jdepref.c208
GetRecipientPreferences :No email address found for contact, assuming workcenter email an8<167839> idln<0>
We're running E1 8.12/Tools 8.98.2.4 over SQL Server 2005.
We couldn't find anything specific on the Oracle Support website except a reference that if you used STRING datatypes instead of VARSTRINGS - this could happen. We actually wrote everything first as STRINGS, then created a second table using VARSTRINGS, but the results are identical.
Does anyone have any ideas on what we could try next? Any help or suggestions would be greatly appreciated!