[#10036] - Problem Type *java.lang.RuntimeException: exception getting dataset from cache*

Category:
Bug report
Priority:
Urgent
Status:
New
Project: Severity:
Major
Resolution:
Open
Component: Reproducibility:
Random
Assigned to:
0

Have this problem with my reports, when i do open, im not have problems with my Data Sourse AWS Redshift, have any reports working actually from this DB, and Have problem from This Simple Select

SELECT id AS IdRol, role AS ROL, basecommissiontotalsale AS BaseComisionValorPagare, basecommissioncash AS BaseComisionValorArticulo, subtotal, invoicecharge AS CargoxFactura, tacticdiscount AS DescuentoTactico, total AS TotalAPagar, commissionfactor AS FACTOR, renewaltotalunearnedinterests AS SUMAINTERESESNODEVENGADOS, renewaltotalsalefactor AS FACTORRENOVACIONVALORPAGARE, renewalcashfactor AS FACTORRENOVACIONVALORARTICULO, lastupdate AS FECHAULTIMAACTUALIZACION, broker AS FONDEADOR, "references/idsolicitud" AS IDSolicitud, "references/idcuenta" AS IDCUENTA, creationstate AS ESTATUS, active AS ACTIVO, "creationtiming/suscriptiondate" AS FECHASOLICITUD, "creationtiming/creationdate" AS FECHAALTA, "creationtiming/fundeddate" AS "FECHALIBERADO", "creationtiming/disperseddate" AS FECHACOBRO, "creationtiming/goalperioddate" AS FECHAMETA, "creationtiming/lastupdate" AS FECHAULTIMAACT, state AS ESTADO, "branchoffice/name" AS SUCURSAL, "branchoffice/multiproduct" AS MULTIPRODUCTO, "pointofsale/name" AS NODO, "pointofsale/secondgeneration" AS SEGUNDAGENERACION, "saleinformation/customerfullname" AS CLIENTE, "saleinformation/customerid" AS IDCLIENTE, "saleinformation/covenant" AS CONVENIO, "saleinformation/operation" AS TIPOVENTA, "saleinformation/telemarketing" AS TELEMARKETING, "saleinformation/stratego" AS STRATEGO, "saleinformation/supervisor" AS SUPERVISOR, "saleinformation/salesrepid" AS IDPROMOTOR, "saleinformation/salesrepcomissionpercent" AS FACTORCONVENIOPRODUCTO, "product/name" AS PRODUCTO, "product/family" AS FAMILIAPRODUCTO, "product/salestargetfamily" AS FAMILIAMETA, "product/interestrate" AS Tasa, "conditions/cash" AS ARTICULO, "conditions/comission" AS COMISIONAPERTURA, "conditions/comissiontax" AS IVACOMISIONAPERTURA, "conditions/interest" AS INTERESES, "conditions/interesttax" AS IVAINTERES, startdate AS FechaAltaComisionista, enddate AS FechaBajaComisionista, complete_name AS NOMBRECOMISIONISTA, salesstaffid AS IDCOMISIONISTA, email AS Correo, bank AS Banco, accountnumber AS Numero_cuenta, clabe AS Clabe, employeeid ID_Empleado FROM public.vw_commissions_report

**************************

Error From Query

Cannot execute JDBC Query.
ERROR: transaction is read-only
Detail:
(Not Detail)

**** Not have restrictions on my View

So, simple, help me Please°°

AttachmentSize
Image icon jasper_2.png47.92 KB
daniel.garcia_1's picture
Joined: Oct 24 2017 - 3:29pm
Last seen: 3 years 6 months ago

2 Comments:

#1
AttachmentSize
Image icon jasper1.png62.42 KB
Feedback
randomness