java.sql.SQLException: Invalid parameter index 3. Query: INSERT INTO [test].[dbo].[HL7Raw] ([LName] ,[FName] ,[Doctor] ,[PCP] ,[MRN] ,[VID] -- ,[PrimaryKey] ,[DTofArrival] -- ,[DTofMessageInsertion] -- ,[DTofMessage] ,[StatusCode] ,[Insurance1] ,[Insurance2] ,[Sex] ,[ReceivingFacility] ,[DOB]) VALUES ('LastName' ,'FirstName' ,'Doctor' ,'PCP' ,? ,? -- ,<PrimaryKey, numeric(18,0),> ,CONVERT(datetime,SUBSTRING("?",1,4)+ --year '-' + SUBSTRING('?',5,2) + --month '-' + SUBSTRING('?',7,2) + --day ' ' + SUBSTRING('?',9,2) + --24hh ':'+ SUBSTRING('?',11,2) + --min ':00.000', 121) -- ,? -- ,? ,'?' ,'?' ,'insuranceelement2' ,'?' ,'?' ,CONVERT(datetime,SUBSTRING('?',1,4)+ --year '-' + SUBSTRING('?',5,2) + --month '-' + SUBSTRING('?',7,2) + --day ' ' + SUBSTRING('?',9,2) + --24hh ':'+ SUBSTRING('?',11,2) + --min ':00.000', 121) ) Parameters: [0732043, 000038426102, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, A08, , F, 1, 19610302, 19610302, 19610302, 19610302, 19610302]

