sql statement bot running and creating error

-1

SQL STATEMENT--

"CALL [IT_IT].[HCDW.IT.IT::UPD_CPS_JOB_TELEMETRY](" + jcsJob.getJobId() +",'" + jcsJob.getJobDefinition().getName() + "','" + jcsJob.getStatus() +"','" + jcsJob.getRunStart().toUTCString() + "')";
        //  aJob.getJobParameterByName("SqlStatement").setInValueString(monitorValues);

ERROR--

User: IT_IT
User: It_*****
Server: BOHANADB1
Executing SQL Statement: CALL
Execution FAILURE
System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: line 1 col 1 (at pos 1)
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
   at Micron.Data.HanaDriver.HanaExecute.Execute(String command)
Exit Code : 1
Exit Code Description: UnknownFailure
sql
odbc
return-code
asked on Stack Overflow Aug 31, 2020 by ayushi jain • edited Aug 31, 2020 by a_horse_with_no_name

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0