• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

UTB Error

mohammedibrahim

Active Member
Hi list,

We have installed E1 8.10 on SQL 2000 :confused: sp3 on our Intel server sp4, things are fine but when I go to UTB and try to look for any table in the system (F0101) except system tables (F98OWSEC) I get this:

2384/596 Wed Oct 13 09:39:52.346 JDBODBC.C5187
ODB0000163 - wSQLFetch failure. rc=-1

2384/596 Wed Oct 13 09:39:52.346 JDBODBC.C5187
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state

2384/596 Wed Oct 13 09:39:52.346 jdb_drvm.c1537
JDB9900189 - Failed to verify that table exists in Business Data - PROD

2384/2480 Wed Oct 13 09:40:04.163 JDBODBC.C5187
ODB0000163 - wSQLFetch failure. rc=-1

2384/2480 Wed Oct 13 09:40:04.163 JDBODBC.C5187
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state

2384/2480 Wed Oct 13 09:40:04.163 jdb_drvm.c1537
JDB9900189 - Failed to verify that table exists in Business Data - PROD

2384/2480 Wed Oct 13 09:40:04.173 B9861110.c131
F0101 not found in Business Data - PROD.
Plus when I check out any report and design mode it’s blank
Please any idea
Thank you
 

bmarxhau

Active Member
Run instcat.sql on your SQL Server to install some stored procedures
that are called by PSFT middleware to lookup catalog information.

Just be sure to run the one in the SQL Server 'home' (x:\Program
Files\SQL Server\...) not the one in Windows 'home' (x:\Windows\...)



Brent Marxhausen
DBT, Inc.
Independent CNC
EMail: bmarxhausen@dynbt.com
 

mohammedibrahim

Active Member
We have fix the problem by removing the ( _ ) from the Database EX. JDE_PD7333 old XE naming it must be JDEPD7333 this will do.

Good luck
 
Top