JR40764: ORACLE CONNECTOR DOES NOT WORK WITH PUBLIC SYNONYM WHEN ORACLE CONNECTOR PARTITIONING TYPE USED

APAR status

• Closed as duplicate of another APAR.

Error description

• 1) Same as JR40012
  ORACLE CONNECTOR DOES NOT WORK WITH PUBLIC SYNONYM WHEN ORACLE
  CONNECTOR PARTITIONING TYPE USED.
  
  ERROR DESCRIPTION:
  Oracle Connector job fails with next error if
  1. the table name is given without schema qualification and
  2. the name is a public synonym and
  3. Oracle connector partition type is used.
  
     Type: Fatal
     Message Id: IIS-CONN-ORA-01031
     Message: Target_TABLE1: The connector could not find the
  specified table or view TABLE1.
  (CC_OraPartitionedTableHelper::determineTableType, file
  CC_OraPartitionedTableHelper.cpp, line 192)
  
  2) Same as JR40701
  
  ORACLE CONNECTOR MIGHT TRUNCATE DATA FROM NVARCHAR
  AND/OR EXTENDED UNICODE COLUMNS
  

Local fix

• JR40012 Use fully qulified table name in Schema_name.Table_name
  format.
  
  JR40701
  Don't use Extended Unicode columns.
  

Problem summary

Problem conclusion

Temporary fix

Comments

• The fixes for this APAR are both found in patch for JR40701.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels