Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MICROS incrementing shifts

Status
Not open for further replies.

DominoDerrik

IS-IT--Management
Dec 11, 2017
1
0
0
US

I'm having the same issue as the thread187-1747655. it started after I upgraded to 5.5. I looked in the DB and there were no records with null values in the shift_seq column
I am also getting an error message when calling the "clock out and in all employees" stored procedure referencing another table with null values for a record that I cannot find in the database

this is what I get in the DLog
Mon Dec 11 05:00:01 2017 | SERVER | Autosequence.dll | 0 | SQLExecDirect: (23000)[Sybase][ODBC Driver][SQL Anywhere]Column 'shift_seq' in table 'shift_emp_dtl' cannot be NULL |
Mon Dec 11 05:00:01 2017 | SERVER | AutoSeqServer | 0 | Autosequence 30001 step 1 of type S has encountered a stored procedure error...Error executing stored procedure. |
Mon Dec 11 05:00:03 2017 | PCWS03 | PeriphsDllWs4 | 0 | Fngrscan: could not post message, hWnd 1879202784 message 49156 last error 0 |
Mon Dec 11 05:00:01 2017 | SERVER | Autosequence.dll | 0 | SQLExecDirect: (23000)[Sybase][ODBC Driver][SQL Anywhere]Column 'shift_seq' in table 'shift_emp_dtl' cannot be NULL |
Mon Dec 11 05:00:01 2017 | SERVER | AutoSeqServer | 0 | Autosequence 30001 step 1 of type S has encountered a stored procedure error...Error executing stored procedure. |
Mon Dec 11 05:00:01 2017 | SERVER | Autosequence.dll | 0 | SQLExecDirect: (23000)[Sybase][ODBC Driver][SQL Anywhere]Column 'shift_seq' in table 'shift_emp_dtl' cannot be NULL |
Mon Dec 11 05:00:01 2017 | SERVER | AutoSeqServer | 0 | Autosequence 30001 step 1 of type S has encountered a stored procedure error...Error executing stored procedure. |
Mon Dec 11 05:00:01 2017 | SERVER | Autosequence.dll | 0 | Step completed. |
Mon Dec 11 05:00:01 2017 | SERVER | Autosequence.dll | 0 | Autosequence 30001 step 1 of type S has completed in 1 seconds. |
Mon Dec 11 05:00:01 2017 | SERVER | Autosequence.dll | 0 | -------------------------------------------- |
Mon Dec 11 05:00:01 2017 | SERVER | AutoSeqServer | 0 | Autosequence 30001 step 2 of type S has begun. |
Mon Dec 11 05:00:01 2017 | SERVER | AutoSeqServer | 0 | Clock Out And In All Employees |
Mon Dec 11 05:00:01 2017 | SERVER | Autosequence.dll | 0 | {CALL MICROS.sp_ClockOutInAllEmployees} |
Mon Dec 11 05:00:01 2017 | SERVER | Autosequence.dll | 0 | SQLExecDirect: (23000)[Sybase][ODBC Driver][SQL Anywhere]Column 'emp_seq' in table 'time_card_dtl' cannot be NULL |
Mon Dec 11 05:00:01 2017 | SERVER | AutoSeqServer | 0 | Autosequence 30001 step 2 of type S has encountered a stored procedure error...Error executing stored procedure. |
Mon Dec 11 05:00:01 2017 | SERVER | Autosequence.dll | 0 | Step completed. |
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top