Since I don't see any hardware information like Model, HMC managed, single partition system or multiple lpars a couple of questions along with reason for asking:
Are you using standalone optical drive(s) or an optical library?
If it is a Library you could have multiple drives in the library and one or more of the drives in the library could be varied on in standalone mode.
Is anyone moving resources between partitions using the HMC?
If someone moves the IOA controlling the drive with it varied on and forces the move, when it is moved back it will get a new Hardware resource name and if auto config is on it will be created with a new device name.
Is there an active virtual optical drive with an image in a mounted status?
If a volume is mounted with the same volume name the mount in the physical drive will fail.
Receiving hundreds of OPT1481 - Add optical disk cartridge failed to complete successfully For devices OPT01 thru OPT11.
Recovery . . . : Ensure that optical device OPT02 is varied on and try the
request again. You may need to eject the cartridge and re-load it.
What is causing this?
How do I resolve?
I don't have this many OPT devices.
What created these.
OPTVRT01 ACTIVE
OPT01 VARIED OFF
OPT02 ACTIVE
OPT03 ACTIVE
OPT04 ACTIVE
OPT05 ACTIVE
OPT06 ACTIVE
OPT07 ACTIVE
OPT08 ACTIVE
OPT09 ACTIVE
OPT10 ACTIVE
OPT11 ACTIVE
Thank You
_____
Paul Steinmetz
IBM i Systems Administrator
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home
psteinmetz@xxxxxxxxxx<mailto:psteinmetz@xxxxxxxxxx>
http://cp.mcafee.com/d/FZsSd6Qm1PW8VOWdPtPqqbXybXXVJd5ZN5NUsrjhvshvvsdFECzBd5BBYSHm4OT2eG_g54WA21o-F0wmVsSjGg85zWA21rBPpEVossgYs_R-jd78VBZW_nKnjpd7affL9LffLZh5dqWqJQnKl3PWApmU6CQmjq8UTsTsS02m-5GNVv3qIA8X0zVsYKgGT2TQ02Hm4OT2eG_gUDkwgb7R842TbwFmi4twh_BPqqar5PoS6xMb40o4xEK5jh07i8_io1Cy0cRfd42bU1Cy0dFhLPh0y-_sSOedKtFwN14cpvF0
------------------------------
message: 5
date: Thu, 29 Sep 2016 14:05:58 -0500
from: CRPence <crpbottle@xxxxxxxxx>
subject: Re: conversion between CCSID 1208 and CCSID 65535 not valid
(RPG Talks To Watson)
On 29-Sep-2016 03:11 -0500, GioArt wrote:
I'm try to run run the example at
[http://cp.mcafee.com/d/FZsS76Qm1PW8VOWdPtPqqbXybXXVJd5ZN5NUsrjhvshvvs
dFECzBd5BBYSHm4OT2eG_g54WA21o-F0wmVsSjGg85zWA21rBPpEVossgYs_R-jd78VBZW_nKnjpd7affL9LffLZh5dqWqJQnKl3PWApmU6CQm3q8UTsTsS02Bchrwhf_BYt9Ast9ArCzBcsyUnFeIiRQu1NJmi4twhYKun8lrxrW01lH2prx7lvEsjGg85zWA21rBMkH92eM8_OVJd5dyVIr3gU5y0c2gQn2FEw3F4vFc0Ph06qDCy15Y0Ph06QETVEwhvvKrp76S6LWZpf9zLlM] but i receive the following error:
SQL0332 "Character conversion between CCSID 1208 and CCSID 65535 not
" valid."
My CCSID is 65535
can some one help me ?
The problem is that "CCSID is 65535". The most likely resolution will be had by issuing the following request in the job that runs whatever is the failing SQL [I am not going to pore of the article looking for what statement fails, when you could have just provided that in your OP]:
CHGJOB CCSID(1144) /* or whatever value for an EBCDIC CCSID from the list at the following URL seems more appropriate for your language environment */
[
http://cp.mcafee.com/d/5fHCNAe3zqb0VZ4sVt6VKVJd5ZN5ZZYSCy-UyUYedFELK8LLK6QQjhOCyOO-rlH2prx7lvE2yti10IvkwgbsKr9R842NZi10JOVIQsIee8uevW_9CzAsO-ZvHTbFICzB7DTATDDT-EyCJtdmWbTaxVZicHs3jqbVJ4srKrKr01i8aYLBaKPcr7Y8DR8qv8kSsGMORGigORGig5o-hBivNZ3wsrlAx7o4vbDBO5mUm-w0lqMCmUhRnW74WA21o-F0wmVs5aOgzI2fYKrjhjoKr6MQe1ow30Ad5MGq80Wh7Wj0cQg1CFVEwhv0cQg1Jad-q84nTXCShNLHCtKOgWvkqz]
The more appropriate\long-term corrective action [if that is helpful], is to accommodate all future logins similarly to the above Change Job (CHGJOB) request that was used to change the job CCSID value.
That is done by *explicitly* setting some your-language-appropriate values for some of the prompted parameters of the Change Profile
(CHGPRF) command as shown here [when signed on as your user profile
(USRPRF) that will be running the SQL]; i.e. should be set to a value *other than* *SYSVAL:
CHGPRF ??LANGID() ??CNTRYID() ??CCSID() ??CHRIDCTL()
For reference, a text snippet for each of those language-sensitive items; these parameter are also on the Change User Profile (CHGUSRPRF):
Language ID (LANGID)
Country or region ID (CNTRYID)
Coded character set ID (CCSID)
Character identifier control (CHRIDCTL)
--
Regards, Chuck
------------------------------
Subject: Digest Footer
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://cp.mcafee.com/d/1jWVIg6hEidEI3DQhPBQrCXCQQnT4nTTPqqbXybzMUSCy-Uy--Urjhd7aqbbbVJmI9BK4tl-wa9R842NZi10JOVIDkwgb7R842TbCPhOMUUxUV_HYCqehPbXR-LsKCOqekuvujuuvvWyaqRQRrELsG7DR8OJMddEK6QhNKVKVI06vaAWsH92eM8_O-2qKMM-l9OwXn5p8hS17OVVJmi4twhYKun8lrxrW01lH2prx7lvEsjGg85zWA21rBMkH92eM8_OVJd5dyVIr3gU5y0c2gQn2FEw3F4vFc0Ph06qDCy15Y0Ph06QETVEwhvvKrp76SsKqcTAMzjhv
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://cp.mcafee.com/d/5fHCMUi6x0SyMevh7enhKrKrjhvshvvvdFELK8Kf3zqqbXybXXxJd4QsFEIILCRqMCmUhRnW0EDkwgb7R842TbCOti10IvkwgbsKrd7b3zy7zD-LOpEV7cLLnWZOWr9EVhVZVdVVZ_G8FHnjlKyZOEuvkzaT0QSyedEzztPtPo0foS9Oc_OIA8X0z_bUH92eM8-nfdGOgzI2fBPOV2Hsbvg0aJojbs8WHZ3yti10IvkwgbsK2Bp8hS17-ndFEFIndzoq70Ig1wi6yUld40t8zZ9w6q80PkYQg8Lw6q80SB6_d42bXZPr8UTAJsxQkYbwJ9.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
------------------------------
End of MIDRANGE-L Digest, Vol 15, Issue 1550
********************************************
⚠ This email is from an external address. Exercise caution when following links or opening attachments. ⚠
________________________________
This email message, including any attachment(s) is for the sole use of the intended recipient(s) and may contain confidential information. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient, please immediately contact the sender by email.
midrange.com
