KEMBAR78
SQL Error: NVARCHAR to DATETIME2 Conversion | PDF | Computing | Software Development
0% found this document useful (0 votes)
86 views3 pages

SQL Error: NVARCHAR to DATETIME2 Conversion

An error occurred during the execution of a SQL stored procedure call activity in a workflow process. The error indicates that there was an issue converting a data type from nvarchar to datetime2 in the SQL query. This caused the workflow task instance to fail.

Uploaded by

AMR
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
86 views3 pages

SQL Error: NVARCHAR to DATETIME2 Conversion

An error occurred during the execution of a SQL stored procedure call activity in a workflow process. The error indicates that there was an issue converting a data type from nvarchar to datetime2 in the SQL query. This caused the workflow task instance to fail.

Uploaded by

AMR
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 3

Instance name: 4060:‫استالم وادارة طلبات التواصل الداخلي‬

Instance error: [<49message:Error converting data type nvarchar to


datetime2.><119flowObjectID:/25.ce685344-9303-4b11-baf8-3935ffff6960//ca3018f5-
febc-45a9-8230-734d50815678/‫( الخطوة‬SaveForwardingHistoryForTimers2)>]
Snapshot ID: 7178f6dc-86cf-4575-a308-1e2b4ca2bab1
Root snapshot ID: undefined
Error time stamp: 24/08/2021 12:00 ‫( ص‬11 hours ago)
Branch ID: undefined
Instance ID: 4060
Task ID: 10410
Stack trace:
com.lombardisoftware.component.common.workflow.WorkflowProcessItemException: An
exception occurred in activity "Call Stored Proc" of "Integration Service" with
name "SQL Call Stored Procedure". Task instance id "Task.10410". Details: "Error
converting data type nvarchar to datetime2.".
at
com.lombardisoftware.component.common.workflow.ExecutionJob.createWorkflowProcessIt
emException(ExecutionJob.java:666)
at
com.lombardisoftware.component.common.workflow.ExecutionJob.doJob(ExecutionJob.java
:525)
at
com.lombardisoftware.server.ejb.workflow.EJBWorkflowManagerBean.doResumeWorkflowEng
ine(EJBWorkflowManagerBean.java:1594)
at
com.lombardisoftware.server.ejb.workflow.EJBWorkflowManagerBean.doResumeWorkflowEng
ine(EJBWorkflowManagerBean.java:717)
at
com.lombardisoftware.server.ejb.workflow.EJBWorkflowManagerBean.resumeTask(EJBWorkf
lowManagerBean.java:374)
at
com.lombardisoftware.server.ejb.workflow.EJBWorkflowManagerBean.resumeTask(EJBWorkf
lowManagerBean.java:338)
at
com.lombardisoftware.server.ejb.workflow.EJSRemoteStatefulEJBWorkflowManager_9907b2
e2.resumeTask(Unknown Source)
at
com.lombardisoftware.server.ejb.workflow._EJBWorkflowManagerInterface_Stub.resumeTa
sk(Unknown Source)
at
com.lombardisoftware.component.common.workflow.EJBWorkflowManagerDelegateDefault.re
sumeTask(EJBWorkflowManagerDelegateDefault.java:120)
at
com.lombardisoftware.component.common.workflow.EJBWorkflowManagerDelegateWebSphere$
5.run(EJBWorkflowManagerDelegateWebSphere.java:76)
at java.security.AccessController.doPrivileged(AccessController.java:734)
at
com.lombardisoftware.client.delegate.common.WebsphereDelegateHelper.doAsCurrentSubj
ectContextSensitive(WebsphereDelegateHelper.java:244)
at
com.lombardisoftware.client.delegate.common.WebsphereDelegateHelper.doAsCurrentSubj
ectContextSensitive(WebsphereDelegateHelper.java:228)
at
com.lombardisoftware.component.common.workflow.EJBWorkflowManagerDelegateWebSphere.
resumeTask(EJBWorkflowManagerDelegateWebSphere.java:74)
at
com.lombardisoftware.bpd.runtime.engine.quartz.ExecuteSystemLaneActivityTask.callSe
rvice(ExecuteSystemLaneActivityTask.java:128)
at
com.lombardisoftware.bpd.runtime.engine.quartz.ExecuteSystemLaneActivityTask.execut
e(ExecuteSystemLaneActivityTask.java:97)
at com.lombardisoftware.server.scheduler.Engine.execute(Engine.java:1090)
at
com.lombardisoftware.server.scheduler.Engine.executeThreadTasks(Engine.java:766)
at com.lombardisoftware.server.scheduler.Engine$1.run(Engine.java:696)
at
com.lombardisoftware.client.delegate.common.WebsphereDelegateHelper$3$1.run(Websphe
reDelegateHelper.java:131)
at java.security.AccessController.doPrivileged(AccessController.java:770)
at javax.security.auth.Subject.doAs(Subject.java:570)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:196)
at
com.lombardisoftware.client.delegate.common.WebsphereDelegateHelper.doAs(WebsphereD
elegateHelper.java:211)
at
com.lombardisoftware.client.delegate.common.WebsphereDelegateHelper$3.run(Websphere
DelegateHelper.java:125)
at
com.lombardisoftware.server.scheduler.threadpool.WorkManagerThreadPool$MyWork.run(W
orkManagerThreadPool.java:163)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:271)
at java.security.AccessController.doPrivileged(AccessController.java:704)
at javax.security.auth.Subject.doAs(Subject.java:490)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:133)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:91)
at com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J2EEContext.java:338)
at java.security.AccessController.doPrivileged(AccessController.java:734)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:806)
at
com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl
.java:222)
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data
type nvarchar to datetime2.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerExce
ption.java:258)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.ja
va:1535)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(
SQLServerPreparedStatement.java:467)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(S
QLServerPreparedStatement.java:409)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection
.java:2478)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.j
ava:219)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement
.java:199)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedSt
atement.java:393)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatemen
t.java:1067)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.j
ava:638)
at teamworks.sql.SQLClient.executePreparedStatement(SQLClient.java:506)
at teamworks.sql.SQLClient.call(SQLClient.java:188)
at teamworks.SQLConnector$3.execute(SQLConnector.java:191)
at teamworks.SQLConnector$3.execute(SQLConnector.java:187)
at teamworks.sql.SQLExecutor.doExecute(SQLExecutor.java:158)
at teamworks.sql.SQLExecutor.execute(SQLExecutor.java:102)
at teamworks.SQLConnector.call(SQLConnector.java:186)
at teamworks.SQLConnector.callFlat(SQLConnector.java:201)
at sun.reflect.GeneratedMethodAccessor485.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:5
5)
at java.lang.reflect.Method.invoke(Method.java:508)
at
teamworks.connector.JavaReflectionConnector$1.execute(JavaReflectionConnector.java:
97)
at
com.lombardisoftware.server.core.ManagedAssetClassLoaderUtil.executeWithManagedAsse
tClassLoader(ManagedAssetClassLoaderUtil.java:58)
at
teamworks.connector.JavaReflectionConnector.execute(JavaReflectionConnector.java:56
)
at
com.lombardisoftware.component.javaconnector.worker.JavaConnectorWorker.invokeJavaM
ethod(JavaConnectorWorker.java:195)
at
com.lombardisoftware.component.javaconnector.worker.JavaConnectorWorker.doJob(JavaC
onnectorWorker.java:120)
at
com.lombardisoftware.component.common.workflow.ExecutionJob.doJob(ExecutionJob.java
:522)
... 35 more

You might also like