database verify failed

[Former Member]

hi guys,

I have one more query.

I get an error log "database verify failed" during the report execution but my report appears fine. is this an error with the JRC ?

Also when i pass 'NULL' for the outputstream object in the processRequest() i get response already commited error but when i pass the pageContext.out to that method i am not gettin that error. i have set the Isownpage and isownform as true.

Thanks,

Prem

[ted_ueda · Accepted solution]

I'd need more info concerning the context within which the database verify error is displayed.

Are you possibly changing the database location in code? This would trigger a database verify step, to ensure the design schema is compatible to the runtime schema.

Since this is intermittent - not every time - I'm wondering if this is load-related.

As for the output stream exception - the viewer works by postback, where it writes HTML output to the response Writer interface, and binaries (export formats) to the response OutputStream interface. The last argument of the processHttpResquest is used to specify the Writer object. If it's null, then it retrieves the getWriter from the HTTPServletResponse argument.

The exception arises because of this - when you pass in null, then it writes to the Writer, and something else on the page is writing to the OutputStream and colliding, since you can't write to both the response.getWriter() and response.getOutputStream() within the same request.

Sincerely,

Ted Ueda

[Former Member · Accepted solution]

Hi,

Yes i am changing the connection parameters during runtime.I am using JNDI based connection in which will take according to the deployement environment(Production,Test).The actual report is developed using development database.

Thanks,

Prem

[ted_ueda · Accepted solution]

Changing connection parameters would trigger a database verify, to ensure the runtime schema accords with the design-time schema.

I would recommend looking at the logs surrounding the error to see if that indicates what was at issue.

Sincerely,

Ted Ueda

[Former Member · Accepted solution]

Hi,

i dont want it to verify the DataBase instead i want the JRC to generate the report with the given Connection parameter. IS it possible.I coouldn't see any other errors other than Error : Database verify failed despite turning on the LOG with INFO.

Please help.

Prem

[Former Member · Accepted solution]

In normal circumstances there is no way to turn off the verify database if you are changing your connection properties at runtime.

[Former Member]

The JRC has been known to verify the database when you are changing table location at runtime. It is how the product is designed; it will verify the database connection with null values before setting the connection.

Because the error you are seeing doesn't affect the application in any way, and as long as the report is running as expected you don't need to give it a second thought.

As for your second issue, it may well be that for whatever reason your application server has a problem when you pass null into that method; it isn't a bug, you can resolve it as you are doing by passing the pageContext.out if that works.

[Former Member]

Hi Ted/Enns,

Please calrify my doubt.

thanks,

Prem