DB Load on Oracle fails | U00009907 Memory view 'string-orig'

Products

• CA Automic One Automation
• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Loading the initialdata via the db load utility on linux fails and the following is written in the log file before it ends:

20240124/103048.964 - U00003532 UCUDB: Checking data source ...
20240124/103048.984 - U00009907 Memory view 'string-orig' (Address='0x7fd46702c5b0', Length='255')
20240124/103048.985 -           00000000  01020304 05060708 090A0B0C 0D0E0F10  >................<
20240124/103048.985 -           00000010  11121314 15161718 191A1B1C 1D1E1F20  >............... <
20240124/103048.985 -           00000020  21222324 25262728 292A2B2C 2D2E2F30  >!"#$%&'()*+,-./0<
20240124/103048.985 -           00000030  31323334 35363738 393A3B3C 3D3E3F40  >123456789:;<=>?@<
20240124/103048.985 -           00000040  41424344 45464748 494A4B4C 4D4E4F50  >ABCDEFGHIJKLMNOP<
20240124/103048.985 -           00000050  51525354 55565758 595A5B5C 5D5E5F60  >QRSTUVWXYZ[\]^_`<
20240124/103048.985 -           00000060  61626364 65666768 696A6B6C 6D6E6F70  >abcdefghijklmnop<
20240124/103048.985 -           00000070  71727374 75767778 797A7B7C 7D7E7F80  >qrstuvwxyz{|}~.€<
20240124/103048.985 -           00000080  81828384 85868788 898A8B8C 8D8E8F90  >‚ƒ„…†‡ˆ‰Š‹ŒŽ<
20240124/103048.985 -           00000090  91929394 95969798 999A9B9C 9D9E9FA0  >‘’“”•–—˜™š›œžŸ <
20240124/103048.985 -           000000A0  A1A2A3A4 A5A6A7A8 A9AAABAC ADAEAFB0  >¡¢£¤¥¦§¨©ª«¬­®¯°<
20240124/103048.985 -           000000B0  B1B2B3B4 B5B6B7B8 B9BABBBC BDBEBFC0  >±²³´µ¶·¸¹º»¼½¾¿À<
20240124/103048.985 -           000000C0  C1C2C3C4 C5C6C7C8 C9CACBCC CDCECFD0  >ÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐ<
20240124/103048.985 -           000000D0  D1D2D3D4 D5D6D7D8 D9DADBDC DDDEDFE0  >ÑÒÓÔÕÖ×ØÙÚÛÜÝÞßà<
20240124/103048.985 -           000000E0  E1E2E3E4 E5E6E7E8 E9EAEBEC EDEEEFF0  >áâãäåæçèéêëìíîïð<
20240124/103048.985 -           000000F0  F1F2F3F4 F5F6F7F8 F9FAFBFC FDFEFF    >ñòóôõö÷øùúûüýþÿ<
20240124/103048.985 - U00009907 Memory view 'string-DB' (Address='0x7fd46702bed0', Length='255')
20240124/103048.985 -           00000000  01020304 05060708 090A0B0C 0D0E0F10  >................<
20240124/103048.985 -           00000010  11121314 15161718 191A1B1C 1D1E1F20  >............... <
20240124/103048.985 -           00000020  21222324 25262728 292A2B2C 2D2E2F30  >!"#$%&'()*+,-./0<
20240124/103048.985 -           00000030  31323334 35363738 393A3B3C 3D3E3F40  >123456789:;<=>?@<
20240124/103048.985 -           00000040  41424344 45464748 494A4B4C 4D4E4F50  >ABCDEFGHIJKLMNOP<
20240124/103048.985 -           00000050  51525354 55565758 595A5B5C 5D5E5F60  >QRSTUVWXYZ[\]^_`<
20240124/103048.985 -           00000060  61626364 65666768 696A6B6C 6D6E6F70  >abcdefghijklmnop<
20240124/103048.985 -           00000070  71727374 75767778 797A7B7C 7D7E7F80  >qrstuvwxyz{|}~.€<
20240124/103048.985 -           00000080  81828384 85868788 898A8B8C 8D8E8F90  >‚ƒ„…†‡ˆ‰Š‹ŒŽ<
20240124/103048.985 -           00000090  91929394 95969798 999A9B9C 9D9E9FA0  >‘’“”•–—˜™š›œžŸ <
20240124/103048.986 -           000000A0  A1A2A3BF A5BFA7BF A9AAABAC ADAEAFB0  >¡¢£¿¥¿§¿©ª«¬­®¯°<
20240124/103048.986 -           000000B0  B1B2B3BF B5B6B7BF B9BABBBF BF59BFC0  >±²³¿µ¶·¿¹º»¿¿Y¿À<
20240124/103048.986 -           000000C0  C1C2C3C4 C5C6C7C8 C9CACBCC CDCECFD0  >ÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐ<
20240124/103048.986 -           000000D0  D1D2D3D4 D5D6D7D8 D9DADBDC DDDEDFE0  >ÑÒÓÔÕÖ×ØÙÚÛÜÝÞßà<
20240124/103048.986 -           000000E0  E1E2E3E4 E5E6E7E8 E9EAEBEC EDEEEFF0  >áâãäåæçèéêëìíîïð<
20240124/103048.986 -           000000F0  F1F2F3F4 F5F6F7F8 F9FAFBFC FDFEFF    >ñòóôõö÷øùúûüýþÿ<
20240124/103048.986 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
20240124/103048.987 - U00003594 UCUDB Ret: '3531' opcode: 'OPEN' SQL Stmnt: ''
20240124/103048.987 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'OPEN' time: '1:014.440.000'
20240124/103048.987 - U00003525 UCUDB: ===> ''
20240124/103048.987 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
20240124/103048.987 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).

Environment

Version 12.3 and 21.0

Cause

The character_set settings did not match between the client and database.  The client was set to WE8ISO8859P15 which causes an extra character (the euro sign) to be inserted and the database is unable to "understand" it

Resolution

Troubleshooting:

Look at the load log and find what the character set for the database:

U00029111 UCUDB - Database parameters:
...
U00003535 DB INFO: 'NLS_CHARACTERSET               = WE8ISO8859P1'

 

Then look at the character set the client is using:

U00029109 UCUDB: Local information from client environment
...
U00003535 DB INFO: 'OCI_NLS_CHARACTER_SET          = WE8ISO8859P15'

The client is likely set in the SQLDRIVERCONNECT string, shown in bold below:

sqlDriverConnect=ODBCVAR=NNJNIORO,DSN=[db schema name];UID=[user name];PWD=???;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15

 

Resolution:

Update the SQLDRIVERCONNECT string in the load ini file to match the database NLS_CHARACTERSET, in this case:

sqlDriverConnect=ODBCVAR=NNJNIORO,DSN=[db schema name];UID=[user name];PWD=???;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P1