My Oracle Support Banner

E-COB: SQLRT: INVALID DBTYPE Error When Running COBOL RemoteCall Test (Doc ID 1550196.1)

Last updated on AUGUST 04, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform. **** ****

Symptoms

Sample Environment:
------------
PeopleTools 8.53.02  ( upgraded from 8.51.11)
COBOL Compiler is SE 5.1 WP4 64 bit  on LINUX

Issue:
-------
The site has upgraded this environment from PeopleTools 8.51.x to 8.53.x .  Remote called processes are failing and Remote Call Test fails as well.

Scenario 1) Remote Call Error Trace, from Remote Call Test button. Navigation: Peopletools->utilities->debug->Peopletools Test Utilities.  Press the Remote Call Test button
-------------------------------------------------------------------



Scenario 2) Another scenario/error message "PTPNETRT - NETRT NOT FOUND".  The following is seen from a remote called application cobol program. e.g SRPCGGRC process.

-----------------------------------------------------------------------

more SRPCGGRC_PSEM_AU_0129125258.out
RCCT: PSPCM: GetConnectString - 1
RCCT: PSPCM: szRunCtl
RCCT: PSPCM: szInstance
RCCT: PSPCM: szDBSignonType ORACLE
RCCT: PSPCM: g_bUnicode 0
RCCT: PSPCM: bValidateSignonWithDatabase 0
RCCT: PSPCM: nDbFlags 0
RCCT: PSPCM: lpszGuid -88498464
RCCT: PSPCM: pSamParms->szDBName HR90QA
RCCT: PSPCM: pSamParms->szOprId PSEM_AU
RCCT: PSPCM: szRunCtl
RCCT: PSPCM: szInstance
RCCT: PSPCM: pSamParms->szInitAccessId2 people
RCCT: PSPCM: lpszGuid 30221102-890e-11e3-89ae-bd19a87fb402
RCCT: PSPCM: GetConnectString - 2
RCCT: PSPCM: GetCommandArgs - 1
RCCT: PSPCM: m_szCmd /psoft/hr90qa/bin/PSRUNRMT
RCCT: PSPCM: m_szConnectString REMOTEAY/ORACLE/HR90QA/PSEM_AU/////0/people/%PSWD%/30221102-890e-11e3-89ae-bd19a87fb402
RCCT: PSPCM: ppszArgV[0] /psoft/hr90qa/bin/PSRUNRMT
RCCT: PSPCM: ppszArgV[1] SRPCGGRC
RCCT: PSPCM: ppszArgV[2] REMOTEAY/ORACLE/HR90QA/PSEM_AU/////0/people/%PSWD%/30221102-890e-11e3-89ae-bd19a87fb402
RCCT: PSPCM: GetCommandArgs - 2
PTPNETRT - NETRT NOT FOUND
DATA TYPE=
DATE NAME=

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.