A fix is available
APAR status
Closed as program error.
Error description
Running ARSEXOAM results in the following SQL error: ARS0013I DB Error: Warning: Unexpected SQL_NO_DATA -- SQLSTATE=N/A, SQLCODE=100, File=arsmvseo.c, Line=617
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Content Manager OnDemand for z/OS 10.5 * * customers. * **************************************************************** * PROBLEM DESCRIPTION: Running ARSEXOAM results in the * * following SQL error: * * * * ARS0013I DB Error: Warning: Unexpected * * SQL_NO_DATA -- * * SQLSTATE=N/A, SQLCODE=100, * * File=arsmvseo.c, Line=617 * **************************************************************** A query was issued without an ORDER BY causing rows being returned in no order which lead to the SQL_NO_DATA.
Problem conclusion
The query is issue with an ORDER BY.
Temporary fix
Comments
APAR Information
APAR number
PH63334
Reported component name
CM OD Z/OS, OD/
Reported component ID
5655H3900
Reported release
A50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-09-20
Closed date
2024-11-26
Last modified date
2024-12-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI99200
Modules/Macros
ARG3WAPI ARG3WCCH ARG3WCNV ARG3WCOM ARG3WOUT ARG3WUTL ARGACC ARGADMIN ARGADMMN ARGAFPD ARGAFPMN ARGAG ARGANN ARGAPP ARGAZSMS ARGAZXML ARGCAB ARGCFG ARGCMLDV ARGCMNFN ARGCOLCT ARGCOMP ARGCONT ARGCS ARGCSL ARGCSSM ARGCSVAN ARGCSVAP ARGCSVDC ARGCSVDR ARGCSVFL ARGCSVGP ARGCSVHT ARGCSVLG ARGCSVLV ARGCSVNQ ARGCSVPM ARGCSVPR ARGCSVSR ARGCSVSS ARGCSVUS ARGCSX ARGDATE ARGDATMN ARGDB ARGDB2 ARGDBDEF ARGDBMN ARGDBMS ARGDBSTB ARGDBUTL ARGDCFTN ARGDOC ARGDOCMN ARGDOCX ARGDSNIF ARGDUR ARGDYNS ARGEVNT ARGEXPRT ARGFASCR ARGFJOBN ARGFOL ARGFSSMS ARGFTI ARGFTSTB ARGGCSMS ARGGCXML ARGGSKOD ARGHDSMS ARGHOLD ARGI128 ARGICU ARGICUOS ARGID ARGIMEXP ARGKMIP ARGKMIPP ARGL390A ARGL390C ARGL390L ARGL390M ARGL390Z ARGLACIF ARGLDAP ARGLDMN ARGLDSTB ARGLGEN ARGLINT ARGLKSTB ARGLOAD ARGLOADC ARGLOCK ARGLSNFN ARGLSNRI ARGLSSTB ARGLSYMN ARGLSYNC ARGLXML ARGMAINT ARGMDATE ARGMDMGR ARGMEM ARGMETER ARGMNGRC ARGMNTMN ARGMSG ARGMSGS ARGMVSE1 ARGMVSEO ARGMVSEU ARGMVSIE ARGMVSLE ARGMVSOC ARGMVSOI ARGMVSPP ARGMVSRD ARGMVSV2 ARGNQ ARGOD ARGODBCI ARGODBCP ARGODF ARGODFCS ARGODFDB ARGODFMN ARGODFPR ARGOS ARGOSMV1 ARGOSMVS ARGOSMVT ARGPARMS ARGPERFM ARGPRIV ARGPROF ARGPRT ARGRPT ARGRPTMN ARGS3SMS ARGS3XML ARGSEC ARGSECOS ARGSEG ARGSLU ARGSLUMN ARGSLUX ARGSM ARGSMAUX ARGSMCAC ARGSMMV2 ARGSMMVS ARGSMSMS ARGSMSTB ARGSOCK ARGSRCH ARGSRVMN ARGSRVR ARGSTASH ARGSTHMN ARGSWSMS ARGSYS ARGSYSCR ARGSYSMN ARGTBLMN ARGTBLSP ARGTFMT ARGTRACE ARGUTILS ARGUUID ARGXAFP ARGXDR ARGXDRCS ARGXFORM ARGXISAX ARGXLINE ARGXML ARGXPORT ARGXUTL ARGZ31OS ARGZDOCD ARGZLIBH ARGZLIBS ARGZOSDB ARGZOSIC ARGZOSOS ARGZOSWT ARGZOSWU ARN3WAPI ARN3WCCH ARN3WCNV ARN3WCOM ARN3WOUT ARN3WUTL ARNACC ARNAG ARNANN ARNAPP ARNAZSMS ARNAZXML ARNCAB ARNCFG ARNCMLDV ARNCOLCT ARNCOMP ARNCONT ARNCS ARNCSL ARNCSSM ARNCSVAN ARNCSVAP ARNCSVDC ARNCSVDR ARNCSVFL ARNCSVGP ARNCSVHT ARNCSVLG ARNCSVLV ARNCSVNQ ARNCSVPM ARNCSVPR ARNCSVSR ARNCSVSS ARNCSVUS ARNCSX ARNDATE ARNDB2 ARNDBDEF ARNDBMS ARNDBSTB ARNDOC ARNDUR ARNDYNS ARNEVNT ARNFOL ARNFSSMS ARNFTSTB ARNGCSMS ARNGCXML ARNGSKOD ARNHDSMS ARNHOLD ARNHPRNT ARNI128 ARNICU ARNICUOS
Fix information
Fixed component name
CM OD Z/OS, OD/
Fixed component ID
5655H3900
Applicable component levels
RA50 PSY UI99200
UP24/11/28 P F411
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSQHWE","label":"Content Manager OnDemand for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A50","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 December 2024