Untitled

mail@pastecode.io avatar
unknown
java
2 years ago
6.9 kB
19
Indexable
Never
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "c"
  Position: 1442
### The error may exist in com/iberdrola/ctlges/colaterales/mapper/ice/IceMapper.xml
### The error may involve com.iberdrola.ctlges.colaterales.mapper.ice.IceMapper.getListadoContratosSinAgruparMaturitySpot-Inline
### The error occurred while setting parameters
### SQL: SELECT c.id, c.id_divisa as idDivisa,           c.id_tipo_operacion as idTipoOperacion, o.descripcion as descOperacion,          c.nombre, c.fecha_inicio as fechaIni,           c.fecha_fin as fechaFin, c.cantidad, c.unidad, c.precio,           c.id_producto as idProducto, p.nombre as descProducto,           p.id_cotiz as codProductoCotiz, p.desc_clearer as descProductoClearer,          c.id_matriz as idMatriz, m.descripcion as descMatriz,          c.portfolio, c.fecha_firma as fechaFirma,           c.precio_clearer as precioClearer, c.precio_mercado as precioMercado,           c.existe_producto as existeProducto,          c.validado as validado, c.d_mes_anio as dMesAnio,          c.fecha_mercado as fechaMercado, c.ote_clearer as oteClearer,          c.fecha_consulta as fechaConsulta,          contraparte.descripcion as descContraparte,          cuenta.descripcion as descCuenta,          d.descripcion as descDuracion,          tipo as tipo,          cierre,          market_fee as marketFee,          execution_fee as executionFee,          clearing_fee as clearingFee,          maturity_date as maturityDate,       delivery_date as deliveryDate,     trade_price as precioTrade,     precio_anterior as precioAnterior,     variation_margin_clearer as variationMarginClearer,     cuenta_clearer as cuentaClearer,     valoracion as valoracion,     variation_margin as variationMargin,     valoracion_clearer as cantidadClearer     c.ote_clearer_total as oteClearerTotal,        c.variation_margin_clearer_total as variationMarginClearerTotal,        c.total_equity_clearer as totalEquityClearer,        c.im_requirement_clearer as imRequirementClearer,        c.margin_call_clearer as marginCallClearer,        c.pnl_clearer as pnlClearer,        c.market_fee_clearer as marketFeeClearer,        c.execution_fee_clearer as executionFeeClearer,        c.clearing_fee_clearer as clearingFeeClearer,        c.interest_amount_clearer as interestAmountClearer     FROM col_contratos_ice c     LEFT JOIN col_tipo_operacion o ON o.id = c.id_tipo_operacion     LEFT JOIN col_productos_ice p ON p.id = c.id_producto     LEFT JOIN col_matrices m ON m.id = c.id_matriz     LEFT JOIN col_cuentas_ice cuenta ON c.id_cuenta = cuenta.id     LEFT JOIN col_contrapartes_ice contraparte ON c.id_contraparte = contraparte.id     LEFT JOIN col_duracion_contrato d ON c.id_duracion = d.id    WHERE c.id_divisa = ?    AND TO_CHAR(CAST(c.fecha_consulta AS DATE), 'DD/MM/YYYY') = TO_CHAR(CAST(? AS DATE), 'DD/MM/YYYY')    AND c.tipo IN ('MATURITY', 'SPOT')
### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "c"
  Position: 1442
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "c"
  Position: 1442
org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "c"
  Position: 1442
### The error may exist in com/iberdrola/ctlges/colaterales/mapper/ice/IceMapper.xml
### The error may involve com.iberdrola.ctlges.colaterales.mapper.ice.IceMapper.getListadoContratosSinAgruparMaturitySpot-Inline
### The error occurred while setting parameters
### SQL: SELECT c.id, c.id_divisa as idDivisa,           c.id_tipo_operacion as idTipoOperacion, o.descripcion as descOperacion,          c.nombre, c.fecha_inicio as fechaIni,           c.fecha_fin as fechaFin, c.cantidad, c.unidad, c.precio,           c.id_producto as idProducto, p.nombre as descProducto,           p.id_cotiz as codProductoCotiz, p.desc_clearer as descProductoClearer,          c.id_matriz as idMatriz, m.descripcion as descMatriz,          c.portfolio, c.fecha_firma as fechaFirma,           c.precio_clearer as precioClearer, c.precio_mercado as precioMercado,           c.existe_producto as existeProducto,          c.validado as validado, c.d_mes_anio as dMesAnio,          c.fecha_mercado as fechaMercado, c.ote_clearer as oteClearer,          c.fecha_consulta as fechaConsulta,          contraparte.descripcion as descContraparte,          cuenta.descripcion as descCuenta,          d.descripcion as descDuracion,          tipo as tipo,          cierre,          market_fee as marketFee,          execution_fee as executionFee,          clearing_fee as clearingFee,          maturity_date as maturityDate,       delivery_date as deliveryDate,     trade_price as precioTrade,     precio_anterior as precioAnterior,     variation_margin_clearer as variationMarginClearer,     cuenta_clearer as cuentaClearer,     valoracion as valoracion,     variation_margin as variationMargin,     valoracion_clearer as cantidadClearer     c.ote_clearer_total as oteClearerTotal,        c.variation_margin_clearer_total as variationMarginClearerTotal,        c.total_equity_clearer as totalEquityClearer,        c.im_requirement_clearer as imRequirementClearer,        c.margin_call_clearer as marginCallClearer,        c.pnl_clearer as pnlClearer,        c.market_fee_clearer as marketFeeClearer,        c.execution_fee_clearer as executionFeeClearer,        c.clearing_fee_clearer as clearingFeeClearer,        c.interest_amount_clearer as interestAmountClearer     FROM col_contratos_ice c     LEFT JOIN col_tipo_operacion o ON o.id = c.id_tipo_operacion     LEFT JOIN col_productos_ice p ON p.id = c.id_producto     LEFT JOIN col_matrices m ON m.id = c.id_matriz     LEFT JOIN col_cuentas_ice cuenta ON c.id_cuenta = cuenta.id     LEFT JOIN col_contrapartes_ice contraparte ON c.id_contraparte = contraparte.id     LEFT JOIN col_duracion_contrato d ON c.id_duracion = d.id    WHERE c.id_divisa = ?    AND TO_CHAR(CAST(c.fecha_consulta AS DATE), 'DD/MM/YYYY') = TO_CHAR(CAST(? AS DATE), 'DD/MM/YYYY')    AND c.tipo IN ('MATURITY', 'SPOT')
### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "c"
  Position: 1442
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "c"
  Position: 1442
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447)
	at com.sun.proxy.$Proxy43.selectList(Unknown Source)