Hi All,

I am getting strange behavior when I call SQL server SP from webfocus(7703) fex...

The fex doesn't call SP ..

 
-SET &bu_id	='1';
-SET &analystid='5';
-SET &depcode='NPX16,NPX23,PSX11';
-SET &depcode_status='1';
-SET &citypair='CFRPME,PMESDR';
-SET &citypair_status='1';
-SET &startdepdate='2012/03/25';
-SET &enddepdate='2012/03/25';
-SET &depdate_status='1';
-SET &capture_date='2012/03/26';
-SET &resource='P';
-SET &resource_status='1';
-SET &equipment='M,N';
-SET &equipment_status='1';
-SET &level='0';
-SET &timeperiod='0';
-SET &return_code='0';                                          
-SET &return_message='0';
-SET ECHO = ALL;
SET SQLENGINE=SQLMSS
-*SQL EX rts_po.DBO.KPI_Load_Factor_KV '1'  ,'5'  ,'NPX16,NPX23,PSX11'  ,'1'  ,'CFRPME,PMESDR'  ,'1'  ,'2012/03/25'  ,'2012/03/25'  ,'1'  ,'2012/03/26'  ,'P'  ,'1'  ,'M,N'  ,'1'  ,'0'  ,'0'  ,'0'  ,'0';
SQL EX RTS_PO.DBO.KPI_Load_Factor_KV '&bu_id','&analystid','&depcode','&depcode_status','&citypair','&citypair_status','&startdepdate','&enddepdate','&depdate_status','&capture_date','&resource','&resource_status','&equipment','&equipment_status','&level','&timeperiod','&return_code','&return_message';
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD
END
-RUN
 

Please help..

-Regards
-Kumud

you do not have any error messages?

-SET &ECHO=ALL;
at the start of this code might help

I have got following after running the report:

  
Your request did not return any output to display.
Possible causes:
- No data rows matched the specified selection criteria.
- Output was directed to a destination such as a file or printer.
- An error occurred during the parsing or running of the request.



 -SET &bu_id	='1';
 -SET &analystid='5';
 -SET &depcode='NPX16,NPX23,PSX11';
 -SET &depcode_status='1';
 -SET &citypair='CFRPME,PMESDR';
 -SET &citypair_status='1';
 -SET &startdepdate='2012/03/25';
 -SET &enddepdate='2012/03/25';
 -SET &depdate_status='1';
 -SET &capture_date='2012/03/26';
 -SET &resource='P';
 -SET &resource_status='1';
 -SET &equipment='M,N';
 -SET &equipment_status='1';
 -SET &level='0';
 -SET &timeperiod='0';
 -SET &return_code='0';
 -SET &return_message='0';
 SET SQLENGINE=SQLMSS
 -*SQL EX rts_po.DBO.KPI_Load_Factor_KV '1'  ,'5'  ,'NPX16,NPX23,PSX11'  ,'1'  ,'CFRPME,PMESDR'  ,'1'  ,'2012/03/25'  ,'2012/03/25'  ,'1'  ,'2012/03/26'  ,'P'  ,'1'  ,'M,N'  ,'1'  ,'0'  ,'0'  ,'0'  ,'0';
 SQL EX RTS_PO.DBO.KPI_Load_Factor_KV '1','5','NPX16,NPX23,PSX11','1','CFRPME,PMESDR','1','2012/03/25','2012/03/25','1','2012/03/26','P','1','M,N','1','0','0','0','0';
 TABLE FILE SQLOUT
 PRINT *
 ON TABLE PCHOLD
 END
 -RUN

I need urgent help on this. Please suggest

-Regards
-Kumud

Hello Kumud,
Are you able to execute it in SQL server management studio with the account that WebFOCUS data adaptor connection is using?
Also, I do not see any set command for your default connection.
ENGINE SQLMSS SET DEFAULT_CONNECTION connection name
Probably that is the reason.