GL Module will not close the year

(0) Share

Report

Posted on by Community Member

When I try to close the GL Module for the year, the process fails. All other module closed without a problem. Any ideas?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Community Member on at

Like (0)

Report

RE: GL Module will not close the year

Please post the log file, someone can help you

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: GL Module will not close the year

Here is the text of the Event Log. Thanks for any help.

System Message 6124: Process started: Fri Jan 13 05:24 P.M.

Closing General Ledger:

================================================================================
System Message 63: [Microsoft][SQL Server Native Client 11.0]Query timeout
                   expired

Debugging info: AcctHist_Close_year
                   '01/13/2017', '2016', 'WSCHUL'
Cursor(CSR_TempTable)
                   AcctHist_Close_year '01/13/2017', '2016', 'WSCHUL'
Optional
                   info: SqlState = HYT00 NativeError = 0 ErrorMsg =
                   [Microsoft][SQL Server Native Client 11.0]Query timeout
                   expired pcbErrorMsg = 63
ODBCRowNumber = -1 Column = -1
                   SSrvrLine = 0 SSrvrMsgState = 0 SSrvrSeverity = 0
                   SSrvrProcname = SSrvrSrvname =

System Message 6127: Error occurred during an abortable transaction. Processing
                     will continue.
================================================================================

================================================================================
System Message 56: [Microsoft][ODBC Driver Manager] Function sequence error

                   Debugging info: SqlCompile - SQLNumResultCols Failed

                   Cursor(CSR_TempTable) AcctHist_Close_year '01/13/2017',
                   '2016', 'WSCHUL'
Optional info: SqlState = HY010
                   NativeError = 0 ErrorMsg = [Microsoft][ODBC Driver Manager]
                   Function sequence error pcbErrorMsg = 56
ODBCRowNumber = -1
                   Column = -1 SSrvrLine = 0 SSrvrMsgState = 0 SSrvrSeverity = 0
                   SSrvrProcname = SSrvrSrvname =

System Message 6127: Error occurred during an abortable transaction. Processing
                     will continue.
================================================================================

================================================================================
System Message 10232: Assertion failure!

File: sqlodbc.cpp
Line:
                      1967

Expression: cursor > 0 AND cursor <= MAXCURSORS

Hit
                      OK to stop program, and report the error to Microsoft
                      Support,
noting the failed expression, file name and line
                      number.

System Message 6130: Fatal error. Process must be stopped at this time.

System Message 6129: Last item(s) processed: , , , ,
================================================================================

System Message 6125: Process ended: Sat Jan 14 10:12 A.M.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: GL Module will not close the year

Here is the text of the Event Log. Thanks for any help.

System Message 6124: Process started: Fri Jan 13 05:24 P.M.

Closing General Ledger:

================================================================================

System Message 63: [Microsoft][SQL Server Native Client 11.0]Query timeout

expired

Debugging info: AcctHist_Close_year

'01/13/2017', '2016', 'WSCHUL'

Cursor(CSR_TempTable)

AcctHist_Close_year '01/13/2017', '2016', 'WSCHUL'

Optional

info: SqlState = HYT00 NativeError = 0 ErrorMsg =

[Microsoft][SQL Server Native Client 11.0]Query timeout

expired pcbErrorMsg = 63

ODBCRowNumber = -1 Column = -1

SSrvrLine = 0 SSrvrMsgState = 0 SSrvrSeverity = 0

SSrvrProcname = SSrvrSrvname =

System Message 6127: Error occurred during an abortable transaction. Processing

will continue.

================================================================================

================================================================================

System Message 56: [Microsoft][ODBC Driver Manager] Function sequence error

Debugging info: SqlCompile - SQLNumResultCols Failed

Cursor(CSR_TempTable) AcctHist_Close_year '01/13/2017',

'2016', 'WSCHUL'

Optional info: SqlState = HY010

NativeError = 0 ErrorMsg = [Microsoft][ODBC Driver Manager]

Function sequence error pcbErrorMsg = 56

ODBCRowNumber = -1

Column = -1 SSrvrLine = 0 SSrvrMsgState = 0 SSrvrSeverity = 0

SSrvrProcname = SSrvrSrvname =

System Message 6127: Error occurred during an abortable transaction. Processing

will continue.

================================================================================

================================================================================

System Message 10232: Assertion failure!

File: sqlodbc.cpp

Line:

1967

Expression: cursor > 0 AND cursor <= MAXCURSORS

Hit

OK to stop program, and report the error to Microsoft

Support,

noting the failed expression, file name and line

number.

System Message 6130: Fatal error. Process must be stopped at this time.

System Message 6129: Last item(s) processed: , , , ,

================================================================================

System Message 6125: Process ended: Sat Jan 14 10:12 A.M.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: GL Module will not close the year

Hi WalkerS

What Solomon version you're using ?. Are you using FRX 6.7 SP4 ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: GL Module will not close the year

SL 15 Version 9.0130423.01, Management Reporter Version 2.12.14001.45, no FRX.

Was this reply helpful? Yes No
Suggested answer

Mark E 6,451 on at

Like (0)

Report

RE: GL Module will not close the year

Was MMR converted over from FRx at some point? If so, are the FRx DB objects still in the App DB? If yes, then you can try removing them and seeing if that resolves the GL closing issue.

Was this reply helpful? Yes No
John_Joyce 1,042 on at

Like (0)

Report

RE: GL Module will not close the year

With full DB back-ups (System & APP DB's), you could try following the guidance in this article:

support.microsoft.com/.../942095

It includes a "Rebuild_Triggers.SQL" file that can be run.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: GL Module will not close the year

I used to get this error and the problem is some FRX 6.7 trigger bugs. There is a SQL script has released in customer source can solve this issue. You should try to find and run that script, it may be solve your issue.

Was this reply helpful? Yes No