Error Message
Posted: Tue Nov 17, 2015 10:58 pm
Dear all,
I would like to ask for your help with an error message I`m getting on PATSTAT Online.
I`m trying to generate a list of number of patent applications per country of origin of the applicant and year. In the case of more than one applicant, I divide the (1) application by the total number of applicants, and each one gets an equal share (i.e., if there are two applicants from different countries, the count for this application is 0.5 for each).
I`m using the following code to generate the table:
SELECT person_ctry_code, appln_filing_year, COUNT(*), SUM(nb_applicants), SUM(1/(nb_applicants*1.00))
FROM tls201_appln a
JOIN tls207_pers_appln b ON a.appln_id = b.appln_id
JOIN tls206_person c ON b.person_id=c.person_id
WHERE appln_filing_year>1998
AND applt_seq_nr>0
AND person_ctry_code NOT IN ('', '--','..','04','75')
GROUP BY a.appln_id, person_ctry_code, appln_filing_year
ORDER BY person_ctry_code, appln_filing_year
I tested the code with a small number of applications (introducing a WHERE condition such as `AND a.appln_id BETWEEN 1 and 1000`) and it works just fine.
However, when I try to run for the complete database (excluding such condition), PATSTAT online returns the following error message: “4:45:14 PM [PATSTAT Online error] The statement did not return a result set.”
Does anyone know what should be the problem, and how could I circumvent it?
Thanks in advance,
Daniel Colombo
I would like to ask for your help with an error message I`m getting on PATSTAT Online.
I`m trying to generate a list of number of patent applications per country of origin of the applicant and year. In the case of more than one applicant, I divide the (1) application by the total number of applicants, and each one gets an equal share (i.e., if there are two applicants from different countries, the count for this application is 0.5 for each).
I`m using the following code to generate the table:
SELECT person_ctry_code, appln_filing_year, COUNT(*), SUM(nb_applicants), SUM(1/(nb_applicants*1.00))
FROM tls201_appln a
JOIN tls207_pers_appln b ON a.appln_id = b.appln_id
JOIN tls206_person c ON b.person_id=c.person_id
WHERE appln_filing_year>1998
AND applt_seq_nr>0
AND person_ctry_code NOT IN ('', '--','..','04','75')
GROUP BY a.appln_id, person_ctry_code, appln_filing_year
ORDER BY person_ctry_code, appln_filing_year
I tested the code with a small number of applications (introducing a WHERE condition such as `AND a.appln_id BETWEEN 1 and 1000`) and it works just fine.
However, when I try to run for the complete database (excluding such condition), PATSTAT online returns the following error message: “4:45:14 PM [PATSTAT Online error] The statement did not return a result set.”
Does anyone know what should be the problem, and how could I circumvent it?
Thanks in advance,
Daniel Colombo