ESU issue after migration from Oracle to SQL

[Jaise James]

Hello,

I recently moved my client from Oracle to SQL . They are XE Sp23.
All the prodution database works fine and user is live and working fine with out any issues.

I have changes the OCM/Datasources both PLanner, system as well server maps.

However, when I am trying to apply a 1099 ESU, it goes to the screen where I can select the ESu and When I click next to go to the screen where I get to select the enironment, it hangs. It never comes up.

In the debug log, it tells me that it trying to use Oracl DB connection for F00941. It uses SQL to opent eh table first and then second time it uss ORacle to open the table. I have checked the OCm, I couldn't find any reason for this behaviour

Oracle says that the problem is happening since I am using terminal server. However,I have applied many ESU over the years using terminal server with console option.

Does any one have any idea why would tis be happening


Here is the part of the log

SELECT LMLL, LMRLS FROM F00941 WHERE ( LMLL = 'JDEPLAN' )
Jan 07 12:57:08 ** 3960/3988 Entering JDB_CloseTable(Table = F00941)
Jan 07 12:57:08 ** 3960/3988 Entering JDB_ClearSequencing
Jan 07 12:57:08 ** 3960/3988 Entering JDB_ClearSelection
Jan 07 12:57:08 ** 3960/3988 Entering JDB_ClearBuffers
Jan 07 12:57:08 ** 3960/3988 Exiting JDB_ClearBuffers with success.
Jan 07 12:57:08 ** 3960/3988 Exiting JDB_CloseTable(Table = F00941) with Success
Jan 07 12:57:08 ** 3960/3988 Entering JDB_FreeUser
Jan 07 12:57:08 ** 3960/3988 Entering JDB_AuditingOn
Jan 07 12:57:08 ** 3960/3988 Exiting JDB_AuditingOn with success
Jan 07 12:57:08 ** 3960/3988 Calling Business function GetCurrentEnvironment for JDE. Application Name [P9670], Version [ZJDE0001] (BSFNLevel = 2)
Jan 07 12:57:08 ** 3960/3988 **********************************************************************************
Jan 07 12:57:08 ** 3960/3988 *** Start dumping data structure for business function GetCurrentEnvironment
Jan 07 12:57:08 ** 3960/3988 **********************************************************************************
Jan 07 12:57:08 ** 3960/3988 IN->[ 1] <Item>: szEnvironmentname <type>: STRING <Value>: [xÁ]
Jan 07 12:57:08 ** 3960/3988 **********************************************************************************
Jan 07 12:57:08 ** 3960/3988 *** End dumping data structure for business function GetCurrentEnvironment
Jan 07 12:57:08 ** 3960/3988 **********************************************************************************
Jan 07 12:57:08 ** 3960/3988 **********************************************************************************
Jan 07 12:57:08 ** 3960/3988 *** Start dumping data structure for business function GetCurrentEnvironment
Jan 07 12:57:08 ** 3960/3988 **********************************************************************************
Jan 07 12:57:08 ** 3960/3988 OUT->[ 1] <Item>: szEnvironmentname <type>: STRING <Value>: [JDEPLAN]
Jan 07 12:57:08 ** 3960/3988 **********************************************************************************
Jan 07 12:57:08 ** 3960/3988 *** End dumping data structure for business function GetCurrentEnvironment
Jan 07 12:57:08 ** 3960/3988 **********************************************************************************
Jan 07 12:57:08 ** 3960/3988 Return value is 0 for GetCurrentEnvironment. (BSFNLevel = 2)
Jan 07 12:57:08 ** 3960/3988 Entering JDB_FetchKeyed
Jan 07 12:57:08 ** 3960/3988 ODBC:A DBInitRequest(new) conn=03941590 hd=0EC1A7D8 dr=0EC19A40 A (JDE@OneWorld Planner - B7333)
Jan 07 12:57:08 ** 3960/3988 SELECT * FROM F00945 WHERE ( RMRLS = 'B7333' )
Jan 07 12:57:08 ** 3960/3988 Entering JDB_OpenTable( Table = F00941)
Jan 07 12:57:08 ** 3960/3988 Database driver name is 'JDBOCI90.DLL'
Jan 07 12:57:08 ** 3960/3988 ORACLE DBInitDrv envr=0EC20C98
Jan 07 12:57:09 ** 3960/3988 ORACLE DBInitCon envr=0EC20C98 conn=0EC54230 PDB01 A (JDE@JDE1) V?? (srvrusers=1) 0

 

[Sebastian Sajaroff]

Hi,

Please, open your Deployment C:\WINDOWS\JDE.INI and
check that there are no mentions to JDBOCI90.DLL (the
Oracle 9 driver); if so, they should be replaced by
JDBODBC.DLL (it's the SQL driver).
Check also on your Database Datasources (both Planner
and DEP environments) that there are no more "O"
datasources, should all be either SQL or MSDE (Local).

Regards,