Data returned for format ARXB0100 not valid - more details added
Last Post 28 Nov 2012 10:07 AM by benderd. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Wayne Evans
New Member
New Member
Posts:24

--
22 Nov 2012 07:46 AM

Hello,

I have SQLRPG programs to connect to Oracle database for which we have installed a new product to connect. The product is DBgate and it uses JDBC drivers to connect. Without changing existing prorgams, I just tried the SQLRPG which connects and fetches data from ORacle server and got the subject error.

Does anyone have any idea about this error and what am I possibly missing. With in the trace log under the DBGate product it also says something about ORA-01008: not all variables bound, which is also a hint towards a resolution.

More information I found from the log which states SQLSTATE:72000 and SQLERR: -438

Actual Error: HJADCT1: SQL error -438  detected for CONNECT

My connect statement in SQLRPG:

exec sql  CONNECT TO :SERVER USER :USERNM USING :PASSWD;

Where Server, usernm and passwd coming from a chain to a file before the connect.

The details in job log says:

Data returned for format ARXB0100 not valid.                       
Error occurred while passing request to application requester driver
  program.

Additional Message Information                        
                                                                               
 Message ID . . . . . . :   CPD3E06       Severity . . . . . . . :   10        
 Message type . . . . . :   Diagnostic                                         
 Date sent  . . . . . . :   22/11/12      Time sent  . . . . . . :   09:22:59  
                                                                               
 Message . . . . :   Data returned for format ARXB0100 not valid.              
 Cause . . . . . :   The data returned from the application driver program does
   not match the format required for format name ARXB0100.                     
 Recovery  . . . :   Correct the data returned and try the request again.      

Additional Message Information                        
                                                                               
 Message ID . . . . . . :   SQL0969       Severity . . . . . . . :   30        
 Message type . . . . . :   Diagnostic                                         
 Date sent  . . . . . . :   22/11/12      Time sent  . . . . . . :   09:22:59  
                                                                               
 Message . . . . :   Error occurred while passing request to application       
   requester driver program.                                                   
 Cause . . . . . :   An unexpected error occurred while passing the SQL request
   to the application requester driver program for relational database HJADCT1.
   See previously listed messages in the job log for the cause of the failure. 
 Recovery  . . . :   Correct any problems and try the request again.

Thanks

farhan

 

benderd
Advanced Member
Advanced Member
Posts:614

--
28 Nov 2012 10:07 AM
Hi,

you should better adress your question to your software vendor - he should know the problem. (It's not related to your Code). This error message is detected by DB2/400 and it's not caused by a CONNECT attempt, it's caused by a prepare. --- But I'm not the vendor of the software and I don't know, how they do the work.

D*B
Access any Database from ADABAS to XBASE with embedded SQL in RPG. http://sourceforge.net/projects/appserver4rpg/
You are not authorized to post a reply.

Acceptable Use Policy