warning: Fallback location internaldb in report server

ReportServer (EN)
1

Hi,

 I am using report server2.2.1 version. I created birt reports with dynamic parameters and I posted that report in report server. For dynamic parameters in report server I used datasource parameters (Example: In a report Country is one of the parameter. That parameter has values of all countries.User has to select his country as per his requirement from drop down list). While executing the report the report takes so much time to get values in to dropdown list (nearly 10 min taking). In tomat server I got the below warning. Please check once and give me any solution to reslove this issue.

Jan 17, 2015 9:02:57 AM net.datenwerke.rs.core.service.internaldb.InternalDbServ
iceImpl getLocation
WARNING: Cannot write to internal db file: D:\ndc-portal-6.2.0-ce-ga1\tomcat-7.0
.42\bin\dbtmp
Jan 17, 2015 9:02:57 AM net.datenwerke.rs.core.service.internaldb.InternalDbServ
iceImpl getLocation
WARNING: Fallback location internaldb: D:\ndc-portal-6.2.0-ce-ga1\tomcat-7.0.42
temp
Jan 17, 2015 9:02:58 AM net.datenwerke.rs.core.service.internaldb.InternalDbServ
iceImpl getLocation
WARNING: Cannot write to internal db file: D:\ndc-portal-6.2.0-ce-ga1\tomcat-7.0
.42\bin\dbtmp
Jan 17, 2015 9:02:58 AM net.datenwerke.rs.core.service.internaldb.InternalDbServ
iceImpl getLocation
WARNING: Fallback location internaldb: D:\ndc-portal-6.2.0-ce-ga1\tomcat-7.0.42
temp
Jan 17, 2015 9:02:58 AM net.datenwerke.rs.core.service.internaldb.InternalDbServ
iceImpl getLocation
WARNING: Cannot write to internal db file: D:\ndc-portal-6.2.0-ce-ga1\tomcat-7.0
.42\bin\dbtmp
Jan 17, 2015 9:02:59 AM net.datenwerke.rs.core.service.internaldb.InternalDbServ
iceImpl getLocation
WARNING: Fallback location internaldb: D:\ndc-portal-6.2.0-ce-ga1\tomcat-7.0.42
temp
Jan 17, 2015 9:02:59 AM net.datenwerke.rs.core.service.internaldb.InternalDbServ
iceImpl getLocation
WARNING: Cannot write to internal db file: D:\ndc-portal-6.2.0-ce-ga1\tomcat-7.0
.42\bin\dbtmp
Jan 17, 2015 9:02:59 AM net.datenwerke.rs.core.service.internaldb.InternalDbServ
iceImpl getLocation
WARNING: Fallback location internaldb: D:\ndc-portal-6.2.0-ce-ga1\tomcat-7.0.42
temp
Jan 17, 2015 9:03:00 AM net.datenwerke.rs.core.service.internaldb.InternalDbServ
iceImpl getLocation
WARNING: Cannot write to internal db file: D:\ndc-portal-6.2.0-ce-ga1\tomcat-7.0
.42\bin\dbtmp
Jan 17, 2015 9:03:00 AM net.datenwerke.rs.core.service.internaldb.InternalDbServ
iceImpl getLocation
WARNING: Fallback location internaldb: D:\ndc-portal-6.2.0-ce-ga1\tomcat-7.0.42
temp
Jan 17, 2015 9:03:01 AM net.datenwerke.rs.core.service.internaldb.InternalDbServ
iceImpl getLocation
WARNING: Cannot write to internal db file: D:\ndc-portal-6.2.0-ce-ga1\tomcat-7.0
.42\bin\dbtmp
Jan 17, 2015 9:03:01 AM net.datenwerke.rs.core.service.internaldb.InternalDbServ
iceImpl getLocation
WARNING: Fallback location internaldb: D:\ndc-portal-6.2.0-ce-ga1\tomcat-7.0.42
temp

Thanks & Regards,

2

Hi,

the warnings don’t seem to be related to your issue. ReportServer is trying to access the internaldb which is, for example, used for demo data and tells
you that it does not have WRITE access and thus uses a fallback location.

How is your datasource parameter configured? 10 minutes seems not right. How many values are you loading into the dropdown box and how long does
the corresponding query take if you run it on the database?

Regards
Arno

3

Hi,

Thank u for your reply. I am new for Report server.  I will tell you step by step what I did.

  1. First I dowloaded installer. And I installed report server with my external tomat7 (i.e, I am using liferay for my websites. So, I installed report server also in leferay tomact only.).
    It is working fine.

  2. I created reports by using Birt Eclipse. I created one report with dynamic parameters. Example Country is one dynamic parameter has nealy 150 countries list & Customer is one of the dynamic parameter has nearly 500 customers list in drop down. In birt report viewer these parameters takes time for getting data in seconds only.

  3. I publish birt report in Report server. For dynamic parameters I used datasource parameters. By using birt datasource I got the countries list from database. In Report server only I am getting so much time for drop down list. Nearly it takes 10 min. Is there any problem. I did not get any idea. Please give any solution for this.

Sorry for the bad english.

4

Hi Kusuma,

could you maybe send us a copy of your Birt Report to info[at]datenwerke.net? I can’t promise anything but I’ll try to have a look at it over the next few days.

Regards
Arno

5

Hi,

 I sent my birt report to info@datenwerke.net on two days back. Please check once and give your valuable suggestions for me.  I am waiting for your reply.
6

see email

Arno