karthik9891
Active Member
Hello,
I've installed deployment server 9.2 and platform pack 9.2. I've deployment server installed in one machine (windows server 2008 r2) and enterprise/database server in a separate machine (windows server 2008 r2). I've been trying to run a UBE (R98403E XJDE0009) to copy data from JDEPLAN to PD910 environment.
but, unable to connect to database to enterprise server during the course.
WHAT I'm able to do?
1. I'm able to connect using sqlplus client.
2. Able to run the enteprise services JDE E920 services.
What not able to?
1. Unable to run PORTTEST on enterprise server. Getting the issue "<porttest> could not be registered".
Here are my UBE logs,
jdeCallObject **********************************************************************************
Oct 13 19:25:30.498096 - 3732/3352 WRK:Starting jdeCallObject *** Start dumping data structure for business function ReadIni
Oct 13 19:25:30.498097 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498098 - 3732/3352 WRK:Starting jdeCallObject IN->[ 1] <Item>: szSectionName <type>: STRING <Value>: [DSPWD]
Oct 13 19:25:30.498099 - 3732/3352 WRK:Starting jdeCallObject IN->[ 2] <Item>: szVariableName <type>: STRING <Value>: [PRODCTL ]
Oct 13 19:25:30.498100 - 3732/3352 WRK:Starting jdeCallObject IN->[ 3] <Item>: szValueForEntryDefault <type>: STRING <Value>: [ ]
Oct 13 19:25:30.498101 - 3732/3352 WRK:Starting jdeCallObject IN->[ 4] <Item>: szFileNameOne <type>: STRING <Value>: []
Oct 13 19:25:30.498102 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498103 - 3732/3352 WRK:Starting jdeCallObject *** End dumping data structure for business function ReadIni
Oct 13 19:25:30.498104 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498105 - 3732/3352 WRK:Starting jdeCallObject Entering jdeCloseDictionary
Oct 13 19:25:30.498106 - 3732/3352 WRK:Starting jdeCallObject Exited jdeCloseDictionary with DDType 0
Oct 13 19:25:30.498107 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498108 - 3732/3352 WRK:Starting jdeCallObject *** Start dumping data structure for business function ReadIni
Oct 13 19:25:30.498109 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498110 - 3732/3352 WRK:Starting jdeCallObject OUT->[ 1] <Item>: szSectionName <type>: STRING <Value>: [DSPWD]
Oct 13 19:25:30.498111 - 3732/3352 WRK:Starting jdeCallObject OUT->[ 2] <Item>: szVariableName <type>: STRING <Value>: [PRODCTL ]
Oct 13 19:25:30.498112 - 3732/3352 WRK:Starting jdeCallObject OUT->[ 3] <Item>: szValueForEntryDefault <type>: STRING <Value>: []
Oct 13 19:25:30.498113 - 3732/3352 WRK:Starting jdeCallObject OUT->[ 4] <Item>: szFileNameOne <type>: STRING <Value>: []
Oct 13 19:25:30.498114 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498115 - 3732/3352 WRK:Starting jdeCallObject *** End dumping data structure for business function ReadIni
Oct 13 19:25:30.498116 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498117 - 3732/3352 WRK:Starting jdeCallObject Entering jdeCloseDictionary
Oct 13 19:25:30.498118 - 3732/3352 WRK:Starting jdeCallObject Exited jdeCloseDictionary with DDType 0
Oct 13 19:25:30.498119 - 3732/3352 WRK:Starting jdeCallObject Return value is 0 for ReadIni. (BSFNLevel = 1)
Oct 13 19:25:30.498120 - 3732/3352 FOREIGN_THREAD COB00001: jdeCallObject called to launch DoesTableExist.
Oct 13 19:25:30.498121 - 3732/3352 WRK:Starting jdeCallObject COB00001: jdeCallObject called to launch DoesTableExist.
Oct 13 19:25:30.498122 - 3732/3352 WRK:Starting jdeCallObject Entering FindObjectCache
Oct 13 19:25:30.498123 - 3732/3352 WRK:Starting jdeCallObject Entering JDB_AuditingOn
Oct 13 19:25:30.498124 - 3732/3352 WRK:Starting jdeCallObject Exiting JDB_AuditingOn with success
Oct 13 19:25:30.498125 - 3732/3352 WRK:Starting jdeCallObject Calling Business function DoesTableExist from Level 1 for JDE. Application Name [R98403E], Version [XJDE0009] (BSFNLevel = 1)
Oct 13 19:25:30.498126 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498127 - 3732/3352 WRK:Starting jdeCallObject *** Start dumping data structure for business function DoesTableExist
Oct 13 19:25:30.498128 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498129 - 3732/3352 WRK:Starting jdeCallObject IN->[ 1] <Item>: szNameObject <type>: STRING <Value>: [F0002 ]
Oct 13 19:25:30.498130 - 3732/3352 WRK:Starting jdeCallObject IN->[ 2] <Item>: szServerDataSource <type>: STRING <Value>: [Control Tables - Prod ]
Oct 13 19:25:30.498131 - 3732/3352 WRK:Starting jdeCallObject IN->[ 3] <Item>: szObjectOwnerID <type>: STRING <Value>: [PRODCTL ]
Oct 13 19:25:30.498132 - 3732/3352 WRK:Starting jdeCallObject IN->[ 4] <Item>: cExistingObjectYOrN <type>: CHAR <Value>: []
Oct 13 19:25:30.498133 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498134 - 3732/3352 WRK:Starting jdeCallObject *** End dumping data structure for business function DoesTableExist
Oct 13 19:25:30.498135 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498136 - 3732/3352 WRK:Starting jdeCallObject Entering jdeCloseDictionary
Oct 13 19:25:30.498137 - 3732/3352 WRK:Starting jdeCallObject Exited jdeCloseDictionary with DDType 0
Oct 13 19:25:30.498138 - 3732/3352 WRK:Starting jdeCallObject Entering JDB_InitBhvr
Oct 13 19:25:30.498139 - 3732/3352 WRK:Starting jdeCallObject Exiting JDB_InitBhvr with Success (UserHandle 0A4F7C18)
Oct 13 19:25:30.498140 - 3732/3352 WRK:Starting jdeCallObject Entering JDB_TableExists (Table F0002)
Oct 13 19:25:30.498141 - 3732/3352 WRK:Starting jdeCallObject Entering JDB_GetDatabaseTypeFromDS (DS Control Tables - Prod)
Oct 13 19:25:30.498142 - 3732/3352 WRK:Starting jdeCallObject Exiting JDB_GetDatabaseTypeFromDS with Success (DS Control Tables - Prod) (Type O)
Oct 13 19:25:30.498143 - 3732/3352 WRK:Starting jdeCallObject Try to fetch proxy info from cache
Oct 13 19:25:40.074000 - 3732/3352 WRK:Starting jdeCallObject OCI0000374 - Failed to connect to the database instance
Any help on this would be of great help.
I've installed deployment server 9.2 and platform pack 9.2. I've deployment server installed in one machine (windows server 2008 r2) and enterprise/database server in a separate machine (windows server 2008 r2). I've been trying to run a UBE (R98403E XJDE0009) to copy data from JDEPLAN to PD910 environment.
but, unable to connect to database to enterprise server during the course.
WHAT I'm able to do?
1. I'm able to connect using sqlplus client.
2. Able to run the enteprise services JDE E920 services.
What not able to?
1. Unable to run PORTTEST on enterprise server. Getting the issue "<porttest> could not be registered".
Here are my UBE logs,
jdeCallObject **********************************************************************************
Oct 13 19:25:30.498096 - 3732/3352 WRK:Starting jdeCallObject *** Start dumping data structure for business function ReadIni
Oct 13 19:25:30.498097 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498098 - 3732/3352 WRK:Starting jdeCallObject IN->[ 1] <Item>: szSectionName <type>: STRING <Value>: [DSPWD]
Oct 13 19:25:30.498099 - 3732/3352 WRK:Starting jdeCallObject IN->[ 2] <Item>: szVariableName <type>: STRING <Value>: [PRODCTL ]
Oct 13 19:25:30.498100 - 3732/3352 WRK:Starting jdeCallObject IN->[ 3] <Item>: szValueForEntryDefault <type>: STRING <Value>: [ ]
Oct 13 19:25:30.498101 - 3732/3352 WRK:Starting jdeCallObject IN->[ 4] <Item>: szFileNameOne <type>: STRING <Value>: []
Oct 13 19:25:30.498102 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498103 - 3732/3352 WRK:Starting jdeCallObject *** End dumping data structure for business function ReadIni
Oct 13 19:25:30.498104 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498105 - 3732/3352 WRK:Starting jdeCallObject Entering jdeCloseDictionary
Oct 13 19:25:30.498106 - 3732/3352 WRK:Starting jdeCallObject Exited jdeCloseDictionary with DDType 0
Oct 13 19:25:30.498107 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498108 - 3732/3352 WRK:Starting jdeCallObject *** Start dumping data structure for business function ReadIni
Oct 13 19:25:30.498109 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498110 - 3732/3352 WRK:Starting jdeCallObject OUT->[ 1] <Item>: szSectionName <type>: STRING <Value>: [DSPWD]
Oct 13 19:25:30.498111 - 3732/3352 WRK:Starting jdeCallObject OUT->[ 2] <Item>: szVariableName <type>: STRING <Value>: [PRODCTL ]
Oct 13 19:25:30.498112 - 3732/3352 WRK:Starting jdeCallObject OUT->[ 3] <Item>: szValueForEntryDefault <type>: STRING <Value>: []
Oct 13 19:25:30.498113 - 3732/3352 WRK:Starting jdeCallObject OUT->[ 4] <Item>: szFileNameOne <type>: STRING <Value>: []
Oct 13 19:25:30.498114 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498115 - 3732/3352 WRK:Starting jdeCallObject *** End dumping data structure for business function ReadIni
Oct 13 19:25:30.498116 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498117 - 3732/3352 WRK:Starting jdeCallObject Entering jdeCloseDictionary
Oct 13 19:25:30.498118 - 3732/3352 WRK:Starting jdeCallObject Exited jdeCloseDictionary with DDType 0
Oct 13 19:25:30.498119 - 3732/3352 WRK:Starting jdeCallObject Return value is 0 for ReadIni. (BSFNLevel = 1)
Oct 13 19:25:30.498120 - 3732/3352 FOREIGN_THREAD COB00001: jdeCallObject called to launch DoesTableExist.
Oct 13 19:25:30.498121 - 3732/3352 WRK:Starting jdeCallObject COB00001: jdeCallObject called to launch DoesTableExist.
Oct 13 19:25:30.498122 - 3732/3352 WRK:Starting jdeCallObject Entering FindObjectCache
Oct 13 19:25:30.498123 - 3732/3352 WRK:Starting jdeCallObject Entering JDB_AuditingOn
Oct 13 19:25:30.498124 - 3732/3352 WRK:Starting jdeCallObject Exiting JDB_AuditingOn with success
Oct 13 19:25:30.498125 - 3732/3352 WRK:Starting jdeCallObject Calling Business function DoesTableExist from Level 1 for JDE. Application Name [R98403E], Version [XJDE0009] (BSFNLevel = 1)
Oct 13 19:25:30.498126 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498127 - 3732/3352 WRK:Starting jdeCallObject *** Start dumping data structure for business function DoesTableExist
Oct 13 19:25:30.498128 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498129 - 3732/3352 WRK:Starting jdeCallObject IN->[ 1] <Item>: szNameObject <type>: STRING <Value>: [F0002 ]
Oct 13 19:25:30.498130 - 3732/3352 WRK:Starting jdeCallObject IN->[ 2] <Item>: szServerDataSource <type>: STRING <Value>: [Control Tables - Prod ]
Oct 13 19:25:30.498131 - 3732/3352 WRK:Starting jdeCallObject IN->[ 3] <Item>: szObjectOwnerID <type>: STRING <Value>: [PRODCTL ]
Oct 13 19:25:30.498132 - 3732/3352 WRK:Starting jdeCallObject IN->[ 4] <Item>: cExistingObjectYOrN <type>: CHAR <Value>: []
Oct 13 19:25:30.498133 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498134 - 3732/3352 WRK:Starting jdeCallObject *** End dumping data structure for business function DoesTableExist
Oct 13 19:25:30.498135 - 3732/3352 WRK:Starting jdeCallObject **********************************************************************************
Oct 13 19:25:30.498136 - 3732/3352 WRK:Starting jdeCallObject Entering jdeCloseDictionary
Oct 13 19:25:30.498137 - 3732/3352 WRK:Starting jdeCallObject Exited jdeCloseDictionary with DDType 0
Oct 13 19:25:30.498138 - 3732/3352 WRK:Starting jdeCallObject Entering JDB_InitBhvr
Oct 13 19:25:30.498139 - 3732/3352 WRK:Starting jdeCallObject Exiting JDB_InitBhvr with Success (UserHandle 0A4F7C18)
Oct 13 19:25:30.498140 - 3732/3352 WRK:Starting jdeCallObject Entering JDB_TableExists (Table F0002)
Oct 13 19:25:30.498141 - 3732/3352 WRK:Starting jdeCallObject Entering JDB_GetDatabaseTypeFromDS (DS Control Tables - Prod)
Oct 13 19:25:30.498142 - 3732/3352 WRK:Starting jdeCallObject Exiting JDB_GetDatabaseTypeFromDS with Success (DS Control Tables - Prod) (Type O)
Oct 13 19:25:30.498143 - 3732/3352 WRK:Starting jdeCallObject Try to fetch proxy info from cache
Oct 13 19:25:40.074000 - 3732/3352 WRK:Starting jdeCallObject OCI0000374 - Failed to connect to the database instance
Any help on this would be of great help.