on 08-09-2017 8:01 PM
Hi ,
I am facing the below error while trying to insert a row in sql database table :
"JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'dbo.PlannedWorkRaw' (structure 'INSERT_STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'.
Any idea how to resolve this error?
regards,
Vaibhav
Shouldn't the 'access' node be the child node of "dtTablename" ?
Br,
Manoj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ya ..you are correct.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It is data issue. most probably due some special character or negative sign at the end of any number.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vaibhav!
Wouldn't you at least provide your insert message example?
Regards, Evgeniy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<?xml version="1.0" encoding="UTF-8"?> <ns1:PortPirieDB_PlannedWorkKPI_MT xmlns:ns1="http://xyz.com"><INSERT_STATEMENT><dtTableName action="INSERT"><table>dbo.PlannedWorkRaw</table></dtTableName><access><Period>1000</Period><MaintenanceOrderKey>test1</MaintenanceOrderKey><MaintenanceOrderText>this is test</MaintenanceOrderText><OperationKey>test2</OperationKey><MaintenancePlannerGroupText>test3</MaintenancePlannerGroupText><WorkCenterText>test4</WorkCenterText><OperationSystemStatusKey>test5</OperationSystemStatusKey><UnplannedHours>2.3</UnplannedHours><PlannedHours>1.2</PlannedHours><ActualHours>0.9</ActualHours><HoursOnPlanned>6.80000000</HoursOnPlanned></access></INSERT_STATEMENT></ns1:PortPirieDB_PlannedWorkKPI_MT>
Also PFA the structure at db end :
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.