Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm somewhat new to QlikView so I apologize if this is basic. I have a .qvw file that I used to query a Remedy db and create QVDs for another file to load from.
The script has two SQL statements each querying a different table. They work when I run them separately, but when I run them together I get an "Unable to Send Request" error.
Here is my script:
/*Full extraction of Feedback data from Remedy*/
VOC_CUSTOMER_FEEDBACK:
SQL
SELECT
FEEDBACK_ID,
SUBMITTER,,
TO_CHAR(CREATE_DATE,'DD-MON-YYYY') as CREATE_DATE,
STATUS,
LOGIN_ID,
FULL_NAME,
EMAIL,
LOCATION,
PRIORITY,
CASE_TYPE,
TICKETS,
FEEDBACK,
PRODUCT,
DECODE(COMBINED_RATING_NUMBER, '0', 'POSITIVE', '1', 'NEGATIVE') as SERVICE_SATISFACTION,
DECODE(REQUEST_CONTACT,'0','No','1', 'Yes') CONTACT_REQUESTED,
DECODE(RATE_YOUR_EXPERIENCE, '0', 'Positive', '1', 'Neutral', '2', 'Negative') as RATE_YOUR_EXPERIENCE,
MODIFIED_DATE
FROM VOC_CUSTOMER_FEEDBACK
WHERE CREATE_DATE > =TO_DATE('01/01/'||TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'YYYY'))-2),'MM/DD/YYYY');
STORE VOC_CUSTOMER_FEEDBACK into $(vQVDPath)VOC_CUSTOMER_FEEDBACK.qvd;
DROP Table VOC_CUSTOMER_FEEDBACK;
LET vPrevYearRemedySec = (MakeDate($(vPrevtoPrevYear),01,01) - MakeDate(1970,01,01))*24*60*60;
VOC_FEEDBACK_V2:
SQL
SELECT
FEEDBACK_ID,
SUBMITTER,
TO_Char(TO_DATE(ARADMIN.GET_REM_DATE(CREATE_DATE), 'MONTH DD, YYYY HH12:MI:SSAM'),'DD-MON-YYYY') AS CREATE_DATE,
//TO_DATE(TRIM(TO_DATE(ARADMIN.GET_REM_DATE(CREATE_DATE), 'MONTH DD, YYYY HH12:MI:SSAM')),'DD-MON-YYYY') AS CREATE_DATE,
DECODE(STATUS ,'3', 'Completed','0', 'Submitted','1', 'Submitted') STATUS,
LOGIN_ID,
FULL_NAME,
EMAIL,
LOCATION,
SOURCE_ID as TICKETS,
FEEDBACK,
PRODUCT,
DECODE (EXPERIENCE_RATING ,'1', 'NEGATIVE','3', 'POSITIVE','5','POSITIVE') SERVICE_SATISFACTION,
DECODE (REQUEST_CONTACT ,'0', 'No','1', 'Yes') CONTACT_REQUESTED,
DECODE (EXPERIENCE_RATING ,'1', 'Negative','3', 'Neutral','5','Positive') RATE_YOUR_EXPERIENCE,
MODIFIED_DATE
FROM VOC_FEEDBACK_V2
WHERE CREATE_DATE >=$(vPrevYearRemedySec);
STORE VOC_FEEDBACK_V2 into $(vQVDPath)VOC_FEEDBACK_V2.qvd;
DROP Table VOC_FEEDBACK_V2;
DISCONNECT;
Maybe your queries comes to soon after another an a small waiting maybe of:
sleep 3000;
might helpful. Another workaround could be to disconnect the connection after the first load and create them new before the second.
- Marcus