Share
Report
790Good afternoon,
SL 2011 FP1 in a remote desktop environment, Server 2008 R2. Back end is SQL 2008 R2.
Had a user enter a timecard with incorrect time, that got approved and posted. We used timecard correction to open a timecard we could enter the correct time on.
User corrected the time card, and when the supervisor went to approve it, it failed. threw an event log:
System Message 6124: Process started: Mon Jun 24 04:16 P.M.
================================================================================
Processing: Posting Document 0000031022 && Line -32408
System Message 245: [Microsoft][SQL Server Native Client 11.0][SQL
Server]Conversion failed when converting the varchar value
'000Y020771' to data type int.
Debugging info: SELECT *
FROM PJLABDIS WHERE docnbr IN (0000031013) AND dl_id01 <>
'R' ORDER BY docnbr, hrs_type, linenbr DESC
Cursor(c_PJLABDIS) SELECT * FROM PJLABDIS WHERE docnbr IN
(000003101
Optional info: SqlState = 22018 NativeError =
245 ErrorMsg = [Microsoft][SQL Server Native Client
11.0][SQL Server]Conversion failed when converting the
varchar value '000Y020771' to data type int. pcbErrorMsg =
136
ODBCRowNumber = 1 Column = -1 SSrvrLine = 1
SSrvrMsgState = 1 SSrvrSeverity = 16 SSrvrProcname =
SSrvrSrvname = DLMS02
System Message 6127: Error occurred during an abortable transaction. Processing
will continue.
================================================================================
================================================================================
Processing: Posting Document 0000031022 && Line -32408
System Message 56: [Microsoft][ODBC Driver Manager] Function sequence error
Debugging info: SqlCompile - SQLNumResultCols Failed
Cursor(c_PJLABDIS) SELECT * FROM PJLABDIS WHERE docnbr IN
(000003101
Optional info: SqlState = HY010 NativeError = 0
ErrorMsg = [Microsoft][ODBC Driver Manager] Function sequence
error pcbErrorMsg = 56
ODBCRowNumber = -1 Column = -1
SSrvrLine = 1 SSrvrMsgState = 0 SSrvrSeverity = 0
SSrvrProcname = SSrvrSrvname = DLMS02
System Message 6127: Error occurred during an abortable transaction. Processing
will continue.
================================================================================
System Message 6125: Process ended: Mon Jun 24 04:16 P.M.
I rejected the time card with no problem, had the user delete all the lines and re-enter them. Went to approve it and got the same results.
Any ideas?
Thanks,
Chris
*This post is locked for comments
All responses (
Answers (
