Question
6
Replies
3558
Views
HSBC
Posted: February 3, 2016
Last activity: May 25, 2016
Closed
Solved
There was a database problem when performing an RDBExecute: code: 0 SQLState: <none> Message: No value has been inserted
Hi, We are using PRPC 6.1 SP2. We used summary view with drill down and when the dril down is clicked we are getting the below error
"There was a database problem when performing an RDBExecute: code: 0 SQLState: <none> Message: No value has been inserted"
We are facing the issue only in PROD but is fine in all non PROD environments including Pre-prod.
Hi Naveen,
I believe you have the DB2 database and you have a list view with one of the filed as date.
As the DB2 DATE type is not supported. Please try one of the following local change for the list view to work with the DATE type:
Create a DB2 View on the table that cast either with the TIMESTAMP function or the CAST function the DB2 Date column to a TIMESTAMP value and then use normal PRPC methods to access that PRPC datetime property.
Syntax for creating the view would be
CREATE VIEW READ_CLASS AS SELECT TIMESTAMP(RPT_DATE, '00.00.00') AS ".RPT_DATE"”
OR
Create a custom getcontent activity with the same casting of datatypes to a TIMESTAMP when you specify the query to generate should also work for you. And use this getcontent activity in the List view.