mirthcorp.com | 4 months ago
  1. 0

    Invalid parameter index 3 - Mirth Community

    mirthcorp.com | 4 months ago
    java.sql.SQLException: Invalid parameter index 3. Query: INSERT INTO [test].[dbo].[HL7Raw] ([LName] ,[FName] ,[Doctor] ,[PCP] ,[MRN] ,[VID] -- ,[PrimaryKey] ,[DTofArrival] -- ,[DTofMessageInsertion] -- ,[DTofMessage] ,[StatusCode] ,[Insurance1] ,[Insurance2] ,[Sex] ,[ReceivingFacility] ,[DOB]) VALUES ('LastName' ,'FirstName' ,'Doctor' ,'PCP' ,? ,? -- ,<PrimaryKey, numeric(18,0),> ,CONVERT(datetime,SUBSTRING("?",1,4)+ --year '-' + SUBSTRING('?',5,2) + --month '-' + SUBSTRING('?',7,2) + --day ' ' + SUBSTRING('?',9,2) + --24hh ':'+ SUBSTRING('?',11,2) + --min ':00.000', 121) -- ,? -- ,? ,'?' ,'?' ,'insuranceelement2' ,'?' ,'?' ,CONVERT(datetime,SUBSTRING('?',1,4)+ --year '-' + SUBSTRING('?',5,2) + --month '-' + SUBSTRING('?',7,2) + --day ' ' + SUBSTRING('?',9,2) + --24hh ':'+ SUBSTRING('?',11,2) + --min ':00.000', 121) ) Parameters: [0732043, 000038426102, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, A08, , F, 1, 19610302, 19610302, 19610302, 19610302, 19610302]
  2. 0

    Unique index or primary key violation when retrying a failed job

    GitHub | 2 years ago | drdee
    azkaban.executor.ExecutorManagerException: Error writing log part.
  3. 0

    cant get it working [#1428232] | Drupal.org

    drupal.org | 1 year ago
    org.drupal.project.async_command.exception.DatabaseRuntimeException: java.sql.SQLException: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' Query: UPDATE async_command SET output=?, id1=?, id2=?, id3=?, id4=?, number1=?, number2=?, number3=?, number4=?, string1=?, string2=?, string3=?, string4=?, status=?, control=?, message=?, weight=?, start=?, end=?, checkpoint=?, progress=? WHERE id=? Parameters: [null, 1, null, null, null, 0.0, 0.0, 0.0, 0.0, null, null, null, null, OKOK, null, Users: 0. Items: 0. (Time spent: 0h0m0s), 0, 1334338042, 1334338042, null, null, 5]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 25#52516950

    GitHub | 2 years ago | StigLau
    net.whydah.identity.user.role.DatastoreException: java.sql.SQLException: Data truncated for column 'RoleID' at row 1 Query: INSERT INTO UserRoles (RoleID, UserID, AppID, OrganizationName, RoleName, RoleValues) values (?, ?, ?, ?, ?, ?) Parameters: [1a177656-f32a-458e-86f8-c23d301cafb1, useradmin, 1, Support, WhydahUserAdmin, 1]
  6. 0

    inlezen (BRK) stand mislukt met oracle database

    GitHub | 1 year ago | mprins
    nl.b3p.brmo.loader.util.BrmoException: Fout bij loaden basisregistratie gegevens

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Invalid parameter index 3. Query: INSERT INTO [test].[dbo].[HL7Raw] ([LName] ,[FName] ,[Doctor] ,[PCP] ,[MRN] ,[VID] -- ,[PrimaryKey] ,[DTofArrival] -- ,[DTofMessageInsertion] -- ,[DTofMessage] ,[StatusCode] ,[Insurance1] ,[Insurance2] ,[Sex] ,[ReceivingFacility] ,[DOB]) VALUES ('LastName' ,'FirstName' ,'Doctor' ,'PCP' ,? ,? -- ,<PrimaryKey, numeric(18,0),> ,CONVERT(datetime,SUBSTRING("?",1,4)+ --year '-' + SUBSTRING('?',5,2) + --month '-' + SUBSTRING('?',7,2) + --day ' ' + SUBSTRING('?',9,2) + --24hh ':'+ SUBSTRING('?',11,2) + --min ':00.000', 121) -- ,? -- ,? ,'?' ,'?' ,'insuranceelement2' ,'?' ,'?' ,CONVERT(datetime,SUBSTRING('?',1,4)+ --year '-' + SUBSTRING('?',5,2) + --month '-' + SUBSTRING('?',7,2) + --day ' ' + SUBSTRING('?',9,2) + --24hh ':'+ SUBSTRING('?',11,2) + --min ':00.000', 121) ) Parameters: [0732043, 000038426102, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, 200810100000, A08, , F, 1, 19610302, 19610302, 19610302, 19610302, 19610302]

      at org.apache.commons.dbutils.QueryRunner.rethrow()
    2. Apache Commons DbUtils
      QueryRunner.update
      1. org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:359)
      2. org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:428)
      2 frames
    3. com.webreach.mirth
      JdbcMessageDispatcher.doSend
      1. com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doDispatch(JdbcMessageDispatcher.java:130)
      2. com.webreach.mirth.connectors.jdbc.JdbcMessageDispatcher.doSend(JdbcMessageDispatcher.java:157)
      2 frames
    4. org.mule.providers
      AbstractMessageDispatcher.send
      1. org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:166)
      1 frame
    5. org.mule.impl
      MuleSession.sendEvent
      1. org.mule.impl.MuleSession.sendEvent(MuleSession.java:191)
      2. org.mule.impl.MuleSession.sendEvent(MuleSession.java:130)
      2 frames
    6. Mule Core
      OutboundMessageRouter.route
      1. org.mule.routing.outbound.AbstractOutboundRouter.send(AbstractOutboundRouter.java:85)
      2. org.mule.routing.outbound.FilteringMulticastingRouter.route(FilteringMulticastingRouter.java:99)
      3. org.mule.routing.outbound.OutboundMessageRouter$1.doInTransaction(OutboundMessageRouter.java:78)
      4. org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:48)
      5. org.mule.routing.outbound.OutboundMessageRouter.route(OutboundMessageRouter.java:82)
      5 frames
    7. org.mule.impl
      MuleSession.sendEvent
      1. org.mule.impl.model.DefaultMuleProxy.onCall(DefaultMuleProxy.java:247)
      2. org.mule.impl.model.seda.SedaComponent.doSend(SedaComponent.java:209)
      3. org.mule.impl.model.AbstractComponent.sendEvent(AbstractComponent.java:277)
      4. org.mule.impl.MuleSession.sendEvent(MuleSession.java:201)
      4 frames
    8. org.mule.routing
      InboundMessageRouter.route
      1. org.mule.routing.inbound.InboundMessageRouter.send(InboundMessageRouter.java:161)
      2. org.mule.routing.inbound.InboundMessageRouter.route(InboundMessageRouter.java:128)
      2 frames
    9. org.mule.providers
      AbstractMessageReceiver.routeMessage
      1. org.mule.providers.AbstractMessageReceiver$DefaultInternalMessageListener.onMessage(AbstractMessageReceiver.java:493)
      2. org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:272)
      3. org.mule.providers.AbstractMessageReceiver.routeMessage(AbstractMessageReceiver.java:231)
      3 frames
    10. com.webreach.mirth
      FileMessageReceiver.poll
      1. com.webreach.mirth.connectors.file.FileMessageReceiver.processFile(FileMessageReceiver.java:219)
      2. com.webreach.mirth.connectors.file.FileMessageReceiver.poll(FileMessageReceiver.java:138)
      2 frames
    11. org.mule.providers
      PollingMessageReceiver.run
      1. org.mule.providers.PollingMessageReceiver.run(PollingMessageReceiver.java:118)
      1 frame
    12. org.mule.impl
      WorkerContext.run
      1. org.mule.impl.work.WorkerContext.run(WorkerContext.java:290)
      1 frame
    13. Backport of JSR 166
      ThreadPoolExecutor$Worker.run
      1. edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
      2. edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
      2 frames
    14. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame