Questions regarding error message and citation query

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

Posts: 1
Joined: Tue Jun 16, 2015 6:19 am

Questions regarding error message and citation query

Post by takeaction » Tue Jun 16, 2015 6:28 am

We are currently working on projects, where we are looking for the forward citations.
We got PATSTAT CDs(Autumn version), sample queries, and references.
But, we are not used to the PATSTAT, so we have a problem of using the sample queries on the reference

The problems are that

What does it means of an error message of [SELECT - 0 row(s), 0 secs] [Error Code: 0, SQL State: 0] The statement did not return a result set.
When I execute a simple query that (SELECT appln_id FROM tls201_appln WHERE APPLN_ID =14754), I get an message.

Second : In ‘The sample Queries and tips PATSTA online’ the note says as below
“This query makes use of the pre-computed attribute nb_citations, which is only available in PATSTAT online. With PATSTAT raw data, you would have to combine data from the tables which are tls201_appln, tls211_pat_publn and tls212_citation”, so we combine three tables in varying ways, but we can’t got the same result of nb_citations which is displayed in the PATSTA online.
Please give me a query which is used for making the pre-computed attribute nb_citations.

It would really help me out a lot if anyone is able to help me with some of my problems. Thank you in advance.

Posts: 114
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: Questions regarding error message and citation query

Post by mkracker » Tue Jun 16, 2015 7:29 am


Your first response is related to PATSTAT Online, the second to PATSTAT Raw Data. So I assume you are using both, right?

1) The error message you noted refers to an internal error of the application. It seems to have occurred first yesterday afternoon, and progressively got worse. Our developers are analysing this.

2) You are using the 2014 Autumn edition.The current 2015 Spring Edition was delivered as Raw Data last week and will be available in PATSTAT Online - tests permitting - in the next couple of days. In this current edition the attribute NB_CITATIONS of table TLS201_APPLN has been renamed to NB_CITING_DOCDB_FAM. Please have a look in the Data Catalog for 2015 Spring (downloadable from ... nline.html) at sections 6.108 and 7.4. There you will find a description of the attribute and the script how to compute this NB_CITING_DOCDB_FAM in PATSTAT Raw Data.

I hope this helps.
Martin Kracker / EPO

Post Reply