IBM Support

SE74466 - OSP-MSGSQL0901-D/TQSQROUTS-PAR-940XBASE CPYFRMIMPF FAILS WITH
SQL0901TYPE 1022, F/QSQROUTS SQ9999 RC10

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 APAR (Authorized Program Analysis Report)

Abstract

OSP-MSGSQL0901-D/TQSQROUTS-PAR-940XBASE CPYFRMIMPF FAILS WITH
SQL0901TYPE 1022, F/QSQROUTS SQ9999 RC10

Error Description

When the Java/CLI environment is initiated for a function like  
SYSTOOLS.HTTPGETCLOBVERBOSE                                    
CPYFRMIMPF fails with                                          
                                                               
SQL0901 Diagnostic 50 09/18/20 12:23:32.561714 QSQROUTS QSYS    
*STMT QSQROUTS QSYS                                            
From module . . . . . . . . : QSQCLNUP                          
From procedure . . . . . . : SQROUTE_CLEANUP                    
Statement . . . . . . . . . : 4146                              
To module . . . . . . . . . : QSQCLNUP                          
To procedure . . . . . . . : SQROUTE_CLEANUP                    
Statement . . . . . . . . . : 4146                              
Thread . . . . : 00000051                                      
Message . . . . : SQL system error.                            
Cause . . . . . : An SQL system error has occurred. The current
SQL                                                            
statement cannot be completed successfully. The error will not  
prevent                                                        
other SQL statements from being processed. Previous messages may
indicate that there is a problem with the SQL statement and SQL
did not                                                        
correctly diagnose the error. The previous message identifier  
was *N.                                                        
Internal error type 1022 has occurred.                          
                                                               
SQ99999 Diagnostic 30 09/18/20 12:23:32.561762 QSQCLI QSYS      
*STMT QCPIMPRT QSYS                                            
From module . . . . . . . . : SQLEX                            
From procedure . . . . . . : SQLExecute                        
Statement . . . . . . . . . : 13678                            
To module . . . . . . . . . : QCPIMPRT                          
To procedure . . . . . . . : CopyAllRecords                    
Statement . . . . . . . . . : 295                              
Thread . . . . : 00000051                                      
Message . . . . : Error occurred in SQL Call Level Interface    
Cause . . . . . : A procedure call encountered an error. The    
error code is                                                  
10 -- Function sequence error.                                  

Problem Summary

When the Java/CLI environment is initiated for a function like  
SYSTOOLS.HTTPGETCLOBVERBOSE                                    
CPYFRMIMPF fails with                                          
                                                               
SQL0901 Diagnostic 50 09/18/20 12:23:32.561714 QSQROUTS QSYS    
*STMT QSQROUTS QSYS                                            
From module . . . . . . . . : QSQCLNUP                          
From procedure . . . . . . : SQROUTE_CLEANUP                    
Statement . . . . . . . . . : 4146                              
To module . . . . . . . . . : QSQCLNUP                          
To procedure . . . . . . . : SQROUTE_CLEANUP                    
Statement . . . . . . . . . : 4146                              
Thread . . . . : 00000051                                      
Message . . . . : SQL system error.                            
Cause . . . . . : An SQL system error has occurred. The current
SQL                                                            
statement cannot be completed successfully. The error will not  
prevent                                                        
other SQL statements from being processed. Previous messages may
indicate that there is a problem with the SQL statement and SQL
did not                                                        
correctly diagnose the error. The previous message identifier  
was *N.                                                        
Internal error type 1022 has occurred.                          
                                                               
SQ99999 Diagnostic 30 09/18/20 12:23:32.561762 QSQCLI QSYS *STMT
QCPIMPRT QSYS                                                  
From module . . . . . . . . : SQLEX                            
From procedure . . . . . . : SQLExecute                        
Statement . . . . . . . . . : 13678                            
To module . . . . . . . . . : QCPIMPRT                          
To procedure . . . . . . . : CopyAllRecords                    
Statement . . . . . . . . . : 295                              
Thread . . . . : 00000051                                      
Message . . . . : Error occurred in SQL Call Level Interface    
Cause . . . . . : A procedure call encountered an error. The    
error code is                                                  
10 -- Function sequence error.                                  

Problem Conclusion

The problem occurs in some cases because the initialization of  
the CLI environment by the native JDBC driver causes problems  
for NOT FENCED Java UDFs.                                      
                                                               
The native JDBC driver has been update to initialize the CLI    
environment in a different manner when it is used in the Java  
UDF and Java stored procedure environment.                      

Temporary Fix

Comments

Circumvention


PTFs Available

R720 SI75378  1000

R730 SI74462  1098

R740 SI74450  1091

Affected Modules


         
         

Affected Publications

Summary Information

Status............................................CLOSED PER
HIPER...........................................No
Component..................................5770SS1ED
Failing Module..........................RCHMGR
Reported Release...................R740
Duplicate Of..............................




IBM i Support

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information

[{"Type":"MASTER","Line of Business":{"code":"LOB08","label":"Cognitive Systems"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2; 7.3; 7.4","Product":{"code":"SG15Q","label":"APARs - OS\/400 General"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
20 April 2021